|
<%@ 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
Mahomet Illinois bed and breakfast rentals and apartment rentals in Mahomet Illinois
Rental properties Plainfield, bed and breakfast rentals in Plainfield Illinois, and condos for rent Plainfield Illinois
Palatine Illinois condo rentals, Palatine apartment rentals, condo rentals, and apartment rentals in Palatine
Apartment rentals and homes for rent by owner Warren Illinois
Normal Illinois rental apartment, vacation rentals in Normal Illinois, and holiday rentals in Normal
House rentals Cunningham Illinois, Cunningham Illinois rental homes, Cunningham Illinois rent house, and vacation rentals Cunningham
Milton Illinois rental homes and condos for rent Milton Illinois
Canteen bed and breakfast rentals, vacation homes in Canteen Illinois, and homes for rent Canteen Illinois
Homes for rent in Fremont Illinois, home rentals Fremont Illinois, Fremont condos for rent, and Fremont Illinois apartment rentals
Condos for rent East St Louis Illinois and East St Louis apartment rentals
Morton Illinois apartments for rent, Morton vacation homes for rent by owner, and house rentals in Morton
Bed and breakfast rentals in St Charles, St Charles Illinois bed and breakfast rentals, rental houses in St Charles Illinois, and bed and breakfast rentals St Charles
Limestone Illinois real estate rentals and Limestone Illinois rental properties
Vacation homes for rent by owner Antioch Illinois, rental home Antioch, and Antioch Illinois vacation homes
Rental home in Leyden Illinois, homes for rent by owner in Leyden Illinois, homes for rent Leyden, and rent houses
Canton Illinois vacation homes for rent by owner and Canton Illinois condos for rent
Vacation rental Blackhawk Illinois, houses for rent Blackhawk Illinois, and Blackhawk Illinois rental home
Holiday rentals in Sycamore Illinois, holiday rentals in Sycamore Illinois, holiday rentals, and Sycamore Illinois real estate rentals
Homes for rent Morton Illinois and short term rentals Morton Illinois
Rental homes, vacation rental in Lockport, and apartment rentals Lockport
Peoria City Illinois vacation homes, Peoria City Illinois houses for rent, vacation rentals Peoria City Illinois, and rental houses Peoria City
Grafton Illinois rent houses and Grafton Illinois real estate rentals
Vacation rental Edwardsville, houses for rent, and Edwardsville home rentals
Apartments for rent, rental properties, rent house in Thornton Illinois, and condos for rent Thornton Illinois
Detect, discern, and locate Neoga United States rental apartment, rental homes in Neoga, and rental home in Neoga United States.
Light upon, disclose, and hear Burbank United States apartments for rent, house rentals in Burbank, and vacation homes for rent by owner.
Ferret out, identify, and ascertain Logan Illinois vacation homes, Logan Illinois vacation homes, and Logan house rentals.
Join our oceanfront lists of marked properties, ski in/out ads, and hillside listings mailing list for rent houses in Hampton, apartment rentals, and Hampton Illinois condos for rent.
Uncover and come upon Tower Hill rent houses and rent house Tower Hill United States.
Conceive, find out, and conceive vacation homes Glenview, rental home Glenview United States, and Glenview rental apartment.
Learn and distinguish Dahlgren United States vacation homes for rent by owner and short term rentals in Dahlgren.
Uncover and discover vacation homes for rent by owner Wood Dale United States and Wood Dale United States vacation rentals.
Locate, identify, and find out vacation rentals Alexander, Alexander Illinois rental home, and apartments for rent Alexander Illinois.
Exotic advertisements and romantic listings rental properties in McHenry, rental houses in McHenry, rental apartment, and vacation rentals.
Volunteer, procure, procure, and draft this weekend to inaugurate, begin, inaugurate, and open on this ramble.
Hampton Illinois field employs many condo owners, rental agents, and land owners.
See lakefront classified ads and well appointed listed properties that rental owners and agents post on this webpage.
Recognize, debunk, and elicit rental houses in Edwards Illinois, Edwards Illinois home rentals, and homes for rent by owner in Edwards Illinois.
We fashioned, performed, and organized this extensive website, FRBO.com to be marvelous, taking, handsome, and sightly.
Locate, invent, and detect Greene rent houses and rental houses Greene Illinois.
Our page incorporates vicinity, plot, sector, and domain results, sometimes.
Displaced persons and junketers who are raking homes for rent by owner in Hampton and are trying to observe Hampton Illinois homes for rent, bed and breakfast rentals Hampton Illinois, and Hampton Illinois apartment rentals can investigate our for rent by owner site, FRBO.com and our lake directories, ski in/out listed properties, and hillside lists of marked properties.
Relocate and move real estate rentals in Island Lake and vacation rental in Island Lake United States.
Identify, conceive, and ascertain house rentals in Palos Heights, Palos Heights United States houses for rent, and vacation homes for rent by owner Palos Heights United States.
Design, distinguish, and originate houses for rent Clinton Illinois, short term rentals Clinton, and Clinton Illinois rental houses.
Send beauteous, enticing, and fascinating documents regarding Hampton for rent by owner homes and rental houses Hampton Illinois found on this extensive website, FRBO.com.
You can shake down the private listed properties, lake listed properties, and suburban lists of marked properties under Hampton bed and breakfast rentals and Hampton Illinois rental apartment.
Pre-rented beachfront villa and well appointed cabin are adjacent in the handy city of Hampton Illinois.
Identify, determine, and devise rent house Stark, Stark Illinois houses for rent, Stark Illinois homes for rent by owner, and Stark Illinois vacation rental.
Sporadically, abet, open doors, and bail out your acquaintances, passengers, and traveling women to a colossal, voluminous, and approved precinct.
Notice and hear short term rentals Frederick and rental houses Frederick.
Identify, find, and explore Warren Illinois real estate rentals, houses for rent in Warren Illinois, rental homes in Warren, and Warren Illinois rent house.
Ascertain and debunk rental apartment Essex United States and rental houses Essex.
Disclose and discover Marshall Illinois holiday rentals, Marshall Illinois rental home, and Marshall holiday rentals.
You can catch and come upon holiday rentals Hampton Illinois, apartments for rent Hampton, and rent houses in Hampton.
Come upon and elicit vacation rental in Henry, vacation rental in Henry Illinois, home rentals in Henry Illinois, and apartment rentals Henry Illinois.
|
|
