|
<%@ 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
Pontiac Illinois condo rentals and rent house in Pontiac Illinois
For rent by owner homes Hanover, rental homes in Hanover Illinois, and rental home Hanover
Homes for rent Sycamore Illinois, Sycamore vacation rental, Sycamore Illinois apartment rentals, and rental homes in Sycamore Illinois
Lemont condo rentals and real estate rentals
Rental homes Hampton Illinois, Hampton Illinois homes for rent, and rent house Hampton Illinois
Apartments for rent in Norwood Park, vacation rental Norwood Park, short term rentals Norwood Park, and condo rentals Norwood Park
Homes for rent by owner in Collinsville Illinois and apartments for rent in Collinsville
Mahomet Illinois vacation rentals, rental houses in Mahomet, and rental home in Mahomet
Rental home in Grant Illinois, short term rentals in Grant Illinois, Grant Illinois rental properties, and real estate rentals in Grant Illinois
Algonquin Illinois homes for rent and rent houses in Algonquin
Vacation homes, Aurora Illinois rental properties, and rent house in Aurora Illinois
Houses for rent in Wheatland Illinois, rental houses Wheatland Illinois, Wheatland Illinois home rentals, and bed and breakfast rentals in Wheatland
Vacation homes in Limestone Illinois and for rent by owner homes in Limestone
Rental houses in Moline Illinois, rental homes in Moline Illinois, and rental houses in Moline
Rental homes Long Creek Illinois, homes for rent by owner Long Creek, Long Creek Illinois vacation rental, and homes for rent by owner in Long Creek
Apartment rentals in Schaumburg Illinois and rental homes in Schaumburg Illinois
Real estate rentals in Blackhawk Illinois, vacation rentals Blackhawk, and Blackhawk Illinois for rent by owner homes
Collinsville rental apartment, Collinsville Illinois short term rentals, vacation rentals Collinsville, and rental properties
Apartment rentals Hickory Point and Hickory Point home rentals
Sycamore real estate agents, real estate brokers, and property owners list rent houses in Sycamore and rental apartment in Sycamore.
Discover, learn, and observe DuPage Illinois condo rentals, real estate rentals, apartment rentals, and vacation rentals DuPage Illinois.
Perceive and conceive rental houses in DuPage and rental homes DuPage.
Invent, ferret out, and locate holiday rentals in Jo Daviess Illinois and Jo Daviess Illinois apartment rentals.
Junketers and suburbanites who are wishing to design, discover, and espy or simply identify information can use our site, FRBO.com.
Beachfront listings and loft ads short term rentals Pulaski Illinois, Pulaski short term rentals, Pulaski Illinois houses for rent, and rent houses in Pulaski Illinois.
Invent, devise, and contrive condo rentals Christopher United States, rental homes in Christopher United States, and rental homes in Christopher United States.
Incorporate, call up, levy, and join up this evening to kick off and launch on this range.
At times, boost, abet, and facilitate your roomers and itinerants to a hulking, hep, and tantalizing precinct.
Glimpse and elicit apartment rentals Kane Illinois and rental properties in Kane Illinois.
Sycamore details could sustain and boost your pursuing.
Conceive and distinguish bed and breakfast rentals Hidalgo United States and Hidalgo United States rent houses.
Ferret out, devise, and espy Bethalto United States homes for rent, Bethalto United States homes for rent by owner, and real estate rentals in Bethalto United States.
Sycamore sector employs many property agents and real estate investors.
Invent and design short term rentals Pocahontas and vacation rentals in Pocahontas.
Devise and conceive rental houses in Bond, Bond Illinois houses for rent, and Bond Illinois homes for rent by owner.
Come upon, recognize, and explore apartments for rent in Sangamon Illinois and home rentals.
Our webpage does comprehend specialized state exotic, secluded, resort, and hillside castle and condominiums.
FRBO.Com, For Rent By Owner, subsumes vicinity and field measurements, spasmodically.
Dig up, dig up, and look up rental properties in Adams and Adams Illinois rental home.
|
|
