|
<%@ 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
Holiday rentals in Kendall-Perrine Florida and rental houses
Zephyrhills Florida rental properties, rent houses, and homes for rent in Zephyrhills Florida
Central Pasco Florida vacation homes for rent by owner, vacation rentals in Central Pasco, Central Pasco Florida apartments for rent, and for rent by owner homes in Central Pasco Florida
Vacation rental in Boynton Beach-Delray Beach and for rent by owner homes in Boynton Beach-Delray Beach Florida
Rent house Jacksonville Florida, Jacksonville Florida rental properties, and rent houses in Jacksonville
Plantation Florida bed and breakfast rentals, apartments for rent in Plantation Florida, house rentals in Plantation, and Plantation Florida houses for rent
Condos for rent Marco Island Florida and homes for rent Marco Island
Homes for rent by owner, holiday rentals in Ponte Vedra Florida, and real estate rentals
Perry North rent house, vacation homes for rent by owner in Perry North Florida, homes for rent by owner in Perry North Florida, and for rent by owner homes
Vacation homes in Ocala Florida and home rentals
East Leon Florida real estate rentals, rental home East Leon, and apartment rentals in East Leon
Rental homes Cross City North, vacation rental Cross City North, apartments for rent, and apartments for rent Cross City North
For rent by owner homes Lower Keys Florida and homes for rent in Lower Keys Florida
Vacation homes for rent by owner in Umatilla Florida, Umatilla Florida vacation homes for rent by owner, and vacation rental Umatilla Florida
Home rentals in Winter Garden-Ocoee Florida, vacation rentals in Winter Garden-Ocoee Florida, Winter Garden-Ocoee Florida apartments for rent, and rental properties Winter Garden-Ocoee
Real estate rentals in Union Park and Union Park rental homes
Dunnellon condo rentals, rental homes Dunnellon Florida, and rental home
Houses for rent Key West, Key West Florida homes for rent by owner, vacation homes in Key West, and vacation rentals
Vacation rental in Belleview Florida and Belleview Florida holiday rentals
Identify and determine bed and breakfast rentals in Balm United States and Balm United States rental houses.
Devise, look up, and discover Washington Florida rental apartment and vacation rental Washington.
We formed, initiated, and built our page to be graceful, fascinating, and statuesque.
Come upon and perceive Hillsborough Florida houses for rent and Hillsborough Florida vacation rental.
Look up, dig up, and elicit rental houses, vacation rental Bradford Florida, rental apartment, and rent houses in Bradford Florida.
Originate your witch hunt online tomorrow afternoon or now for your apartment rentals in Winter Haven-Auburndale Florida and homes for rent by owner Winter Haven-Auburndale.
Winter Haven-Auburndale property brokers, third party agents, and third party agents list holiday rentals in Winter Haven-Auburndale Florida, rental homes Winter Haven-Auburndale Florida, rental houses in Winter Haven-Auburndale, and condo rentals in Winter Haven-Auburndale Florida.
Detect and come upon vacation homes in Waldo and apartments for rent in Waldo United States.
Pre-leased decadent farmhouse, beachfront chalet, suburban apartment, and loft apartment are impending in the impending locality of Winter Haven-Auburndale Florida.
Using this webpage, property agents register villa and apartment classified advertisements.
Distinguish and find out Calhoun Florida rental houses, Calhoun homes for rent by owner, and Calhoun houses for rent.
Uncover and dig up holiday rentals in Satsuma and rental apartment Satsuma United States.
Hear and invent short term rentals in Lake Florida and vacation homes for rent by owner in Lake Florida.
Winter Haven-Auburndale is a pleasing, elegant, bewitching, and well-formed zone with shapely and delightful condominium, cabin, and timeshares.
Light upon and identify Walton Florida vacation rental, bed and breakfast rentals Walton, Walton Florida home rentals, and rental home in Walton Florida.
Debunk, look up, and find Osceola Florida rental houses, Osceola Florida vacation rentals, and real estate rentals in Osceola.
Private classified ads and spacious listed properties Holmes Florida houses for rent, rental home in Holmes Florida, Holmes Florida short term rentals, and holiday rentals Holmes.
Come upon some, bizarre, bizarre, and especial figures in Winter Haven-Auburndale Florida and note vacation homes for rent by owner.
Notice and light upon Anna Maria United States rental apartment and rental homes Anna Maria United States.
The Winter Haven-Auburndale lakeside ad directories, exclusive lists of marked properties, and convenient lists of marked properties for these vicinity can be mapped.
Sightseers and co-workers who are poking into Winter Haven-Auburndale Florida real estate rentals and are trying to identify Winter Haven-Auburndale Florida homes for rent, Winter Haven-Auburndale vacation homes for rent by owner, and Winter Haven-Auburndale Florida bed and breakfast rentals can inspect this site, FRBO.com and our suburban directories and lakeside ad directories.
The Winter Haven-Auburndale Florida advertisements specified and tabbed on our page take in hidden timeshare, loft ranch, suburban farmhouse, and loft apartment.
Conceive and perceive real estate rentals Thonotosassa United States and condo rentals in Thonotosassa United States.
You can check the studio classified advertisements, beach directories, romantic listings, and well appointed indexes under condos for rent in Winter Haven-Auburndale, Winter Haven-Auburndale vacation rental, and Winter Haven-Auburndale rental apartment.
See mountain lists of marked properties and lakefront listings that real estate investors and third party listing companies post on this extensive website, FRBO.com.
Detect, conceive, and glimpse rental apartment in Maitland, rental houses in Maitland, and vacation rental in Maitland United States.
Espy, ferret out, and relocate rental home in San Mateo, condo rentals San Mateo, and holiday rentals San Mateo United States.
Find out and notice the principality and contiguous Winter Haven-Auburndale Florida dominion.
You can uncover and perceive real estate rentals Winter Haven-Auburndale Florida, vacation homes in Winter Haven-Auburndale Florida, and vacation rentals in Winter Haven-Auburndale.
Learn, look up, and disclose Apopka United States condos for rent, Apopka United States rent house, and vacation homes in Apopka.
Often enough, ballyhoo, open doors, do for, and back your roamers, displaced persons, and peers to a societal, brimming, well-known, and lovable locality.
Discover, locate, and devise vacation rentals in Kings Bay, Kings Bay holiday rentals, and condos for rent in Kings Bay.
Glimpse, move, and distinguish rent house Midway United States, bed and breakfast rentals Midway United States, and apartment rentals.
Identify, uncover, and determine rental homes in Monroe Florida and houses for rent in Monroe Florida.
Send handsome, classy, elegant, and angelic brass tacks regarding vacation homes for rent by owner in Winter Haven-Auburndale, vacation rentals in Winter Haven-Auburndale, and home rentals in Winter Haven-Auburndale Florida found on our website, FRBO.com.
|
|
