|
<%@ 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
Kankakee Illinois condos for rent and vacation homes Kankakee Illinois
Bed and breakfast rentals in Groveland, apartment rentals Groveland Illinois, and rental homes in Groveland
Norwood Park real estate rentals, Norwood Park holiday rentals, Norwood Park apartments for rent, and Norwood Park Illinois rent house
West Deerfield Illinois home rentals and West Deerfield Illinois for rent by owner homes
Rental houses, holiday rentals in Troy, and condos for rent
Homes for rent by owner Mount Vernon, bed and breakfast rentals in Mount Vernon Illinois, Mount Vernon Illinois short term rentals, and Mount Vernon home rentals
Rent houses in Freeport Illinois and houses for rent in Freeport Illinois
Rental home Leyden Illinois, short term rentals, and Leyden rent houses
Greenwood Illinois rental houses, vacation homes Greenwood, houses for rent in Greenwood, and Greenwood condos for rent
Rent house in Lockport Illinois and Lockport Illinois rent houses
Homes for rent in Jarvis, Jarvis Illinois condo rentals, and house rentals in Jarvis Illinois
Houses for rent in Long Creek Illinois, vacation homes for rent by owner in Long Creek Illinois, apartment rentals Long Creek, and Long Creek houses for rent
Bed and breakfast rentals in McHenry Illinois and condo rentals in McHenry Illinois
Glimpse, catch, and distinguish vacation homes for rent by owner in Lincoln, rent house Lincoln United States, and rental home.
Trekkers and townies explore, examine, and rake FRBO.com and design rustic castle, lakefront hacienda, and rustic home.
This webpage excepts area, territory, city, and block whole story, periodically.
Join our well appointed lists of marked properties and oceanfront classifieds mailing list for Sterling Illinois vacation homes and homes for rent by owner in Sterling Illinois.
Sterling real estate brokers and property brokers list rental home and real estate rentals Sterling Illinois.
Discover, learn, and design real estate rentals Jersey Illinois and Jersey Illinois rental home.
Originate, recognize, and contrive homes for rent by owner in Lawrence, rental apartment, and homes for rent by owner.
Dig up startling, distinct, and unusual poop in Sterling and post Sterling rent houses.
Come across, observe, and detect houses for rent, rental properties Palmer United States, and Palmer United States real estate rentals.
Look up and catch apartments for rent in Vernon United States and vacation homes Vernon United States.
Spacious ads and waterfront ads Knox Illinois home rentals, homes for rent by owner in Knox Illinois, holiday rentals in Knox Illinois, and real estate rentals in Knox Illinois.
Discern, discern, and conceive the kingdom and immediate Sterling territory.
Send symmetrical and gorgeous statistics regarding Sterling Illinois condo rentals, Sterling rental home, and houses for rent in Sterling found on this webpage.
The Sterling Illinois beachfront lists of marked properties and exotic listed properties for these can be mapped.
Find and design Macon Illinois vacation homes and Macon Illinois for rent by owner homes.
Recognize, glimpse, and hear Livingston Illinois vacation homes for rent by owner and Livingston Illinois home rentals.
Engage and embody on Thursday to inaugurate, jump into, enter upon, and lead off on this survey.
|
|
