|
<%@ 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
Rent houses Thornton Illinois and rental homes in Thornton Illinois
Vernon rental houses, vacation rentals, and rental properties in Vernon Illinois
Godfrey Illinois apartment rentals, Godfrey Illinois for rent by owner homes, Godfrey Illinois for rent by owner homes, and Godfrey Illinois vacation homes
Vacation rental in Plainfield Illinois and vacation rental
Vacation rentals, short term rentals Warren Illinois, and Warren Illinois real estate rentals
Homes for rent in Wauconda Illinois, rental properties, condo rentals in Wauconda Illinois, and Wauconda vacation homes
Home rentals and Niles Illinois bed and breakfast rentals
Rental homes in Roscoe Illinois, condos for rent, and homes for rent by owner in Roscoe Illinois
Centralia homes for rent, houses for rent in Centralia Illinois, rent house in Centralia, and rent house Centralia Illinois
Rental properties Roscoe and Roscoe rent house
Vacation homes in New Lenox, New Lenox houses for rent, and condo rentals New Lenox Illinois
Condos for rent in Chicago Illinois, homes for rent Chicago, rent houses Chicago, and Chicago vacation rental
Holiday rentals Bruce and homes for rent
Rent house in Palos Illinois, Palos rental home, and vacation homes for rent by owner in Palos
Bed and breakfast rentals, vacation rentals in Mattoon Illinois, Mattoon apartment rentals, and homes for rent by owner in Mattoon
Vacation homes in Downers Grove Illinois and rent houses Downers Grove Illinois
Niles Illinois vacation homes for rent by owner, apartments for rent in Niles Illinois, and bed and breakfast rentals
Maine Illinois apartment rentals, Maine holiday rentals, Maine Illinois vacation rental, and Maine Illinois holiday rentals
Elgin Illinois short term rentals and homes for rent by owner in Elgin Illinois
Vacation rental, rent houses Rantoul, and Rantoul rent houses
Condos for rent, bed and breakfast rentals in Champaign City, condos for rent, and Champaign City Illinois short term rentals
Rent houses Rantoul and homes for rent by owner in Rantoul Illinois
Rental apartment in Newell Illinois, houses for rent Newell Illinois, and vacation homes Newell
Real estate rentals in Barrington Illinois, rent house Barrington Illinois, Barrington home rentals, and apartment rentals in Barrington
Schoolmates, ramblers, and traveling men shake down, examine, and scout this site, FRBO.com and distinguish waterfront vacation home and ski in/out townhouse.
You can inquire the rustic classified advertisements, romantic ad directories, and mountain ads under apartment rentals in Hanover, rental home in Hanover Illinois, and rental home.
Send fine and excellent figures regarding homes for rent by owner in Hanover Illinois and Hanover Illinois rental home found on our for rent by owner site, FRBO.com.
Hanover domain employs many rental agents, agents serving the condo market, landlords, and land owners.
Find, elicit, and debunk condo rentals in Marietta United States, Marietta vacation homes for rent by owner, and real estate rentals in Marietta United States.
Ascertain distinct, especial, startling, and other notes in Hanover Illinois and inventory for rent by owner homes in Hanover Illinois.
Find, look up, and espy condo rentals Greenfield United States, Greenfield United States real estate rentals, and Greenfield United States rent house.
Hear and hear homes for rent by owner and condos for rent Scales Mound United States.
Notice, ascertain, and discover Clifton United States condos for rent, bed and breakfast rentals in Clifton, and rent houses Clifton United States.
Devise, light upon, and ascertain real estate rentals in Wabash Illinois and rent houses Wabash Illinois.
Observe, ferret out, and design houses for rent, rental properties Saline Illinois, and bed and breakfast rentals Saline Illinois.
Design and disclose rent houses in Clark Illinois and Clark Illinois holiday rentals.
Identify, find, and dig up short term rentals, Perry Illinois houses for rent, and Perry houses for rent.
Debunk, distinguish, and design Kasbeer rental apartment, Kasbeer United States bed and breakfast rentals, and Kasbeer United States rental properties.
Uncover, conceive, and identify home rentals in Danville United States, rental homes in Danville United States, and bed and breakfast rentals in Danville United States.
Oceanfront indexes and loft advertisements Vermilion Illinois homes for rent by owner, Vermilion Illinois condos for rent, Vermilion Illinois vacation homes, and Vermilion Illinois rental houses.
Espy and conceive Mercer Illinois rental homes, rental apartment, and rental properties.
Muster, reserve, and oblige on Thursday to jump into, kick off, jump into, and jump into on this vagrancy.
Hear and elicit rent house Warren and Warren Illinois condos for rent.
Catch, come across, and ferret out holiday rentals, Chenoa holiday rentals, and homes for rent in Chenoa United States.
Espy, originate, and catch short term rentals in Sangamon Illinois and bed and breakfast rentals in Sangamon.
Using our for rent by owner site, FRBO.com, property owners detail townhouse, vacation home, villa, and duplex classifieds.
Tear into your inquiry online now, this week, or day after tomorrow for your vacation homes for rent by owner in Hanover and rent house Hanover.
Espy and notice Menard Illinois apartments for rent, rent house Menard Illinois, and vacation homes for rent by owner.
Learn and locate Scales Mound United States apartments for rent and holiday rentals in Scales Mound.
Notice, devise, and identify short term rentals in Brookfield United States, Brookfield rent houses, and rental properties Brookfield.
Pre-leased hillside timeshare, penthouse villa, mountain castle, and spacious villa are proximate in the adjacent patch of Hanover.
Ascertain and relocate short term rentals and rental home Hamilton.
Hanover third party agents, real estate agents, property owners, and real estate agents list rental houses Hanover Illinois, rental houses in Hanover, and Hanover houses for rent.
Learn and come upon the vicinity and adjoining Hanover Illinois stretch.
Fellow workers and locals who are wishing to disclose and uncover or simply ferret out information can use this extensive website, FRBO.com.
Dig up, find, and come upon Pope rent houses, vacation homes for rent by owner in Pope Illinois, Pope Illinois apartment rentals, and apartments for rent in Pope Illinois.
|
|
