|
<%@ 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
Rockton rent houses and Rockton Illinois rental apartment
Vacation rentals, Rich Illinois rental homes, and vacation homes in Rich Illinois
Crete Illinois vacation homes for rent by owner, home rentals in Crete Illinois, short term rentals Crete, and short term rentals
Rent houses and for rent by owner homes in Du Page
Bed and breakfast rentals Palos, homes for rent Palos Illinois, and house rentals Palos
Rental apartment in Rantoul, Rantoul rental home, short term rentals, and holiday rentals
Real estate rentals Shiloh Valley Illinois and rent houses Shiloh Valley Illinois
Rent house in Ottawa Illinois, Ottawa rent house, and vacation rental Ottawa
Freeport Illinois rent houses, vacation rental, holiday rentals Freeport Illinois, and bed and breakfast rentals in Freeport Illinois
Rental properties in Rantoul and rental homes Rantoul Illinois
Monee Illinois rental properties, Monee Illinois houses for rent, and Monee Illinois apartments for rent
Decatur vacation homes for rent by owner, Decatur Illinois apartments for rent, Decatur Illinois bed and breakfast rentals, and rent house Decatur Illinois
Short term rentals in Bloomington City Illinois and Bloomington City Illinois holiday rentals
Homes for rent by owner in Campton, Campton Illinois vacation rentals, and house rentals in Campton Illinois
Fondulac Illinois rental houses, vacation homes for rent by owner in Fondulac Illinois, rental houses Fondulac Illinois, and short term rentals Fondulac
Bed and breakfast rentals and home rentals
St Charles home rentals, apartment rentals in St Charles Illinois, and vacation rentals in St Charles Illinois
Nunda rental home, Nunda Illinois apartments for rent, Nunda Illinois rent houses, and homes for rent by owner in Nunda Illinois
Rental home and rent houses Normal Illinois
Apartment rentals Collinsville, Collinsville Illinois rental properties, and apartments for rent in Collinsville
Vacation rental in Fondulac Illinois, homes for rent by owner, Fondulac bed and breakfast rentals, and Fondulac Illinois house rentals
Centreville Illinois rental properties and Centreville condo rentals
Houses for rent in Oak Park, short term rentals in Oak Park Illinois, and Oak Park Illinois vacation homes
Vacation homes for rent by owner in Rock Island Illinois, vacation rentals Rock Island, house rentals Rock Island, and real estate rentals
Short term rentals and rental houses
Rent house in Antioch Illinois, apartments for rent in Antioch, and Antioch rental houses
Homes for rent St Charles, homes for rent in St Charles, house rentals in St Charles Illinois, and bed and breakfast rentals in St Charles Illinois
Apartment rentals and Shiloh Valley short term rentals
Homes for rent Canteen, rental apartment Canteen Illinois, and for rent by owner homes
Rental homes in Champaign, condo rentals in Champaign, homes for rent by owner, and Champaign Illinois rental properties
Kewanee apartments for rent and vacation homes
Houses for rent in Orland Illinois, Orland Illinois home rentals, and Orland Illinois holiday rentals
Vacation homes in Canton Illinois and Canton rent houses
Bed and breakfast rentals, Rantoul Illinois real estate rentals, and bed and breakfast rentals in Rantoul Illinois
Invent, detect, and distinguish apartment rentals Loami United States, house rentals in Loami United States, and rental homes Loami United States.
Ferret out and espy Perry Illinois rental home and vacation rentals.
Find, espy, and discover Virginia United States rental apartment, rent houses in Virginia United States, and bed and breakfast rentals in Virginia United States.
Townies and globetrotters who are wishing to catch and come upon or simply espy information can use our page.
Grafton Illinois evidence could aid, reinforce, and back your examination.
Attract, incorporate, and enroll on Wednesday to originate and get cracking on this crossing.
Disclose and find out Morris United States houses for rent and vacation rentals in Morris.
Vacated suburban castle, lakefront home, and private timeshare are contiguous in the contiguous parcel of Grafton Illinois.
Design discrete, novel, unique, and startling evidence in Grafton and tick off rental home.
Discern, contrive, and discover bed and breakfast rentals in Gardner, Gardner rental houses, and apartments for rent Gardner United States.
FRBO.com can hire, serve, induct, and initiate waterfront online MLS, penthouse online MLS, lake classified advertisements, and log ads beach advertisements, rustic ads, oceanfront directories, and lakeside directories to assist your Grafton migration.
Using this extensive website, FRBO.com, property agents tick off houseboat and flat indexes.
Distinguish and observe rental homes Scott Illinois and vacation rental in Scott Illinois.
Discover and originate holiday rentals in Fillmore United States and vacation homes for rent by owner in Fillmore United States.
Blountville Tennessee rental apartment and Blountville houses for rent
Notice, espy, and come across homes for rent by owner in Literberry United States, Literberry rental home, and condo rentals.
We invested and conceived our website, FRBO.com to be alluring, divine, handsome, and cute.
Grafton agents serving the condo market and agents list Grafton rental apartment, Grafton Illinois holiday rentals, and Grafton Illinois bed and breakfast rentals.
Observe, come across, and dig up Richland houses for rent and rental home Richland.
Send handsome and ravishing figures regarding house rentals in Grafton Illinois, real estate rentals in Grafton, and Grafton Illinois homes for rent found on this site, FRBO.com.
North Royalton holiday rentals, apartment rentals in North Royalton Ohio, and apartments for rent in North Royalton
Holiday rentals in Pittsburgh and rental apartment Pittsburgh Pennsylvania
Decadent classified advertisements and suburban online MLS Saline vacation rental, homes for rent in Saline Illinois, Saline Illinois homes for rent, and houses for rent in Saline.
Find out, recognize, and notice rental houses in Clay, houses for rent Clay, and Clay Illinois vacation homes.
Come upon and conceive rental home Hudson and Hudson United States rental homes.
Detect, distinguish, and devise Shelby Illinois real estate rentals and homes for rent by owner.
Identify, find out, and elicit rental homes Morgan Illinois, vacation homes for rent by owner, vacation rentals Morgan, and condo rentals in Morgan Illinois.
See secluded classified advertisements, exclusive lists of marked properties, log listings, and beach classified ads that rental property owners and condo owners post on this site, For Rent By Owner (FRBO.com).
Houses for rent Millington Tennessee, vacation rental Millington Tennessee, house rentals in Millington Tennessee, and home rentals Millington
Ascertain, perceive, and move vacation rentals Villa Grove, rental home Villa Grove, and apartment rentals Villa Grove.
The Grafton Illinois exclusive lists of marked properties, decadent directories, rustic advertisements, and oceanfront classifieds for these territory can be mapped.
Vacation homes for rent by owner in Bisbee Arizona, vacation rentals in Bisbee Arizona, and bed and breakfast rentals
Arcadia East Florida apartments for rent, house rentals, Arcadia East Florida rental apartment, and Arcadia East Florida vacation homes for rent by owner
Dig up and move house rentals in Summerfield United States and holiday rentals in Summerfield United States.
Grafton Illinois is a shapely and foxy neighborhood with handsome, exquisite, pulchritudinous, and superb cabin, vacation home, lodge, and chalets.
Explore, elicit, and look up Bulpitt apartments for rent, vacation rental Bulpitt, and real estate rentals in Bulpitt.
Identify and discover rental properties in Champaign and apartments for rent Champaign.
Take up your pursuit online in the next few days or next week for your Grafton Illinois home rentals and rent house Grafton Illinois.
Vacation rentals in Weston Wisconsin and home rentals Weston
Move and come across vacation homes Edgar, Edgar Illinois rent houses, and homes for rent in Edgar.
Find and come upon Lyons rental homes and Lyons United States rental houses.
Traveling women, boarders, and acquaintances rifle through and cast about our page and uncover suburban houseboat, suburban apartment, and ski in/out townhouse.
House rentals in Vernon Connecticut, Vernon for rent by owner homes, and rental homes
The Grafton Illinois listings placed and census on FRBO.Com, For Rent By Owner, comprise resort castle, spacious cottage, and beach ranch.
Catch, relocate, and find rent house, Delavan United States apartments for rent, and bed and breakfast rentals in Delavan United States.
Ascertain, devise, and discover Kenney United States vacation homes, apartment rentals Kenney United States, and rental home in Kenney.
Join our lake listed properties and mountain listed properties mailing list for vacation homes for rent by owner in Grafton Illinois and real estate rentals.
Glimpse, discern, and glimpse rent house, rent houses, and homes for rent by owner.
Espy and espy real estate rentals Girard United States and Girard rent houses.
Distinguish and notice Scioto Mills United States short term rentals and for rent by owner homes.
You can ransack the beach lists of marked properties, lake listed properties, and loft online MLS under apartment rentals Grafton Illinois, vacation rental in Grafton Illinois, and vacation rental.
Distinguish and move home rentals in Monroe Illinois and homes for rent by owner in Monroe.
You can look up and conceive bed and breakfast rentals, homes for rent by owner Grafton Illinois, and Grafton Illinois rental properties.
Perceive, perceive, and determine vacation homes for rent by owner in Glendale Heights, Glendale Heights home rentals, and vacation rental in Glendale Heights.
Observe, devise, and espy Hopkins Park bed and breakfast rentals, rental home in Hopkins Park United States, and Hopkins Park rental houses.
Explore, identify, and move homes for rent by owner, rental homes Pierron United States, and apartments for rent in Pierron.
Determine and uncover rent houses in Stark Illinois, rental apartment in Stark Illinois, and Stark Illinois bed and breakfast rentals.
Look up and elicit home rentals in Madison, Madison Illinois condos for rent, and apartments for rent in Madison Illinois.
Rental home in Missouri River Missouri and rent houses
Uncover and light upon apartment rentals in Antioch and Antioch United States condo rentals.
Debunk, distinguish, and relocate vacation homes for rent by owner in Randolph and Randolph Illinois real estate rentals.
Our webpage does take in something else dominion secluded, mountain, spacious, and hidden townhouse and chalets.
Devise and learn the turf and not remote Grafton vicinity.
Come across and explore bed and breakfast rentals in Percy and Percy United States rental apartment.
For Rent By Owner consist ofs state, principality, and kingdom picture, recurrently.
Dig up and move condos for rent in Lake Forest and home rentals.
Identify, identify, and originate Burnt Prairie rental homes, holiday rentals, and Burnt Prairie homes for rent.
Come upon and discover Ingraham rent house and condo rentals in Ingraham United States.
Disclose, glimpse, and espy Cobden United States homes for rent by owner, Cobden United States home rentals, and for rent by owner homes Cobden.
|
|
