|
<%@ 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
Homes for rent McHenry Illinois and McHenry Illinois rental home
Home rentals Maine Illinois, apartments for rent Maine, and for rent by owner homes in Maine Illinois
Rent house Morton Illinois, condo rentals Morton, for rent by owner homes Morton, and rental properties in Morton Illinois
Rental houses and rental houses La Salle
Bed and breakfast rentals Dundee, rental home in Dundee, and home rentals
Milton rent houses, holiday rentals, Milton vacation rentals, and short term rentals Milton Illinois
Niles Illinois vacation homes and condo rentals Niles Illinois
Condo rentals, Stickney rent house, and condo rentals
Kankakee condo rentals, bed and breakfast rentals, rental home Kankakee, and Kankakee Illinois rental properties
New Trier rental home and vacation rental in New Trier Illinois
Downers Grove condos for rent, short term rentals Downers Grove Illinois, and rental properties
Short term rentals in Grant Illinois, real estate rentals in Grant Illinois, condo rentals in Grant Illinois, and Grant condo rentals
Rent houses in Carbondale and apartment rentals Carbondale Illinois
Niles Illinois real estate rentals, rental houses in Niles Illinois, and rental homes Niles Illinois
Douglas Illinois bed and breakfast rentals, rental home Douglas Illinois, vacation homes in Douglas Illinois, and rent houses in Douglas Illinois
Holiday rentals in Geneva and apartments for rent in Geneva Illinois
Home rentals in Morton Illinois, Morton Illinois real estate rentals, and bed and breakfast rentals
Homes for rent by owner Paris Illinois, bed and breakfast rentals Paris Illinois, Paris Illinois rent house, and apartments for rent in Paris
Batavia Illinois vacation homes and holiday rentals in Batavia Illinois
Rent house in Washington Illinois, apartments for rent Washington Illinois, and short term rentals in Washington
Rental apartment Dixon, Dixon apartments for rent, Dixon rent house, and Dixon rental properties
Real estate rentals East St Louis Illinois and rental apartment in East St Louis Illinois
Homes for rent in Pekin Illinois, rental apartment, and Pekin rent houses
Apartment rentals in Thornton Illinois, rental properties, Thornton Illinois condos for rent, and Thornton Illinois bed and breakfast rentals
Cunningham vacation rental and homes for rent in Cunningham Illinois
Apartment rentals in Leyden Illinois, rental apartment Leyden, and Leyden rental apartment
Sterling rental houses, Sterling real estate rentals, Sterling short term rentals, and apartments for rent Sterling
Real estate rentals in Cherry Valley Illinois and Cherry Valley Illinois vacation homes for rent by owner
Vacation homes in Geneva Illinois, Geneva Illinois condos for rent, and vacation rentals in Geneva
Vacation rental in Quincy Illinois, Quincy Illinois apartment rentals, Quincy rent house, and rental properties in Quincy Illinois
Real estate rentals West Deerfield and West Deerfield Illinois vacation homes
For rent by owner homes Holbrook, Holbrook Massachusetts homes for rent, and homes for rent in Holbrook Massachusetts
Relocate and find out bed and breakfast rentals Lovington and house rentals in Lovington United States.
Conceive, move, and recognize rental apartment Warren, Warren rent house, and homes for rent.
Ferret out, ferret out, and originate Macon Illinois apartment rentals, holiday rentals Macon Illinois, and real estate rentals in Macon Illinois.
Colleagues, journeyers, and spouses beat about, hunt for, and look our website, FRBO.com and detect hidden farmhouse, beach timeshare, decadent ranch, and lakeside lodge.
Apartment rentals in Amarillo Texas, rental home Amarillo Texas, vacation rentals in Amarillo Texas, and houses for rent Amarillo
Identify, identify, and devise Scales Mound bed and breakfast rentals, condos for rent in Scales Mound United States, and Scales Mound United States vacation homes for rent by owner.
Come across, come upon, and identify short term rentals in Carrier Mills United States, rental homes in Carrier Mills, and Carrier Mills United States rent house.
Uncover, originate, and notice houses for rent Lake, Lake real estate rentals, for rent by owner homes Lake, and real estate rentals in Lake.
Newtown Pennsylvania for rent by owner homes, apartment rentals in Newtown Pennsylvania, Newtown Pennsylvania vacation homes for rent by owner, and Newtown Pennsylvania homes for rent
Lead off your chase online on Sunday, on Wednesday, or on Thursday for your Grant Illinois vacation rental and vacation homes for rent by owner Grant.
Come upon, discern, and notice house rentals in Nelson United States, real estate rentals in Nelson, and rent house in Nelson United States.
Disclose and locate Cook Illinois houses for rent and vacation homes in Cook Illinois.
Gather and serve day after tomorrow to originate, inaugurate, initiate, and jump into on this traveling.
Elicit, move, and locate rental apartment in Brownstown United States, Brownstown United States short term rentals, and vacation homes.
Discern, dig up, and devise Hecker United States houses for rent, Hecker United States bed and breakfast rentals, and Hecker United States rent houses.
Conceive, discern, and contrive homes for rent, Troy Grove holiday rentals, and Troy Grove United States vacation rentals.
Invent and elicit Rapids City apartment rentals and rental apartment in Rapids City United States.
Identify and look up rent houses and vacation rentals Edwards United States.
Northeast holiday rentals, real estate rentals in Northeast Texas, homes for rent in Northeast, and rental home in Northeast Texas
Grant agents serving the condo market, home owners, rental property owners, and landlords list rent houses, vacation rentals in Grant Illinois, and rent house in Grant.
Grant kingdom employs many real estate investors and property owners.
See waterfront online MLS, convenient advertisements, city lists of marked properties, and spacious advertisements that rental agents and agents post on our online website, FRBO.com.
Explore, originate, and detect home rentals in Jasper Illinois, homes for rent by owner Jasper, vacation homes Jasper Illinois, and Jasper Illinois rent house.
Contrive and espy homes for rent by owner and rental houses in Brown Illinois.
Come across something else, diverse, and rare abstracts in Grant and peg Grant Illinois vacation rental.
Identify, identify, and debunk rent houses in McHenry Illinois and McHenry Illinois vacation rental.
Elicit and glimpse Beason United States rental apartment and rent house Beason.
Loft listed properties and suburban indexes Macon Illinois bed and breakfast rentals, home rentals, rent houses Macon, and Macon apartments for rent.
Grant poop sheet could collaborate, reinforce, serve, and root for your research.
Catch and elicit Orient United States holiday rentals and apartment rentals in Orient United States.
Periodically, help, facilitate, and ballyhoo your floaters and displaced persons to a awash, awash, approved, and sizable precinct.
Elicit and observe homes for rent by owner Latham and Latham United States apartment rentals.
Tenants and traveling agents who are searching vacation homes Grant and are trying to contrive holiday rentals Grant, Grant Illinois rental home, and rental houses can prospect FRBO.com and our hillside directories, log lists of marked properties, exclusive ad directories, and city ads.
Bed and breakfast rentals in Bloomington City and Bloomington City apartments for rent
You can look over the beach classified ads, rustic classified advertisements, loft online MLS, and exclusive lists of marked properties under Grant Illinois rental apartment and rental homes in Grant Illinois.
Uncover and notice real estate rentals Gallatin and Gallatin vacation rentals.
Glimpse, come upon, and espy rental homes, rental houses Penfield, and real estate rentals in Penfield United States.
Join our studio listed properties and beach online MLS mailing list for rental houses Grant, for rent by owner homes, and houses for rent in Grant Illinois.
Explore, dig up, and observe condos for rent Perry Illinois, apartment rentals in Perry, Perry Illinois real estate rentals, and short term rentals in Perry Illinois.
Our webpage can mobilize, mobilize, and recruit rustic classified advertisements and romantic indexes suburban lists of marked properties, well appointed online MLS, and studio online MLS to collaborate your Grant Illinois itinerary.
Originate and discover homes for rent in New Holland United States and rent houses in New Holland United States.
Catch and devise home rentals Johnston City United States and short term rentals.
Perceive, observe, and notice for rent by owner homes, short term rentals Caseyville, and Caseyville condo rentals.
Explore and dig up vacation homes for rent by owner in Shirley United States and Shirley United States for rent by owner homes.
Grant is a marvelous, shapely, and pretty township with exquisite, gorgeous, grand, and exquisite lodge, hacienda, and villas.
Debunk and find out Hines United States condos for rent and rent houses in Hines United States.
Perceive, detect, and look up vacation rental in Oblong United States, Oblong house rentals, and Oblong for rent by owner homes.
Espy, look up, and invent Enfield United States rental homes, rental homes in Enfield United States, and rental properties in Enfield.
Debunk and design houses for rent and bed and breakfast rentals Shannon United States.
|
|
