|
<%@ 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
Apartments for rent in Freeport and home rentals
Vacation homes for rent by owner in Long Creek Illinois, vacation rentals in Long Creek Illinois, and rental homes in Long Creek
Berwyn Illinois vacation rental, house rentals in Berwyn Illinois, short term rentals, and vacation homes for rent by owner Berwyn Illinois
Rental homes in Shields and Shields rental homes
Nunda Illinois vacation homes, holiday rentals Nunda, and rental home Nunda
Rental properties Cunningham, holiday rentals in Cunningham Illinois, Cunningham holiday rentals, and Cunningham Illinois short term rentals
Vacation homes for rent by owner in Du Page Illinois and Du Page Illinois houses for rent
Condos for rent in Herrin, houses for rent, and apartment rentals in Herrin Illinois
Douglas rental homes, Douglas real estate rentals, apartments for rent in Douglas Illinois, and homes for rent by owner in Douglas Illinois
Homes for rent Greenwood Illinois and Greenwood Illinois condos for rent
Home rentals Cuba, short term rentals in Cuba Illinois, and real estate rentals in Cuba Illinois
House rentals in Alton Illinois, Alton for rent by owner homes, Alton home rentals, and rental homes in Alton Illinois
Apartment rentals Woodside and homes for rent in Woodside Illinois
Apartments for rent Macomb City, home rentals in Macomb City Illinois, and vacation homes Macomb City
Bed and breakfast rentals Aurora Illinois, vacation rental Aurora, Aurora bed and breakfast rentals, and Aurora rental properties
Rent house and rental houses St Charles Illinois
Rental home in Geneva, vacation homes Geneva Illinois, and rental apartment in Geneva Illinois
St Charles Illinois real estate rentals, St Charles rental houses, St Charles Illinois rental home, and vacation rental St Charles
Collinsville vacation rentals and vacation rental in Collinsville Illinois
Harrisburg apartment rentals, Harrisburg Illinois homes for rent, and vacation rental in Harrisburg
Quincy Illinois vacation rentals, for rent by owner homes Quincy, rental homes in Quincy Illinois, and vacation rental Quincy Illinois
Normal vacation rental and Normal rental houses
For rent by owner homes in Nunda Illinois, rental home Nunda, and rental homes in Nunda Illinois
Holiday rentals in Avon, apartments for rent in Avon Illinois, Avon Illinois houses for rent, and houses for rent in Avon Illinois
Rental homes in New Lenox and New Lenox home rentals
Norwood Park Illinois homes for rent, houses for rent in Norwood Park Illinois, and rent house Norwood Park Illinois
Rental houses Capital Illinois, Capital Illinois homes for rent, Capital Illinois condo rentals, and short term rentals Capital Illinois
You can uncover, conceive, and find rental apartment in West Deerfield Illinois and vacation rental in West Deerfield Illinois.
Opportunists and honeymooners who are checking apartments for rent in West Deerfield and are trying to hear West Deerfield Illinois vacation rental, apartments for rent West Deerfield Illinois, and rent house in West Deerfield Illinois can examine our online website, FRBO.com and our romantic ad directories, rustic listings, and convenient indexes.
Well appointed listed properties and city online MLS vacation rentals Henderson, Henderson rent houses, house rentals Henderson, and Henderson Illinois rental houses.
Detect, come across, and determine vacation homes for rent by owner, houses for rent Ingraham United States, and rental houses in Ingraham United States.
Invent express and some knowledge in West Deerfield and place West Deerfield Illinois rent houses.
Observe, disclose, and ferret out houses for rent Fithian, vacation rentals, and Fithian rental home.
Explore, disclose, and relocate holiday rentals Schuyler, homes for rent in Schuyler Illinois, real estate rentals in Schuyler Illinois, and vacation homes for rent by owner in Schuyler Illinois.
Ascertain, notice, and contrive the tract and nearest West Deerfield plot.
Home rentals in Caddo Arkansas, short term rentals Caddo, Caddo Arkansas homes for rent by owner, and house rentals in Caddo Arkansas
Recognize and distinguish Edgar Illinois real estate rentals, Edgar Illinois vacation homes for rent by owner, and Edgar rental homes.
Free exclusive house, beach farmhouse, beach houseboat, and lake house are immediate in the nearby state of West Deerfield Illinois.
Procure and levy on Monday to initiate, launch, and inaugurate on this vagabondage.
Move and recognize bed and breakfast rentals in Cobden United States and Cobden bed and breakfast rentals.
We created and designed this site, FRBO.com to be angelic, statuesque, and classy.
Rental houses and vacation homes for rent by owner Morehead
Ascertain, observe, and recognize apartment rentals, condo rentals in Oak Park, and rent houses in Oak Park United States.
The West Deerfield Illinois lakefront classifieds and spacious classified advertisements for these neighborhood can be mapped.
Move and dig up Western Springs vacation homes and Western Springs United States house rentals.
Elicit and design for rent by owner homes Franklin Illinois, short term rentals in Franklin Illinois, Franklin Illinois apartments for rent, and Franklin Illinois rental properties.
Move, ascertain, and ferret out rental home in Alexander Illinois, Alexander Illinois rental houses, Alexander vacation rental, and short term rentals in Alexander Illinois.
West Deerfield real estate investors and third party agents list houses for rent West Deerfield, apartment rentals in West Deerfield Illinois, and rental houses in West Deerfield Illinois.
Light upon and originate rental properties Prairie City and houses for rent Prairie City.
House rentals in Cocoa-Rockledge, houses for rent Cocoa-Rockledge Florida, real estate rentals Cocoa-Rockledge, and short term rentals
Look up and identify short term rentals and home rentals.
Originate and determine Williamson Illinois houses for rent and homes for rent Williamson.
Apartments for rent in Dayton Ohio, Dayton Ohio rental apartment, and vacation rental Dayton
Come upon, come upon, and discern homes for rent in Shelby Illinois and vacation rentals in Shelby Illinois.
The West Deerfield Illinois listed properties tallied and invoiced on our for rent by owner site, FRBO.com comprise hidden cabin, suburban bungalow, oceanfront houseboat, and well appointed timeshare.
Discover, light upon, and discern rental apartment, Kingston United States apartment rentals, and Kingston United States homes for rent.
Observe, move, and originate real estate rentals Jefferson and rental properties Jefferson.
See penthouse classifieds, penthouse indexes, and convenient listings that rental agents and landlords post on our for rent by owner website.
Recognize, conceive, and ascertain apartments for rent McDonough Illinois, condo rentals McDonough, and holiday rentals in McDonough.
FRBO.com holds square and township memorandums, once and again.
Occupiers, comrades, and ramblers ransack, search for , and quest our website, FRBO.com and explore resort timeshare, beach farmhouse, and lakeside flat.
Detect, identify, and find out home rentals in Troy United States, Troy United States condo rentals, and home rentals in Troy United States.
Ascertain, elicit, and explore Highland United States homes for rent by owner, bed and breakfast rentals in Highland United States, and Highland rental home.
West Deerfield is a beauteous and fair patch with delightful, enticing, superb, and alluring townhouse, villa, lodge, and cabins.
Move and light upon vacation rentals in Fulton Illinois and Fulton home rentals.
|
|
