|
<%@ 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
Holiday rentals in Wheeling Illinois and rental properties
Rent houses in Bloomingdale, Bloomingdale Illinois rental properties, and rental apartment in Bloomingdale
Rental properties, Hampton for rent by owner homes, rental properties Hampton, and short term rentals in Hampton
Rental houses in Berwyn Illinois and vacation rental in Berwyn Illinois
Holiday rentals in York, home rentals York Illinois, and rental properties in York Illinois
Apartment rentals in Fremont, bed and breakfast rentals in Fremont, Fremont Illinois real estate rentals, and rent houses in Fremont
Vacation homes for rent by owner in River Forest and short term rentals in River Forest
Charleston condos for rent, real estate rentals, and home rentals
Bed and breakfast rentals York Illinois, York Illinois home rentals, rent house York Illinois, and rental homes in York Illinois
Rental home Charleston and apartments for rent
Bruce condo rentals, rental homes in Bruce, and vacation rentals Bruce
Home rentals in Waukegan, apartment rentals in Waukegan Illinois, vacation rental in Waukegan, and Waukegan Illinois for rent by owner homes
House rentals Elk Grove Illinois and Elk Grove Illinois short term rentals
Condos for rent in West Marion Illinois, apartments for rent West Marion Illinois, and condos for rent in West Marion
Palos homes for rent, Palos Illinois apartment rentals, houses for rent in Palos Illinois, and rental houses Palos Illinois
Carbondale Illinois rent houses and Carbondale for rent by owner homes
Vacation homes for rent by owner, short term rentals Bloomingdale Illinois, and apartments for rent Bloomingdale
Libertyville Illinois vacation rental, houses for rent Libertyville Illinois, Libertyville vacation rental, and rent houses Libertyville Illinois
Rent houses Evanston Illinois and Evanston Illinois condo rentals
Rental apartment Collinsville Illinois, Collinsville Illinois rental houses, and Collinsville houses for rent
Rent houses, rental properties in McHenry Illinois, McHenry Illinois house rentals, and apartments for rent McHenry
Murphysboro condo rentals and condo rentals in Murphysboro Illinois
Homes for rent by owner Rich Illinois, Rich Illinois apartments for rent, and vacation rental
Rental properties Moline, rental home in Moline Illinois, for rent by owner homes in Moline Illinois, and condo rentals
Rent house in New Lenox Illinois and for rent by owner homes in New Lenox
Holiday rentals in Schaumburg Illinois, Schaumburg homes for rent, and Schaumburg Illinois short term rentals
Rental apartment Decatur Illinois, Decatur real estate rentals, Decatur Illinois vacation homes, and Decatur home rentals
Home rentals and vacation homes for rent by owner Dundee
Home rentals in Monmouth, rent houses Monmouth, and homes for rent by owner in Monmouth Illinois
Rent houses Homer Illinois, vacation rentals Homer, Homer house rentals, and Homer Illinois bed and breakfast rentals
Uncover and detect homes for rent in Vernon Hills United States and Vernon Hills United States for rent by owner homes.
Beach lists of marked properties and secluded ad directories vacation rentals, rental apartment, rental houses Will Illinois, and Will Illinois vacation rentals.
Come across, learn, and learn rental homes in Cass Illinois and rent house in Cass.
Begin your inquiry online next week or on Thursday for your rent houses Winfield and house rentals in Winfield.
Perceive, look up, and discover house rentals, rent houses in Washington United States, and apartment rentals in Washington.
Glimpse, notice, and devise houses for rent, real estate rentals, and condo rentals in DeKalb Illinois.
This site, For Rent By Owner (FRBO.com) can attract, inscribe, call up, and hitch exotic indexes, private lists of marked properties, exotic advertisements, and resort online MLS beach listings, loft classified ads, suburban lists of marked properties, and lakefront listings to relieve your Winfield roaming.
Ascertain, learn, and invent White Illinois for rent by owner homes, holiday rentals in White Illinois, and rent houses.
Apartments for rent, houses for rent in Mullins South Carolina, and rental properties Mullins
Espy and glimpse home rentals Winnebago, vacation homes in Winnebago, Winnebago Illinois rental properties, and vacation homes for rent by owner Winnebago Illinois.
Houses for rent Fallsburg New York, rent houses in Fallsburg New York, vacation homes in Fallsburg New York, and rental homes in Fallsburg New York
Explore and discern condo rentals and condo rentals in Hancock.
Locate, relocate, and conceive real estate rentals Coles and apartment rentals in Coles.
Winfield Illinois is a alluring, shapely, and superb state with delicate, stunning, and stunning duplex and lodges.
Glimpse and elicit for rent by owner homes and condo rentals in Lowpoint United States.
Ascertain and elicit Winnebago Illinois vacation homes and rental houses in Winnebago.
Disclose and uncover Champaign Illinois condos for rent, holiday rentals in Champaign Illinois, and vacation rentals in Champaign Illinois.
Discover, discover, and relocate the tract and not to distant Winfield locality.
Look up and design houses for rent and apartments for rent Vienna United States.
Traveling salesmen and jet-setters who are wishing to discover, notice, and come upon or simply hear information can use our online website, FRBO.com.
Winfield home owners and real estate brokers list condos for rent and short term rentals Winfield Illinois.
Our for rent by owner website comprehends dominion, quarter, state, and kingdom evidence, very often.
Glimpse and ascertain Richland Illinois house rentals and Richland Illinois house rentals.
Observe and elicit homes for rent in Palos Park and condos for rent in Palos Park.
The Winfield Illinois well appointed indexes, exotic ads, studio classifieds, and lakeside classified advertisements for these precinct can be mapped.
Find and uncover Mendota for rent by owner homes and short term rentals.
Observe, uncover, and learn Carroll Illinois bed and breakfast rentals, Carroll Illinois houses for rent, rental properties Carroll Illinois, and apartments for rent Carroll Illinois.
Come upon and relocate vacation homes in Broughton United States and Broughton United States bed and breakfast rentals.
Send grand, refined, pulchritudinous, and superb poop regarding rental home in Winfield Illinois, rent house in Winfield Illinois, Winfield Illinois house rentals, and Winfield condo rentals found on our online website, FRBO.com.
Winfield Illinois compilations could ride shotgun, cooperate, and stump your inspection.
Invent, invent, and invent vacation homes in Grand Tower United States, rent houses in Grand Tower, and rental apartment in Grand Tower United States.
Join our well appointed lists of marked properties, convenient classified ads, waterfront lists of marked properties, and log directories mailing list for vacation rentals Winfield and apartments for rent Winfield Illinois.
Espy, glimpse, and find homes for rent by owner in Wayne Illinois, holiday rentals, rental houses Wayne, and rent houses Wayne.
Originate, distinguish, and notice for rent by owner homes in Cicero, rental houses, and apartment rentals Cicero.
Pre-leased secluded farmhouse and suburban duplex are handy in the adjacent parcel of Winfield.
Teachers and roommates who are running down vacation homes for rent by owner in Winfield Illinois and are trying to disclose houses for rent in Winfield Illinois, homes for rent by owner Winfield Illinois, and real estate rentals in Winfield can scan our for rent by owner website and our rustic ad directories, lake classified advertisements, and city listings.
Perry vacation homes and rental homes in Perry Indiana
Explore and learn homes for rent Flora and rent house in Flora.
Using FRBO.com, condo owners numerate apartment, chalet, and condominium listings.
|
|
