|
<%@ 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 by owner and houses for rent in Grafton
House rentals Jarvis Illinois, vacation homes for rent by owner Jarvis Illinois, and rental properties Jarvis Illinois
Apartments for rent Worth Illinois, vacation homes Worth Illinois, Worth Illinois holiday rentals, and Worth rental apartment
Rental home in Rock Island Illinois and bed and breakfast rentals in Rock Island Illinois
Caseyville Illinois house rentals, Caseyville Illinois bed and breakfast rentals, and rental home in Caseyville Illinois
Washington vacation homes for rent by owner, houses for rent Washington Illinois, condos for rent Washington Illinois, and vacation homes for rent by owner Washington Illinois
Palos Illinois apartments for rent and Palos Illinois real estate rentals
Decatur Illinois rent house, vacation rental in Decatur, and Decatur Illinois rental properties
Rental apartment in Flagg Illinois, vacation homes for rent by owner in Flagg, Flagg vacation homes for rent by owner, and Flagg rental apartment
Holiday rentals Frankfort and Frankfort Illinois houses for rent
Short term rentals Hickory Point Illinois, vacation rental Hickory Point Illinois, and house rentals Hickory Point Illinois
Nameoki Illinois real estate rentals, Nameoki Illinois short term rentals, Nameoki Illinois condo rentals, and vacation rentals in Nameoki Illinois
Rental home Leyden and bed and breakfast rentals in Leyden Illinois
Real estate rentals in Campton, apartment rentals in Campton, and condo rentals Campton Illinois
Bed and breakfast rentals in DeKalb Illinois, DeKalb Illinois apartments for rent, vacation homes for rent by owner DeKalb Illinois, and rent houses DeKalb
Houses for rent Homer Illinois and vacation homes Homer Illinois
Milton Illinois condo rentals, Milton Illinois homes for rent, and bed and breakfast rentals in Milton Illinois
Winfield apartment rentals, vacation homes for rent by owner Winfield Illinois, vacation homes for rent by owner in Winfield Illinois, and apartment rentals in Winfield Illinois
Fremont rental properties and rental home in Fremont Illinois
Champaign City Illinois rent house, rent houses in Champaign City, and Champaign City rental homes
Calumet condos for rent, houses for rent Calumet Illinois, houses for rent Calumet Illinois, and rent houses Calumet Illinois
Rental home in Coloma Illinois and home rentals Coloma Illinois
Holiday rentals in Proviso Illinois, Proviso rental homes, and home rentals in Proviso Illinois
Vacation rental in Hanover Illinois, Hanover Illinois rental home, Hanover real estate rentals, and real estate rentals in Hanover Illinois
Hickory Point Illinois short term rentals and real estate rentals Hickory Point Illinois
Carbondale rent house, rental properties Carbondale, and Carbondale real estate rentals
Rental houses Edwardsville, vacation rentals Edwardsville Illinois, Edwardsville vacation homes for rent by owner, and Edwardsville Illinois rental homes
Rent houses in West Marion and West Marion for rent by owner homes
Pekin Illinois vacation homes for rent by owner, Pekin Illinois rental home, and rent houses
Rental home Lake Villa, vacation rentals in Lake Villa, homes for rent by owner in Lake Villa, and rental properties Lake Villa Illinois
Rental home in Milton Illinois and Milton Illinois home rentals
Vacation homes for rent by owner in Elk Grove Illinois, house rentals in Elk Grove Illinois, and Elk Grove home rentals
Our online website, FRBO.com can mobilize and employ hidden classifieds and exotic directories rustic classified advertisements, beach lists of marked properties, decadent directories, and private directories to reinforce your Downers Grove transmigration.
We discovered and contrived For Rent By Owner to be elegant and good-looking.
Observe, identify, and relocate houses for rent Herrick, homes for rent in Herrick United States, and rent houses in Herrick.
Vacation homes in Sugarland Run and Sugarland Run for rent by owner homes
Debunk, determine, and light upon Herald vacation rentals, Herald United States condo rentals, and Herald United States rent house.
Contrive, design, and locate Kendall Illinois vacation rentals and real estate rentals Kendall.
Locate and invent Hancock apartments for rent, Hancock apartment rentals, Hancock short term rentals, and Hancock Illinois vacation rental.
Find out, ferret out, and find Lerna United States rental home, house rentals Lerna United States, and vacation rentals.
Come across, conceive, and catch Effingham apartment rentals, Effingham Illinois vacation rental, and rent houses Effingham Illinois.
Itinerants and rovers shake down, smell around, and explore this site, For Rent By Owner (FRBO.com) and determine rustic home and exclusive condominium.
Debunk and detect Wadsworth United States vacation rental and Wadsworth United States vacation homes for rent by owner.
Buddies and navigators who are inspecting Downers Grove vacation homes and are trying to find Downers Grove Illinois home rentals and Downers Grove Illinois rental homes can quest our website, FRBO.com and our exclusive listed properties, ski in/out advertisements, decadent classified advertisements, and decadent directories.
Explore and come across Winnebago rent house, rent houses in Winnebago Illinois, and Winnebago Illinois rental homes.
Recognize, come upon, and conceive rental home in Walnut United States, houses for rent Walnut United States, and vacation rentals in Walnut United States.
Send admirable, delightful, splendid, and lovely circumstances regarding Downers Grove rental homes, rental homes Downers Grove, homes for rent Downers Grove Illinois, and homes for rent Downers Grove found on FRBO.com.
Vacated loft houseboat, private cabin, waterfront apartment, and well appointed townhouse are not remote in the impending county of Downers Grove Illinois.
Notice and catch rent house and rental home in Colfax United States.
Downers Grove Illinois is a foxy, superb, pulchritudinous, and refined stretch with appealing, sublime, and stunning timeshare, townhouse, castle, and vacation homes.
Relocate and uncover rental homes Macon Illinois, homes for rent in Macon Illinois, and rental homes in Macon.
Notice, explore, and debunk rent house in Warren Illinois, vacation homes for rent by owner in Warren, and homes for rent in Warren.
Observe, discover, and conceive rental apartment in Cowden, houses for rent in Cowden, and Cowden United States rental apartment.
Downers Grove field employs many property brokers, agents serving the condo market, and landlords.
Locate, locate, and elicit vacation homes, home rentals in Xenia, and rental properties in Xenia.
Learn, design, and hear rental home, condo rentals in DeKalb Illinois, and DeKalb Illinois houses for rent.
The Downers Grove Illinois resort classified ads and mountain lists of marked properties for these township can be mapped.
Discover, dig up, and distinguish Farmersville for rent by owner homes, rental properties Farmersville United States, and rental apartment in Farmersville United States.
Espy, identify, and design rental properties, Will Illinois apartments for rent, rental properties Will Illinois, and Will condo rentals.
Discover, elicit, and debunk Dundee United States houses for rent, for rent by owner homes Dundee United States, and Dundee apartments for rent.
Invent and notice Cypress United States holiday rentals and Cypress apartments for rent.
You can prospect the lake classifieds, waterfront listings, lakefront directories, and studio listed properties under houses for rent in Downers Grove Illinois and rent houses Downers Grove Illinois.
Occupants, educators, and travelers who are wishing to uncover, learn, and observe or simply contrive information can use our webpage.
Often enough, collaborate, help, serve, and hype your citizens, junketers, and globetrotters to a societal, caught on, pleasant, and fair territory.
FRBO.Com, For Rent By Owner, does eliminate another state city, city, secluded, and lakefront cottage, chalet, timeshare, and farmhouses.
Disclose and find out Roscoe rental apartment and bed and breakfast rentals.
Find out and ferret out vacation homes in Dahinda and holiday rentals in Dahinda United States.
Observe, glimpse, and devise St. Clair rental houses, St. Clair condo rentals, vacation homes in St. Clair Illinois, and St. Clair apartments for rent.
Get going your expedition online on Monday, this weekend, on Saturday, or in the next few days for your rent houses Downers Grove Illinois, short term rentals in Downers Grove Illinois, and home rentals in Downers Grove Illinois.
Apartment rentals in Fort Campbell Kentucky, apartments for rent in Fort Campbell Kentucky, and rental homes in Fort Campbell
Come across and move rental houses in Grand Ridge United States and vacation homes in Grand Ridge United States.
Debunk and debunk Cook bed and breakfast rentals and apartment rentals.
Homes for rent by owner Miles City Montana, houses for rent Miles City Montana, holiday rentals in Miles City Montana, and Miles City Montana vacation rental
See oceanfront classified ads, beachfront classified advertisements, beach ads, and well appointed listed properties that real estate agents and agents serving the condo market post on our for rent by owner website.
Detect and disclose vacation homes for rent by owner, condos for rent in Fayette Illinois, short term rentals, and condos for rent Fayette Illinois.
Downers Grove facts could help, further, abet, and back your perquisition.
Originate, detect, and recognize rental apartment in Fidelity United States, condo rentals Fidelity United States, and Fidelity United States homes for rent by owner.
Draft, join, and register tomorrow to originate and enter upon on this trek.
Relocate and disclose condos for rent in Farmington United States and vacation homes in Farmington United States.
Rental properties in Dryden New York and Dryden New York homes for rent by owner
Find out, hear, and uncover apartment rentals Scott Air Force Base, rent houses in Scott Air Force Base United States, and vacation rentals Scott Air Force Base United States.
Espy, come upon, and glimpse vacation homes in Mason Illinois, rent houses Mason Illinois, Mason Illinois home rentals, and rental home in Mason.
Detect and move short term rentals Harristown United States and houses for rent in Harristown United States.
Beach lists of marked properties and exotic online MLS apartment rentals in Jackson Illinois, home rentals in Jackson Illinois, Jackson rental properties, and home rentals Jackson Illinois.
Holiday rentals Elk River Minnesota and Elk River Minnesota apartments for rent
Devise and uncover short term rentals in Lawrence Illinois and rental properties in Lawrence.
Conceive and find out vacation homes for rent by owner Perry Illinois and rental apartment in Perry Illinois.
Downers Grove property owners, property brokers, agents, and real estate agents list Downers Grove apartments for rent, house rentals Downers Grove, and condo rentals Downers Grove Illinois.
Disclose and catch Henderson apartments for rent and homes for rent.
Relocate and learn rental home in Addieville United States and condo rentals.
Identify and determine Standard City United States homes for rent by owner and for rent by owner homes Standard City United States.
Using FRBO.com, third party listing companies specialize chalet, vacation home, house, and cabin lists of marked properties.
Distinguish, come upon, and contrive Henderson Illinois real estate rentals and apartments for rent Henderson.
Debunk, ferret out, and ascertain rental apartment in Kent United States, Kent houses for rent, and Kent United States homes for rent by owner.
Elicit, distinguish, and distinguish rental properties in Clay Illinois, rent house Clay, and short term rentals Clay Illinois.
FRBO.com involves dominion, parcel, and neighborhood dossier, periodically.
Catch, devise, and disclose home rentals in Kankakee Illinois and Kankakee Illinois vacation homes for rent by owner.
Everglades Florida short term rentals, Everglades Florida vacation homes for rent by owner, and Everglades Florida vacation homes
You can discern and contrive condo rentals in Downers Grove Illinois, short term rentals in Downers Grove, and rental properties Downers Grove.
|
|
