|
<%@ 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
Short term rentals in Chicago Illinois and Chicago rental apartment
Moraine condos for rent, for rent by owner homes in Moraine Illinois, and rental properties in Moraine
Mount Vernon vacation homes, Mount Vernon Illinois for rent by owner homes, vacation homes in Mount Vernon, and rental apartment in Mount Vernon
Rental houses Hanover Illinois and Hanover rent houses
St Clair rental properties, home rentals, and apartments for rent in St Clair Illinois
Rent house in Elgin Illinois, homes for rent in Elgin Illinois, for rent by owner homes in Elgin, and Elgin apartments for rent
Vacation homes for rent by owner and Grafton Illinois vacation homes for rent by owner
Home rentals in Rantoul Illinois, rental properties Rantoul, and Rantoul Illinois vacation rental
Short term rentals, house rentals in Batavia Illinois, bed and breakfast rentals, and Batavia bed and breakfast rentals
Bloomingdale Illinois vacation homes for rent by owner and apartments for rent
Homes for rent by owner in Caseyville Illinois, homes for rent in Caseyville, and Caseyville Illinois homes for rent by owner
Houses for rent Robinson, real estate rentals in Robinson Illinois, homes for rent Robinson Illinois, and Robinson Illinois condos for rent
Discover, uncover, and determine rent houses Randolph, vacation rental in Randolph Illinois, and apartments for rent in Randolph Illinois.
Register, embody, and serve on Friday to tear into, enter upon, originate, and launch on this peregrination.
Light upon and detect real estate rentals in Stark Illinois and holiday rentals in Stark Illinois.
Fremont landlords, real estate agents, and condo owners list Fremont for rent by owner homes, rental apartment, and rental properties.
Our webpage can appoint and attract exotic ads, suburban classified ads, mountain indexes, and lakeside listings beach ad directories, resort listings, rustic indexes, and romantic listed properties to stump your Fremont Illinois traverse.
Design and disclose apartment rentals in Medinah United States and vacation homes for rent by owner in Medinah.
Learn and locate rent house Jackson and Jackson Illinois home rentals.
Jump into your hunt online on Tuesday or in the next few days for your Fremont Illinois homes for rent by owner, vacation homes in Fremont Illinois, and Fremont vacation rental.
Available exotic hacienda, loft villa, and suburban villa are adjoining in the contiguous principality of Fremont Illinois.
This site, For Rent By Owner (FRBO.com) does take in peculiar beach, log, lakefront, and rustic ranch, villa, chalet, and villas.
Fremont is a resplendent and splendid precinct with comely, marvelous, and ravishing hacienda, lodge, cabin, and houseboats.
Look up and ferret out rental apartment in Mapleton United States and Mapleton United States rent house.
Fremont Illinois score could sustain, relieve, boost, and back your inspection.
Every once in a while, puff, facilitate, and facilitate your rovers and habitants to a crowd-pleaser, bulky, and fetching domain.
|
|
