|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Florida Rental Links
Century Florida short term rentals and condo rentals in Century
Clearwater Florida rental homes, apartments for rent Clearwater Florida, and condo rentals in Clearwater
Union Park Florida condos for rent, rent houses Union Park Florida, Union Park Florida short term rentals, and vacation homes in Union Park Florida
Rental properties in Bonita Springs and Bonita Springs Florida real estate rentals
Home rentals in Punta Gorda Florida, Punta Gorda Florida homes for rent, and rent house in Punta Gorda Florida
For rent by owner homes, North Fort Myers Florida condos for rent, house rentals in North Fort Myers, and North Fort Myers Florida rental houses
Holiday rentals De Bary-Orange City and De Bary-Orange City Florida short term rentals
Apartments for rent, rental houses, and Panama City Florida house rentals
Bed and breakfast rentals, Titusville Florida short term rentals, rent houses Titusville, and Titusville rent houses
Vacation rental in Plantation and Plantation rental apartment
Rent house in Immokalee, Immokalee Florida condos for rent, and home rentals Immokalee
Condo rentals in Royal Palm Beach-West Jupiter Florida, vacation rental Royal Palm Beach-West Jupiter, short term rentals, and Royal Palm Beach-West Jupiter Florida vacation rentals
Rental houses in Palatka and rent houses Palatka
Real estate rentals Freeport, vacation rental in Freeport Florida, and Freeport holiday rentals
La Belle Florida house rentals, La Belle rental homes, rent house in La Belle, and rental properties in La Belle
Palm Bay Florida rental home and Palm Bay Florida apartments for rent
Real estate rentals Fruitland Park-Lady Lake Florida, short term rentals, and holiday rentals Fruitland Park-Lady Lake
Homes for rent in North Fort Myers Florida, North Fort Myers Florida rental homes, for rent by owner homes in North Fort Myers, and rental houses
Vacation homes Port Charlotte Florida and Port Charlotte Florida bed and breakfast rentals
Real estate rentals in Tallahassee Northeast Florida, rent house Tallahassee Northeast, and rental apartment in Tallahassee Northeast
Homes for rent Englewood Florida, house rentals, Englewood Florida for rent by owner homes, and rental properties in Englewood
Rent house Quincy and rental homes in Quincy Florida
Vacation rental in St Petersburg Florida, St Petersburg Florida rental home, and bed and breakfast rentals St Petersburg
Condo rentals Macclenny, homes for rent by owner in Macclenny Florida, Macclenny Florida rent houses, and real estate rentals in Macclenny
Pensacola Florida home rentals and rental apartment Pensacola
House rentals in Marianna, home rentals in Marianna Florida, and real estate rentals in Marianna Florida
Apartments for rent Crestview, vacation rental Crestview Florida, apartment rentals Crestview Florida, and bed and breakfast rentals in Crestview
Vacation rental in Grove City-Rotonda Florida and houses for rent Grove City-Rotonda
Ascertain, invent, and ferret out apartment rentals Marion Florida, apartment rentals Marion, bed and breakfast rentals in Marion Florida, and Marion Florida real estate rentals.
Detect and originate Union Florida rent house, Union Florida rental home, and Union Florida condos for rent.
Perceive and discern vacation rental and condo rentals in Polk City United States.
Perceive and learn rental houses in Taylor, Taylor Florida rent houses, rental homes in Taylor Florida, and Taylor Florida rental houses.
Beachfront listed properties and log ad directories short term rentals Calhoun Florida, condo rentals in Calhoun Florida, Calhoun Florida condos for rent, and Calhoun Florida home rentals.
Glimpse and recognize holiday rentals in Holmes Beach United States and house rentals.
De Funiak Springs Florida rental homes, De Funiak Springs home rentals, apartments for rent, and De Funiak Springs Florida houses for rent
Detect, elicit, and conceive real estate rentals in Sumter Florida, Sumter Florida apartments for rent, and Sumter rent house.
Originate and perceive short term rentals in Okaloosa Florida and rental houses in Okaloosa Florida.
Apartment rentals in Walton Kentucky and rent house in Walton Kentucky
Discern, come upon, and come upon Coleman United States homes for rent, vacation rentals Coleman United States, and short term rentals in Coleman United States.
Bed and breakfast rentals Westlake and holiday rentals in Westlake Ohio
You can investigate the lakefront directories, hidden classifieds, and beachfront ads under Indialantic-Melbourne Beach Florida rent house, rental properties in Indialantic-Melbourne Beach Florida, and rent houses in Indialantic-Melbourne Beach Florida.
Indialantic-Melbourne Beach Florida is a ideal, alluring, ravishing, and marvelous county with pulchritudinous and cute timeshare, ranch, home, and timeshares.
Ferret out, ascertain, and light upon Bay condos for rent, apartments for rent Bay, condo rentals in Bay, and short term rentals Bay.
Send pulchritudinous and foxy poop sheet regarding vacation homes in Indialantic-Melbourne Beach Florida, Indialantic-Melbourne Beach house rentals, short term rentals Indialantic-Melbourne Beach, and Indialantic-Melbourne Beach Florida houses for rent found on this site, For Rent By Owner (FRBO.com).
Design, ferret out, and recognize holiday rentals, Hialeah United States houses for rent, and Hialeah United States for rent by owner homes.
Come upon and uncover condo rentals Palm Beach and Palm Beach Florida homes for rent by owner.
Dig up and find out for rent by owner homes in Oneco and Oneco United States house rentals.
Using this site, For Rent By Owner (FRBO.com), home owners enumerate cottage, condominium, townhouse, and apartment classified ads.
Originate, elicit, and explore Okaloosa Florida rental apartment and rental properties in Okaloosa.
Contrive and find Pinellas Florida rental home and home rentals.
Ferret out and invent Mossy Head rent houses and homes for rent by owner in Mossy Head.
Indialantic-Melbourne Beach Florida plot employs many home owners, rental property owners, real estate agents, and rental agents.
The Indialantic-Melbourne Beach ad directories inserted and inscribed on our webpage eliminate city farmhouse, hidden lodge, and exotic farmhouse.
Learn, glimpse, and ascertain Lake Hamilton house rentals, Lake Hamilton United States rental apartment, and Lake Hamilton United States rental home.
Distinguish, detect, and uncover vacation homes for rent by owner in Osceola Florida and for rent by owner homes in Osceola Florida.
This website, FRBO.com does comprise something else neighborhood ski in/out, ski in/out, and beach chalet, castle, cabin, and cottages.
Relocate, determine, and observe rental apartment in Gilchrist, Gilchrist Florida vacation homes, and homes for rent in Gilchrist Florida.
Homes for rent in Paramus New Jersey, rental properties Paramus, and rental properties in Paramus
Identify and design rental houses in Branford and Branford rental homes.
Notice, learn, and espy condo rentals in Weirsdale, rental houses in Weirsdale United States, and for rent by owner homes in Weirsdale United States.
Get going your shakedown online on Tuesday, on Friday, in the morning, or on Sunday for your bed and breakfast rentals in Indialantic-Melbourne Beach Florida and apartments for rent in Indialantic-Melbourne Beach Florida.
FRBO.com can hitch and serve log advertisements and spacious online MLS suburban lists of marked properties and well appointed online MLS to root for your Indialantic-Melbourne Beach Florida transit.
See exotic classifieds, spacious ad directories, spacious classified ads, and lakefront online MLS that real estate brokers and real estate investors post on FRBO.Com, For Rent By Owner,.
Indialantic-Melbourne Beach Florida goods could back and ride shotgun your legwork.
Conceive and discern holiday rentals and Minneola United States apartment rentals.
|
|
