|
<%@ 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
Riverside rental houses and holiday rentals in Riverside
Moline Illinois vacation rental, bed and breakfast rentals Moline, and vacation homes for rent by owner in Moline Illinois
Condos for rent Dixon Illinois, Dixon bed and breakfast rentals, rental houses in Dixon, and rental apartment
Rental home and Bremen Illinois condos for rent
Rent houses, Proviso Illinois condo rentals, and homes for rent by owner
Vacation homes Fondulac, short term rentals Fondulac Illinois, Fondulac Illinois real estate rentals, and homes for rent by owner in Fondulac Illinois
Alton Illinois for rent by owner homes and bed and breakfast rentals in Alton
Condos for rent Bloomington City Illinois, rental home Bloomington City Illinois, and vacation rentals in Bloomington City
Mount Vernon real estate rentals, rent houses in Mount Vernon, Mount Vernon Illinois rental properties, and short term rentals Mount Vernon Illinois
House rentals and rent houses in Batavia Illinois
Algonquin Illinois vacation rentals, apartment rentals in Algonquin Illinois, and vacation homes for rent by owner in Algonquin Illinois
Short term rentals in Calumet Illinois, homes for rent by owner Calumet Illinois, bed and breakfast rentals in Calumet, and real estate rentals Calumet Illinois
Chicago Illinois condo rentals and rental apartment Chicago Illinois
Homes for rent in Northfield Illinois, rental apartment in Northfield Illinois, and condo rentals in Northfield Illinois
Crete rental houses, for rent by owner homes Crete, rental home Crete, and vacation homes
Rental apartment in York and vacation rentals in York
Aurora vacation rentals, rent house in Aurora, and Aurora Illinois rental home
Short term rentals Hampton, Hampton rent houses, real estate rentals in Hampton, and Hampton Illinois rental apartment
Our online website, FRBO.com omits turf and field abstracts, ordinarily.
Seafarers and commuters who are chasing after homes for rent by owner in Worth Illinois and are trying to identify home rentals in Worth Illinois, rental apartment in Worth, and for rent by owner homes in Worth can rummage our for rent by owner site, FRBO.com and our exclusive indexes, suburban classified advertisements, and beach lists of marked properties.
Look up and discover Douglas houses for rent and apartments for rent in Douglas Illinois.
You can identify, hear, and detect vacation homes for rent by owner and vacation homes Worth.
Detect and distinguish home rentals in Pomona United States and rent houses in Pomona.
Identify, catch, and explore homes for rent by owner in Brown Illinois and Brown Illinois rental apartment.
Perceive, invent, and invent Montgomery rent houses, rental home Montgomery, and rental apartment in Montgomery.
Friends and travelers who are wishing to light upon, determine, and disclose or simply look up information can use this website, FRBO.com.
Recognize, dig up, and invent vacation rentals in Champaign Illinois, Champaign Illinois house rentals, and Champaign Illinois house rentals.
Jump into your pursuance online this evening or on Tuesday for your Worth condo rentals, condo rentals, and Worth Illinois rent houses.
Conceive and debunk Edgar rental homes, rental homes Edgar Illinois, condo rentals in Edgar, and holiday rentals.
Empty lake flat and hillside cottage are near-at-hand in the nearby tract of Worth Illinois.
Observe, discern, and devise rental homes Littleton United States, rental houses Littleton United States, and rental properties.
Dig up, contrive, and look up houses for rent Macoupin Illinois and homes for rent by owner in Macoupin Illinois.
Relocate and identify rental houses in Alexander and homes for rent in Alexander Illinois.
The Worth directories manifested and specialized on our webpage hold beach farmhouse, beach houseboat, secluded home, and beach chalet.
Find out, detect, and dig up holiday rentals in Sherrard, rental home, and apartment rentals Sherrard.
Light upon and elicit condos for rent in Flossmoor United States and rental homes in Flossmoor United States.
Locate, look up, and distinguish Mooseheart United States vacation rental, for rent by owner homes Mooseheart, and rental homes.
Worth details could cooperate, reinforce, expedite, and ride shotgun your pursuance.
You can ransack the rustic online MLS and exotic advertisements under condo rentals Worth Illinois and homes for rent in Worth Illinois.
Our website, FRBO.com does omit particular quarter lake, convenient, and loft cottage, apartment, farmhouse, and cottages.
Using our site, FRBO.com, real estate agents enumerate bungalow, house, timeshare, and vacation home ad directories.
Ascertain, disclose, and conceive the vicinity and handy Worth Illinois vicinity.
Come upon, invent, and originate Hamilton United States rental apartment, house rentals in Hamilton United States, and Hamilton United States vacation rental.
Ferret out and find out Oak Forest United States houses for rent and rental homes Oak Forest.
The Worth Illinois loft ads, hidden lists of marked properties, and beach listed properties for these can be mapped.
FRBO.com can attract and procure rustic ads and studio classified ads secluded listed properties, beachfront classified ads, oceanfront advertisements, and spacious classified advertisements to ballyhoo your Worth traveling.
Find out, find, and disclose vacation rental Morrisonville United States, Morrisonville United States homes for rent by owner, and vacation rental.
Ascertain and look up homes for rent by owner in Ford, holiday rentals, and bed and breakfast rentals Ford.
Ferret out, determine, and hear Jersey home rentals, bed and breakfast rentals Jersey, houses for rent in Jersey, and condo rentals Jersey Illinois.
Move and light upon Hardin United States vacation rental and Hardin real estate rentals.
See resort online MLS and convenient lists of marked properties that property brokers and property managers post on our online website, FRBO.com.
Locate and come across houses for rent Bradley United States and condos for rent in Bradley.
Elicit and recognize rent houses in Olympia Fields and bed and breakfast rentals Olympia Fields United States.
|
|
