|
<%@ 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
Home rentals Aurora Illinois and Aurora Illinois condos for rent
Greenwood Illinois rent houses, rent house Greenwood Illinois, and house rentals in Greenwood
Holiday rentals, rental home in River Forest Illinois, vacation rental in River Forest Illinois, and River Forest rent house
Vacation homes in Rockton Illinois and rent houses in Rockton
Rental homes in Robinson, condo rentals in Robinson, and Robinson Illinois rental apartment
Apartments for rent Norwood Park, bed and breakfast rentals in Norwood Park Illinois, for rent by owner homes in Norwood Park, and rental properties Norwood Park
Home rentals and Macomb City home rentals
Apartment rentals Moraine Illinois, homes for rent, and bed and breakfast rentals Moraine
Condos for rent, Belleville short term rentals, Belleville Illinois vacation rental, and Belleville rent house
Aurora Illinois rental properties and short term rentals Aurora Illinois
Rental apartment Norwood Park, holiday rentals, and Norwood Park apartment rentals
Rental home in Bruce Illinois, vacation rentals in Bruce Illinois, vacation rentals, and vacation rental Bruce Illinois
Flagg vacation homes for rent by owner and home rentals
Apartments for rent Schaumburg, apartment rentals Schaumburg, and Schaumburg Illinois holiday rentals
Real estate rentals in Belleville, rent houses, condos for rent Belleville Illinois, and house rentals in Belleville Illinois
Danville Illinois rental apartment and vacation homes for rent by owner Danville
Shields Illinois vacation homes, Shields rent house, and condo rentals in Shields Illinois
Rental homes Rantoul, home rentals in Rantoul Illinois, homes for rent by owner in Rantoul Illinois, and rental home Rantoul
Oswego Illinois bed and breakfast rentals and vacation homes for rent by owner in Oswego
Apartments for rent, Belleville Illinois homes for rent, and homes for rent by owner in Belleville Illinois
Rental apartment Groveland, vacation rental, Groveland Illinois rental apartment, and house rentals Groveland Illinois
Bed and breakfast rentals Lyons Illinois and Lyons Illinois holiday rentals
Houses for rent in Worth, Worth house rentals, and rental houses Worth
Greenwood Illinois rental houses, home rentals in Greenwood Illinois, for rent by owner homes in Greenwood Illinois, and houses for rent
Peoria City rental homes and rent houses Peoria City Illinois
Murphysboro Illinois condos for rent, houses for rent in Murphysboro, and rent house Murphysboro Illinois
Vacation rentals in Normal Illinois, vacation rentals Normal Illinois, Normal house rentals, and Normal Illinois homes for rent
Homes for rent by owner and Bloom Illinois rental properties
Charleston Illinois short term rentals, short term rentals in Charleston Illinois, and vacation rental in Charleston Illinois
Shiloh Valley houses for rent, for rent by owner homes Shiloh Valley Illinois, apartments for rent in Shiloh Valley, and bed and breakfast rentals in Shiloh Valley
Vacation rental in Normal and Normal Illinois for rent by owner homes
Holiday rentals in Moline Illinois, rent houses, and for rent by owner homes
Rent houses and Dixon Illinois vacation rentals
Our page involves plot, parcel, principality, and county brass tacks, infrequently.
Light upon bizarre and sundry brass tacks in Ela and enumerate short term rentals in Ela.
Palos Illinois homes for rent by owner, rental properties, condos for rent in Palos, and for rent by owner homes in Palos Illinois
Ela property managers and agents serving the condo market list for rent by owner homes Ela and condo rentals Ela Illinois.
Elicit and perceive condo rentals in Rock Island and homes for rent by owner Rock Island Illinois.
Dig up, find out, and find home rentals in Grand Chain United States, Grand Chain vacation homes for rent by owner, and Grand Chain United States short term rentals.
You can frisk the lakeside lists of marked properties, hillside listed properties, and oceanfront listings under Ela Illinois bed and breakfast rentals, condos for rent in Ela Illinois, and Ela Illinois vacation rentals.
Devise, find out, and come upon rent house in Jefferson Illinois and homes for rent by owner Jefferson.
Invent, move, and catch short term rentals in Mc Clure United States, rental apartment in Mc Clure United States, and bed and breakfast rentals in Mc Clure United States.
Holiday rentals and Mandan houses for rent
Catch and relocate bed and breakfast rentals in Bureau Illinois, for rent by owner homes in Bureau Illinois, short term rentals in Bureau Illinois, and house rentals in Bureau Illinois.
Homes for rent in Austintown Ohio, Austintown Ohio houses for rent, rental home in Austintown Ohio, and rental properties in Austintown
Distinguish, move, and glimpse homes for rent by owner and Effingham Illinois houses for rent.
Catch, catch, and debunk rental apartment Radom, bed and breakfast rentals in Radom United States, and Radom United States house rentals.
See oceanfront classified ads, beach lists of marked properties, beach classified ads, and hillside online MLS that real estate investors and real estate brokers post on our website, FRBO.com.
Relocate and find condo rentals in Wapella United States and Wapella United States rental home.
Come across, determine, and originate Dennison United States holiday rentals, Dennison short term rentals, and rental apartment in Dennison United States.
This site, For Rent By Owner (FRBO.com) can draft, volunteer, and join up lakefront ads, hillside advertisements, suburban classified advertisements, and waterfront listed properties oceanfront classified ads, beach lists of marked properties, beach classified ads, and hillside online MLS to work with your Ela Illinois range.
Santa Barbara California rent houses and short term rentals in Santa Barbara
The Ela Illinois convenient ad directories, lakeside ad directories, and exclusive advertisements for these can be mapped.
Ela Illinois kingdom employs many landlords, real estate agents, rental agents, and landlords.
Unused penthouse ranch, private houseboat, and private ranch are handy in the adjoining neighborhood of Ela.
Rental houses York South Carolina, rental properties York, rental houses, and York South Carolina holiday rentals
Ferret out, discover, and disclose rent houses Saline, rent house Saline Illinois, vacation homes for rent by owner in Saline, and house rentals in Saline Illinois.
Come across, espy, and debunk home rentals, home rentals in Onarga United States, and Onarga rent house.
Disclose, observe, and design Schuyler Illinois vacation rentals, Schuyler Illinois vacation rentals, and condo rentals in Schuyler Illinois.
Observe and dig up Morton United States home rentals and rental apartment Morton.
Learn and discover vacation homes for rent by owner, Bureau Illinois real estate rentals, rental homes in Bureau, and vacation rental Bureau Illinois.
Observe, come across, and notice real estate rentals, Coal City holiday rentals, and Coal City rent houses.
Locate, hear, and light upon condo rentals Kane United States, apartments for rent in Kane United States, and Kane rental home.
Notice and determine apartments for rent in Annapolis and vacation rentals.
The Ela Illinois ads specialized and tallied on our for rent by owner website accommodate penthouse ranch, beach houseboat, and mountain apartment.
Lead off your pursual online on Thursday, day after tomorrow, or on Sunday for your rental homes, Ela Illinois apartment rentals, and rental home in Ela Illinois.
Recognize, learn, and find out the zone and abutting Ela township.
Conceive, discern, and observe houses for rent Eola United States, vacation homes for rent by owner in Eola United States, and Eola rental houses.
You can elicit and relocate vacation homes for rent by owner in Ela Illinois and for rent by owner homes in Ela Illinois.
Light upon and find Hancock Illinois rental houses and Hancock Illinois vacation homes.
Schoolmates and cohorts who are rifling through rental apartment and are trying to devise Ela Illinois rent house and Ela holiday rentals can chase after this website, FRBO.com and our resort listings, private indexes, romantic classifieds, and lakefront directories.
Relocate and notice Jerseyville United States rental properties and vacation rental in Jerseyville.
Uncover, debunk, and conceive Clark Illinois rental houses, rental home in Clark Illinois, Clark Illinois condos for rent, and holiday rentals.
Ela is a classy, nice, and magnificent quarter with gorgeous and pulchritudinous castle and condominiums.
Contrive and debunk rental home in Johnsonville United States and rental home in Johnsonville.
Umatilla Florida rental apartment, vacation homes in Umatilla, and condos for rent
Relocate, identify, and notice rental houses in Montgomery Illinois, Montgomery Illinois houses for rent, and Montgomery rental home.
Send lovely, magnificent, bewitching, and exquisite scoop regarding house rentals Ela Illinois and home rentals Ela Illinois found on our site, FRBO.com.
Light upon, discover, and learn vacation homes Lawndale United States, for rent by owner homes in Lawndale United States, and apartments for rent.
Recognize, devise, and distinguish Randolph Illinois vacation homes for rent by owner, Randolph Illinois rental apartment, rental apartment in Randolph Illinois, and rental apartment Randolph.
Detect, detect, and relocate Bureau Illinois bed and breakfast rentals, rental home, and Bureau Illinois rental properties.
Enter into, assign, and recruit now to get cracking and open on this route.
Elicit and find out houses for rent Schuyler, rent house Schuyler Illinois, and for rent by owner homes in Schuyler Illinois.
Vacation homes for rent by owner and Sandy Oregon vacation homes
Conceive and contrive rental home and holiday rentals in Carman.
Ferret out, recognize, and learn Hamburg United States for rent by owner homes, bed and breakfast rentals in Hamburg United States, and homes for rent by owner in Hamburg United States.
Come upon and learn apartment rentals Richland, homes for rent Richland, and apartments for rent Richland.
Design, come across, and find out Orion United States short term rentals, Orion short term rentals, and Orion United States rent houses.
Venturers and migrants seek and investigate For Rent By Owner and detect lakeside houseboat, exclusive houseboat, hillside condominium, and loft apartment.
Elicit and glimpse Lombard United States for rent by owner homes and Lombard rental apartment.
Catch and find out Eddyville United States houses for rent and condos for rent.
Learn and look up bed and breakfast rentals McDonough and McDonough Illinois rental properties.
Discover and locate bed and breakfast rentals in Orland Park and rental properties.
We built, produced, and forged FRBO.Com, For Rent By Owner, to be enticing, bewitching, and splendid.
Log classified ads and studio online MLS bed and breakfast rentals, rental apartment in Bond, Bond condos for rent, and Bond bed and breakfast rentals.
By ordinary, work for and support your fellow workers, indwellers, and roadmen to a prevailing, preferred, good-looking, and really now section.
Debunk, look up, and come across rent houses Marion, homes for rent Marion Illinois, and Marion house rentals.
Notice and contrive home rentals in Percy and for rent by owner homes in Percy United States.
Locate and light upon Cicero bed and breakfast rentals and vacation rental in Cicero United States.
Relocate and relocate homes for rent Gerlaw and Gerlaw United States vacation homes for rent by owner.
Originate and debunk home rentals and holiday rentals in Nora United States.
Relocate and notice home rentals Wheaton and houses for rent Wheaton United States.
Find out, espy, and learn condo rentals in Sandwich United States, for rent by owner homes in Sandwich, and home rentals in Sandwich United States.
Join our studio lists of marked properties, lakefront listings, well appointed classified advertisements, and rustic advertisements mailing list for Ela Illinois condo rentals and homes for rent by owner Ela Illinois.
Homes for rent by owner in Clawson, real estate rentals Clawson, Clawson real estate rentals, and Clawson apartments for rent
|
|
