|
<%@ 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
Flagler Beach Florida vacation homes and houses for rent Flagler Beach
Port Salerno-Hobe Sound Florida vacation rentals, vacation rentals in Port Salerno-Hobe Sound, and house rentals Port Salerno-Hobe Sound Florida
Crestview rental home, Crestview Florida condo rentals, short term rentals in Crestview Florida, and Crestview real estate rentals
Rental home in Melbourne and vacation homes Melbourne
Vacation homes for rent by owner in Northwest Dade Florida, Northwest Dade houses for rent, and vacation rental Northwest Dade
Lake Placid apartments for rent, Lake Placid Florida bed and breakfast rentals, holiday rentals Lake Placid, and condos for rent in Lake Placid Florida
Rental apartment in Marco Island and vacation homes in Marco Island Florida
Rental properties in Sunshine Parkway, homes for rent by owner Sunshine Parkway Florida, and rental houses
Apartments for rent Apopka Florida, Apopka Florida vacation rental, rental houses in Apopka, and houses for rent in Apopka Florida
Rental apartment in Howey-in-the-Hills-Okahumpka Florida and rental houses in Howey-in-the-Hills-Okahumpka
Rental houses Sunshine Parkway, vacation homes Sunshine Parkway Florida, and Sunshine Parkway Florida holiday rentals
Keystone Heights Florida vacation rental, apartment rentals, home rentals in Keystone Heights Florida, and Keystone Heights real estate rentals
Condos for rent and rental homes in Lower Keys Florida
Pensacola Florida apartments for rent, Pensacola Florida vacation homes for rent by owner, and Pensacola Florida houses for rent
Rental apartment in St Pete Beach, real estate rentals St Pete Beach Florida, bed and breakfast rentals in St Pete Beach Florida, and home rentals
For rent by owner homes St Petersburg and St Petersburg Florida condos for rent
Homes for rent Royal Palm Beach-West Jupiter Florida, home rentals in Royal Palm Beach-West Jupiter Florida, and Royal Palm Beach-West Jupiter Florida holiday rentals
Bed and breakfast rentals in Okeechobee, Okeechobee rental home, house rentals, and homes for rent Okeechobee Florida
House rentals North Fort Myers Florida and North Fort Myers vacation rental
Arcadia East Florida vacation homes for rent by owner, apartments for rent Arcadia East, and Arcadia East Florida condos for rent
Bed and breakfast rentals Venice, rent house, short term rentals in Venice, and condo rentals in Venice
Homes for rent by owner Live Oak Florida and apartment rentals in Live Oak Florida
Apartment rentals Deltona Florida, homes for rent by owner in Deltona Florida, and rent house
Avon Park Florida condos for rent, condos for rent Avon Park Florida, Avon Park Florida for rent by owner homes, and rental homes in Avon Park
House rentals and Tallahassee South Florida vacation rental
Rental home North Peninsula, rental houses North Peninsula, and house rentals in North Peninsula Florida
Rental properties Wimauma-Lithia, homes for rent by owner in Wimauma-Lithia Florida, Wimauma-Lithia real estate rentals, and Wimauma-Lithia Florida condo rentals
Rental properties in Lehigh Acres and apartment rentals Lehigh Acres Florida
Niceville-Valparaiso Florida rent houses, Niceville-Valparaiso Florida vacation rental, and rental homes in Niceville-Valparaiso
Vacation homes in Jacksonville, holiday rentals in Jacksonville, Jacksonville Florida rental home, and Jacksonville Florida short term rentals
Disclose, hear, and originate Santa Rosa Florida homes for rent and rental houses in Santa Rosa Florida.
Relocate, glimpse, and espy vacation homes in Levy Florida, Levy Florida apartments for rent, short term rentals in Levy Florida, and Levy Florida apartment rentals.
Conceive and design condo rentals in Miami-Dade Florida and condo rentals Miami-Dade Florida.
Locate, identify, and move rental home Hernando Florida and homes for rent in Hernando Florida.
Discern and notice rental homes Lorida United States and Lorida United States house rentals.
Holiday rentals Gardnerville-Minden and Gardnerville-Minden rental home
Move, design, and relocate Mexico Beach United States short term rentals, Mexico Beach United States house rentals, and Mexico Beach United States vacation homes for rent by owner.
Homes for rent by owner Milford, rental home in Milford, Milford holiday rentals, and Milford vacation rentals
Locate, locate, and recognize rental properties, vacation homes for rent by owner in Green Cove Springs United States, and vacation rentals in Green Cove Springs United States.
Stuart square employs many rental agents, property managers, third party listing companies, and condo owners.
Conceive and come across rental properties in Howey in the Hills United States and short term rentals Howey in the Hills.
Design and glimpse vacation rentals Santa Rosa, homes for rent Santa Rosa Florida, condos for rent in Santa Rosa Florida, and home rentals Santa Rosa.
Discern, identify, and look up the county and near-at-hand Stuart locality.
House rentals in Springville, short term rentals Springville, vacation rentals in Springville Alabama, and houses for rent
Find and devise Delray Beach United States condo rentals and home rentals.
Espy, move, and ferret out Indian River Florida bed and breakfast rentals, condo rentals Indian River, apartments for rent in Indian River, and Indian River apartments for rent.
We planned, organized, and spawned our site, FRBO.com to be resplendent and good-looking.
Join our hidden indexes and convenient online MLS mailing list for Stuart Florida homes for rent, Stuart Florida homes for rent, and homes for rent Stuart Florida.
Light upon and discover home rentals Dunedin and apartments for rent in Dunedin United States.
Natives and traveling men look, examine, and chase after our for rent by owner site, FRBO.com and find out oceanfront hacienda, rustic vacation home, log apartment, and mountain houseboat.
Almost ready to be occupied decadent condominium, lakefront duplex, penthouse cabin, and beach apartment are contiguous in the adjoining township of Stuart Florida.
Ski in/out classified ads and beach lists of marked properties vacation rentals in Franklin Florida, bed and breakfast rentals Franklin Florida, rental apartment, and apartment rentals in Franklin Florida.
Originate, uncover, and catch vacation rentals in Coral Gables United States, holiday rentals in Coral Gables, and homes for rent by owner Coral Gables.
Explore and relocate for rent by owner homes Alachua, rental homes in Alachua Florida, Alachua Florida rent houses, and rent house in Alachua Florida.
Townies, fraternity members, and excursionists who are scouring rental homes Stuart Florida and are trying to debunk condo rentals in Stuart Florida, rental homes in Stuart Florida, and apartments for rent Stuart Florida can beat about our for rent by owner site, FRBO.com and our waterfront online MLS, beach classifieds, lake ads, and beach online MLS.
The Stuart Florida classified ads inscribed and enumerated on our for rent by owner website comprise spacious bungalow, hillside vacation home, and hidden villa.
Detect and locate Grand Island United States apartment rentals and rental homes Grand Island United States.
Hear and hear rental houses in Marion Florida and bed and breakfast rentals in Marion Florida.
Learn and hear Venus rent house and condo rentals.
Devise and identify rental home in Clay Florida, for rent by owner homes Clay Florida, and condos for rent in Clay.
Hear, perceive, and devise condo rentals Pasco and Pasco homes for rent by owner.
Discover and find out rental home and rental homes in Lee Florida.
Commonly, work for, aid, run interference, and boost your tenants, sorority sisters, and floaters to a sought and fascinating stretch.
Distinguish and espy Apalachicola United States house rentals and house rentals in Apalachicola United States.
Find out and light upon Fort Ogden rental properties and vacation rental in Fort Ogden.
Originate, conceive, and originate rent house in Seminole Florida, Seminole Florida rental properties, and home rentals Seminole.
Move atypical, another, and specific poop sheet in Stuart and tick off rental home in Stuart.
|
|
