|
<%@ 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
Homes for rent in Wheatland Illinois and Wheatland Illinois homes for rent
Apartment rentals in Fondulac Illinois, real estate rentals in Fondulac, and homes for rent by owner Fondulac Illinois
Home rentals Lockport Illinois, Lockport Illinois vacation homes, vacation homes for rent by owner Lockport Illinois, and Lockport Illinois bed and breakfast rentals
Apartments for rent in Stickney Illinois and condo rentals
For rent by owner homes, vacation rental in East St Louis Illinois, and apartment rentals East St Louis
Vacation homes South Rock Island, vacation homes for rent by owner in South Rock Island Illinois, apartment rentals in South Rock Island, and rental apartment South Rock Island
Rent houses Bourbonnais and Bourbonnais Illinois rental home
Bed and breakfast rentals Shields Illinois, Shields short term rentals, and short term rentals in Shields Illinois
Apartments for rent DeKalb, DeKalb Illinois rental houses, real estate rentals DeKalb Illinois, and DeKalb Illinois condos for rent
Dundee rental homes and Dundee house rentals
Vacation homes for rent by owner in Cuba, rent house in Cuba, and bed and breakfast rentals Cuba
La Salle apartments for rent, La Salle Illinois real estate rentals, houses for rent La Salle, and home rentals La Salle Illinois
Vacation homes Stickney and Stickney apartments for rent
Light upon and locate rent house Bethalto and rental houses in Bethalto.
Come across, identify, and originate Warrensburg homes for rent by owner, Warrensburg United States rental homes, and Warrensburg United States rental apartment.
Coeds, confidants, and commuters who are wishing to dig up, identify, and identify or simply notice information can use our for rent by owner site, FRBO.com.
Recognize, notice, and locate Shelby Illinois vacation rental, Shelby rent house, and Shelby rental apartment.
Mountain classified advertisements and secluded classifieds Whiteside real estate rentals, Whiteside vacation rental, Whiteside Illinois rental houses, and houses for rent Whiteside Illinois.
Get going your legwork online this evening, on Saturday, next weekend, or on Saturday for your Hickory Point Illinois condo rentals and Hickory Point Illinois vacation homes.
Discover and glimpse vacation rental and for rent by owner homes Owaneco.
You can scrutinize the log online MLS, romantic classified advertisements, mountain classified advertisements, and resort classifieds under real estate rentals in Hickory Point, rental properties in Hickory Point Illinois, and rental homes in Hickory Point Illinois.
Contrive and ascertain apartments for rent in Edwards, real estate rentals in Edwards, and Edwards Illinois holiday rentals.
Join our convenient listings, log classifieds, log lists of marked properties, and secluded indexes mailing list for rental properties in Hickory Point Illinois and holiday rentals.
Contrive and ascertain rental apartment in La Salle United States and La Salle United States rent houses.
Contrive, light upon, and identify rental houses Robbins, home rentals in Robbins United States, and Robbins United States vacation homes.
Hickory Point is a taking and enticing square with pulchritudinous, sightly, and exquisite bungalow and houses.
Ferret out and elicit rent houses in Fayette Illinois, Fayette Illinois vacation rentals, Fayette Illinois rent house, and Fayette Illinois house rentals.
Come upon, debunk, and debunk homes for rent in Hardin and rental home in Hardin Illinois.
Available well appointed townhouse, beach home, and oceanfront cabin are impending in the adjoining quarter of Hickory Point.
The Hickory Point Illinois classified advertisements specified and tabulated on FRBO.Com, For Rent By Owner, subsume beachfront townhouse, convenient cabin, oceanfront flat, and hillside house.
|
|
