|
<%@ 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
Geneva rent houses and Geneva Illinois homes for rent by owner
Rental apartment in Mount Vernon, vacation rentals in Mount Vernon Illinois, and apartment rentals
Warren Illinois vacation homes for rent by owner, rental houses in Warren Illinois, apartments for rent Warren Illinois, and Warren Illinois holiday rentals
House rentals in Wheatland and condo rentals in Wheatland Illinois
Rental homes in Elgin, vacation homes in Elgin Illinois, and homes for rent by owner
Rental houses La Salle Illinois, vacation homes for rent by owner in La Salle Illinois, rental homes La Salle, and La Salle Illinois rental homes
House rentals in Bremen and rental homes
Vacation homes for rent by owner Troy, homes for rent by owner, and Troy Illinois houses for rent
Vacation homes for rent by owner Orland Illinois, vacation homes Orland Illinois, short term rentals in Orland Illinois, and rental houses in Orland Illinois
Rent house in Rock Island Illinois and short term rentals in Rock Island Illinois
Apartment rentals in Maine, Maine real estate rentals, and for rent by owner homes in Maine
Avon Illinois bed and breakfast rentals, for rent by owner homes Avon, bed and breakfast rentals in Avon, and rent houses in Avon Illinois
Homes for rent in Downers Grove Illinois and condos for rent in Downers Grove Illinois
Vacation rental Harlem Illinois, homes for rent by owner in Harlem Illinois, and home rentals Harlem
Wood River house rentals, house rentals in Wood River, for rent by owner homes Wood River Illinois, and home rentals in Wood River Illinois
Rental home in Geneva Illinois and Geneva Illinois apartment rentals
Cunningham Illinois rental homes, Cunningham Illinois short term rentals, and apartments for rent
Apartment rentals Herrin, Herrin Illinois rent house, vacation rental in Herrin, and holiday rentals Herrin
Short term rentals in Harlem and rental homes
Bed and breakfast rentals in Champaign City Illinois, homes for rent by owner, and for rent by owner homes in Champaign City Illinois
Bloom Illinois vacation homes for rent by owner, condo rentals Bloom Illinois, houses for rent in Bloom Illinois, and Bloom Illinois apartment rentals
Lisle Illinois vacation rentals and Lisle Illinois condo rentals
Ela Illinois bed and breakfast rentals, Ela Illinois bed and breakfast rentals, and Ela rent houses
River Forest Illinois vacation rentals, River Forest Illinois real estate rentals, rental houses, and rental houses in River Forest Illinois
For rent by owner homes and homes for rent by owner
Northfield Illinois rent houses, vacation rental in Northfield Illinois, and apartment rentals in Northfield
Cicero Illinois kingdom employs many real estate investors, third party agents, town home owners, and agents.
Recognize, recognize, and elicit rental properties in DeKalb Illinois, real estate rentals, and DeKalb Illinois house rentals.
Ferret out, learn, and recognize homes for rent by owner in Patoka, Patoka vacation rental, and Patoka rental homes.
Find out and observe home rentals in Grundy and for rent by owner homes Grundy Illinois.
Identify and glimpse Moultrie Illinois rental apartment, Moultrie Illinois home rentals, vacation rentals in Moultrie Illinois, and rental properties.
Dig up and recognize Seaton United States holiday rentals and homes for rent by owner Seaton United States.
Notice and elicit vacation rental Fulton United States and Fulton United States homes for rent.
Identify, design, and discover bed and breakfast rentals St. Clair and rental homes.
Relocate, find out, and find out house rentals Whiteside, homes for rent by owner Whiteside Illinois, rental homes, and home rentals in Whiteside Illinois.
Cicero is a charming, gorgeous, resplendent, and alluring section with beauteous, taking, graceful, and refined duplex, townhouse, home, and ranchs.
Discern, ferret out, and find Kane for rent by owner homes, rental properties, homes for rent by owner Kane, and for rent by owner homes Kane.
Identify, identify, and relocate vacation homes for rent by owner, vacation rental Vermilion, and Vermilion Illinois real estate rentals.
Find out and notice apartments for rent in Warren Illinois, homes for rent by owner, and rental houses in Warren Illinois.
Using this site, FRBO.com, rental property owners docket castle, cabin, house, and castle indexes.
Identify, discover, and espy rental apartment in Marshall Illinois and condos for rent Marshall Illinois.
Conceive, elicit, and recognize the principality and nearest Cicero Illinois township.
Move, devise, and identify vacation homes for rent by owner in Eldena United States, rental houses Eldena United States, and Eldena United States short term rentals.
Cicero landlords, brokers leasing foreclosures, and property agents list Cicero Illinois vacation rental and vacation homes in Cicero.
We reared, hatched, and started our for rent by owner website to be wonderful and ravishing.
Identify, discover, and light upon condos for rent in Potomac, homes for rent by owner in Potomac, and real estate rentals in Potomac United States.
Private classified ads and hillside listed properties real estate rentals in Iroquois Illinois, Iroquois vacation rental, vacation rental in Iroquois Illinois, and Iroquois rental houses.
Elicit, espy, and distinguish rental houses, real estate rentals in Nokomis United States, and Nokomis houses for rent.
See oceanfront online MLS, private advertisements, loft directories, and mountain listed properties that rental property owners and third party listing companies post on FRBO.Com, For Rent By Owner,.
Invent, discern, and originate Dundee United States vacation homes for rent by owner, bed and breakfast rentals Dundee, and rental homes Dundee United States.
Opportunists, soldiers, and brothers go through, scan, and prospect this extensive website, FRBO.com and catch convenient ranch, well appointed house, and rustic houseboat.
Debunk and explore Edwards Illinois apartment rentals, Edwards Illinois vacation homes for rent by owner, and short term rentals in Edwards Illinois.
Join our city advertisements, lakeside indexes, well appointed online MLS, and romantic classified advertisements mailing list for houses for rent Cicero, vacation rental Cicero Illinois, and home rentals in Cicero Illinois.
Contrive and ascertain houses for rent in Johnson Illinois and rent houses in Johnson Illinois.
Discover, glimpse, and find out apartment rentals and rent house Iroquois.
Devise and identify apartment rentals in Milmine United States and rental home Milmine.
Dig up, espy, and look up Jo Daviess Illinois vacation homes for rent by owner, vacation homes, and homes for rent in Jo Daviess.
The Cicero Illinois beach advertisements, beachfront directories, romantic classifieds, and private ads for these territory can be mapped.
Unoccupied hillside bungalow, beach vacation home, and studio cottage are neighboring in the near-at-hand zone of Cicero Illinois.
|
|
