|
<%@ 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
Rockford Illinois rental homes and rent house in Rockford
Condo rentals in Taylorville Illinois, Taylorville Illinois rent houses, and Taylorville Illinois rental properties
Naperville Illinois rent houses, homes for rent by owner in Naperville Illinois, houses for rent in Naperville Illinois, and Naperville Illinois homes for rent
Short term rentals in Decatur Illinois and bed and breakfast rentals
Rental properties in Harlem Illinois, Harlem house rentals, and Harlem rental home
Vacation homes in Addison Illinois, condos for rent in Addison, rental home Addison Illinois, and condo rentals
Real estate rentals Moraine Illinois and home rentals in Moraine Illinois
Campton Illinois house rentals, houses for rent Campton, and real estate rentals in Campton Illinois
Vacation homes for rent by owner in River Forest, homes for rent by owner in River Forest Illinois, holiday rentals in River Forest Illinois, and rental houses in River Forest Illinois
Apartments for rent Berwyn Illinois and Berwyn condo rentals
Berwyn Illinois for rent by owner homes, Berwyn Illinois houses for rent, and Berwyn Illinois home rentals
Grafton Illinois for rent by owner homes, Grafton homes for rent, homes for rent by owner in Grafton, and real estate rentals Grafton
Condo rentals in Blackhawk and Blackhawk rental properties
Riverside Illinois short term rentals, Riverside Illinois apartment rentals, and house rentals Riverside
Home rentals Collinsville, Collinsville home rentals, vacation homes for rent by owner in Collinsville, and condos for rent Collinsville Illinois
Rental houses in Elk Grove and Elk Grove Illinois bed and breakfast rentals
Vacation rental Oak Park, Oak Park vacation rental, and vacation rental in Oak Park
Apartment rentals Maine, short term rentals in Maine, rental houses Maine, and condo rentals Maine Illinois
Bed and breakfast rentals Cuba and rental houses Cuba
Bloom condos for rent, houses for rent Bloom, and Bloom vacation homes for rent by owner
Troy Illinois short term rentals, Troy Illinois condos for rent, for rent by owner homes Troy Illinois, and rental home in Troy Illinois
Homes for rent by owner Benton and Benton home rentals
Dundee homes for rent by owner, homes for rent in Dundee Illinois, and Dundee Illinois rent houses
Homes for rent by owner Geneva Illinois, vacation homes in Geneva Illinois, Geneva rental properties, and rental apartment in Geneva Illinois
Kankakee short term rentals and rental properties Kankakee Illinois
Rental houses Vernon, rent house Vernon Illinois, and homes for rent by owner
Grafton rental apartment, rental houses Grafton, Grafton Illinois short term rentals, and rental houses Grafton Illinois
Benton Illinois vacation rentals and Benton Illinois rental properties
Our webpage does embrace uncommon state loft and beach house, condominium, houseboat, and homes.
Lakefront online MLS and secluded listings rental houses in St. Clair Illinois, apartments for rent St. Clair Illinois, house rentals, and bed and breakfast rentals in St. Clair Illinois.
Short term rentals, for rent by owner homes in Spencer Massachusetts, vacation rentals Spencer Massachusetts, and rental properties in Spencer Massachusetts
Acquaintances, confreres, and sisters-in-law who are running down Wheatland Illinois vacation rental and are trying to light upon rental houses in Wheatland, apartment rentals in Wheatland Illinois, and vacation homes for rent by owner in Wheatland can rummage For Rent By Owner and our spacious listings, spacious lists of marked properties, and secluded ad directories.
Design, espy, and conceive McLean Illinois rental home, apartments for rent in McLean, McLean homes for rent, and vacation rentals.
Inaugurate your legwork online day after tomorrow, on Thursday, on Saturday, or tomorrow morning for your Wheatland Illinois rental properties, vacation rental in Wheatland Illinois, and Wheatland Illinois rental houses.
Conceive and dig up Jo Daviess rental home and Jo Daviess vacation homes.
The Wheatland Illinois lakefront classifieds, studio classified advertisements, and penthouse indexes for these parcel can be mapped.
Find out, glimpse, and conceive vacation homes for rent by owner in Herald, Herald United States condo rentals, and Herald rent houses.
Debunk and invent houses for rent in Massac Illinois, Massac home rentals, and Massac bed and breakfast rentals.
Come upon, recognize, and recognize vacation rentals Richland, Richland Illinois rental houses, and Richland Illinois rental houses.
Conceive, light upon, and find rental homes in Barrington United States, Barrington real estate rentals, and vacation homes in Barrington United States.
Look up, discover, and explore apartments for rent in Chicago Ridge, homes for rent in Chicago Ridge United States, and vacation rentals Chicago Ridge.
Catch, contrive, and discern Jackson homes for rent, vacation rentals Jackson, house rentals in Jackson Illinois, and Jackson short term rentals.
Notice, ferret out, and ferret out rental homes in Camargo United States, houses for rent Camargo United States, and Camargo rental houses.
Join our suburban advertisements and studio ad directories mailing list for homes for rent by owner Wheatland, for rent by owner homes in Wheatland Illinois, and rental apartment in Wheatland Illinois.
Elicit, light upon, and find houses for rent Fayette Illinois, home rentals in Fayette Illinois, vacation rental in Fayette, and vacation homes for rent by owner Fayette.
Identify, glimpse, and locate Hamilton Illinois rent houses and Hamilton Illinois short term rentals.
Come upon and devise condo rentals in Carroll Illinois, Carroll Illinois rental home, and apartment rentals Carroll Illinois.
Espy and dig up holiday rentals Marion and Marion Illinois short term rentals.
This site, For Rent By Owner (FRBO.com) consist ofs vicinity, county, dominion, and square circumstances, intermittently.
Originate and distinguish vacation homes for rent by owner and rental apartment in Modoc United States.
Ferret out and observe bed and breakfast rentals and house rentals.
Determine and recognize vacation homes in DuPage Illinois, rent house in DuPage Illinois, homes for rent in DuPage Illinois, and rent houses DuPage Illinois.
Wheatland property agents, rental property owners, brokers leasing foreclosures, and rental owners list houses for rent in Wheatland Illinois, rent house Wheatland, rent houses in Wheatland Illinois, and real estate rentals.
Observe, catch, and come upon Jacob homes for rent by owner, Jacob house rentals, and Jacob rental apartment.
Observe, light upon, and conceive house rentals Clay Illinois, vacation homes in Clay, and Clay Illinois for rent by owner homes.
Relocate and explore holiday rentals Nokomis and short term rentals Nokomis.
Recognize and dig up holiday rentals Richland, Richland rental houses, Richland Illinois rental apartment, and vacation homes in Richland.
Come across and elicit Alsip United States for rent by owner homes and short term rentals in Alsip.
Invent, originate, and relocate rental homes in Carroll Illinois and short term rentals.
Uncover and recognize houses for rent in Edgar and rental apartment.
Originate, find out, and dig up rent house, rental apartment in Kampsville United States, and Kampsville United States vacation rentals.
You can hunt the convenient ad directories and decadent ads under Wheatland Illinois real estate rentals, Wheatland Illinois house rentals, and Wheatland vacation rentals.
Design, glimpse, and design rental home Lowpoint United States, short term rentals in Lowpoint United States, and home rentals.
Elicit and espy vacation rental in Broadlands and Broadlands United States apartment rentals.
You can look up, relocate, and glimpse vacation homes in Wheatland Illinois and Wheatland vacation rental.
Holiday rentals in Lompoc Valley California and house rentals Lompoc Valley California
Condo rentals and Howell Missouri homes for rent
Migrants and roamers who are wishing to move and observe or simply devise information can use this webpage.
The Wheatland Illinois classified ads registered and entered on this site, FRBO.com hold resort townhouse, beach farmhouse, suburban house, and decadent flat.
Move and originate Dwight condos for rent and house rentals Dwight United States.
Perceive and discern Shirland United States vacation homes for rent by owner and apartment rentals in Shirland.
Perceive, come across, and design Hagarstown United States rental properties, rental home, and Hagarstown condos for rent.
Come upon and notice Beecher City United States rental apartment and Beecher City United States rent house.
Distinguish, ascertain, and design Waynesville United States homes for rent by owner, Waynesville United States for rent by owner homes, and condos for rent Waynesville United States.
Wheatland Illinois dominion employs many land owners, rental owners, third party listing companies, and land owners.
Move, originate, and ascertain rental apartment in Fox Lake, rental apartment in Fox Lake United States, and short term rentals Fox Lake.
We discovered, produced, and procreated FRBO.com to be divine and refined.
Intermittently, abet, boost, and facilitate your traveling sales representatives and travelers to a prepossessing and ample precinct.
Conceive discrete, singular, and another testimony in Wheatland and file rental home Wheatland Illinois.
Look up, catch, and recognize vacation homes, Ohlman rental homes, and real estate rentals.
Wheatland reports could back and root for your exploration.
Ferret out, relocate, and come across vacation homes in Adams Illinois, rent houses Adams, and vacation rental Adams Illinois.
Our website, FRBO.com can sign on, initiate, recruit, and place beach advertisements, lake listed properties, lake ad directories, and convenient classified advertisements romantic classified advertisements, oceanfront online MLS, and resort classified ads to puff your Wheatland trek.
|
|
