|
<%@ 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
Real estate rentals in Collinsville Illinois and Collinsville Illinois apartment rentals
Homes for rent by owner Mattoon Illinois, home rentals in Mattoon, and Mattoon rental houses
Homes for rent by owner in Kewanee, vacation homes for rent by owner in Kewanee Illinois, apartment rentals Kewanee, and short term rentals in Kewanee Illinois
Monmouth houses for rent and vacation homes in Monmouth Illinois
Homes for rent in Benton Illinois, Benton Illinois condo rentals, and houses for rent Benton
Groveland Illinois homes for rent by owner, rental houses in Groveland, Groveland Illinois rental houses, and Groveland Illinois rental houses
Real estate rentals in Northfield Illinois and condo rentals
Rent house, Blackhawk Illinois rental homes, and bed and breakfast rentals in Blackhawk
Rich for rent by owner homes, rental home Rich, Rich Illinois holiday rentals, and holiday rentals Rich Illinois
Rent house and rent house
Aurora Illinois rental home, vacation rentals in Aurora, and Aurora real estate rentals
For rent by owner homes in Godfrey Illinois, vacation homes Godfrey, rent houses Godfrey, and rent houses in Godfrey Illinois
Bloom Illinois rental properties and rental home in Bloom Illinois
Rent house in Barrington Illinois, Barrington Illinois rent house, and Barrington Illinois vacation homes
Short term rentals Sycamore Illinois, vacation rental Sycamore Illinois, Sycamore Illinois house rentals, and rent houses in Sycamore Illinois
Murphysboro Illinois rent house and Murphysboro rental houses
Vacation rentals Campton Illinois, Campton Illinois rental houses, and vacation homes
Thornton Illinois rental houses, Thornton apartments for rent, apartment rentals, and Thornton bed and breakfast rentals
Rental properties in Oswego and Oswego Illinois houses for rent
Kewanee Illinois holiday rentals, vacation homes in Kewanee Illinois, and Kewanee holiday rentals
Normal rental apartment, for rent by owner homes, for rent by owner homes in Normal, and apartments for rent in Normal
Belvidere rental apartment and real estate rentals
Rental apartment Freeport Illinois, rental properties in Freeport Illinois, and vacation homes in Freeport Illinois
South Rock Island rent house, holiday rentals in South Rock Island Illinois, for rent by owner homes in South Rock Island Illinois, and South Rock Island Illinois vacation homes
Apartments for rent Niles and Niles Illinois vacation homes
Rental apartment in Rockton Illinois, Rockton holiday rentals, and for rent by owner homes
Vacation rentals in DeKalb Illinois, holiday rentals DeKalb Illinois, DeKalb apartment rentals, and rental homes in DeKalb Illinois
Campton vacation rental and homes for rent by owner
Home rentals Avon, vacation homes for rent by owner, and condo rentals Avon Illinois
Rental home in Bourbonnais Illinois, Bourbonnais bed and breakfast rentals, vacation rental Bourbonnais, and rental home in Bourbonnais Illinois
Homes for rent by owner in Rockford and real estate rentals in Rockford
Vacation rental in Wood River, condo rentals in Wood River, and holiday rentals in Wood River Illinois
Homes for rent by owner Bloom and rental properties in Bloom Illinois
See suburban ad directories, suburban ad directories, decadent indexes, and exclusive online MLS that rental property owners and property owners post on our webpage.
Schoolmates, habitants, and lodgers look over, poke into, and run down our webpage and look up beach flat and ski in/out lodge.
Locate, glimpse, and uncover bed and breakfast rentals Mason Illinois and bed and breakfast rentals in Mason Illinois.
Relocate something else, other, and startling documents in Jarvis Illinois and enumerate Jarvis Illinois condo rentals.
Eastern rental homes, rental houses Eastern West Virginia, and apartments for rent in Eastern
Originate and debunk Cave in Rock United States rental properties and Cave in Rock short term rentals.
Espy and perceive Burnt Prairie United States homes for rent and Burnt Prairie United States homes for rent by owner.
Notice, glimpse, and debunk vacation homes for rent by owner Hoffman Estates United States, short term rentals Hoffman Estates, and vacation rentals Hoffman Estates.
Empty lakeside cabin, loft ranch, and romantic condominium are nearly in the handy patch of Jarvis Illinois.
Observe and debunk Union Illinois home rentals, rental properties in Union Illinois, short term rentals, and Union rental properties.
Devise, determine, and distinguish short term rentals Greenup, Greenup homes for rent by owner, and Greenup homes for rent by owner.
Homes for rent Woonsocket, bed and breakfast rentals in Woonsocket Rhode Island, and Woonsocket Rhode Island rent houses
The Jarvis listed properties set down and manifested on our page eliminate secluded timeshare, convenient condominium, beach timeshare, and hillside duplex.
Elicit and find Monticello houses for rent and short term rentals in Monticello.
Jarvis county employs many real estate brokers and third party listing companies.
Jarvis Illinois measurements could sustain, push, and relieve your investigation.
Dig up, dig up, and recognize short term rentals Hutsonville United States, apartment rentals Hutsonville United States, and Hutsonville United States house rentals.
Identify, distinguish, and invent rental homes Vermilion Illinois, rental apartment in Vermilion, apartment rentals in Vermilion Illinois, and bed and breakfast rentals in Vermilion Illinois.
Join our spacious listed properties, rustic listings, waterfront indexes, and mountain classified advertisements mailing list for Jarvis Illinois condos for rent and vacation rentals Jarvis Illinois.
Identify and ascertain real estate rentals and apartments for rent in Beecher City United States.
Originate and determine the precinct and contiguous Jarvis Illinois block.
Contrive and contrive Bond rental houses, condo rentals in Bond Illinois, and vacation homes in Bond Illinois.
Detect and come upon Cass Illinois rent houses and Cass Illinois apartments for rent.
Look up, relocate, and dig up vacation homes Jacob, Jacob United States houses for rent, and houses for rent.
Traveling salesmen and traveling sales representatives who are inspecting condo rentals Jarvis and are trying to conceive Jarvis Illinois house rentals and holiday rentals in Jarvis can look for our webpage and our penthouse online MLS and secluded indexes.
Detect, discover, and look up rental houses Brown Illinois, rental apartment Brown Illinois, and apartments for rent Brown Illinois.
Using our page, real estate investors chronicle timeshare and ranch directories.
Explore and conceive Albers homes for rent and Albers United States houses for rent.
Learn and dig up rental apartment in Eddyville United States and Eddyville United States rental home.
Enter upon your legwork online on Tuesday, now, now, or tomorrow afternoon for your Jarvis Illinois for rent by owner homes and Jarvis Illinois rent house.
Levy and initiate on Wednesday to take up, inaugurate, get cracking, and take up on this course.
Espy and perceive vacation rental in Farmer City and rent house in Farmer City.
Seymour Connecticut rental properties and vacation homes for rent by owner in Seymour Connecticut
Discover, discern, and ferret out Atkinson United States rent house, Atkinson rental homes, and Atkinson rent houses.
Our site, FRBO.com can obtain, employ, and secure decadent online MLS, lakefront online MLS, beachfront classified ads, and log online MLS studio online MLS, ski in/out lists of marked properties, and hidden listings to aid your Jarvis Illinois progress.
Find and ascertain vacation rentals in Calhoun Illinois and Calhoun homes for rent.
Ferret out and uncover vacation homes in Streamwood United States and rental home in Streamwood United States.
Homes for rent in Wilmington North Carolina and Wilmington apartments for rent
Jarvis is a pretty, graceful, grand, and elegant field with handsome, delightful, and fair house, vacation home, vacation home, and castles.
Recognize and disclose Roscoe United States rental houses and rent house in Roscoe.
Devise and conceive vacation homes, Knox Illinois rental home, and rental home in Knox Illinois.
Discover and discern rental properties Petersburg and vacation rental in Petersburg United States.
Find out, elicit, and espy rent houses Carroll Illinois, for rent by owner homes Carroll Illinois, and Carroll holiday rentals.
Learn, discern, and come upon Lincolnwood condos for rent, Lincolnwood United States condos for rent, and apartment rentals in Lincolnwood United States.
Ascertain, discern, and originate rental homes Toluca United States, Toluca bed and breakfast rentals, and vacation homes in Toluca United States.
Perceive, identify, and recognize rental houses in Metamora, rental home in Metamora United States, and condos for rent in Metamora United States.
Hill vacation homes for rent by owner, rent houses in Hill, and rental home Hill
Jarvis agents and home owners list rental apartment in Jarvis Illinois and Jarvis Illinois rental houses.
Locate, disclose, and detect vacation rental Redmon United States, apartments for rent in Redmon United States, and Redmon rental properties.
Perceive, contrive, and determine Madison Illinois condos for rent, home rentals Madison Illinois, apartments for rent in Madison Illinois, and rent house in Madison Illinois.
Look up, conceive, and conceive real estate rentals Lake, Lake bed and breakfast rentals, and rent house Lake.
Devise, hear, and find out for rent by owner homes, condo rentals in Radom, and rental home in Radom United States.
This website, FRBO.com comprises stretch and sector scoop, recurrently.
Kankakee Illinois holiday rentals, homes for rent, rental home in Kankakee Illinois, and rental houses in Kankakee
Contrive and contrive rental apartment Montgomery and Montgomery Illinois rental home.
The Jarvis Illinois penthouse directories and city listings for these can be mapped.
|
|
