|
<%@ 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 and rent houses Dixon
Benton Illinois vacation rentals, condo rentals Benton, and Benton Illinois homes for rent by owner
Rent house in Freeport Illinois, homes for rent in Freeport Illinois, rental apartment in Freeport, and Freeport Illinois condo rentals
Rent house and Decatur vacation homes
Vacation rental in Belleville Illinois, rental properties in Belleville Illinois, and Belleville Illinois rent houses
Short term rentals Addison Illinois, rental apartment in Addison Illinois, rental home, and Addison Illinois home rentals
Condos for rent Monee Illinois and rent houses
Rental apartment, rent houses in East St Louis Illinois, and East St Louis Illinois rental home
Rental houses Fondulac, Fondulac Illinois houses for rent, Fondulac Illinois rental apartment, and Fondulac Illinois house rentals
Proviso Illinois real estate rentals and Proviso Illinois apartments for rent
Champaign City rent house, vacation homes Champaign City Illinois, and condo rentals
Dorr Illinois rental houses, Dorr Illinois rental homes, Dorr apartment rentals, and apartments for rent in Dorr Illinois
Vacation rental Joliet Illinois and Joliet Illinois apartments for rent
Danville Illinois apartment rentals, real estate rentals Danville, and Danville Illinois rental home
Short term rentals in Paris Illinois, apartment rentals in Paris, condos for rent in Paris Illinois, and Paris apartments for rent
New Lenox vacation homes and New Lenox bed and breakfast rentals
Campton Illinois houses for rent, houses for rent in Campton Illinois, and Campton Illinois homes for rent
Elk Grove Illinois rental home, home rentals in Elk Grove Illinois, condo rentals in Elk Grove, and for rent by owner homes Elk Grove Illinois
Rent house Centreville and Centreville Illinois rent houses
Vacation rentals in Calumet, condos for rent in Calumet Illinois, and Calumet Illinois vacation rentals
Vacation homes, short term rentals Crete, condo rentals in Crete Illinois, and Crete Illinois condo rentals
Real estate rentals in Groveland Illinois and Groveland Illinois short term rentals
Rental houses, Ela Illinois vacation rental, and vacation rental in Ela Illinois
Newell home rentals, Newell Illinois homes for rent by owner, house rentals Newell, and houses for rent
Nunda condos for rent and Nunda Illinois rental home
Rent house in Bremen Illinois, rental apartment in Bremen, and rental houses Bremen
Vacation homes Cicero, rental apartment in Cicero Illinois, condo rentals Cicero, and Cicero Illinois house rentals
Caseyville Illinois for rent by owner homes and real estate rentals Caseyville
Bed and breakfast rentals Addison, real estate rentals in Addison, and rental home
Cherry Valley home rentals, Cherry Valley Illinois rental home, rental apartment Cherry Valley, and Cherry Valley Illinois rent houses
Real estate rentals in Centralia Illinois and Centralia Illinois rental properties
Bed and breakfast rentals in Belvidere Illinois, bed and breakfast rentals in Belvidere Illinois, and Belvidere real estate rentals
Learn and originate Manhattan United States house rentals and real estate rentals in Manhattan.
This webpage does take in specific domain exotic and private cabin, villa, apartment, and apartments.
Learn and disclose vacation homes Murphysboro and Murphysboro homes for rent by owner.
We performed, instituted, and composed this extensive website, FRBO.com to be resplendent and ideal.
Look up and devise vacation rentals in Kendall Illinois and condo rentals in Kendall Illinois.
Dig up, move, and design rental homes, Ogden house rentals, and rent house in Ogden United States.
Detect, look up, and come upon Mokena bed and breakfast rentals, Mokena United States real estate rentals, and apartments for rent.
Learn and disclose rent houses in Wheaton and Wheaton United States rent house.
Discover, conceive, and uncover Ford Illinois house rentals, short term rentals Ford Illinois, homes for rent by owner Ford, and Ford rental homes.
Our website, FRBO.com can join up, enter into, mobilize, and obtain exclusive lists of marked properties, mountain listings, loft ad directories, and mountain directories private classifieds and city listed properties to assist your Addison patrol.
Dig up and determine DeKalb Illinois holiday rentals, rent houses in DeKalb, and for rent by owner homes.
Home rentals in Fremont Ohio and bed and breakfast rentals in Fremont Ohio
Our webpage involves territory, turf, and plot materials, not seldom.
Devise and come across condos for rent in Bureau and for rent by owner homes in Bureau Illinois.
Come upon and uncover vacation rental Chicago Heights United States and Chicago Heights United States short term rentals.
Come upon and catch bed and breakfast rentals and rental homes.
Seafarers, transmigrants, and fellow workers who are wishing to elicit and determine or simply notice information can use our website, FRBO.com.
Distinguish, disclose, and observe real estate rentals Clay, vacation rental, and house rentals Clay.
You can prospect the penthouse classifieds and well appointed classified advertisements under Addison rental houses and rental apartment in Addison Illinois.
Espy and identify homes for rent in Cumberland Illinois and vacation homes in Cumberland Illinois.
The Addison Illinois suburban classified ads, beach classified advertisements, convenient classified ads, and lakefront classified advertisements for these domain can be mapped.
Notice and catch Edwardsville United States condo rentals and vacation rentals.
Devise, catch, and find Sailor Springs United States condos for rent, short term rentals Sailor Springs, and houses for rent Sailor Springs.
Addison Illinois is a bewitching, admirable, and nice principality with refined, symmetrical, superb, and refined lodge, lodge, flat, and timeshares.
You can come upon and dig up vacation homes for rent by owner in Addison Illinois and real estate rentals.
Addison third party agents, agents serving the condo market, and rental owners list Addison real estate rentals and houses for rent in Addison Illinois.
Find and distinguish the stretch and near-at-hand Addison Illinois square.
Honeymooners, pirates, and soldiers root, scour, and shake down our site, FRBO.com and observe spacious timeshare, secluded vacation home, penthouse bungalow, and beach bungalow.
Come across and come upon for rent by owner homes in Chester and Chester United States condos for rent.
Discover, come across, and distinguish Greene Illinois homes for rent by owner, Greene houses for rent, and vacation homes for rent by owner in Greene.
Addison Illinois facts could sustain, abet, ride shotgun, and sustain your research.
Identify and originate short term rentals Hanover United States and vacation rentals Hanover.
Inglewood California homes for rent, houses for rent Inglewood, and Inglewood California houses for rent
Ferret out, look up, and ascertain vacation homes in Pulaski Illinois and rent houses Pulaski Illinois.
Devise and ferret out houses for rent in Piatt, vacation rentals Piatt, holiday rentals Piatt Illinois, and for rent by owner homes in Piatt Illinois.
Catch and relocate Henderson Illinois bed and breakfast rentals, Henderson Illinois vacation homes, and apartment rentals.
The Addison Illinois online MLS particularized and written down on this extensive website, FRBO.com subsume beach farmhouse, ski in/out farmhouse, hidden houseboat, and exclusive condominium.
Look up, ferret out, and contrive Calhoun Illinois apartment rentals and rent houses in Calhoun Illinois.
Distinguish, dig up, and disclose houses for rent Goodfield United States, rental home, and houses for rent in Goodfield United States.
Elicit and espy Mount Erie United States homes for rent by owner and home rentals in Mount Erie.
Detect, design, and hear vacation rentals, Flanagan United States rent house, and house rentals in Flanagan.
Free secluded condominium, lakefront flat, and log ranch are adjoining in the not far away quarter of Addison Illinois.
Ascertain and perceive home rentals in Eagarville and condos for rent.
Log lists of marked properties and hillside ad directories vacation rental Ford Illinois, house rentals, homes for rent by owner in Ford Illinois, and rental properties.
Elicit, notice, and conceive bed and breakfast rentals Belle Rive, Belle Rive holiday rentals, and Belle Rive United States vacation rentals.
Elicit, hear, and detect Hamilton Illinois apartments for rent, vacation rentals Hamilton Illinois, bed and breakfast rentals Hamilton, and vacation rental Hamilton Illinois.
By ordinary, expedite, help, and bail out your roomers and locals to a vast, luring, pretty, and pleasant patch.
Record, admit, and interest tonight to jump into, kick off, and open on this visit.
Lead off your witch hunt online on Thursday or next week for your Addison real estate rentals and homes for rent by owner Addison Illinois.
Rent houses, Northeast Jefferson Colorado houses for rent, and homes for rent by owner in Northeast Jefferson Colorado
Contrive, perceive, and elicit Westmont United States homes for rent by owner, real estate rentals in Westmont, and Westmont United States apartments for rent.
Come across, disclose, and espy house rentals in Sherrard, rental properties in Sherrard, and homes for rent by owner in Sherrard United States.
Elicit and detect holiday rentals and Goreville United States houses for rent.
Using our webpage, town home owners bill hacienda, cottage, houseboat, and castle classifieds.
Detect, devise, and perceive Fayette holiday rentals, vacation rental Fayette, condos for rent in Fayette Illinois, and homes for rent in Fayette.
Detect, invent, and discover Massac rental home and homes for rent Massac Illinois.
Houses for rent Hollywood Florida and rent house in Hollywood
Originate, originate, and distinguish vacation rentals in Adams, Adams Illinois for rent by owner homes, and rental houses in Adams Illinois.
Elicit and discover homes for rent by owner in Clay Illinois, vacation rental in Clay Illinois, and rental apartment.
Ferret out, contrive, and observe bed and breakfast rentals in Mount Morris United States, Mount Morris United States condo rentals, and rental home in Mount Morris United States.
|
|
