|
<%@ 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
Algonquin Illinois apartments for rent and rental properties Algonquin
Vacation homes for rent by owner McHenry, homes for rent McHenry Illinois, and rent houses McHenry
Northfield rent house, vacation homes, bed and breakfast rentals Northfield Illinois, and holiday rentals in Northfield Illinois
For rent by owner homes and homes for rent by owner
Edwardsville Illinois rental homes, vacation homes in Edwardsville Illinois, and Edwardsville Illinois condo rentals
Holiday rentals in Greenwood, homes for rent in Greenwood Illinois, Greenwood Illinois condos for rent, and condo rentals Greenwood Illinois
Herrin Illinois rental houses and Herrin Illinois rental home
Rental houses, Pekin Illinois holiday rentals, and Pekin Illinois rental apartment
Bed and breakfast rentals in Addison Illinois, homes for rent in Addison, rent house, and rental homes Addison Illinois
Bed and breakfast rentals in Greenwood Illinois and home rentals in Greenwood
Bed and breakfast rentals in West Deerfield Illinois, West Deerfield Illinois homes for rent, and vacation homes West Deerfield Illinois
Rental houses in DeKalb Illinois, homes for rent in DeKalb Illinois, home rentals in DeKalb, and DeKalb rental properties
Shiloh Valley Illinois houses for rent and Shiloh Valley Illinois house rentals
Condos for rent in Woodside Illinois, apartment rentals Woodside Illinois, and Woodside Illinois apartment rentals
Vacation homes for rent by owner in Kankakee, apartments for rent Kankakee, house rentals in Kankakee, and holiday rentals in Kankakee
Explore and devise rental houses Knox Illinois, rental homes Knox, real estate rentals Knox, and Knox homes for rent.
Join our loft online MLS, loft listings, and spacious online MLS mailing list for Macomb City homes for rent by owner and rental apartment Macomb City.
Look up and light upon Magnolia United States condo rentals and Magnolia United States real estate rentals.
Elicit and observe bed and breakfast rentals and Bridgeview United States condos for rent.
Espy and find out Scott Illinois apartments for rent and Scott Illinois vacation rentals.
Locate, observe, and uncover apartments for rent in Jefferson Illinois, Jefferson Illinois homes for rent by owner, and Jefferson Illinois house rentals.
Using this extensive website, FRBO.com, brokers leasing foreclosures itemize cottage, vacation home, farmhouse, and cottage online MLS.
Notice, look up, and identify condo rentals, houses for rent, apartments for rent Carroll Illinois, and Carroll rental houses.
The Macomb City listings run down and detailed on our for rent by owner website comprise waterfront vacation home, suburban villa, and convenient villa.
Learn, espy, and light upon homes for rent by owner in Melvin United States, apartment rentals in Melvin, and vacation rentals Melvin United States.
Locate, contrive, and catch apartments for rent in Homewood, rental properties in Homewood United States, and holiday rentals in Homewood.
This website, FRBO.com does subsume special section hillside and ski in/out farmhouse, houseboat, and haciendas.
Locate and dig up rental properties Greene and short term rentals Greene Illinois.
Ferret out and distinguish Riverside United States bed and breakfast rentals and apartments for rent Riverside.
Embark on your quest online now, tomorrow evening, tonight, or on Saturday for your Macomb City Illinois apartments for rent and rent houses in Macomb City.
Ready to move in decadent duplex, studio duplex, well appointed farmhouse, and beach home are not far away in the nearest turf of Macomb City Illinois.
Uncover, find out, and discover apartments for rent Brocton, Brocton vacation homes, and homes for rent by owner.
Debunk discrete and rare knowledge in Macomb City Illinois and tally Macomb City home rentals.
Itinerants and honeymooners who are wishing to learn, come upon, and conceive or simply hear information can use our online website, FRBO.com.
Expeditionists and bedmates who are seeking Macomb City vacation rentals and are trying to hear Macomb City Illinois rental properties and vacation homes for rent by owner in Macomb City Illinois can look our for rent by owner website and our city classified advertisements, log directories, hillside classified advertisements, and mountain listed properties.
Distinguish and move condo rentals in Kane and Kane Illinois rental homes.
Entrepreneurs, occupants, and roomers ferret and chase after our for rent by owner website and conceive log timeshare, lake farmhouse, secluded house, and exclusive home.
|
|
