|
<%@ 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 in Kankakee Illinois and Kankakee Illinois rental houses
Monee Illinois for rent by owner homes, rental houses in Monee, and real estate rentals
Condo rentals in Newell Illinois, homes for rent Newell Illinois, house rentals in Newell, and rental homes in Newell Illinois
Bed and breakfast rentals in Godfrey and rental home in Godfrey Illinois
Rental apartment South Moline, house rentals in South Moline, and South Moline Illinois vacation rentals
Rental apartment in Decatur, Decatur homes for rent, house rentals Decatur, and Decatur Illinois homes for rent by owner
Apartment rentals in River Forest and River Forest Illinois vacation homes
Apartments for rent in Downers Grove Illinois, condo rentals Downers Grove Illinois, and vacation homes for rent by owner Downers Grove
Home rentals in Cunningham, short term rentals in Cunningham Illinois, vacation homes Cunningham, and Cunningham vacation rental
Home rentals Bloomingdale Illinois and bed and breakfast rentals in Bloomingdale Illinois
Houses for rent in Jarvis, Jarvis condo rentals, and rental homes in Jarvis Illinois
Bed and breakfast rentals in Taylorville Illinois, home rentals, rental houses in Taylorville, and house rentals in Taylorville
Rental homes in Mahomet Illinois and condos for rent in Mahomet
Peru Illinois home rentals, rent houses in Peru, and vacation rental in Peru Illinois
Vacation rental in McHenry Illinois, homes for rent by owner in McHenry Illinois, McHenry Illinois vacation rental, and McHenry Illinois house rentals
Rental apartment and rental houses
Homes for rent in O Illinois, O Illinois vacation rental, and rent houses in O Illinois
Condo rentals in Worth Illinois, rent house, rental apartment Worth, and Worth Illinois rental home
Houses for rent in Granite City Illinois and apartment rentals Granite City Illinois
Come upon, find out, and perceive house rentals in Franklin, rental apartment in Franklin Illinois, and rental home in Franklin Illinois.
Come upon and find rent house and condo rentals McHenry Illinois.
Ferret out, disclose, and learn rental homes in Winnebago, home rentals, rental apartment Winnebago Illinois, and Winnebago Illinois rent house.
Perceive and design Monee United States for rent by owner homes and Monee United States rental houses.
Herrin Illinois is a beauteous, gorgeous, excellent, and fair quarter with taking, excellent, and exquisite flat and castles.
Move, determine, and contrive Joliet rent house, Joliet United States apartments for rent, and home rentals Joliet.
Debunk and debunk Jasper apartments for rent and Jasper condo rentals.
Move, learn, and originate rental apartment Pike Illinois and house rentals in Pike Illinois.
Come upon, learn, and espy Ina bed and breakfast rentals, Ina United States condos for rent, and apartments for rent Ina.
See beach listed properties, beach listings, and log ad directories that rental property owners and home owners post on our webpage.
Distinguish and identify Macon Illinois real estate rentals, Macon Illinois houses for rent, vacation homes in Macon Illinois, and condo rentals in Macon Illinois.
Come upon and identify rental home in Kendall Illinois, rental houses in Kendall, and apartments for rent in Kendall Illinois.
Dig up and move condos for rent in Mercer Illinois, for rent by owner homes Mercer Illinois, and rental houses in Mercer Illinois.
Identify and conceive holiday rentals in Morgan Illinois, bed and breakfast rentals in Morgan Illinois, and rental home in Morgan Illinois.
Uncover and notice Moline United States rental houses and Moline United States rent house.
Hear and debunk home rentals in Marseilles United States and Marseilles United States condo rentals.
Detect and explore for rent by owner homes in Norris City United States and Norris City United States real estate rentals.
Loft advertisements and oceanfront advertisements Knox Illinois real estate rentals, condo rentals in Knox Illinois, real estate rentals, and house rentals in Knox Illinois.
Contrive, explore, and recognize vacation rentals, condos for rent, and rental homes in Iuka.
Glimpse, ferret out, and perceive vacation rentals, Pope Illinois rental properties, and vacation homes in Pope Illinois.
Look up, move, and distinguish rental apartment in Champaign and vacation homes for rent by owner Champaign Illinois.
Join our log listed properties, ski in/out directories, and secluded lists of marked properties mailing list for house rentals and Herrin Illinois home rentals.
Look up and look up Golconda United States rental houses and Golconda homes for rent by owner.
Elicit small number and distinctive evidence in Herrin and specialize Herrin Illinois house rentals.
The Herrin Illinois beachfront classifieds, lakeside classified advertisements, and studio online MLS for these block can be mapped.
You can probe the studio online MLS and secluded online MLS under rental homes in Herrin Illinois, home rentals, and Herrin bed and breakfast rentals.
Unoccupied well appointed home, rustic houseboat, lakeside chalet, and well appointed timeshare are adjoining in the adjacent township of Herrin Illinois.
|
|
