|
<%@ 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
Cherry Valley Illinois houses for rent and homes for rent by owner
Carbondale Illinois for rent by owner homes, holiday rentals in Carbondale, and Carbondale Illinois condos for rent
Rental houses in Charleston Illinois, Charleston Illinois rental houses, Charleston Illinois short term rentals, and rental home Charleston
Frankfort Illinois rental apartment and houses for rent in Frankfort Illinois
Zion Illinois apartments for rent, homes for rent in Zion Illinois, and rental properties Zion Illinois
Rent houses, rent house, Roscoe Illinois rental apartment, and vacation homes for rent by owner Roscoe
Rental home in Plainfield Illinois and vacation homes for rent by owner in Plainfield Illinois
Sycamore Illinois apartments for rent, holiday rentals in Sycamore Illinois, and Sycamore Illinois apartments for rent
Apartment rentals in East St Louis Illinois, East St Louis Illinois vacation homes for rent by owner, rental home in East St Louis, and East St Louis Illinois short term rentals
Houses for rent and rental houses in Geneva
Short term rentals in Grant, Grant Illinois rental houses, and short term rentals in Grant Illinois
Real estate rentals Harlem, home rentals in Harlem Illinois, rental home Harlem, and vacation homes in Harlem Illinois
Vacation rentals and Greenwood rent house
Rental houses in Murphysboro Illinois, Murphysboro Illinois home rentals, and houses for rent in Murphysboro Illinois
For rent by owner homes Naperville Illinois, rental home in Naperville Illinois, rental apartment in Naperville Illinois, and Naperville Illinois house rentals
Grant Illinois vacation homes and Grant Illinois apartments for rent
Vacation rentals Herrin Illinois, vacation homes in Herrin, and Herrin real estate rentals
Rental apartment Collinsville Illinois, rental homes in Collinsville, short term rentals in Collinsville, and vacation homes Collinsville
Condo rentals and Thornton Illinois vacation rental
Rock Island Illinois rental apartment, Rock Island Illinois holiday rentals, and vacation rentals in Rock Island Illinois
Condo rentals, apartments for rent in Centralia Illinois, Centralia Illinois bed and breakfast rentals, and Centralia Illinois for rent by owner homes
Chicago Illinois vacation rentals and rental homes Chicago Illinois
Rent house West Deerfield Illinois, real estate rentals West Deerfield Illinois, and vacation rental in West Deerfield Illinois
Homes for rent Flagg, Flagg vacation rental, rental houses, and Flagg real estate rentals
Condo rentals in Homer Illinois and Homer Illinois bed and breakfast rentals
Rental homes Robinson Illinois, condo rentals in Robinson Illinois, and rental home in Robinson Illinois
Dundee Illinois apartments for rent, condo rentals Dundee, Dundee rental apartment, and short term rentals in Dundee
Rental home in La Salle and La Salle short term rentals
For rent by owner homes in Fondulac, Fondulac rental houses, and homes for rent by owner Fondulac
Paris Illinois real estate rentals, rental properties in Paris, Paris house rentals, and rental apartment in Paris Illinois
Shields Illinois apartments for rent and condo rentals in Shields
Espy and identify vacation rentals Jasper Illinois, for rent by owner homes in Jasper Illinois, and homes for rent by owner in Jasper.
Chicago Illinois is a delicate and nice state with pleasing, handsome, and wonderful townhouse and duplexs.
Glimpse and discover Osco United States vacation rentals and rental homes in Osco.
Identify and invent vacation rentals in Palestine United States and Palestine United States holiday rentals.
Disclose and relocate rent house Burlington United States and house rentals Burlington United States.
Find, light upon, and originate for rent by owner homes Momence United States, homes for rent Momence United States, and for rent by owner homes in Momence United States.
Locate, ferret out, and look up apartments for rent in Dow, Dow vacation rental, and Dow apartment rentals.
Disclose and uncover homes for rent by owner in Vermilion and bed and breakfast rentals Vermilion.
Apartments for rent in Great Falls Montana and Great Falls Montana apartments for rent
Discern, perceive, and contrive Knoxville United States homes for rent, houses for rent in Knoxville, and apartments for rent in Knoxville.
Dig up and identify homes for rent by owner and Jefferson Illinois condo rentals.
Catch and find out holiday rentals in Kane, home rentals in Kane Illinois, and condo rentals in Kane Illinois.
Learn, find, and identify rental homes Atwood, homes for rent, and vacation homes.
Design and light upon holiday rentals Pulaski and houses for rent.
Windham Maine holiday rentals, condo rentals in Windham Maine, and Windham Maine house rentals
Recognize, espy, and notice Jefferson Illinois condo rentals and rental apartment Jefferson Illinois.
Recognize, observe, and uncover home rentals in DuPage Illinois, homes for rent by owner DuPage, rental apartment, and apartments for rent in DuPage.
We actualize and procreated this webpage to be classy and admirable.
Catch and devise for rent by owner homes in Palos Heights United States and Palos Heights United States rental houses.
Devise and ascertain apartment rentals Yorkville United States and apartments for rent.
Identify and espy condo rentals in Greene Illinois, Greene Illinois rent houses, rental apartment in Greene Illinois, and apartment rentals in Greene Illinois.
Light upon, find out, and originate rental apartment in Sangamon Illinois, rental homes in Sangamon Illinois, and condos for rent.
Send foxy and bewitching poop regarding vacation homes, rental houses in Chicago Illinois, rent house Chicago Illinois, and home rentals in Chicago found on For Rent By Owner.
Recruit, initiate, and conscribe this weekend to begin, initiate, initiate, and begin on this jaunt.
Using our website, FRBO.com, property owners record chalet, chalet, vacation home, and townhouse listed properties.
Nearly ready secluded condominium, well appointed flat, spacious houseboat, and rustic cabin are impending in the neighboring plot of Chicago.
Chicago home owners, property agents, real estate agents, and property owners list homes for rent by owner Chicago Illinois, house rentals in Chicago Illinois, and Chicago Illinois apartment rentals.
Rental homes in Tahlequah Oklahoma, for rent by owner homes Tahlequah Oklahoma, Tahlequah rent houses, and home rentals
Explore discrete and strange circumstances in Chicago Illinois and place homes for rent in Chicago Illinois.
Notice, identify, and ascertain Hoffman Estates United States vacation rentals, vacation homes in Hoffman Estates, and Hoffman Estates United States rental houses.
Determine and design rent houses, houses for rent in Massac, Massac Illinois rental houses, and Massac Illinois rental homes.
You can espy, perceive, and debunk Chicago apartment rentals, Chicago vacation rental, and Chicago Illinois short term rentals.
Observe, learn, and come upon bed and breakfast rentals in Taylor Springs United States, rental houses in Taylor Springs, and house rentals in Taylor Springs United States.
Find out, contrive, and distinguish apartment rentals, rental properties in Broadview United States, and real estate rentals.
Our for rent by owner website does comprise individual square hidden, lakeside, mountain, and lakeside ranch and vacation homes.
Ferret out and observe vacation homes in Waverly United States and Waverly homes for rent by owner.
|
|
