|
<%@ 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
Vacation rentals Wauconda Illinois and holiday rentals
Kankakee vacation homes for rent by owner, Kankakee Illinois apartment rentals, and vacation rental
Danville vacation rental, homes for rent Danville, for rent by owner homes in Danville Illinois, and holiday rentals Danville
Homes for rent by owner Libertyville Illinois and rental homes in Libertyville Illinois
Condos for rent in Antioch Illinois, Antioch Illinois homes for rent, and for rent by owner homes in Antioch
Apartments for rent in St Charles Illinois, St Charles rental houses, condos for rent St Charles Illinois, and St Charles Illinois rental houses
Rental home Sterling and Sterling Illinois holiday rentals
Vacation homes Caseyville, house rentals, and condos for rent in Caseyville
Vacation rentals in Harrisburg, apartment rentals in Harrisburg, rental homes, and houses for rent Harrisburg Illinois
Homes for rent Paris and vacation rentals Paris Illinois
House rentals in Dorr, Dorr Illinois home rentals, and home rentals in Dorr Illinois
Apartments for rent, home rentals in Alton Illinois, Alton Illinois house rentals, and Alton Illinois holiday rentals
Vacation homes for rent by owner in Blackhawk and rental homes in Blackhawk
Devise, learn, and find out rental home Knox and rent house.
The Palos Illinois beach listings, well appointed lists of marked properties, private classified ads, and exotic indexes for these field can be mapped.
Espy, identify, and detect rental apartment in Alexander, Alexander Illinois rental homes, house rentals Alexander Illinois, and bed and breakfast rentals in Alexander Illinois.
Palos details could open doors and back your inquest.
Elicit, light upon, and ferret out rental apartment New Lenox, rental homes in New Lenox United States, and bed and breakfast rentals New Lenox United States.
Catch and dig up rental properties in Westmont and rent houses in Westmont United States.
Recognize, come upon, and glimpse short term rentals Media, home rentals Media United States, and real estate rentals in Media United States.
Identify, originate, and relocate bed and breakfast rentals in Cook, houses for rent, and condos for rent.
Distinguish, devise, and observe rent houses, Glen Carbon rent houses, and for rent by owner homes Glen Carbon.
This site, FRBO.com does omit ad hoc domain oceanfront and lakeside timeshare, houseboat, and houses.
Our for rent by owner website can interest and serve oceanfront ad directories and beach listed properties beach indexes, lakeside lists of marked properties, and exotic advertisements to bail out your Palos survey.
Send well-formed and admirable statistics regarding Palos Illinois vacation rental, Palos vacation rental, Palos Illinois for rent by owner homes, and vacation rentals in Palos Illinois found on this extensive website, FRBO.com.
Speculators, possessors, and excursionists who are rummaging Palos vacation homes for rent by owner and are trying to observe homes for rent by owner, apartments for rent in Palos Illinois, and Palos homes for rent by owner can hunt our for rent by owner website and our lakeside online MLS, mountain ad directories, and rustic lists of marked properties.
Conceive and conceive houses for rent in New Berlin United States and New Berlin United States rental home.
Palos Illinois principality employs many property brokers, rental owners, third party agents, and land owners.
Espy and determine vacation homes for rent by owner and homes for rent by owner Cass Illinois.
Join our romantic classified advertisements, hidden lists of marked properties, oceanfront classified advertisements, and private indexes mailing list for bed and breakfast rentals in Palos Illinois, rental properties in Palos Illinois, and for rent by owner homes Palos Illinois.
Come upon, discern, and identify vacation homes for rent by owner Harvel, rent house Harvel, and Harvel United States for rent by owner homes.
Beachfront classifieds and penthouse classified ads vacation homes for rent by owner in Washington Illinois, Washington Illinois rental apartment, rental homes in Washington Illinois, and home rentals Washington Illinois.
Conceive, find, and design Buckley house rentals, rental houses in Buckley United States, and Buckley houses for rent.
|
|
