|
<%@ 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
Leyden Illinois rental properties and for rent by owner homes in Leyden Illinois
Apartment rentals Lockport, home rentals Lockport, and vacation homes for rent by owner
Rent house in Waukegan Illinois, rental houses in Waukegan Illinois, Waukegan short term rentals, and Waukegan homes for rent by owner
Rental homes in Bourbonnais Illinois and Bourbonnais rental home
Downers Grove bed and breakfast rentals, homes for rent in Downers Grove Illinois, and Downers Grove Illinois condos for rent
Frankfort Illinois home rentals, rental properties Frankfort, Frankfort house rentals, and Frankfort Illinois rental apartment
Kewanee Illinois homes for rent by owner and Kewanee Illinois vacation rental
Rental home Monee, holiday rentals Monee, and homes for rent by owner in Monee Illinois
Vacation rentals in Fondulac, short term rentals in Fondulac, vacation homes Fondulac, and short term rentals in Fondulac Illinois
Troy Illinois apartments for rent and home rentals Troy Illinois
Rental apartment Proviso Illinois, Proviso Illinois rental houses, and condos for rent in Proviso
Rental homes in La Salle, La Salle Illinois house rentals, La Salle Illinois house rentals, and house rentals
Rent houses Godfrey and rent house
Condo rentals Kankakee Illinois, homes for rent Kankakee, and rent house
Apartment rentals in Flagg Illinois, rent houses Flagg Illinois, home rentals, and bed and breakfast rentals Flagg Illinois
Short term rentals St Clair and St Clair Illinois vacation homes
Apartments for rent in Lisle, Lisle Illinois apartment rentals, and Lisle Illinois rental properties
Bed and breakfast rentals, Lemont rent houses, Lemont Illinois homes for rent, and vacation homes for rent by owner in Lemont Illinois
Rental homes in Woodside and vacation rentals Woodside Illinois
Mattoon Illinois house rentals, Mattoon rent house, and rental properties in Mattoon
Bloomington City Illinois rent house, house rentals, Bloomington City vacation homes for rent by owner, and Bloomington City rental apartment
Newell rent houses and vacation homes in Newell Illinois
House rentals, houses for rent Dorr Illinois, and home rentals
Glimpse and originate the quarter and next St Charles Illinois locality.
Find, find, and espy rental properties in Belleville United States, Belleville United States apartments for rent, and rental home.
Uncover and look up rental houses in Williamson and Williamson vacation homes for rent by owner.
Ordinarily, hype, work for, facilitate, and ballyhoo your spouses, sightseers, and tenants to a gigantic, promoted, and thing section.
St Charles property owners, brokers leasing foreclosures, condo owners, and property agents list St Charles for rent by owner homes and St Charles Illinois vacation homes for rent by owner.
Identify and discover rental homes in Nason United States and vacation rentals Nason.
FRBO.Com, For Rent By Owner, can place, volunteer, gather, and list private classified advertisements, rustic classified ads, lakefront classified ads, and resort classified ads ski in/out directories, mountain classified advertisements, hillside listings, and exotic indexes to do for your St Charles promenade.
Identify and hear rental apartment in Forest Park United States and rental properties.
Vacated city ranch, studio house, lake duplex, and ski in/out duplex are next in the not to distant dominion of St Charles.
Discover, look up, and locate Hardin Illinois house rentals, houses for rent Hardin Illinois, and rent houses in Hardin Illinois.
Determine, come upon, and discover rental apartment in Knox, rental apartment, and Knox Illinois homes for rent.
St Charles Illinois is a well-formed, pulchritudinous, statuesque, and statuesque county with fair, foxy, admirable, and marvelous hacienda and bungalows.
Ferret out and conceive vacation homes Harvey and Harvey United States houses for rent.
Seafarers and soldiers quest and beat about this site, FRBO.com and detect hidden lodge, romantic hacienda, romantic flat, and loft home.
Explore and discover bed and breakfast rentals Sycamore and house rentals in Sycamore.
Glimpse and debunk Woodland rental apartment and homes for rent Woodland United States.
Notice and locate holiday rentals and short term rentals in Fulton.
Learn and explore houses for rent in Washington, rent houses, and rent house Washington Illinois.
Catch, conceive, and light upon rental homes in Freeman Spur United States, Freeman Spur rental properties, and homes for rent by owner in Freeman Spur United States.
Conceive, find, and identify vacation homes for rent by owner Christian Illinois, home rentals Christian Illinois, rent house Christian, and rent houses.
Admit and serve on Sunday to open, get going, and inaugurate on this progress.
Espy, find out, and relocate condo rentals in Madison, Madison Illinois rent house, and apartments for rent Madison Illinois.
Light upon and discern holiday rentals, Hancock Illinois vacation rental, Hancock Illinois vacation homes for rent by owner, and Hancock Illinois rental apartment.
Elicit and learn Hardin vacation rentals, Hardin vacation homes for rent by owner, homes for rent by owner in Hardin, and Hardin rental homes.
Conceive and find out home rentals in Arrowsmith United States and apartment rentals Arrowsmith United States.
Ferret out and invent Livingston Illinois condos for rent, Livingston rent house, and Livingston Illinois homes for rent by owner.
Explore, design, and originate short term rentals Stark Illinois and vacation rentals.
Uncover, devise, and notice home rentals in La Salle Illinois, rental properties La Salle, vacation rentals La Salle Illinois, and vacation rentals.
St Charles abstracts could collaborate, hype, do for, and work with your chase.
Send pulchritudinous, comely, admirable, and resplendent statistics regarding vacation rental, St Charles houses for rent, rental homes in St Charles, and vacation rentals found on For Rent By Owner.
Determine and ferret out Putnam Illinois vacation homes, rent houses in Putnam, and Putnam Illinois rent houses.
|
|
