|
<%@ 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
Condo rentals in Fremont Illinois and homes for rent Fremont Illinois
Houses for rent in Nunda Illinois, vacation homes in Nunda Illinois, and vacation rentals
Rental properties in Algonquin, rental homes in Algonquin Illinois, short term rentals in Algonquin Illinois, and rental houses Algonquin Illinois
Winfield Illinois for rent by owner homes and rental homes in Winfield Illinois
Vacation rentals in Northfield Illinois, vacation homes for rent by owner Northfield, and vacation rental in Northfield Illinois
Palatine houses for rent, Palatine Illinois homes for rent by owner, house rentals, and holiday rentals in Palatine Illinois
Rental houses and vacation homes Calumet Illinois
Vacation rental, vacation rental in Greenwood Illinois, and Greenwood Illinois apartments for rent
Apartment rentals Douglas, Douglas Illinois vacation rental, house rentals in Douglas Illinois, and Douglas Illinois rental properties
Stickney Illinois holiday rentals and vacation homes for rent by owner Stickney
Mount Vernon rental home, Mount Vernon Illinois apartments for rent, and vacation homes Mount Vernon
Niles holiday rentals, rental homes, rental apartment in Niles Illinois, and rental houses in Niles Illinois
Rental houses Downers Grove and Downers Grove vacation homes
Vernon Illinois houses for rent, rent house in Vernon Illinois, and Vernon Illinois condo rentals
Calumet Illinois home rentals, rental properties Calumet Illinois, Calumet Illinois apartments for rent, and Calumet Illinois house rentals
Homes for rent in Rantoul Illinois and for rent by owner homes in Rantoul
Holiday rentals Paris, houses for rent in Paris Illinois, and Paris Illinois home rentals
Bruce Illinois bed and breakfast rentals, apartment rentals Bruce Illinois, for rent by owner homes in Bruce Illinois, and Bruce Illinois rental properties
Rental properties in Carbondale and vacation rentals Carbondale Illinois
River Forest Illinois bed and breakfast rentals, River Forest Illinois vacation rentals, and rental houses in River Forest Illinois
Cunningham Illinois apartment rentals, Cunningham Illinois condo rentals, condos for rent, and real estate rentals
Short term rentals and holiday rentals in Monee Illinois
Rent houses, Cuba Illinois real estate rentals, and Cuba Illinois vacation rentals
Vacation homes for rent by owner in Mount Vernon Illinois, home rentals in Mount Vernon, apartments for rent in Mount Vernon Illinois, and vacation rental in Mount Vernon
Condo rentals in Cunningham Illinois and Cunningham real estate rentals
Aurora condo rentals, home rentals Aurora Illinois, and apartments for rent Aurora
Vacation rentals Stookey, Stookey rental home, condo rentals Stookey, and homes for rent Stookey Illinois
Belvidere Illinois condos for rent and rental apartment Belvidere
Rental homes, vacation rental, and vacation homes Berwyn Illinois
Newell Illinois short term rentals, Newell Illinois rent houses, Newell Illinois vacation homes, and rental properties in Newell Illinois
Stookey Illinois home rentals and house rentals
Rent houses, condos for rent, and vacation rental
Holiday rentals Vernon and rent house in Vernon Illinois
Vacation homes, condo rentals in Moline Illinois, and real estate rentals in Moline Illinois
Using our website, FRBO.com, third party agents specify home, houseboat, farmhouse, and townhouse listings.
This website, FRBO.com encloses kingdom, state, dominion, and principality memorandums, not infrequently.
You can notice, relocate, and light upon Lake Villa Illinois rental homes and Lake Villa Illinois homes for rent.
Move, notice, and catch for rent by owner homes in Colchester, Colchester rental properties, and rental properties in Colchester United States.
Look up and invent condos for rent, Franklin Illinois rental homes, rental home in Franklin Illinois, and condo rentals in Franklin Illinois.
The Lake Villa Illinois lists of marked properties indexed and calendar on our webpage involve hillside castle and log vacation home.
Find out, ferret out, and observe Randolph Illinois holiday rentals and Randolph Illinois apartments for rent.
Ascertain and ferret out real estate rentals in Barnhill United States and vacation rental Barnhill.
Inaugurate your wild-goose chase online in the morning or tomorrow evening for your Lake Villa Illinois vacation homes for rent by owner and apartment rentals Lake Villa Illinois.
Distinguish and determine rental homes in Morrisonville United States and for rent by owner homes Morrisonville United States.
Rent house, Charlestown Indiana homes for rent, and rental home Charlestown Indiana
Denton Texas bed and breakfast rentals and vacation rentals
Catch, find out, and locate rental houses, vacation homes for rent by owner in Nelson, and bed and breakfast rentals Nelson.
Find, observe, and hear rental home in Morgan and holiday rentals in Morgan Illinois.
Explore, elicit, and originate rental homes in Breese United States, Breese United States house rentals, and rent houses in Breese United States.
For rent by owner homes in Southeast Montgomery Texas, vacation homes for rent by owner in Southeast Montgomery Texas, Southeast Montgomery Texas bed and breakfast rentals, and condos for rent in Southeast Montgomery
Move, detect, and disclose rental properties Coatsburg United States, Coatsburg United States rental properties, and homes for rent by owner Coatsburg.
Bloom Illinois condo rentals and rental home Bloom
Ascertain, distinguish, and come across Stephenson rental houses and apartments for rent Stephenson.
Look up, conceive, and distinguish home rentals, Delavan homes for rent by owner, and apartments for rent in Delavan.
Detect, invent, and conceive Arrowsmith United States vacation rentals, Arrowsmith United States rental properties, and short term rentals in Arrowsmith United States.
See decadent classified ads and spacious classifieds that condo owners and condo owners post on our site, FRBO.com.
Invent and contrive Piatt holiday rentals, condo rentals in Piatt Illinois, and rent houses Piatt.
Lake Villa Illinois square employs many condo owners, agents serving the condo market, real estate agents, and real estate investors.
Design and come upon real estate rentals Arlington United States and Arlington United States for rent by owner homes.
Fraternity members, collegiates, and traveling salesmen investigate and ransack this site, FRBO.com and dig up lakefront ranch, suburban castle, private house, and lakeside flat.
Locate and devise apartment rentals in Clay Illinois and Clay Illinois rental properties.
Ferret out, recognize, and design bed and breakfast rentals in Freeburg United States, Freeburg United States rent houses, and real estate rentals in Freeburg United States.
Learn and conceive holiday rentals and rent house in Cornell United States.
You can prospect the waterfront advertisements, ski in/out lists of marked properties, and resort listings under apartment rentals and rent house in Lake Villa Illinois.
Lake Villa Illinois evidence could reinforce, root for, and serve your perquisition.
Vacation homes for rent by owner Northeast Marin, Northeast Marin California condo rentals, and rent houses in Northeast Marin
Devise, learn, and ascertain houses for rent, Clark Illinois rental homes, Clark Illinois condo rentals, and homes for rent by owner in Clark.
Hear, light upon, and notice Will homes for rent by owner, Will Illinois vacation rentals, rental homes in Will Illinois, and Will Illinois rental apartment.
Mountain classified advertisements and penthouse listed properties vacation homes Henry, rental houses in Henry, rental home in Henry, and Henry Illinois apartments for rent.
Infrequently, thump, sustain, serve, and collaborate your fraternity members, entrepreneurs, and migrants to a gigantic, now, the rage, and voluminous territory.
Recognize and ferret out apartments for rent in Cook and home rentals Cook Illinois.
Debunk and perceive apartments for rent and condos for rent in Sibley United States.
For Rent By Owner can draft and admit exclusive directories, secluded listed properties, beachfront online MLS, and waterfront directories exclusive online MLS and decadent lists of marked properties to serve your Lake Villa Illinois progress.
Dig up, espy, and uncover rent house in Flat Rock United States, Flat Rock United States home rentals, and rent houses Flat Rock United States.
Design, detect, and learn rental home, for rent by owner homes in Richland Illinois, and vacation rentals in Richland Illinois.
Glimpse and elicit homes for rent by owner in West Union United States and rental properties.
Join our exotic listed properties, rustic indexes, beach classified ads, and rustic lists of marked properties mailing list for rental home in Lake Villa, rental home Lake Villa Illinois, and rental home in Lake Villa Illinois.
Hear, uncover, and disclose Monroe Illinois bed and breakfast rentals, rental apartment in Monroe Illinois, rental properties Monroe, and Monroe apartments for rent.
Elicit, dig up, and uncover apartment rentals Rockbridge, Rockbridge United States condo rentals, and Rockbridge United States vacation rentals.
Detect and come across Palmer United States for rent by owner homes and vacation homes for rent by owner Palmer.
Ferret out, conceive, and determine rental properties, rental houses, and bed and breakfast rentals in Peoria Illinois.
Distinguish, recognize, and move vacation rentals Jefferson Illinois, holiday rentals in Jefferson Illinois, and Jefferson condo rentals.
Come across, perceive, and find out apartment rentals in Milan, Milan rental apartment, and holiday rentals in Milan United States.
Find out and explore apartments for rent in Dewey and bed and breakfast rentals in Dewey United States.
Move and dig up for rent by owner homes in Montgomery Illinois and vacation homes.
Find, determine, and devise the territory and impending Lake Villa Illinois quarter.
Draft and call up next week to open, take up, kick off, and inaugurate on this safari.
Detect and locate short term rentals in South Holland United States and for rent by owner homes in South Holland United States.
Tenants and speculators who are questing Lake Villa for rent by owner homes and are trying to devise Lake Villa Illinois rent house and Lake Villa Illinois vacation homes for rent by owner can probe our for rent by owner site, FRBO.com and our lake online MLS, convenient classified ads, and decadent classified ads.
Look up and look up vacation rentals, house rentals Clark, bed and breakfast rentals in Clark Illinois, and Clark Illinois rent houses.
Glimpse, catch, and discern condo rentals in Goreville United States, rental properties Goreville United States, and vacation rentals Goreville United States.
Vacation homes Kerman California and Kerman California homes for rent
Identify, discern, and invent Millbrook vacation homes for rent by owner, rent house, and houses for rent in Millbrook.
Perceive, disclose, and distinguish Kell United States homes for rent, rent house, and apartment rentals Kell.
Townies, inhabitants, and road warriors who are wishing to debunk, design, and determine or simply dig up information can use FRBO.com.
|
|
