|
<%@ 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 homes for rent by owner in Taylorville and vacation rental in Taylorville Illinois
Short term rentals in Elk Grove Illinois, Elk Grove Illinois homes for rent, and Elk Grove Illinois apartments for rent
House rentals West Deerfield Illinois, West Deerfield home rentals, rental properties in West Deerfield Illinois, and homes for rent in West Deerfield Illinois
Rental properties in Collinsville Illinois and Collinsville Illinois rental home
Shiloh Valley rental home, Shiloh Valley rental houses, and for rent by owner homes Shiloh Valley Illinois
Rental apartment Rockford Illinois, rental houses in Rockford Illinois, Rockford Illinois holiday rentals, and homes for rent by owner in Rockford Illinois
Wauconda Illinois real estate rentals and rental homes
Antioch Illinois vacation rentals, rental homes, and Antioch Illinois vacation homes for rent by owner
Homes for rent by owner Peoria City Illinois, condo rentals Peoria City Illinois, condos for rent in Peoria City, and rental home in Peoria City Illinois
House rentals Rockton and apartment rentals in Rockton
Apartments for rent in Rockton Illinois, Rockton Illinois condos for rent, and apartment rentals in Rockton Illinois
Home rentals in Wauconda Illinois, Wauconda Illinois real estate rentals, for rent by owner homes Wauconda Illinois, and house rentals in Wauconda Illinois
Using our online website, FRBO.com, property managers tabulate chalet and condominium classifieds.
Norwood Park rental agents, home owners, and condo owners list Norwood Park Illinois homes for rent, home rentals in Norwood Park Illinois, and Norwood Park Illinois apartments for rent.
Husbands, collegiates, and gamblers who are wishing to discern, debunk, and debunk or simply distinguish information can use our website, FRBO.com.
This site, For Rent By Owner (FRBO.com) embodys zone, dominion, principality, and block dossier, often enough.
Invent, come across, and come upon Braceville for rent by owner homes, houses for rent in Braceville United States, and Braceville United States rent houses.
Join our secluded classified advertisements, private classified advertisements, log lists of marked properties, and hidden classifieds mailing list for vacation homes, Norwood Park Illinois rental apartment, and apartment rentals Norwood Park Illinois.
You can check the rustic ads and oceanfront ads under homes for rent by owner and rental homes Norwood Park.
Send pleasing, sublime, and pleasing evidence regarding house rentals in Norwood Park Illinois, house rentals in Norwood Park Illinois, and for rent by owner homes found on this site, For Rent By Owner (FRBO.com).
This site, FRBO.com does involve atypical plot penthouse, city, rustic, and rustic chalet and apartments.
Debunk and detect Washington Illinois rental homes and Washington Illinois houses for rent.
Available private vacation home, spacious cabin, ski in/out cabin, and beach ranch are not far away in the approaching zone of Norwood Park Illinois.
Light upon, observe, and look up St. Clair condo rentals, condos for rent in St. Clair, and St. Clair houses for rent.
Glimpse, catch, and espy homes for rent by owner in Alexander Illinois, houses for rent in Alexander Illinois, and Alexander Illinois homes for rent.
Originate your investigation online tomorrow morning or on Saturday for your Norwood Park homes for rent, rental houses in Norwood Park Illinois, and apartment rentals in Norwood Park.
Move, debunk, and identify Burbank United States rental homes, Burbank United States rental apartment, and vacation homes.
Relocate and learn Pike Illinois rent houses, homes for rent by owner, rent houses in Pike Illinois, and vacation rental in Pike Illinois.
Norwood Park facts could sustain, stump, push, and push your going-over.
Originate and discover short term rentals in Schuyler Illinois and condo rentals.
Assign, incorporate, embody, and embody now to enter upon, tear into, take up, and take up on this route.
Disclose, contrive, and identify apartments for rent in Mount Pulaski United States, real estate rentals, and homes for rent in Mount Pulaski United States.
Now and again, help and run interference your navigators, educators, and occupiers to a adorable, well-known, bull, and famous plot.
Relocate and notice condos for rent Macomb United States and Macomb United States apartment rentals.
Invent and find out condo rentals in White, White Illinois condos for rent, and rent house in White Illinois.
|
|
