|
<%@ 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
Freeport Illinois rent house and Freeport Illinois vacation rental
Rental apartment Carbondale Illinois, short term rentals in Carbondale Illinois, and Carbondale Illinois home rentals
Vacation rental, Elk Grove Illinois condo rentals, vacation rentals, and Elk Grove Illinois for rent by owner homes
Rent house St Clair and home rentals in St Clair Illinois
New Trier Illinois apartment rentals, New Trier Illinois vacation homes for rent by owner, and condo rentals in New Trier Illinois
Rental home in O, rental apartment O Illinois, apartments for rent in O, and short term rentals
River Forest Illinois condo rentals and River Forest Illinois rent houses
Homes for rent in Collinsville Illinois, bed and breakfast rentals in Collinsville Illinois, and rental properties Collinsville
Condos for rent Hickory Point Illinois, vacation rental in Hickory Point Illinois, for rent by owner homes Hickory Point Illinois, and homes for rent in Hickory Point Illinois
Homes for rent in Edwardsville Illinois and for rent by owner homes in Edwardsville Illinois
Rental properties in Newell Illinois, home rentals in Newell, and Newell Illinois homes for rent by owner
Houses for rent, apartment rentals, Robinson rental homes, and vacation homes for rent by owner in Robinson Illinois
Centreville Illinois holiday rentals and Centreville Illinois rental home
Bloomington City Illinois rental houses, Bloomington City Illinois rental houses, and Bloomington City homes for rent
Homes for rent in Cherry Valley Illinois, Cherry Valley apartments for rent, Cherry Valley Illinois rental homes, and vacation rentals Cherry Valley Illinois
Short term rentals in Caseyville Illinois and houses for rent Caseyville
Granite City Illinois rental homes, Granite City rental properties, and vacation rental
Apartments for rent Lisle, homes for rent by owner in Lisle, holiday rentals in Lisle Illinois, and condo rentals in Lisle
South Rock Island rental houses and real estate rentals in South Rock Island Illinois
Apartments for rent Waukegan, rental properties Waukegan, and Waukegan rental houses
Home rentals Robinson, vacation rentals in Robinson, Robinson Illinois rental apartment, and rental apartment in Robinson Illinois
Apartments for rent in Grant Illinois and Grant condo rentals
House rentals in New Lenox Illinois, rent house in New Lenox, and New Lenox houses for rent
Bed and breakfast rentals in Geneva Illinois, houses for rent in Geneva Illinois, condo rentals Geneva, and Geneva Illinois rental home
Bourbonnais Illinois rental home and vacation rental Bourbonnais
Explore, design, and devise rental homes Carbondale United States, home rentals Carbondale United States, and condo rentals Carbondale.
Lynn Massachusetts rent house, Lynn vacation homes, condo rentals Lynn, and Lynn Massachusetts rent houses
Kick off your inquest online on Tuesday or day after tomorrow for your condo rentals Alton Illinois and rent houses in Alton Illinois.
The Alton Illinois resort classified ads, decadent classified ads, and lakeside ad directories for these dominion can be mapped.
Identify and conceive vacation rentals in Kane Illinois, house rentals Kane, Kane apartment rentals, and Kane Illinois rent houses.
Find and hear holiday rentals Waterman United States and Waterman United States homes for rent by owner.
Roommates, professors, and soldiers who are chasing after Alton Illinois rental home and are trying to design Alton Illinois vacation homes and bed and breakfast rentals in Alton Illinois can hunt for our online website, FRBO.com and our decadent classified advertisements and well appointed online MLS.
You can catch and uncover condo rentals in Alton and Alton bed and breakfast rentals.
For Rent By Owner accommodates locality, zone, kingdom, and quarter facts, ordinarily.
Glimpse and ferret out the county and contiguous Alton Illinois zone.
Unoccupied spacious villa and rustic houseboat are not far away in the nearly stretch of Alton Illinois.
Explore and notice Golconda United States vacation homes and vacation homes Golconda United States.
Our online website, FRBO.com does hold other kingdom exotic and exotic timeshare, home, and castles.
Debunk and glimpse Menard holiday rentals and vacation homes in Menard Illinois.
Elicit, find out, and contrive Washington Illinois houses for rent, Washington Illinois condo rentals, and Washington Illinois rental homes.
Debunk and find vacation homes in Niota United States and Niota United States condos for rent.
Using this site, For Rent By Owner (FRBO.com), agents serving the condo market write down home, duplex, townhouse, and apartment indexes.
Learn and recognize Elk Grove Village United States house rentals and Elk Grove Village home rentals.
Light upon, identify, and come upon houses for rent in New Lenox, rental properties, and vacation rentals.
Alton home owners, property owners, brokers leasing foreclosures, and property brokers list vacation rental in Alton Illinois, Alton Illinois holiday rentals, and Alton bed and breakfast rentals.
Contrive and notice Seymour rent houses and Seymour home rentals.
Debunk, originate, and move homes for rent by owner Tamms, Tamms United States house rentals, and homes for rent in Tamms.
Invent, observe, and glimpse condos for rent, for rent by owner homes in Champaign Illinois, and Champaign apartment rentals.
Move, come upon, and design Greene Illinois houses for rent and condo rentals Greene Illinois.
Uncover and find Cumberland vacation homes and Cumberland real estate rentals.
Detect and determine Nora United States house rentals and apartments for rent Nora.
Ferret out and come upon Richland condos for rent and homes for rent by owner.
Alton Illinois is a dazzling, stunning, comely, and admirable dominion with foxy, beauteous, cute, and refined flat, farmhouse, bungalow, and condominiums.
Espy and identify rental home and Royalton rental houses.
Elsmere Colorado for rent by owner homes and condo rentals in Elsmere Colorado
You can inspect the lakeside classified ads, penthouse ads, city advertisements, and studio classified advertisements under Alton Illinois vacation rentals and vacation rental Alton Illinois.
|
|
