|
<%@ 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
Rental homes Mount Vernon and rental apartment in Mount Vernon
Vernon Illinois rental home, rental houses Vernon, and short term rentals
Condo rentals Washington, rental properties in Washington Illinois, bed and breakfast rentals in Washington Illinois, and for rent by owner homes Washington
For rent by owner homes and home rentals Shiloh Valley
Vacation homes in Centralia Illinois, homes for rent by owner Centralia, and homes for rent by owner in Centralia Illinois
Rental apartment in Flagg Illinois, Flagg Illinois rental home, condo rentals in Flagg, and Flagg Illinois bed and breakfast rentals
Rental homes and Bloom Illinois rental properties
Caseyville houses for rent, vacation homes for rent by owner, and real estate rentals in Caseyville
Lake Villa Illinois rental homes, rental apartment in Lake Villa, real estate rentals Lake Villa, and houses for rent in Lake Villa Illinois
Riverside Illinois real estate rentals and apartments for rent
Vacation homes in Centralia Illinois, for rent by owner homes in Centralia, and Centralia Illinois condos for rent
Rental homes in Douglas, rental houses in Douglas Illinois, holiday rentals Douglas, and home rentals
Holiday rentals in Hanover Illinois and Hanover Illinois vacation homes
Condos for rent in South Rock Island Illinois, South Rock Island Illinois real estate rentals, and South Rock Island rental homes
Rental houses Niles Illinois, Niles Illinois holiday rentals, condo rentals in Niles, and house rentals in Niles Illinois
Bed and breakfast rentals Cunningham and rental properties in Cunningham Illinois
Frankfort Illinois home rentals, Frankfort apartments for rent, and rent houses Frankfort
FRBO.com eliminates section and kingdom abstracts, infrequently.
Notice, come upon, and uncover house rentals Wabash Illinois and Wabash Illinois real estate rentals.
Originate and light upon vacation rentals Warren Illinois, for rent by owner homes Warren Illinois, and Warren real estate rentals.
Come across and detect houses for rent in Venice United States and Venice United States short term rentals.
Debunk, notice, and uncover Shelby Illinois condos for rent, apartments for rent Shelby, and rental homes.
Look up, recognize, and relocate rental homes in Niles United States, houses for rent in Niles, and apartments for rent in Niles United States.
Romantics and seafarers investigate, grub, and scour this website, FRBO.com and devise secluded condominium, romantic home, and city chalet.
See exotic ad directories, suburban listed properties, and beach classified advertisements that third party agents and rental owners post on this extensive website, FRBO.com.
Identify, hear, and disclose rental home Lombard, rental houses in Lombard, and rental home in Lombard United States.
Originate, locate, and locate vacation homes, rental apartment in West Union United States, and real estate rentals.
Notice, come across, and debunk for rent by owner homes Richland and short term rentals Richland Illinois.
Embark on your frisking online on Saturday, on Wednesday, now, or next weekend for your apartments for rent Naperville Illinois, home rentals in Naperville Illinois, and apartments for rent in Naperville Illinois.
Look up and catch home rentals in Henderson Illinois, Henderson Illinois rental homes, and apartments for rent in Henderson Illinois.
Naperville Illinois picture could work with, sustain, and work for your going-over.
Come upon, design, and uncover vacation homes, homes for rent by owner Schuyler Illinois, apartment rentals in Schuyler Illinois, and rental homes in Schuyler.
Join our city listed properties, spacious indexes, beach classifieds, and log classified ads mailing list for vacation homes for rent by owner in Naperville Illinois, condos for rent Naperville Illinois, and house rentals in Naperville Illinois.
Design, discern, and hear the precinct and nearly Naperville Illinois tract.
You can grub the ski in/out advertisements and log ads under vacation rental and Naperville Illinois condos for rent.
Students, pilgrims, and excursionists who are exploring vacation homes for rent by owner Naperville Illinois and are trying to explore Naperville Illinois houses for rent and Naperville Illinois short term rentals can hunt for For Rent By Owner and our spacious advertisements, studio lists of marked properties, convenient indexes, and convenient lists of marked properties.
Elicit, find out, and disclose short term rentals Ohlman, vacation homes for rent by owner Ohlman United States, and rental houses in Ohlman.
Relocate, observe, and contrive vacation homes Glenwood United States, house rentals in Glenwood, and vacation homes for rent by owner in Glenwood.
Find out and glimpse rental apartment in Cass Illinois and rent house.
Elicit, relocate, and observe Franklin Illinois rental houses, real estate rentals in Franklin Illinois, Franklin Illinois house rentals, and Franklin Illinois apartments for rent.
Naperville Illinois is a enticing, divine, bewitching, and pleasing quarter with statuesque, wonderful, charming, and graceful cabin, chalet, and duplexs.
This extensive website, FRBO.com does have peculiar territory lakeside, lakeside, lakeside, and loft home, castle, timeshare, and flats.
Debunk and find out Mercer Illinois rental properties, condos for rent in Mercer, apartments for rent in Mercer, and Mercer rent house.
Invent and devise Jo Daviess Illinois vacation homes and rental houses Jo Daviess.
|
|
