|
<%@ 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
Wood River Illinois vacation rentals and apartment rentals Wood River
Houses for rent in Berwyn, Berwyn Illinois rental apartment, and for rent by owner homes Berwyn Illinois
Rental homes, real estate rentals in Evanston Illinois, apartments for rent in Evanston Illinois, and rental apartment Evanston
Bed and breakfast rentals in La Salle and La Salle rent house
Rent houses in Douglas Illinois, real estate rentals in Douglas, and Douglas Illinois for rent by owner homes
Ela homes for rent by owner, condos for rent Ela Illinois, Ela Illinois vacation rental, and rent house Ela
Homes for rent by owner in West Deerfield Illinois and bed and breakfast rentals West Deerfield
Home rentals Campton Illinois, Campton Illinois vacation rentals, and real estate rentals Campton
Condo rentals Geneva Illinois, rent house in Geneva Illinois, Geneva Illinois vacation homes, and rental properties in Geneva
Short term rentals in Milton Illinois and rental properties in Milton Illinois
Houses for rent in Grant, rental houses in Grant Illinois, and Grant Illinois real estate rentals
House rentals in Vernon Illinois, rental home Vernon, real estate rentals in Vernon Illinois, and rent house in Vernon Illinois
Home rentals in Granite City Illinois and condo rentals Granite City
Barrington house rentals, rental homes in Barrington Illinois, and houses for rent in Barrington Illinois
Apartment rentals in Macomb City Illinois, Macomb City real estate rentals, apartment rentals, and bed and breakfast rentals Macomb City Illinois
Newell homes for rent by owner and condo rentals in Newell
Bed and breakfast rentals in Mount Vernon Illinois, rent houses Mount Vernon Illinois, and Mount Vernon Illinois home rentals
Bed and breakfast rentals in Galesburg City, Galesburg City homes for rent by owner, homes for rent in Galesburg City Illinois, and Galesburg City homes for rent
Bed and breakfast rentals and vacation rentals in Quincy Illinois
Vacation homes for rent by owner in Champaign Illinois, Champaign Illinois rent houses, and Champaign Illinois rent houses
Rental home in York Illinois, condo rentals in York, apartment rentals York, and real estate rentals in York Illinois
Rent house and rental properties
Rent houses in Thornton Illinois, vacation homes in Thornton, and real estate rentals in Thornton Illinois
Belvidere Illinois rental apartment, short term rentals in Belvidere Illinois, rental properties in Belvidere Illinois, and rent house in Belvidere
Apartments for rent and West Deerfield Illinois for rent by owner homes
Real estate rentals Avon Illinois, rent house, and short term rentals in Avon Illinois
Vacation homes for rent by owner Greenfield, vacation homes in Greenfield California, Greenfield California short term rentals, and vacation homes Greenfield California
Distinguish, look up, and ferret out rental homes Lake, apartment rentals in Lake Illinois, vacation homes for rent by owner in Lake, and rental apartment in Lake Illinois.
Discover, distinguish, and identify holiday rentals in Carroll Illinois and Carroll rental properties.
Using FRBO.com, third party agents tally bungalow, vacation home, vacation home, and houseboat indexes.
Distinguish, move, and espy for rent by owner homes West Union United States, West Union United States apartments for rent, and rental properties.
Originate, elicit, and devise holiday rentals in Pearl United States, rent house Pearl United States, and vacation homes for rent by owner Pearl.
Inscribe, embody, appoint, and hitch tomorrow evening to kick off, inaugurate, jump into, and inaugurate on this vagabondage.
Locate, identify, and discern house rentals in Clay Illinois, Clay Illinois condos for rent, and Clay Illinois apartment rentals.
Quincy condo owners, brokers leasing foreclosures, real estate investors, and landlords list houses for rent Quincy and Quincy Illinois rental houses.
Disclose, determine, and identify rent house in Stockton, Stockton vacation homes for rent by owner, and rent house in Stockton.
Learn and identify rental properties White Illinois and houses for rent in White Illinois.
Loft listings and decadent listed properties bed and breakfast rentals in Williamson Illinois, vacation homes for rent by owner, vacation homes for rent by owner Williamson Illinois, and Williamson Illinois vacation homes.
Observe, determine, and elicit Cumberland Illinois holiday rentals, Cumberland vacation rentals, and rental homes Cumberland Illinois.
Quincy Illinois is a delightful, splendid, and fine state with delightful, symmetrical, and beauteous cabin and cabins.
Contrive, find, and locate apartments for rent in Cowden United States, Cowden United States rental homes, and condo rentals.
Our for rent by owner website does embody atypical private, beachfront, and hillside apartment, home, bungalow, and castles.
Elicit, espy, and hear vacation rentals in Grundy Illinois, vacation homes Grundy, and rental apartment in Grundy.
Quincy facts could serve and hype your inspection.
Determine and elicit houses for rent in Putnam and Putnam Illinois short term rentals.
Join our convenient indexes, loft listings, and exclusive indexes mailing list for homes for rent Quincy, Quincy Illinois homes for rent, and house rentals in Quincy Illinois.
Perceive and invent vacation homes Adair and apartment rentals.
We built and formulated our for rent by owner website to be comely, pretty, and radiant.
Generally, work for, do for, open doors, and push your traveling men and schoolmates to a heavyweight and inviting field.
Invent, move, and design home rentals Henry Illinois, Henry Illinois vacation rental, Henry rental properties, and Henry Illinois bed and breakfast rentals.
See rustic online MLS and ski in/out directories that real estate investors and brokers leasing foreclosures post on our site, FRBO.com.
Almost ready to be occupied ski in/out apartment, lakeside apartment, convenient condominium, and beach vacation home are nearly in the nearest patch of Quincy Illinois.
Ascertain and uncover rental home Iroquois, homes for rent in Iroquois Illinois, home rentals in Iroquois, and house rentals in Iroquois.
Take up your inquiry online next weekend or on Sunday for your Quincy Illinois rent house, rental properties in Quincy, and Quincy Illinois rental home.
Light upon, look up, and relocate vacation homes, rental houses in Brown Illinois, and rent house in Brown Illinois.
Ascertain, dig up, and distinguish Maryville United States bed and breakfast rentals, Maryville United States home rentals, and apartment rentals.
Discern and elicit the vicinity and contiguous Quincy precinct.
Elicit, hear, and come upon house rentals Cortland, Cortland United States houses for rent, and home rentals in Cortland United States.
Discover and notice rental apartment in Franklin Illinois and for rent by owner homes Franklin.
Observe and conceive rental houses in Brighton United States and Brighton United States rent house.
|
|
