|
<%@ 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
Rental houses in Proviso and rental home in Proviso Illinois
New Lenox real estate rentals, New Lenox Illinois rental houses, and short term rentals in New Lenox Illinois
Champaign vacation homes for rent by owner, holiday rentals Champaign Illinois, rent house in Champaign, and short term rentals Champaign
Bloomington City Illinois apartments for rent and homes for rent by owner in Bloomington City
Vernon Illinois houses for rent, home rentals Vernon, and short term rentals in Vernon
Northfield Illinois houses for rent, apartments for rent in Northfield Illinois, vacation homes for rent by owner Northfield, and Northfield Illinois house rentals
Rent house Bremen Illinois and vacation homes for rent by owner in Bremen Illinois
Apartment rentals in Avon Illinois, Avon Illinois condos for rent, and condos for rent in Avon
Quincy apartment rentals, holiday rentals Quincy, Quincy Illinois bed and breakfast rentals, and Quincy Illinois houses for rent
Home rentals and vacation rental Long Creek Illinois
Homes for rent in Orland Illinois, rental houses in Orland Illinois, and Orland rental apartment
Holiday rentals in Troy, Troy condo rentals, bed and breakfast rentals in Troy Illinois, and Troy Illinois rental properties
Rental houses Quincy Illinois and for rent by owner homes
Bed and breakfast rentals York Illinois, for rent by owner homes in York Illinois, and real estate rentals
Real estate rentals O, O condo rentals, O Illinois condo rentals, and condo rentals O Illinois
Condo rentals in Taylorville Illinois and houses for rent in Taylorville Illinois
Rent houses in Douglas, holiday rentals in Douglas, and vacation rental in Douglas Illinois
Home rentals in Bourbonnais, house rentals in Bourbonnais Illinois, for rent by owner homes in Bourbonnais Illinois, and Bourbonnais Illinois rental apartment
Warren Illinois homes for rent by owner and Warren Illinois apartment rentals
Find and discern vacation homes for rent by owner, short term rentals Morgan Illinois, rental properties in Morgan Illinois, and Morgan Illinois houses for rent.
Perceive and identify rental houses Breese and Breese homes for rent by owner.
Send beauteous, sublime, angelic, and refined input regarding houses for rent in Cherry Valley, Cherry Valley Illinois homes for rent by owner, and short term rentals in Cherry Valley Illinois found on this webpage.
You can grub the loft classified ads, mountain ads, lake online MLS, and resort classified ads under rent houses in Cherry Valley Illinois and Cherry Valley rent houses.
Disclose, perceive, and notice the turf and neighboring Cherry Valley dominion.
Design and uncover Flossmoor United States vacation homes for rent by owner and home rentals in Flossmoor United States.
Move original, extraordinary, sundry, and sparse details in Cherry Valley Illinois and enumerate vacation homes for rent by owner in Cherry Valley Illinois.
Cherry Valley rental agents, land owners, town home owners, and agents serving the condo market list holiday rentals and vacation rental Cherry Valley.
Identify and perceive condo rentals and Campus United States vacation homes.
Light upon and contrive Brownstown vacation homes for rent by owner and Brownstown United States apartment rentals.
You can notice and debunk Cherry Valley Illinois vacation homes for rent by owner, vacation homes Cherry Valley, and vacation homes for rent by owner in Cherry Valley.
Conceive, come across, and light upon holiday rentals Sesser, Sesser United States rental homes, and Sesser short term rentals.
Notice and dig up short term rentals in Clark and rental properties Clark Illinois.
Hitch, appoint, and conscribe tomorrow afternoon to get cracking, originate, open, and launch on this travel.
Espy and discern homes for rent in Geneseo United States and Geneseo United States homes for rent by owner.
Opportunists, roamers, and floaters probe and explore our website, FRBO.com and conceive beach home, beachfront home, penthouse house, and lakeside condominium.
Discern, locate, and observe for rent by owner homes in Woodford, Woodford rental home, and Woodford Illinois apartment rentals.
Uncover, espy, and originate vacation homes for rent by owner in La Grange United States, La Grange United States holiday rentals, and La Grange United States vacation rental.
Observe, look up, and locate vacation rentals in Vermilion Illinois, Vermilion Illinois house rentals, homes for rent in Vermilion Illinois, and vacation rental Vermilion.
The Cherry Valley mountain indexes and romantic lists of marked properties for these county can be mapped.
Light upon, discern, and notice apartment rentals Western Springs United States, Western Springs United States house rentals, and homes for rent in Western Springs United States.
Colleagues, occupants, and boarders who are scouting rental homes in Cherry Valley Illinois and are trying to notice Cherry Valley short term rentals, condos for rent, and Cherry Valley Illinois rental home can look our page and our oceanfront online MLS and oceanfront listings.
We established and coined our online website, FRBO.com to be grand, divine, and graceful.
Kick off your research online in the morning or now for your short term rentals in Cherry Valley Illinois, vacation homes for rent by owner in Cherry Valley Illinois, and homes for rent by owner in Cherry Valley.
Relocate, discern, and glimpse condo rentals in Princeton United States, for rent by owner homes in Princeton United States, and vacation rentals in Princeton.
Relocate, move, and glimpse Monroe Illinois rental homes, vacation rental in Monroe, and Monroe apartment rentals.
|
|
