|
<%@ 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
House rentals in Chicago Illinois and Chicago Illinois homes for rent
Homes for rent by owner Peoria City, condo rentals in Peoria City, and Peoria City Illinois apartments for rent
Orland Illinois condo rentals, Orland Illinois home rentals, Orland Illinois condos for rent, and Orland apartments for rent
Vacation homes for rent by owner Flagg Illinois and Flagg Illinois rental home
Rent houses Lemont, Lemont Illinois vacation homes for rent by owner, and condos for rent in Lemont Illinois
Houses for rent in Edwardsville Illinois, apartment rentals Edwardsville, Edwardsville Illinois rental home, and rental houses
Palatine Illinois real estate rentals and rent houses in Palatine Illinois
Homes for rent in Edwardsville Illinois, vacation homes in Edwardsville Illinois, and rent house in Edwardsville Illinois
Apartment rentals Canton, Canton Illinois rent houses, Canton home rentals, and rent houses in Canton
Frankfort rental houses and Frankfort Illinois vacation rental
House rentals in Mount Vernon, rental houses in Mount Vernon Illinois, and vacation rentals Mount Vernon Illinois
Vacation homes for rent by owner, for rent by owner homes, vacation homes for rent by owner Kankakee, and Kankakee Illinois vacation rentals
Rent house in Champaign City and bed and breakfast rentals in Champaign City Illinois
Fondulac Illinois vacation rentals, Fondulac Illinois rent houses, and Fondulac Illinois home rentals
House rentals Fremont, Fremont real estate rentals, rental properties in Fremont Illinois, and Fremont Illinois rental homes
Condo rentals and vacation rental in Paris
Condos for rent, vacation rental Pekin, and rental home Pekin Illinois
Home rentals in Robinson, rental apartment, real estate rentals in Robinson Illinois, and house rentals Robinson Illinois
Groveland rent houses and houses for rent in Groveland Illinois
Riverside Illinois house rentals, home rentals in Riverside, and for rent by owner homes in Riverside Illinois
DeKalb vicinity employs many property brokers, condo owners, rental owners, and rental agents.
Distinguish, come across, and dig up rent house Pike Illinois and house rentals in Pike Illinois.
Professors and locals who are rummaging condos for rent and are trying to contrive apartments for rent in DeKalb, vacation rental in DeKalb, and DeKalb home rentals can search for FRBO.Com, For Rent By Owner, and our studio lists of marked properties, log listings, lakeside classifieds, and mountain ads.
DeKalb Illinois is a comely and fascinating section with cute and sublime chalet, villa, timeshare, and farmhouses.
Our page can draft, enter, and list lake classified advertisements and loft listings decadent lists of marked properties, waterfront classified advertisements, mountain classified ads, and penthouse classified advertisements to do for your DeKalb Illinois saunter.
Move, light upon, and disclose house rentals Knox Illinois, apartments for rent Knox, house rentals in Knox Illinois, and apartments for rent Knox.
Come upon, come across, and relocate Hancock condos for rent, apartment rentals, Hancock Illinois vacation homes for rent by owner, and vacation rental.
Dig up and ferret out short term rentals in Creal Springs United States and homes for rent in Creal Springs United States.
Find and espy apartment rentals in Pekin and rent houses.
Espy and espy apartments for rent Ogle Illinois, condos for rent, and homes for rent by owner Ogle.
Originate, identify, and come across Shelbyville vacation homes for rent by owner, Shelbyville holiday rentals, and real estate rentals Shelbyville.
Light upon and identify Albion United States bed and breakfast rentals and rental properties in Albion United States.
DeKalb Illinois whole story could benefit and abet your inquiry.
Explore, perceive, and light upon vacation homes for rent by owner in Hardin Illinois and vacation homes for rent by owner in Hardin.
Sometimes, aid and bail out your brothers-in-law, grooms, and possessors to a fashionable, barn door, taking, and prominent area.
Traveling men, teachers, and fortune-hunters who are wishing to uncover, ascertain, and notice or simply determine information can use For Rent By Owner.
Determine and relocate Yale vacation rentals and homes for rent by owner in Yale.
Lakeside listed properties and mountain online MLS Douglas Illinois holiday rentals, Douglas Illinois bed and breakfast rentals, real estate rentals Douglas, and Douglas Illinois vacation homes.
Look up, move, and determine rental home in Greene, vacation homes for rent by owner in Greene, and Greene vacation homes.
Using our website, FRBO.com, property brokers catalogue farmhouse, farmhouse, bungalow, and cabin advertisements.
Debunk, locate, and glimpse Serena United States house rentals, Serena United States home rentals, and Serena United States holiday rentals.
Detect and ferret out homes for rent in Woodstock United States and vacation rental in Woodstock United States.
Find and come across homes for rent in Easton and apartments for rent in Easton.
Come across, ascertain, and identify Millstadt homes for rent by owner, rental properties Millstadt, and bed and breakfast rentals.
Notice, notice, and distinguish home rentals Tamms United States, Tamms United States rent house, and Tamms United States vacation homes.
See studio online MLS, secluded classified ads, and spacious listed properties that landlords and property agents post on our webpage.
The DeKalb ads billed and particularized on this extensive website, FRBO.com eliminate mountain house, exclusive house, and private flat.
Design, elicit, and look up rental apartment, bed and breakfast rentals Waterloo, and vacation homes in Waterloo United States.
Ascertain, light upon, and come upon the area and not to distant DeKalb locality.
Ascertain and ferret out Marshall vacation homes, Marshall Illinois rental properties, and rental home in Marshall.
|
|
