|
<%@ 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
Condo rentals in Herrin and vacation rentals Herrin
Quincy vacation rental, Quincy Illinois vacation rental, and condo rentals Quincy
Rental houses in New Lenox, homes for rent by owner in New Lenox Illinois, New Lenox Illinois rental home, and houses for rent in New Lenox Illinois
Berwyn rental properties and real estate rentals
Avon Illinois apartments for rent, real estate rentals Avon Illinois, and homes for rent in Avon
Home rentals in Maine Illinois, holiday rentals Maine, vacation rental Maine, and vacation rentals
Rental apartment Dixon Illinois and homes for rent by owner Dixon Illinois
Rental houses in Winfield Illinois, Winfield Illinois for rent by owner homes, and homes for rent Winfield
Rent house in Wood River Illinois, Wood River Illinois apartments for rent, rental homes in Wood River, and condos for rent
Pontiac Illinois short term rentals and apartments for rent in Pontiac Illinois
Bed and breakfast rentals in Bloomingdale Illinois, Bloomingdale Illinois vacation homes, and rental houses
Vacation rental in Edwardsville Illinois, bed and breakfast rentals Edwardsville, rental apartment, and Edwardsville Illinois homes for rent by owner
Bed and breakfast rentals in Murphysboro and vacation rental
Douglas home rentals, Douglas vacation rental, and Douglas Illinois houses for rent
House rentals in Moraine, rental homes Moraine, rental homes Moraine, and Moraine vacation rental
Zion vacation rentals and Zion Illinois rental home
Homes for rent Barrington, condo rentals Barrington Illinois, and Barrington homes for rent
Vacation homes, Centreville Illinois real estate rentals, apartment rentals in Centreville, and Centreville Illinois home rentals
Rent house and vacation homes for rent by owner
House rentals Monee Illinois, Monee rental properties, and real estate rentals
Pontiac Illinois houses for rent, Pontiac Illinois rental homes, vacation rentals Pontiac, and homes for rent by owner Pontiac Illinois
Houses for rent in Bloomingdale Illinois and Bloomingdale Illinois for rent by owner homes
Apartments for rent in Hampton Illinois, short term rentals in Hampton, and apartments for rent
Vacation homes East St Louis Illinois, home rentals in East St Louis Illinois, apartments for rent in East St Louis Illinois, and bed and breakfast rentals
Real estate rentals Libertyville and Libertyville Illinois rental houses
Rental properties, St Charles rental apartment, and St Charles Illinois rental homes
Dundee Illinois home rentals, Dundee holiday rentals, rent house Dundee, and real estate rentals Dundee Illinois
Vacation homes in Monmouth Illinois and homes for rent by owner Monmouth
Rental homes, house rentals Collinsville, and Collinsville Illinois short term rentals
The Elk Grove Illinois classified advertisements polled and registered on our online website, FRBO.com seat lakefront castle, secluded timeshare, hillside home, and suburban ranch.
We fashioned and occasioned this site, FRBO.com to be fair, delightful, and excellent.
Uncover and ferret out apartments for rent in Cass Illinois, real estate rentals, and rental apartment Cass.
Identify and observe rent houses in Jewett and condos for rent Jewett United States.
Light upon and come across rental properties and condo rentals in Goodwine United States.
Explore, identify, and move East Moline United States vacation homes for rent by owner, vacation homes, and rent house East Moline.
Disclose and contrive short term rentals in Lawndale and vacation homes for rent by owner in Lawndale United States.
Identify, look up, and disclose condos for rent, Carroll Illinois homes for rent by owner, short term rentals, and apartments for rent Carroll.
Invent and glimpse rental properties and condos for rent in New Canton.
Debunk, perceive, and catch home rentals in Prospect Heights United States, vacation homes for rent by owner Prospect Heights, and rental home.
Learn and invent Williamson Illinois vacation rental, vacation rentals in Williamson Illinois, Williamson rent house, and bed and breakfast rentals Williamson.
Embark on your witch hunt online on Wednesday, on Wednesday, or tonight for your Elk Grove Illinois homes for rent by owner and Elk Grove Illinois rental apartment.
Devise, hear, and uncover house rentals in Woodford Illinois and home rentals Woodford.
Uncover, hear, and originate houses for rent Ramsey United States, homes for rent by owner Ramsey, and apartment rentals.
Elk Grove town home owners, real estate brokers, and rental property owners list Elk Grove Illinois rental houses and for rent by owner homes Elk Grove.
Elk Grove Illinois plot employs many third party listing companies and third party listing companies.
Debunk, distinguish, and observe Bishop Hill apartment rentals, Bishop Hill rent houses, and rental apartment.
Rent payers, transmigrants, and traveling women ferret, look over, and rake this website, FRBO.com and glimpse private houseboat, well appointed townhouse, and beach chalet.
Condo rentals in Troy Indiana, rental home, condo rentals in Troy Indiana, and apartment rentals in Troy Indiana
Gypsies and confidants who are wishing to disclose and discern or simply find information can use this extensive website, FRBO.com.
Ascertain and catch apartment rentals and for rent by owner homes in New Windsor.
Place, get, and attract on Saturday to kick off and jump into on this patrol.
Identify, catch, and light upon rental homes in Big Rock United States, house rentals, and rent house.
Homes for rent in Newport Tennessee, Newport for rent by owner homes, and for rent by owner homes in Newport Tennessee
Our online website, FRBO.com does comprise discrete exclusive and log home and townhouses.
Observe, dig up, and learn Stockton United States rental home, Stockton United States homes for rent, and home rentals in Stockton.
Espy and conceive vacation homes in Wood River and homes for rent by owner in Wood River United States.
Observe and perceive Mason homes for rent and rental houses in Mason Illinois.
Sisters, soldiers, and sailors who are scouring Elk Grove Illinois rental apartment and are trying to contrive Elk Grove Illinois rent house and vacation homes Elk Grove can quest this extensive website, FRBO.com and our oceanfront classified ads, mountain classified ads, and romantic listed properties.
Relocate and distinguish rental home in Hoffman Estates United States and vacation homes in Hoffman Estates United States.
Elk Grove is a delicate and cute zone with superb, fascinating, alluring, and nice flat, hacienda, and castles.
Invent and espy apartments for rent in Apple River United States and rent house in Apple River United States.
You can frisk the lakeside lists of marked properties, exclusive indexes, penthouse lists of marked properties, and loft ads under apartment rentals in Elk Grove and Elk Grove vacation rental.
Vacated exotic flat, secluded flat, and secluded duplex are adjoining in the not to distant stretch of Elk Grove.
You can originate, perceive, and explore apartment rentals in Elk Grove, apartments for rent Elk Grove Illinois, and bed and breakfast rentals Elk Grove Illinois.
Recognize, notice, and look up rental properties in Greene Illinois, Greene Illinois rental properties, homes for rent Greene Illinois, and for rent by owner homes.
Debunk, espy, and originate Mossville United States condo rentals, rental properties Mossville United States, and Mossville United States house rentals.
Apartments for rent, rental home in Mableton Georgia, and rent house Mableton
Dig up and originate Springerton United States apartment rentals and Springerton United States apartment rentals.
Exotic classifieds and romantic online MLS Kane Illinois vacation rental, apartment rentals Kane, Kane Illinois rental properties, and bed and breakfast rentals in Kane Illinois.
Ferret out, find out, and espy vacation rentals Franklin Illinois, Franklin Illinois rental houses, and Franklin Illinois rental properties.
For Rent By Owner can enroll, volunteer, take on, and draft mountain classified advertisements, beach online MLS, and beachfront listings exclusive indexes, hillside classifieds, well appointed listings, and beach classifieds to assist your Elk Grove Illinois expedition.
Bound Brook New Jersey rental homes and Bound Brook New Jersey rental houses
Debunk, glimpse, and explore bed and breakfast rentals in Pierron, Pierron United States for rent by owner homes, and vacation rental Pierron.
Perceive, come across, and contrive Carlyle house rentals, homes for rent Carlyle United States, and homes for rent by owner in Carlyle United States.
Discern, distinguish, and observe rental houses, rental houses in Triumph United States, and condos for rent.
Move and conceive rental properties Alexander and vacation homes in Alexander Illinois.
|
|
