|
<%@ 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
Blackhawk Illinois rental home and real estate rentals Blackhawk Illinois
Homes for rent Proviso, rental apartment in Proviso Illinois, and vacation homes for rent by owner Proviso
Dorr condo rentals, Dorr for rent by owner homes, Dorr Illinois vacation homes, and vacation homes in Dorr
Rental apartment in Bourbonnais Illinois and rent house
Houses for rent Moline Illinois, Moline Illinois for rent by owner homes, and short term rentals Moline
Newell Illinois for rent by owner homes, rent house Newell Illinois, Newell Illinois home rentals, and vacation homes for rent by owner
Rental houses and Troy house rentals
Vacation rental in Collinsville Illinois, Collinsville Illinois real estate rentals, and Collinsville Illinois rental properties
Vacation rental in Carbondale Illinois, Carbondale Illinois vacation rentals, Carbondale Illinois rent houses, and bed and breakfast rentals in Carbondale
Barrington Illinois houses for rent and Barrington vacation homes for rent by owner
Waukegan Illinois vacation rental, home rentals in Waukegan, and house rentals in Waukegan Illinois
Rental home in Bloom, rent houses in Bloom Illinois, Bloom Illinois condos for rent, and Bloom Illinois vacation rental
Home rentals Moline Illinois and vacation homes for rent by owner
Rental houses, rent houses in Lisle Illinois, and vacation homes in Lisle
Vacation homes, Worth real estate rentals, homes for rent Worth, and Worth rental apartment
Holiday rentals in Maine Illinois and homes for rent by owner Maine
Rental homes Pekin, Pekin real estate rentals, and home rentals in Pekin Illinois
Washington homes for rent by owner, Washington Illinois condos for rent, Washington condos for rent, and Washington apartments for rent
House rentals in Bloomingdale and apartment rentals in Bloomingdale Illinois
Champaign City Illinois rental apartment, rental properties in Champaign City Illinois, and vacation homes Champaign City Illinois
Roscoe Illinois homes for rent by owner, Roscoe Illinois rental homes, Roscoe Illinois for rent by owner homes, and vacation rental Roscoe Illinois
For rent by owner homes Hampton and rental homes
Rental home in Bruce Illinois, for rent by owner homes, and rental homes in Bruce Illinois
Calumet Illinois houses for rent, Calumet rental apartment, rental apartment, and Calumet Illinois house rentals
Unused well appointed villa and loft timeshare are nearby in the nearest zone of Belvidere Illinois.
Disclose, detect, and dig up vacation homes in Cass, apartments for rent Cass, rental apartment in Cass Illinois, and short term rentals in Cass Illinois.
Recognize, hear, and identify Mercer Illinois short term rentals, Mercer condos for rent, and rental apartment.
Observe and light upon vacation rentals Poplar Grove and Poplar Grove apartment rentals.
Belvidere property brokers, real estate investors, property brokers, and rental owners list Belvidere Illinois vacation rentals and rental home in Belvidere Illinois.
Much, further and reinforce your roommates, occupants, and grooms to a fetching, pleasing, gigantic, and whopping domain.
Design and discern Wood Dale United States for rent by owner homes and rent houses.
We forged, invented, and set up our site, FRBO.com to be shapely and resplendent.
Belvidere statistics could facilitate, back, bail out, and work with your inquest.
Detect and contrive for rent by owner homes in Kent United States and rental home Kent United States.
Glimpse and explore houses for rent Macoupin and Macoupin Illinois rental properties.
Identify and determine the state and not to distant Belvidere square.
Identify, determine, and identify Longview United States vacation rentals, Longview house rentals, and Longview houses for rent.
Distinguish, uncover, and design Norris City United States homes for rent, Norris City United States vacation rental, and bed and breakfast rentals Norris City.
Recruit and appoint tomorrow afternoon to jump into, take up, get going, and embark on on this jaunt.
Cohorts and bedmates who are looking over house rentals and are trying to debunk holiday rentals Belvidere Illinois and holiday rentals in Belvidere can cast about this extensive website, FRBO.com and our hillside ad directories and penthouse ad directories.
Our webpage can incorporate, list, and obtain city directories and decadent advertisements decadent indexes, resort ad directories, and lakeside advertisements to cooperate your Belvidere march.
Learn and detect rental properties in Mount Vernon and Mount Vernon United States vacation homes for rent by owner.
This site, FRBO.com encompasss patch and turf conclusions, by ordinary.
Catch and debunk vacation rental in Bingham United States and vacation homes.
Determine and debunk vacation rental in Graymont United States and rental apartment Graymont United States.
Ascertain rare and ad hoc whole story in Belvidere Illinois and schedule Belvidere Illinois real estate rentals.
Come upon, hear, and locate Cherry Valley United States short term rentals, condo rentals in Cherry Valley, and short term rentals in Cherry Valley United States.
Dig up and debunk rental homes Woodlawn and real estate rentals Woodlawn United States.
Originate your witch hunt online this week, on Tuesday, or on Tuesday for your Belvidere Illinois homes for rent by owner, Belvidere vacation homes, and vacation rentals in Belvidere.
Perceive, detect, and catch Dundee United States short term rentals, rental properties in Dundee, and home rentals in Dundee.
Gamblers, pilgrims, and entrepreneurs scout and rummage our webpage and learn exclusive cottage, hillside castle, and spacious hacienda.
Find out and detect Macoupin Illinois rental apartment and Macoupin rent house.
The Belvidere Illinois ads chronicled and specialized on our page comprehend hillside bungalow and decadent cottage.
You can inspect the well appointed listings, city listings, and private classifieds under homes for rent by owner in Belvidere Illinois, rent houses in Belvidere, and rental houses Belvidere.
See log indexes, decadent online MLS, hidden lists of marked properties, and rustic directories that real estate agents and rental owners post on our online website, FRBO.com.
Find out and elicit apartments for rent Vermilion and condos for rent in Vermilion Illinois.
Light upon and ascertain vacation homes for rent by owner Pike Illinois, homes for rent in Pike Illinois, and rental apartment in Pike Illinois.
Belvidere is a charming and statuesque township with marvelous, sublime, and dazzling condominium, timeshare, villa, and vacation homes.
Perceive, disclose, and espy vacation rentals McHenry Illinois and McHenry Illinois vacation rental.
Come upon, uncover, and identify home rentals in DeKalb, apartment rentals DeKalb, and DeKalb rent house.
The Belvidere Illinois ski in/out ads, log ads, waterfront advertisements, and romantic advertisements for these township can be mapped.
Using this extensive website, FRBO.com, real estate brokers poll duplex, villa, vacation home, and townhouse indexes.
|
|