|
<%@ 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
House rentals in Wauconda Illinois and home rentals in Wauconda Illinois
Rental homes in Elk Grove Illinois, home rentals in Elk Grove Illinois, and Elk Grove Illinois rental home
Rental houses in Jarvis Illinois, condos for rent Jarvis Illinois, Jarvis Illinois rent house, and home rentals Jarvis Illinois
Vacation homes for rent by owner Du Page Illinois and Du Page Illinois for rent by owner homes
Harlem Illinois real estate rentals, home rentals in Harlem Illinois, and vacation homes for rent by owner Harlem
Waukegan Illinois home rentals, Waukegan apartment rentals, rental home Waukegan, and Waukegan apartment rentals
Apartment rentals and Flagg Illinois apartments for rent
Vacation rental Elgin, Elgin Illinois real estate rentals, and apartment rentals Elgin
Roscoe Illinois rent houses, vacation homes for rent by owner Roscoe, homes for rent in Roscoe, and Roscoe Illinois rental home
Home rentals in South Rock Island Illinois and houses for rent South Rock Island
Homes for rent by owner in Bloomington City Illinois, condos for rent, and homes for rent by owner Bloomington City Illinois
Hickory Point Illinois houses for rent, rental apartment in Hickory Point Illinois, short term rentals in Hickory Point Illinois, and Hickory Point Illinois rental houses
Champaign City bed and breakfast rentals and rental houses in Champaign City
Vacation rentals in Freeport Illinois, Freeport short term rentals, and Freeport Illinois rental apartment
West Deerfield Illinois apartments for rent, rental apartment West Deerfield Illinois, West Deerfield Illinois house rentals, and holiday rentals
Rental apartment and Rantoul Illinois apartment rentals
Apartment rentals Joliet Illinois, Joliet Illinois real estate rentals, and rental houses Joliet
Mount Vernon house rentals, homes for rent, Mount Vernon Illinois apartments for rent, and short term rentals in Mount Vernon Illinois
Vacation rentals Quincy and Quincy Illinois condos for rent
Vacation homes in Bourbonnais, Bourbonnais Illinois rental houses, and apartments for rent in Bourbonnais
Godfrey Illinois short term rentals, Godfrey Illinois vacation homes for rent by owner, apartments for rent in Godfrey, and vacation homes Godfrey Illinois
Collinsville rental home and vacation homes
Homes for rent by owner, apartment rentals, and holiday rentals
Centreville Illinois for rent by owner homes, homes for rent, homes for rent by owner Centreville Illinois, and vacation homes Centreville Illinois
Schaumburg Illinois rent house and Schaumburg Illinois apartment rentals
Libertyville vacation homes for rent by owner, vacation rental Libertyville, and vacation homes for rent by owner
Long Creek Illinois house rentals, vacation homes in Long Creek Illinois, vacation homes in Long Creek Illinois, and Long Creek Illinois home rentals
Vacation rentals and Harlem Illinois rental home
Invent and notice vacation homes Danville and Danville United States rental properties.
Lisle agents and landlords list for rent by owner homes in Lisle Illinois, bed and breakfast rentals Lisle Illinois, and rental apartment in Lisle Illinois.
Find out, devise, and elicit rental home in Henning, Henning United States real estate rentals, and homes for rent in Henning United States.
Dig up and identify vacation rental in Hennepin United States and rent house in Hennepin.
Join our hillside directories, penthouse ad directories, and convenient classified advertisements mailing list for vacation homes in Lisle Illinois and apartment rentals Lisle Illinois.
Move, detect, and discover Waggoner United States apartment rentals, rental properties Waggoner United States, and Waggoner United States rental apartment.
Perceive, distinguish, and originate rental houses in Champaign Illinois, homes for rent in Champaign Illinois, and Champaign Illinois vacation rentals.
Home rentals in Cliffside Park New Jersey, Cliffside Park New Jersey condos for rent, and houses for rent in Cliffside Park New Jersey
Come across, perceive, and perceive short term rentals, Roxana United States for rent by owner homes, and Roxana house rentals.
Sightseers and locals scour, ferret, and shake down our for rent by owner site, FRBO.com and notice beachfront flat and convenient timeshare.
Lisle Illinois township employs many third party agents, third party agents, town home owners, and property managers.
The Lisle rustic classified ads and spacious ad directories for these precinct can be mapped.
Light upon, catch, and detect Sherman United States holiday rentals, Sherman rental properties, and Sherman for rent by owner homes.
Catch, perceive, and notice the section and immediate Lisle Illinois patch.
Elicit, hear, and relocate East Galesburg United States condos for rent, house rentals, and rental homes in East Galesburg.
Oviedo Florida rental properties, condos for rent, house rentals in Oviedo, and rental homes in Oviedo
Rustic indexes and beach directories vacation rental in Washington, rental apartment in Washington, houses for rent Washington, and apartment rentals.
Travelers, adventurers, and trippers who are scouring Lisle Illinois real estate rentals and are trying to catch rental homes in Lisle and rental apartment can scrutinize this website, FRBO.com and our spacious classified ads, suburban listed properties, waterfront online MLS, and penthouse listings.
Discern and uncover vacation rentals in DeKalb and DeKalb vacation homes for rent by owner.
Uncover and dig up Jo Daviess Illinois house rentals and vacation homes for rent by owner in Jo Daviess Illinois.
Discern, locate, and distinguish short term rentals, rental home in Marshall, short term rentals Marshall, and Marshall house rentals.
Lisle is a sightly, ideal, and grand township with admirable, delicate, superb, and foxy lodge, cabin, and ranchs.
Come across and invent apartment rentals and Bardolph condos for rent.
Dig up and find Mound City United States apartments for rent and rent house Mound City.
Come across singular, special, and rare info in Lisle and schedule Lisle Illinois bed and breakfast rentals.
Notice and observe Matteson United States rental properties and short term rentals Matteson.
FRBO.Com, For Rent By Owner, comprises neighborhood, zone, field, and township figures, usually.
|
|
