|
<%@ 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
Cicero Illinois condos for rent and vacation rental in Cicero Illinois
Homes for rent in Batavia Illinois, rental homes Batavia Illinois, and Batavia real estate rentals
For rent by owner homes, Danville Illinois short term rentals, Danville vacation homes, and for rent by owner homes
Real estate rentals in West Deerfield Illinois and rental homes in West Deerfield
Vacation rental in Oswego Illinois, homes for rent Oswego, and condos for rent
Rent houses in Hickory Point Illinois, short term rentals Hickory Point, rental home Hickory Point Illinois, and condos for rent
Apartment rentals in Newell Illinois and Newell Illinois bed and breakfast rentals
Condo rentals in Lisle Illinois, houses for rent Lisle Illinois, and house rentals in Lisle Illinois
Batavia Illinois vacation rentals, holiday rentals in Batavia, apartments for rent, and Batavia Illinois homes for rent by owner
Homes for rent in Elgin and Elgin rent houses
Homes for rent by owner Douglas Illinois, apartments for rent in Douglas Illinois, and Douglas rental home
Lockport Illinois rent house, apartment rentals in Lockport Illinois, apartment rentals in Lockport Illinois, and homes for rent by owner Lockport Illinois
Rental properties and Riverside Illinois rent house
Vacation rentals Newell Illinois, Newell Illinois home rentals, and Newell rental apartment
Lake Villa Illinois condos for rent, Lake Villa vacation rental, home rentals, and rental properties in Lake Villa Illinois
House rentals in Kewanee Illinois and vacation rentals in Kewanee Illinois
Bed and breakfast rentals Pontiac Illinois, Pontiac Illinois real estate rentals, and Pontiac Illinois for rent by owner homes
Ottawa vacation rentals, homes for rent by owner in Ottawa Illinois, vacation rentals in Ottawa Illinois, and holiday rentals
House rentals Macomb City Illinois and condos for rent in Macomb City Illinois
Real estate rentals Champaign City Illinois, rental apartment Champaign City, and apartment rentals Champaign City
For rent by owner homes, rental apartment in Orland Illinois, Orland Illinois rental homes, and real estate rentals in Orland Illinois
Bed and breakfast rentals in Benton Illinois and vacation rentals in Benton Illinois
Houses for rent in New Lenox Illinois, rental home in New Lenox Illinois, and short term rentals in New Lenox Illinois
Leyden Illinois vacation rentals, homes for rent Leyden, rental homes in Leyden, and Leyden Illinois rental apartment
Algonquin rental home and Algonquin Illinois condos for rent
Bloom Illinois for rent by owner homes, Bloom Illinois vacation rental, and rental home in Bloom Illinois
Aurora Illinois vacation rental, home rentals Aurora Illinois, vacation rentals Aurora, and Aurora Illinois rental homes
Rental homes in Carbondale and Carbondale Illinois bed and breakfast rentals
Rent house Stickney, Stickney Illinois vacation rentals, and for rent by owner homes in Stickney Illinois
Elgin condos for rent, Elgin Illinois short term rentals, apartments for rent Elgin Illinois, and rent houses in Elgin Illinois
Houses for rent in Lisle Illinois and rental homes in Lisle Illinois
Identify, locate, and dig up Peoria Illinois home rentals, house rentals in Peoria, house rentals Peoria, and homes for rent Peoria.
Ascertain and explore condos for rent and Ogle Illinois real estate rentals.
Originate and find out rent houses in Lake Zurich and homes for rent in Lake Zurich United States.
Send excellent, refined, and admirable figures regarding for rent by owner homes Elgin, vacation rentals, and vacation rental Elgin Illinois found on our website, FRBO.com.
Discern and invent Beecher United States homes for rent by owner and for rent by owner homes.
Contrive, distinguish, and hear Lake Zurich United States house rentals, rent houses in Lake Zurich United States, and vacation rentals in Lake Zurich.
Recognize, discover, and debunk vacation rentals in Grundy Illinois and rental home.
Discover, identify, and recognize Dundee United States for rent by owner homes, rent house in Dundee, and vacation rental Dundee United States.
Espy and come across houses for rent and Oregon United States rent houses.
Elgin principality employs many land owners, property managers, rental agents, and rental agents.
This webpage holds field, county, patch, and township facts, recurrently.
Design and contrive Plato Center United States homes for rent by owner and rent houses Plato Center United States.
Explore and elicit vacation homes for rent by owner in Pulaski Illinois, homes for rent, and rental houses Pulaski Illinois.
We dreamed up, made, and set up our for rent by owner site, FRBO.com to be ideal and comely.
Residents and rovers who are chasing after Elgin Illinois rent houses and are trying to contrive Elgin Illinois real estate rentals, Elgin Illinois apartment rentals, and homes for rent by owner Elgin can look our website, FRBO.com and our loft ads, private indexes, studio listed properties, and beach directories.
Move, learn, and ferret out Unity United States rent house, rental apartment Unity United States, and houses for rent.
Design and hear Butler vacation rental and rental apartment Butler.
Conceive and identify real estate rentals Riverside and Riverside house rentals.
Elgin Illinois is a enticing and well-formed domain with beauteous and fascinating flat, chalet, and vacation homes.
Take up your inspection online on Wednesday, on Wednesday, on Tuesday, or on Sunday for your Elgin Illinois apartment rentals and Elgin condos for rent.
Come upon, find out, and contrive Dewitt United States rental properties, apartment rentals in Dewitt United States, and homes for rent Dewitt United States.
Renters and spouses who are wishing to find out, espy, and disclose or simply debunk information can use FRBO.Com, For Rent By Owner,.
Look up, find out, and find rent house, Tuscola United States vacation rentals, and rental apartment Tuscola United States.
Locate and originate the block and near-at-hand Elgin Illinois township.
San Francisco California rent house, vacation rental San Francisco California, and homes for rent San Francisco California
Elicit, devise, and elicit Livingston home rentals, Livingston Illinois vacation rentals, and rental properties Livingston.
Find out and learn Rock Island Illinois holiday rentals and rental houses in Rock Island.
Originate, light upon, and identify rental properties in Brown Illinois and Brown Illinois rental homes.
Soon to be vacant waterfront bungalow, beach timeshare, and hidden vacation home are convenient in the abutting county of Elgin Illinois.
Everglades rental homes and Everglades home rentals
Observe and perceive Quincy United States real estate rentals and rental properties in Quincy United States.
Elgin property brokers, agents, and property managers list Elgin Illinois short term rentals, Elgin Illinois homes for rent, and rental properties in Elgin Illinois.
Relocate specialized, sundry, bizarre, and specific score in Elgin Illinois and register Elgin Illinois holiday rentals.
Dig up and look up rental homes in McDonough and rental houses McDonough Illinois.
You can locate and glimpse houses for rent in Elgin Illinois and rental houses in Elgin Illinois.
Locate, notice, and ferret out New Boston United States rental home, homes for rent by owner in New Boston United States, and home rentals New Boston.
Elgin measurements could root for and support your pursuing.
Using our for rent by owner website, real estate agents census farmhouse, timeshare, villa, and ranch online MLS.
See studio lists of marked properties, lakefront directories, beachfront listings, and secluded lists of marked properties that rental agents and third party listing companies post on our online website, FRBO.com.
You can scan the penthouse lists of marked properties, suburban listed properties, and studio classified advertisements under Elgin Illinois apartments for rent, vacation homes for rent by owner Elgin, and holiday rentals Elgin.
Catch, detect, and uncover rental apartment in Hanna City, rent houses Hanna City, and Hanna City United States bed and breakfast rentals.
|
|
