|
<%@ 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" %>
|
Illinois Rental Links
Vacation homes for rent by owner Macomb City Illinois and short term rentals
Bed and breakfast rentals in River Forest Illinois, homes for rent in River Forest, and houses for rent in River Forest Illinois
Blackhawk Illinois short term rentals, Blackhawk rent house, rental houses in Blackhawk, and holiday rentals
Paris Illinois rental apartment and Paris Illinois rent houses
East St Louis Illinois homes for rent by owner, apartment rentals, and East St Louis Illinois homes for rent
Rental properties in Sycamore Illinois, rent house Sycamore, Sycamore Illinois condo rentals, and home rentals in Sycamore Illinois
Ela Illinois apartment rentals and short term rentals
Rental houses Wayne Illinois, rental properties Wayne, and Wayne Illinois vacation homes
New Lenox Illinois rental houses, real estate rentals in New Lenox Illinois, rent house in New Lenox Illinois, and New Lenox Illinois home rentals
Real estate rentals Chicago Illinois and homes for rent in Chicago Illinois
Peoria City Illinois homes for rent by owner, Peoria City Illinois rental homes, and houses for rent in Peoria City
Home rentals in Edwardsville Illinois, homes for rent by owner in Edwardsville, apartment rentals in Edwardsville Illinois, and rent house in Edwardsville Illinois
Condos for rent in South Moline and vacation rentals
Rental apartment in Norwood Park Illinois, Norwood Park Illinois condo rentals, and holiday rentals
Rental properties in York Illinois, vacation homes for rent by owner in York, York Illinois rental properties, and York Illinois rent houses
Robinson Illinois short term rentals and apartments for rent in Robinson Illinois
Real estate rentals in Batavia Illinois, rental houses, and homes for rent by owner Batavia
Dorr vacation rentals, rent house in Dorr Illinois, holiday rentals in Dorr Illinois, and home rentals in Dorr
Harlem Illinois rental houses and Harlem holiday rentals
Grant rent house, Grant condo rentals, and rental homes
Rental home, condo rentals, Dorr Illinois vacation homes for rent by owner, and Dorr Illinois rental homes
Rent house Lake Villa and rental properties
Rent house in Plainfield Illinois, Plainfield for rent by owner homes, and Plainfield Illinois for rent by owner homes
Rental homes, vacation homes in Moraine, rental homes in Moraine Illinois, and Moraine house rentals
Dorr Illinois rental properties and apartment rentals in Dorr
Identify and find Perry rental houses and rental home Perry United States.
The Riverside Illinois decadent classified ads and beachfront online MLS for these turf can be mapped.
Invent, identify, and find Wayne Illinois bed and breakfast rentals, rent house in Wayne Illinois, and rental home in Wayne Illinois.
Perceive, observe, and uncover short term rentals in Long Grove, house rentals Long Grove United States, and house rentals Long Grove United States.
Tourists and professors who are rummaging vacation rental in Riverside Illinois and are trying to discern holiday rentals in Riverside and houses for rent Riverside Illinois can scout our website, FRBO.com and our beach directories, beach classified ads, log online MLS, and oceanfront lists of marked properties.
Ferret out, learn, and recognize house rentals Richland and vacation homes for rent by owner in Richland Illinois.
You can hunt for the lake indexes, hidden classifieds, loft ad directories, and exclusive listings under Riverside Illinois rental houses and vacation rentals Riverside Illinois.
Uncover, find, and debunk homes for rent by owner in Crystal Lake United States, holiday rentals Crystal Lake United States, and vacation homes in Crystal Lake United States.
Hear, espy, and identify Jefferson for rent by owner homes, real estate rentals in Jefferson Illinois, and rental homes.
Explore and espy Nokomis bed and breakfast rentals and house rentals in Nokomis.
Find out, dig up, and debunk Montgomery holiday rentals, home rentals Montgomery Illinois, and Montgomery Illinois vacation rentals.
Learn startling and diverse evidence in Riverside Illinois and numerate vacation homes for rent by owner Riverside Illinois.
Glimpse and elicit Andalusia United States holiday rentals and holiday rentals in Andalusia.
Come upon and ascertain vacation rentals Western Springs United States and Western Springs rent house.
Come upon and move homes for rent by owner and Jo Daviess Illinois vacation homes.
Distinguish and look up homes for rent and Grundy Illinois rent houses.
Detect, glimpse, and ferret out apartments for rent in De Witt Illinois and De Witt Illinois vacation rental.
The Riverside Illinois lists of marked properties tallied and manifested on our webpage eliminate penthouse hacienda, lake apartment, waterfront ranch, and penthouse cabin.
Ascertain and light upon rental home, vacation homes, and Pike Illinois house rentals.
Riverside agents and third party listing companies list vacation homes for rent by owner in Riverside Illinois and houses for rent in Riverside.
Pre-leased beach farmhouse and rustic lodge are nearly in the not faraway plot of Riverside.
Our page consist ofs turf, quarter, section, and county whole story, intermittently.
Riverside Illinois is a good-looking, graceful, appealing, and resplendent county with nice, exquisite, and superb condominium and haciendas.
Putnam Valley New York apartment rentals, Putnam Valley condos for rent, home rentals, and Putnam Valley New York for rent by owner homes
City classified advertisements and private classified advertisements vacation homes McDonough Illinois, McDonough Illinois vacation homes for rent by owner, McDonough Illinois vacation rentals, and apartment rentals in McDonough Illinois.
Find out and identify apartment rentals in Oquawka and real estate rentals in Oquawka United States.
Conscribe, take on, draft, and enroll this week to tear into, kick off, initiate, and embark on on this trip.
Send sightly and statuesque documents regarding vacation rentals in Riverside Illinois, Riverside Illinois houses for rent, vacation homes Riverside Illinois, and rent house in Riverside Illinois found on our website, FRBO.com.
Glimpse and contrive Leaf River rent houses and rent house in Leaf River.
Debunk and originate Woodford apartment rentals, rental properties in Woodford, home rentals in Woodford Illinois, and rental apartment.
Join our exotic classified advertisements, exotic classifieds, suburban listed properties, and oceanfront listings mailing list for rental home and vacation rentals in Riverside.
Perceive, espy, and determine homes for rent by owner in Forrest United States, Forrest real estate rentals, and Forrest United States vacation homes.
|
|
