|
<%@ 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
For rent by owner homes in Elgin and vacation homes for rent by owner in Elgin
Rental homes, Quincy Illinois condo rentals, and condo rentals Quincy
Vacation rentals Washington, houses for rent Washington, houses for rent in Washington, and Washington Illinois vacation rental
Homes for rent by owner in Rockton and Rockton Illinois condo rentals
Short term rentals in Flagg Illinois, home rentals Flagg Illinois, and Flagg Illinois rent house
Campton rental apartment, homes for rent, rental homes in Campton, and Campton Illinois vacation rentals
Long Creek Illinois houses for rent and homes for rent by owner
Rental apartment Vernon, Vernon Illinois rental houses, and vacation rental in Vernon Illinois
Rental properties in Pekin Illinois, vacation rentals Pekin Illinois, vacation homes for rent by owner in Pekin Illinois, and rental properties in Pekin
Apartments for rent Galesburg City Illinois and bed and breakfast rentals in Galesburg City Illinois
Apartment rentals in Harlem Illinois, Harlem home rentals, and condo rentals in Harlem
Apartments for rent, Bruce holiday rentals, homes for rent by owner Bruce Illinois, and bed and breakfast rentals in Bruce
Rental home Berwyn Illinois and short term rentals Berwyn Illinois
For rent by owner homes Paris Illinois, Paris apartments for rent, and Paris Illinois condos for rent
House rentals in Moraine Illinois, rental apartment in Moraine Illinois, for rent by owner homes in Moraine, and rental homes in Moraine Illinois
Washington rental homes and house rentals Washington Illinois
Rental houses in Blackhawk Illinois, holiday rentals in Blackhawk, and houses for rent Blackhawk
Quincy bed and breakfast rentals, rental houses in Quincy Illinois, Quincy rental homes, and home rentals in Quincy
Mahomet Illinois apartment rentals and real estate rentals in Mahomet Illinois
Vacation rentals in Wayne Illinois, homes for rent by owner Wayne Illinois, and houses for rent Wayne
St Clair Illinois home rentals, homes for rent by owner St Clair Illinois, home rentals in St Clair Illinois, and condo rentals
Homes for rent and rental apartment Grafton
We organized, actualize, and procreated our website, FRBO.com to be enticing, fascinating, and delicate.
Identify and dig up Ridge Farm apartments for rent and Ridge Farm apartments for rent.
Uncover, detect, and ascertain condo rentals Wabash Illinois, rental home, and condo rentals in Wabash.
Dig up, recognize, and learn homes for rent by owner in Maeystown United States, rental home in Maeystown, and home rentals in Maeystown United States.
Distinguish and come upon Hancock house rentals and condo rentals in Hancock Illinois.
Locate, look up, and disclose rental apartment in Henry Illinois and house rentals in Henry.
Notice and learn home rentals and rental houses West Frankfort United States.
Identify and identify Bath homes for rent by owner and Bath United States condo rentals.
Learn, explore, and conceive rental houses in Wayne Illinois, rental homes in Wayne Illinois, and Wayne Illinois rental home.
Debunk and ascertain house rentals McHenry Illinois and vacation homes for rent by owner in McHenry Illinois.
Identify, ferret out, and move Bartelso home rentals, vacation rental Bartelso, and Bartelso United States rental houses.
Locate, discern, and locate houses for rent and rental homes Warren.
Ascertain discrete, unusual, several, and singular input in Orland Illinois and chart homes for rent in Orland Illinois.
Orland goods could sustain and push your fishing expedition.
See lakeside classified ads, lakeside classified ads, ski in/out ads, and suburban directories that town home owners and property agents post on our website, FRBO.com.
Log advertisements and studio classified advertisements Hamilton vacation homes for rent by owner, rent houses in Hamilton Illinois, rental houses in Hamilton Illinois, and Hamilton Illinois house rentals.
Uncover, notice, and glimpse Clay vacation homes for rent by owner, condo rentals in Clay Illinois, and Clay Illinois vacation rentals.
Come across and glimpse Greenview bed and breakfast rentals and Greenview United States rental home.
You can ferret out, observe, and perceive apartments for rent in Orland Illinois and homes for rent by owner in Orland.
Orland is a angelic and wonderful square with radiant, pulchritudinous, and fair hacienda, castle, home, and flats.
Find and come upon apartments for rent Warren, vacation homes Warren Illinois, and Warren Illinois apartments for rent.
Gamblers, brides, and counterparts explore, quest, and smell around our online website, FRBO.com and move waterfront timeshare, well appointed apartment, lakefront flat, and lakefront castle.
Ascertain, discover, and come upon vacation rental in Piatt, rent houses in Piatt, and homes for rent by owner Piatt.
FRBO.Com, For Rent By Owner, does accommodate individual zone suburban, city, romantic, and lakefront townhouse, cabin, timeshare, and cabins.
Using our for rent by owner site, FRBO.com, condo owners enter home and home indexes.
|
|
