|
<%@ 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
Palatine Illinois rent house and houses for rent Palatine Illinois
Bed and breakfast rentals Addison, Addison real estate rentals, and vacation homes for rent by owner in Addison Illinois
Home rentals Alton Illinois, short term rentals Alton, real estate rentals Alton, and holiday rentals in Alton Illinois
Condos for rent Collinsville Illinois and vacation rentals Collinsville Illinois
Warren vacation homes, Warren holiday rentals, and homes for rent in Warren
Rental houses in Dundee Illinois, vacation homes in Dundee Illinois, Dundee vacation rental, and Dundee Illinois home rentals
Bloomingdale Illinois condo rentals and rental properties in Bloomingdale Illinois
Robinson Illinois house rentals, Robinson vacation rental, and Robinson Illinois real estate rentals
Homes for rent in Belleville, vacation rental Belleville Illinois, Belleville Illinois home rentals, and Belleville Illinois condo rentals
Niles Illinois rent houses and rent house in Niles Illinois
Vacation homes in Benton Illinois, rent house, and bed and breakfast rentals
Algonquin Illinois facts could hype and reinforce your investigation.
Catch and detect rental homes in Bureau Illinois, vacation rentals in Bureau Illinois, Bureau Illinois apartments for rent, and Bureau Illinois condo rentals.
This webpage can draft and gather city lists of marked properties, hillside lists of marked properties, well appointed classified ads, and spacious indexes studio directories, lakefront ad directories, romantic online MLS, and lake listings to abet your Algonquin ramble.
Contrive, invent, and discover rent houses New Memphis United States, holiday rentals in New Memphis, and rental homes New Memphis United States.
Fortune-hunters, co-workers, and voyagers who are foraging condo rentals and are trying to relocate Algonquin Illinois condos for rent, rent houses Algonquin Illinois, and Algonquin Illinois home rentals can cast about our site, FRBO.com and our convenient lists of marked properties and spacious lists of marked properties.
The Algonquin Illinois advertisements inventoried and buttoned down on our website, FRBO.com enclose exotic castle, lakeside hacienda, and oceanfront cottage.
Algonquin real estate agents, town home owners, property owners, and brokers leasing foreclosures list real estate rentals in Algonquin, condo rentals Algonquin Illinois, and real estate rentals.
Using this site, FRBO.com, town home owners catalogue houseboat, timeshare, house, and bungalow ad directories.
Conceive and come upon condo rentals Cave in Rock and Cave in Rock real estate rentals.
Ascertain and dig up Chestnut rental houses and rental properties.
Kick off your perquisition online tomorrow evening or on Wednesday for your short term rentals in Algonquin and home rentals Algonquin Illinois.
|
|
