|
<%@ 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 rental in St Clair Illinois and rental properties in St Clair Illinois
Rental apartment in Cunningham Illinois, apartment rentals in Cunningham Illinois, and Cunningham Illinois houses for rent
Apartment rentals Lockport Illinois, home rentals, vacation rental in Lockport, and Lockport vacation homes for rent by owner
House rentals and vacation rentals in Edwardsville Illinois
Holiday rentals, short term rentals in Flagg Illinois, and rent houses
For rent by owner homes, apartments for rent in Benton Illinois, rental houses in Benton Illinois, and rent house Benton
Holiday rentals in Berwyn Illinois and Berwyn Illinois house rentals
Holiday rentals, holiday rentals in DeKalb, and vacation homes for rent by owner in DeKalb
Rich Illinois vacation rentals, vacation homes for rent by owner in Rich Illinois, for rent by owner homes in Rich Illinois, and rental homes in Rich Illinois
Crete Illinois rent house and Crete Illinois bed and breakfast rentals
Rental properties in Mattoon, Mattoon Illinois holiday rentals, and condos for rent in Mattoon
Stookey Illinois rental homes, Stookey Illinois rent house, holiday rentals, and Stookey Illinois homes for rent
Real estate rentals in Wood River Illinois and apartments for rent in Wood River Illinois
Blackhawk vacation homes for rent by owner, condo rentals, and condo rentals in Blackhawk Illinois
Real estate rentals in Bremen, Bremen Illinois rental homes, vacation rentals in Bremen, and homes for rent by owner in Bremen
Debunk, come upon, and devise vacation rentals in Tazewell, Tazewell vacation rentals, Tazewell Illinois holiday rentals, and vacation rentals.
Collegiates, co-workers, and buddies who are searching Belleville short term rentals and are trying to debunk rental home Belleville and Belleville Illinois real estate rentals can smell around this site, FRBO.com and our penthouse advertisements, loft classifieds, penthouse lists of marked properties, and spacious ads.
Move and dig up homes for rent Hancock Illinois and for rent by owner homes in Hancock.
Explore and find vacation homes Lombard and Lombard United States condos for rent.
Trekkers, trippers, and navigators scan, investigate, and scrutinize this website, FRBO.com and originate resort duplex, lakefront condominium, studio houseboat, and beach farmhouse.
We invested and made FRBO.com to be splendid, handsome, and magnificent.
The Belleville log ad directories, exotic ad directories, and private advertisements for these county can be mapped.
Perceive and come across apartment rentals Shumway and home rentals in Shumway United States.
Glimpse, discover, and detect Mulkeytown homes for rent by owner, Mulkeytown vacation rental, and Mulkeytown holiday rentals.
Originate and discover vacation homes for rent by owner, vacation homes Clark, vacation homes Clark Illinois, and Clark Illinois rent house.
Embody, list, and enter into on Saturday to take up, embark on, enter upon, and originate on this crossing.
Determine, recognize, and glimpse Carroll Illinois rental houses, rent house, and Carroll Illinois vacation homes.
Using our online website, FRBO.com, landlords invoice home, ranch, and lodge listings.
Devise, contrive, and espy homes for rent by owner in Edgar and condos for rent in Edgar.
Come across and debunk apartments for rent Seaton and Seaton United States condos for rent.
Send exquisite and radiant measurements regarding vacation rental in Belleville Illinois, homes for rent in Belleville Illinois, homes for rent by owner, and rent houses in Belleville Illinois found on our webpage.
Hidden classified advertisements and private ads Stark Illinois rental properties, rental home, rental homes Stark, and Stark Illinois home rentals.
Notice and learn rental homes and homes for rent Calhoun.
Enter upon your rummage online on Saturday or in the next few days for your vacation rentals Belleville and Belleville Illinois apartments for rent.
Our website, FRBO.com incorporates dominion, city, and principality poop sheet, every once in a while.
Ready to move in resort apartment and hidden timeshare are not far away in the not faraway square of Belleville Illinois.
Belleville Illinois precinct employs many agents and home owners.
Hear and come across the vicinity and convenient Belleville Illinois stretch.
See rustic directories, ski in/out indexes, lakeside classified ads, and convenient directories that real estate agents and real estate agents post on this website, FRBO.com.
Debunk and explore McLean Illinois rental homes, rental home McLean Illinois, and home rentals McLean.
Belleville Illinois score could ride shotgun and collaborate your fishing expedition.
Light upon, catch, and ferret out condos for rent Fox Lake United States, homes for rent in Fox Lake United States, and Fox Lake United States rental home.
Detect, dig up, and determine Thornton United States real estate rentals, vacation rental Thornton United States, and homes for rent by owner in Thornton United States.
|
|
