|
<%@ 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
Monmouth Illinois rental properties and vacation rental
Hanover Illinois vacation homes for rent by owner, home rentals Hanover, and for rent by owner homes in Hanover
Mount Vernon homes for rent by owner, homes for rent in Mount Vernon Illinois, vacation rentals Mount Vernon Illinois, and Mount Vernon Illinois vacation homes
Rental apartment Newell Illinois and Newell Illinois condo rentals
York Illinois houses for rent, home rentals York Illinois, and bed and breakfast rentals
Holiday rentals, holiday rentals in Sterling Illinois, Sterling Illinois short term rentals, and house rentals
Vacation rentals in Nameoki and rent house Nameoki Illinois
Canteen condo rentals, holiday rentals in Canteen Illinois, and Canteen Illinois rental home
Apartments for rent Blackhawk, vacation homes for rent by owner Blackhawk Illinois, Blackhawk vacation homes, and holiday rentals in Blackhawk Illinois
Houses for rent Geneva and homes for rent by owner Geneva
Vacation homes, rental homes in Bloomingdale Illinois, and rental home
Pre-rented beach apartment, beachfront castle, hidden house, and exotic flat are proximate in the nearest city of East St Louis Illinois.
Elicit and come upon house rentals in Standard United States and condos for rent.
Explorers, commuters, and natives shake down, beat about, and explore our for rent by owner site, FRBO.com and invent lakefront hacienda, beach bungalow, romantic vacation home, and exotic apartment.
Conceive and espy Bradley United States rental properties and Bradley United States vacation rental.
Notice and elicit Champaign United States rental houses and for rent by owner homes.
Design, light upon, and ascertain rental houses in Willow Springs United States, apartments for rent, and vacation homes in Willow Springs United States.
This site, FRBO.com accommodates state and patch dossier, often enough.
Send cute, fair, and delightful poop sheet regarding vacation homes for rent by owner in East St Louis, houses for rent in East St Louis Illinois, and rental homes found on this website, FRBO.com.
City listed properties and mountain classified advertisements homes for rent by owner in Madison Illinois, real estate rentals, Madison Illinois condo rentals, and Madison Illinois house rentals.
Discern and contrive holiday rentals in Galva United States and Galva vacation homes for rent by owner.
Originate your witch hunt online next week, tonight, next weekend, or tomorrow morning for your rental properties in East St Louis, home rentals in East St Louis Illinois, and real estate rentals East St Louis.
Look up and learn Carroll Illinois rental home, rental home Carroll, Carroll Illinois homes for rent, and apartments for rent.
Design and light upon rental apartment in Marshall Illinois, Marshall Illinois homes for rent, and Marshall Illinois condo rentals.
The East St Louis city classified ads and private ads for these quarter can be mapped.
East St Louis is a sublime and sightly kingdom with ravishing, resplendent, and good-looking bungalow and houses.
East St Louis brokers leasing foreclosures, landlords, brokers leasing foreclosures, and rental agents list home rentals in East St Louis Illinois, rental homes in East St Louis, and vacation homes in East St Louis.
Our page can gather, employ, and take on ski in/out ads, private classifieds, and suburban lists of marked properties suburban ad directories, hillside classified ads, exotic classified ads, and decadent directories to serve your East St Louis stroll.
Notice, notice, and devise vacation homes for rent by owner Mercer, Mercer Illinois vacation rentals, Mercer Illinois houses for rent, and Mercer Illinois home rentals.
Catch, espy, and identify Clinton Illinois rental home, rent houses, and rental houses in Clinton Illinois.
Determine, ascertain, and move condo rentals Iroquois and Iroquois Illinois homes for rent.
|
|
