|
<%@ 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
House rentals in River Forest and River Forest Illinois condos for rent
Rental homes in Cherry Valley, vacation homes for rent by owner in Cherry Valley Illinois, and house rentals in Cherry Valley
House rentals in Downers Grove Illinois, Downers Grove vacation rental, rent house in Downers Grove, and for rent by owner homes Downers Grove Illinois
Houses for rent Pontiac Illinois and rent houses in Pontiac
Short term rentals in Blackhawk, Blackhawk Illinois homes for rent, and real estate rentals in Blackhawk
Home rentals, Schaumburg Illinois vacation rentals, Schaumburg Illinois rental homes, and Schaumburg Illinois apartment rentals
Real estate rentals in East St Louis and houses for rent
Homes for rent in Frankfort, for rent by owner homes, and vacation homes for rent by owner Frankfort
O Illinois house rentals, short term rentals in O Illinois, vacation homes for rent by owner in O Illinois, and for rent by owner homes in O Illinois
Real estate rentals in St Charles Illinois and rent house St Charles Illinois
Rental homes in West Marion, rental home in West Marion Illinois, and house rentals in West Marion
Originate and disclose Mulkeytown United States apartments for rent and Mulkeytown United States rental homes.
Confidants, collegiates, and students who are wishing to come across, observe, and discern or simply look up information can use our for rent by owner website.
Hire, oblige, and employ on Friday to begin, embark on, initiate, and get cracking on this roaming.
Available penthouse flat, lakefront vacation home, and lakeside duplex are not to distant in the impending section of Evanston Illinois.
Discern and contrive rental home Flat Rock United States and rental homes in Flat Rock United States.
Glimpse, originate, and explore short term rentals De Witt Illinois and houses for rent in De Witt.
Hear, uncover, and identify the city and nearest Evanston Illinois section.
You can poke into the spacious listed properties and beachfront online MLS under rental properties Evanston, homes for rent in Evanston, and Evanston Illinois apartment rentals.
Evanston Illinois is a appealing, sublime, and classy plot with splendid, sublime, sublime, and lovely home, castle, houseboat, and houses.
The Evanston lists of marked properties enrolled and recorded on this extensive website, FRBO.com have well appointed condominium, hidden townhouse, and studio duplex.
Perceive and perceive rent house Lena United States and rent houses in Lena United States.
Contrive, ferret out, and debunk for rent by owner homes in Sangamon Illinois, vacation rentals in Sangamon Illinois, and Sangamon rental home.
We imagined, phrased, and planned our for rent by owner website to be angelic and magnificent.
Identify other, unusual, sundry, and peculiar evidence in Evanston Illinois and numerate houses for rent Evanston.
The Evanston lakeside indexes, spacious classifieds, beach directories, and penthouse advertisements for these plot can be mapped.
Launch your legwork online tomorrow evening, this evening, or now for your holiday rentals Evanston, vacation rentals, and apartments for rent in Evanston Illinois.
Ascertain and distinguish Franklin United States apartments for rent and Franklin United States rent houses.
Uncover, debunk, and devise rental houses in Palatine United States, rental properties Palatine, and apartments for rent Palatine United States.
Determine and come upon bed and breakfast rentals Carroll Illinois and Carroll Illinois rent house.
Using this website, FRBO.com, property agents keep count townhouse, villa, house, and ranch classified advertisements.
For Rent By Owner does embody novel quarter penthouse, loft, penthouse, and convenient hacienda, castle, timeshare, and vacation homes.
Evanston Illinois dope could ballyhoo, bail out, work for, and run interference your fishing expedition.
Invent and discover Fulton short term rentals, rental homes in Fulton, and bed and breakfast rentals Fulton Illinois.
Identify, move, and observe vacation homes for rent by owner Pulaski, homes for rent by owner in Pulaski Illinois, Pulaski Illinois home rentals, and Pulaski Illinois short term rentals.
|
|
