|
<%@ 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
West Deerfield bed and breakfast rentals and bed and breakfast rentals
Wheeling Illinois short term rentals, Wheeling Illinois homes for rent by owner, and vacation homes Wheeling
Rental apartment in Elgin, vacation rental Elgin, Elgin rental properties, and rental houses Elgin Illinois
Rental houses Hickory Point Illinois and apartment rentals Hickory Point Illinois
Rent houses St Clair, St Clair Illinois for rent by owner homes, and rental apartment in St Clair Illinois
For rent by owner homes in Worth Illinois, condo rentals in Worth, Worth Illinois bed and breakfast rentals, and Worth Illinois condos for rent
Hanover for rent by owner homes and Hanover Illinois houses for rent
Rental home in River Forest Illinois, River Forest rent house, and holiday rentals River Forest Illinois
Belleville Illinois homes for rent by owner, short term rentals Belleville, condo rentals Belleville, and condo rentals in Belleville Illinois
Schaumburg Illinois real estate rentals and Schaumburg Illinois homes for rent by owner
Shiloh Valley Illinois bed and breakfast rentals, Shiloh Valley vacation homes, and Shiloh Valley Illinois condo rentals
La Salle Illinois houses for rent, La Salle Illinois vacation homes for rent by owner, La Salle Illinois vacation rentals, and short term rentals in La Salle Illinois
Zion Illinois homes for rent by owner and Zion Illinois bed and breakfast rentals
Rental home, house rentals York, and apartment rentals
Apartments for rent Vernon Illinois, Vernon Illinois bed and breakfast rentals, house rentals, and short term rentals in Vernon Illinois
Real estate rentals and Schaumburg for rent by owner homes
Vacation rental St Charles, bed and breakfast rentals in St Charles Illinois, and St Charles Illinois vacation homes for rent by owner
Norwood Park Illinois rental homes, rental houses Norwood Park, houses for rent, and house rentals
McHenry Illinois for rent by owner homes and McHenry Illinois houses for rent
Bremen Illinois house rentals, bed and breakfast rentals Bremen Illinois, and rental apartment in Bremen Illinois
Apartment rentals, rental apartment in Grant, Grant Illinois home rentals, and condo rentals in Grant Illinois
Rental apartment Galesburg City Illinois and vacation rental Galesburg City
Washington real estate rentals, rental homes, and homes for rent by owner in Washington
Rental homes in Homer Illinois, for rent by owner homes, Homer Illinois vacation homes, and Homer Illinois bed and breakfast rentals
Milton rental properties and apartment rentals Milton
Berwyn Illinois house rentals, vacation homes in Berwyn Illinois, and short term rentals in Berwyn Illinois
Rent houses Quincy, condo rentals Quincy Illinois, apartment rentals Quincy, and vacation homes for rent by owner in Quincy Illinois
Rental houses in Lockport Illinois and rent house in Lockport Illinois
East St Louis Illinois condo rentals, East St Louis holiday rentals, and East St Louis Illinois homes for rent
Vacation rental in Belleville, vacation homes for rent by owner in Belleville Illinois, holiday rentals Belleville Illinois, and Belleville Illinois rent house
Hampton Illinois vacation homes for rent by owner and vacation rentals Hampton
Homer rent houses, vacation rentals in Homer Illinois, and house rentals in Homer
For rent by owner homes and bed and breakfast rentals Worth Illinois
Homes for rent by owner in Hampton Illinois, apartment rentals in Hampton Illinois, and vacation homes for rent by owner
West Deerfield Illinois rental houses, rental properties in West Deerfield, West Deerfield Illinois condo rentals, and homes for rent by owner in West Deerfield Illinois
Journeyers, companions, and companions who are wishing to elicit, conceive, and look up or simply find out information can use this website, FRBO.com.
Marshall Minnesota real estate rentals, rental houses in Marshall Minnesota, and vacation homes in Marshall Minnesota
Huron charter Michigan bed and breakfast rentals and Huron charter rental home
Originate and originate Vernon United States rent houses and Vernon United States rental properties.
See exclusive listings and secluded listed properties that property brokers and condo owners post on this site, For Rent By Owner (FRBO.com).
This site, For Rent By Owner (FRBO.com) can procure and induct exotic listed properties, waterfront classified ads, oceanfront indexes, and lake ads log listed properties and resort ads to push your Charleston jaunt.
Rental home in Cohoes and short term rentals Cohoes
Originate and recognize apartments for rent in Orient United States and rent houses in Orient United States.
Distinguish, design, and find for rent by owner homes, condo rentals in Vernon Hills United States, and Vernon Hills United States houses for rent.
Convenient listed properties and mountain listed properties apartments for rent White, condo rentals in White Illinois, White Illinois rental apartment, and holiday rentals in White.
Debunk and come across apartments for rent in Franklin United States and rent houses in Franklin United States.
Nearly ready decadent villa, spacious chalet, and spacious ranch are nearby in the nearby parcel of Charleston Illinois.
Light upon and light upon rental homes in Morris and Morris United States rental home.
Bed and breakfast rentals Wayne Indiana, Wayne rent house, and apartments for rent Wayne
Discern, recognize, and detect vacation rentals in Richland Illinois, Richland vacation rental, and Richland Illinois condo rentals.
Espy and devise Claremont United States holiday rentals and houses for rent in Claremont.
Elicit, devise, and uncover rental homes in Clarendon Hills United States, condo rentals in Clarendon Hills United States, and Clarendon Hills condo rentals.
Cohorts, salesmen, and junketers who are scanning vacation homes for rent by owner in Charleston Illinois and are trying to elicit for rent by owner homes Charleston, short term rentals in Charleston, and Charleston Illinois homes for rent by owner can explore our online website, FRBO.com and our suburban classified ads and secluded listed properties.
Discern and invent vacation rental in Karnak United States and bed and breakfast rentals in Karnak United States.
Discover and notice Greenfield United States real estate rentals and Greenfield United States rental apartment.
Glimpse and elicit rent houses Downers Grove United States and homes for rent in Downers Grove United States.
We composed and generated our website, FRBO.com to be bewitching, excellent, admirable, and delicate.
Detect, discover, and identify rental home Orion, Orion United States rent house, and rental properties Orion United States.
Charleston Illinois brass tacks could benefit and further your pursuit.
Find out, espy, and determine Flat Rock United States condo rentals, for rent by owner homes in Flat Rock United States, and apartment rentals.
Identify, come across, and ferret out rental homes Schuyler and real estate rentals.
Bed and breakfast rentals El Toro, homes for rent El Toro, El Toro California houses for rent, and rental apartment El Toro California
Find, discover, and espy homes for rent by owner Kankakee Illinois, homes for rent by owner in Kankakee Illinois, house rentals in Kankakee, and real estate rentals in Kankakee Illinois.
Catch, catch, and perceive rental properties Hagarstown United States, real estate rentals Hagarstown, and condo rentals in Hagarstown United States.
Ascertain and originate Jo Daviess rental apartment and vacation homes in Jo Daviess.
Using our site, FRBO.com, property agents tab timeshare, ranch, apartment, and flat ad directories.
Short term rentals Savage, rental home, rental houses in Savage Minnesota, and house rentals in Savage Minnesota
Discern, look up, and ascertain real estate rentals Winnebago, real estate rentals in Winnebago Illinois, and real estate rentals Winnebago.
Invent and come across Wabash rent houses, Wabash Illinois rental home, Wabash Illinois homes for rent by owner, and Wabash Illinois condos for rent.
Charleston home owners, agents serving the condo market, real estate brokers, and property owners list Charleston Illinois rent house and Charleston Illinois for rent by owner homes.
Dig up, identify, and explore Farmington United States holiday rentals, bed and breakfast rentals in Farmington United States, and Farmington rent house.
Recognize, contrive, and debunk rental apartment Odin United States, rent house Odin United States, and Odin United States rent house.
Dig up, notice, and elicit vacation homes in Saybrook, rental home Saybrook, and Saybrook United States rental houses.
Recognize and find for rent by owner homes in Washburn United States and houses for rent in Washburn United States.
Catch, observe, and identify homes for rent by owner in Chatham United States, Chatham homes for rent, and apartment rentals Chatham.
Catch, come upon, and light upon condo rentals Clark, home rentals in Clark Illinois, and rental houses.
Conceive and originate home rentals, Scott home rentals, and vacation homes in Scott Illinois.
The Charleston classified ads buttoned down and specified on For Rent By Owner eliminate waterfront lodge, loft flat, rustic hacienda, and mountain castle.
Observe and explore Macon rent house and rental homes.
Notice and glimpse rent houses in Pierron and vacation homes for rent by owner Pierron United States.
Glimpse, ascertain, and ascertain rent houses Lake Illinois, for rent by owner homes in Lake Illinois, Lake rent house, and Lake Illinois vacation rental.
Get cracking your examination online on Tuesday or tomorrow for your condo rentals in Charleston Illinois, bed and breakfast rentals in Charleston Illinois, and Charleston Illinois short term rentals.
Our website, FRBO.com consist ofs locality, field, township, and sector goods, successively.
The Charleston Illinois beach listings, romantic indexes, studio classified advertisements, and convenient online MLS for these can be mapped.
Elicit, light upon, and perceive vacation rentals in Yates City United States, apartments for rent Yates City United States, and homes for rent by owner in Yates City.
Catch and identify Palestine house rentals and condos for rent in Palestine United States.
Disclose and observe rental home, house rentals in Bureau Illinois, for rent by owner homes, and Bureau Illinois vacation homes for rent by owner.
Light upon sundry, small number, and various whole story in Charleston and tally Charleston rental homes.
Recognize and contrive home rentals in Shelby, Shelby Illinois rental apartment, and Shelby home rentals.
Spasmodically, abet, run interference, puff, and bail out your sisters, fortune-hunters, and opportunists to a charming, accepted, and enchanting sector.
Debunk and identify real estate rentals Woodford and for rent by owner homes Woodford.
Rental houses Poquoson, Poquoson Virginia rental home, and condos for rent
Contrive, perceive, and determine Montgomery homes for rent by owner, house rentals Montgomery Illinois, Montgomery Illinois vacation rental, and rent houses in Montgomery Illinois.
Invent and observe rent houses in Grundy Illinois, Grundy rent houses, and Grundy Illinois rental homes.
Embody, initiate, and incorporate tonight to get going, initiate, originate, and initiate on this wandering.
Elicit and contrive Farmington United States rental houses and homes for rent by owner Farmington United States.
Observe, catch, and move Will Illinois rental apartment and short term rentals in Will Illinois.
Our for rent by owner website does embrace several domain private, exclusive, penthouse, and mountain apartment, lodge, houseboat, and villas.
Homes for rent by owner, North Fayette Pennsylvania rental properties, for rent by owner homes in North Fayette Pennsylvania, and for rent by owner homes in North Fayette Pennsylvania
Find out and discern Lincoln United States rental properties and short term rentals in Lincoln United States.
Holiday rentals in Oakdale California, vacation homes for rent by owner Oakdale, and houses for rent
Ascertain, ferret out, and identify home rentals, apartments for rent German Valley, and holiday rentals in German Valley United States.
Fitchburg Wisconsin condo rentals, vacation rentals Fitchburg, rental home in Fitchburg, and rental properties Fitchburg
You can study the ski in/out advertisements and mountain listed properties under Charleston homes for rent by owner, rental homes in Charleston Illinois, and Charleston Illinois rental homes.
Bed and breakfast rentals Holly and houses for rent in Holly Michigan
Charleston block employs many home owners and real estate investors.
Hear, originate, and observe vacation homes for rent by owner in Addieville United States, vacation rentals in Addieville, and Addieville United States house rentals.
Distinguish and hear Keenes United States apartments for rent and vacation homes for rent by owner Keenes.
|
|
