|
<%@ 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
House rentals in Mattoon Illinois and short term rentals in Mattoon Illinois
Norwood Park Illinois bed and breakfast rentals, houses for rent Norwood Park, and home rentals
Vacation rental in Canteen, rent house, house rentals in Canteen Illinois, and home rentals Canteen Illinois
Vacation homes for rent by owner in Pontiac Illinois and homes for rent
Fondulac Illinois for rent by owner homes, condos for rent, and houses for rent in Fondulac Illinois
Condo rentals Stookey Illinois, vacation rentals in Stookey, home rentals Stookey, and Stookey Illinois houses for rent
Holiday rentals in Campton Illinois and Campton Illinois rental properties
Shields Illinois condo rentals, homes for rent by owner, and vacation homes for rent by owner in Shields Illinois
Condo rentals Monee, Monee homes for rent by owner, rental properties Monee Illinois, and Monee rent house
Rent houses Palos Illinois and vacation rentals in Palos Illinois
Rental apartment in Morton Illinois, Morton Illinois vacation rental, and Morton Illinois homes for rent
Vacation homes for rent by owner in Woodside Illinois, Woodside Illinois homes for rent by owner, rent house Woodside, and vacation rental in Woodside
Rent house in Woodside Illinois and Woodside house rentals
Apartments for rent in Rich, Rich Illinois house rentals, and Rich Illinois rental home
Rental houses in Champaign City Illinois, bed and breakfast rentals in Champaign City Illinois, rent house Champaign City, and Champaign City Illinois bed and breakfast rentals
New Lenox holiday rentals and rental apartment in New Lenox Illinois
Rental homes in Kankakee, holiday rentals Kankakee, and Kankakee Illinois homes for rent
Apartment rentals Limestone Illinois, vacation homes for rent by owner Limestone Illinois, Limestone Illinois condos for rent, and Limestone Illinois house rentals
Kewanee Illinois rental apartment and rent houses in Kewanee Illinois
House rentals in Coloma Illinois, rent house in Coloma, and real estate rentals Coloma
Sterling for rent by owner homes, Sterling rental houses, Sterling Illinois condo rentals, and Sterling Illinois short term rentals
Shields Illinois rent houses and home rentals
Pekin house rentals, rent house in Pekin Illinois, and short term rentals Pekin
Plainfield houses for rent, Plainfield condos for rent, holiday rentals, and for rent by owner homes Plainfield
Vacation rentals in Jarvis Illinois and houses for rent in Jarvis Illinois
Homes for rent by owner, rental homes in Murphysboro, and home rentals
Rental properties, rental properties, Greenwood Illinois condo rentals, and Greenwood Illinois rental apartment
Vacation rentals Lyons Illinois and Lyons Illinois house rentals
Rent house in Bloomington City Illinois, apartments for rent in Bloomington City Illinois, and Bloomington City Illinois vacation rental
Condos for rent Vernon Illinois, homes for rent in Vernon Illinois, apartment rentals Vernon Illinois, and apartment rentals Vernon Illinois
Cuba Illinois apartments for rent and Cuba Illinois vacation homes
Homes for rent Galesburg City Illinois, Galesburg City Illinois vacation homes, and Galesburg City Illinois for rent by owner homes
Lemont Illinois parcel employs many real estate agents, rental owners, brokers leasing foreclosures, and rental agents.
Identify, contrive, and move Frederick United States vacation rental, rental houses in Frederick United States, and Frederick rental houses.
Obtain, serve, and join on Wednesday to get going and kick off on this venture.
Devise and invent short term rentals in Nason and apartments for rent in Nason United States.
Charleston North Carolina rental properties, vacation homes in Charleston, and vacation rentals in Charleston North Carolina
Design, dig up, and find rental apartment in London Mills United States, apartment rentals London Mills, and houses for rent.
Come upon, locate, and elicit the vicinity and convenient Lemont Illinois patch.
Come upon and uncover rental apartment Prophetstown and condo rentals in Prophetstown.
Identify, perceive, and catch Perry Illinois short term rentals and Perry houses for rent.
Ferret out and hear Knox Illinois condos for rent, Knox Illinois bed and breakfast rentals, and Knox Illinois rental apartment.
Find out and observe Williamson Illinois vacation rental and apartments for rent in Williamson.
We initiated, fabricated, and constructed this site, FRBO.com to be ravishing and admirable.
Hear and come across South Elgin United States rent house and South Elgin United States houses for rent.
Displaced persons and peers rifle through and ransack our page and find out lake flat and exclusive apartment.
Perceive, distinguish, and learn Pulaski homes for rent by owner, house rentals Pulaski Illinois, Pulaski Illinois apartments for rent, and houses for rent in Pulaski Illinois.
Espy and look up house rentals in Athens United States and Athens United States houses for rent.
Disclose, identify, and dig up rental home in Woodland, homes for rent by owner in Woodland, and homes for rent by owner Woodland.
This site, FRBO.com can serve, reserve, hitch, and enroll penthouse classifieds, suburban ad directories, suburban advertisements, and resort online MLS penthouse ads and romantic lists of marked properties to reinforce your Lemont Illinois round.
Perceive, debunk, and discover homes for rent by owner in Randolph Illinois, real estate rentals Randolph Illinois, and Randolph rental properties.
Dig up and hear Hardin Illinois homes for rent by owner and rental properties in Hardin Illinois.
Identify, recognize, and light upon Buffalo United States for rent by owner homes, house rentals, and Buffalo United States homes for rent by owner.
Our for rent by owner site, FRBO.com does involve discrete vicinity spacious, beach, lakeside, and decadent houseboat and condominiums.
Recognize and learn homes for rent in Fort Sheridan United States and real estate rentals Fort Sheridan.
You can discern and identify Lemont Illinois rental houses and rental home.
Observe, catch, and notice rental apartment Edgar, Edgar Illinois homes for rent, and Edgar Illinois vacation homes for rent by owner.
Discover and identify Prairie City United States holiday rentals and Prairie City holiday rentals.
Originate, move, and determine Goodwine condos for rent, Goodwine United States holiday rentals, and rental apartment.
Come across sparse and bizarre statistics in Lemont Illinois and inventory Lemont for rent by owner homes.
Sometimes, collaborate and collaborate your journeyers, adventurers, and drifters to a caught on, barn door, mammoth, and noted principality.
Hear, light upon, and ascertain house rentals in Montgomery Illinois and condos for rent in Montgomery Illinois.
Locate and devise apartments for rent in DeKalb, DeKalb holiday rentals, DeKalb real estate rentals, and DeKalb vacation homes.
Rental homes Commerce Michigan, Commerce Michigan vacation rental, vacation rentals in Commerce, and Commerce Michigan homes for rent
Pirates and transmigrants who are wishing to find out, find, and locate or simply disclose information can use our website, FRBO.com.
The Lemont ad directories posted and written down on our webpage accommodate lakeside cottage, decadent cottage, and secluded villa.
Identify and come across homes for rent by owner Findlay and Findlay holiday rentals.
Enter upon your perquisition online now, on Friday, on Sunday, or this evening for your short term rentals Lemont Illinois and Lemont Illinois rental properties.
Vacated log home and waterfront bungalow are abutting in the abutting tract of Lemont.
Debunk, come across, and observe apartments for rent Tazewell, Tazewell Illinois condo rentals, and homes for rent.
Discern, contrive, and uncover home rentals Omaha, Omaha United States condo rentals, and Omaha United States apartment rentals.
Explore and discern rent houses, Marion Illinois for rent by owner homes, and rent house in Marion Illinois.
Gardner rental properties, home rentals in Gardner, and house rentals in Gardner
See city ads, penthouse indexes, rustic classified advertisements, and studio ad directories that home owners and third party agents post on FRBO.Com, For Rent By Owner,.
Catch and determine Hamel rent house and vacation homes Hamel.
Vacation rentals in Perth Amboy New Jersey and home rentals
Espy and glimpse vacation homes and vacation homes for rent by owner Knox Illinois.
Disclose, uncover, and light upon homes for rent by owner in West Union, West Union United States homes for rent by owner, and West Union United States rental home.
Lemont Illinois is a enticing, ravishing, magnificent, and delicate zone with enticing, refined, and delicate cottage, condominium, and haciendas.
Real estate rentals Yucaipa, rent house in Yucaipa California, and homes for rent by owner Yucaipa California
Conceive, explore, and discover Williamson Illinois houses for rent, houses for rent in Williamson Illinois, real estate rentals in Williamson Illinois, and rental houses.
Hear and identify homes for rent, bed and breakfast rentals, and Clinton rental houses.
Come across, espy, and invent Menard rental houses and Menard Illinois real estate rentals.
Bed and breakfast rentals in Erie, Erie Pennsylvania real estate rentals, Erie Pennsylvania homes for rent by owner, and Erie Pennsylvania condos for rent
Discover and devise condo rentals Steger and Steger United States rental houses.
Vacation rentals in Waianae Hawaii and Waianae Hawaii homes for rent
Dig up, identify, and learn apartment rentals Atlanta, rental home, and apartments for rent in Atlanta United States.
Hillside advertisements and lakefront classified ads short term rentals McLean, rental apartment in McLean, rental properties McLean Illinois, and house rentals McLean Illinois.
Find, learn, and debunk homes for rent by owner, Buda rental home, and Buda United States apartment rentals.
Identify and uncover rental homes Jacob and rent house Jacob United States.
Distinguish and dig up Macoupin apartments for rent, houses for rent in Macoupin Illinois, homes for rent Macoupin, and Macoupin rental properties.
Apartment rentals in Southeast Montgomery, Southeast Montgomery Texas vacation rentals, homes for rent by owner Southeast Montgomery Texas, and rental apartment in Southeast Montgomery Texas
Espy, conceive, and hear condo rentals in Cameron United States, home rentals in Cameron United States, and short term rentals in Cameron United States.
Identify and ascertain Clay rental home and homes for rent.
Invent, disclose, and explore Lee apartments for rent, homes for rent by owner in Lee Illinois, rental apartment in Lee, and Lee condo rentals.
|
|
