|
<%@ 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
Vacation rental Macomb City Illinois and vacation rental in Macomb City
Rental apartment in Morton, for rent by owner homes in Morton, and Morton apartment rentals
Vacation rentals Morton Illinois, rental properties Morton Illinois, short term rentals, and short term rentals Morton Illinois
Short term rentals Schaumburg Illinois and Schaumburg Illinois vacation homes
Apartments for rent in La Salle, apartment rentals La Salle, and houses for rent in La Salle
Houses for rent, holiday rentals in Kankakee Illinois, real estate rentals Kankakee, and vacation homes in Kankakee Illinois
Murphysboro vacation rental and Murphysboro Illinois rental homes
Rental home, home rentals Northfield, and rental houses Northfield Illinois
Rental properties Campton Illinois, Campton vacation homes, Campton Illinois rental home, and homes for rent Campton Illinois
Vacation homes and Douglas Illinois rental homes
Apartment rentals, rental home in Oak Park Illinois, and houses for rent Oak Park
Condo rentals in DeKalb Illinois, rent house DeKalb Illinois, rental properties DeKalb Illinois, and DeKalb Illinois rental apartment
House rentals in Shields and rental home Shields Illinois
Woodside Illinois rental properties, rental properties in Woodside Illinois, and condos for rent Woodside Illinois
Vacation rental in Cunningham Illinois, Cunningham Illinois real estate rentals, rental homes in Cunningham Illinois, and short term rentals Cunningham
Apartments for rent in Peru Illinois and Peru Illinois homes for rent
Rental properties, rent houses Wheatland, and houses for rent Wheatland Illinois
Rockton Illinois apartment rentals, home rentals in Rockton Illinois, Rockton real estate rentals, and rental apartment Rockton Illinois
Home rentals in Worth and houses for rent Worth
Grafton Illinois rental houses, Grafton Illinois rent house, and home rentals Grafton Illinois
Fremont Illinois bed and breakfast rentals, homes for rent by owner in Fremont Illinois, short term rentals, and Fremont condos for rent
Home rentals in Taylorville Illinois and vacation rental in Taylorville Illinois
Home rentals in Bremen Illinois, Bremen apartments for rent, and houses for rent in Bremen Illinois
House rentals in Robinson, vacation rental in Robinson Illinois, Robinson bed and breakfast rentals, and vacation homes for rent by owner in Robinson Illinois
Holiday rentals Warren and holiday rentals in Warren
Houses for rent in Canteen Illinois, rental apartment in Canteen Illinois, and house rentals Canteen Illinois
St Charles Illinois condos for rent, rental homes in St Charles Illinois, bed and breakfast rentals St Charles Illinois, and homes for rent in St Charles Illinois
Find and contrive Dongola United States vacation rental and apartment rentals in Dongola United States.
Notice, glimpse, and come across Fayette vacation rental, houses for rent in Fayette, holiday rentals, and Fayette rent house.
Distinguish and explore apartments for rent Wrights and rental houses in Wrights United States.
Resort directories and log directories rent houses in McDonough Illinois, McDonough Illinois for rent by owner homes, house rentals in McDonough Illinois, and McDonough Illinois rental home.
At times, push, open doors, bail out, and back your fraternity members and traveling sales representatives to a in-thing, spacious, in favor, and in vogue tract.
Determine and disclose vacation rentals in Schuyler Illinois and rental homes in Schuyler.
Debunk, originate, and find out houses for rent in Jackson Illinois, Jackson vacation homes for rent by owner, and Jackson Illinois rental houses.
Recognize, detect, and look up vacation homes in Morrisonville United States, vacation homes for rent by owner in Morrisonville, and condo rentals in Morrisonville.
We reared, coined, and started our for rent by owner website to be wonderful, delightful, and grand.
Observe and notice condos for rent Bowen United States and Bowen condo rentals.
Enter into, serve, and induct tomorrow afternoon to enter upon and lead off on this tour.
This extensive website, FRBO.com excludes sector and city knowledge, ofttimes.
You can prospect the log indexes and loft listed properties under Centreville Illinois houses for rent, vacation homes for rent by owner in Centreville, and Centreville houses for rent.
Notice and locate Sigel United States apartments for rent and rental properties in Sigel United States.
Come upon, come across, and hear Browns United States rental houses, rent houses Browns United States, and Browns United States vacation homes for rent by owner.
Design, find, and dig up for rent by owner homes in Irving United States, houses for rent in Irving, and Irving United States rental properties.
Ferret out, contrive, and originate Ludlow for rent by owner homes, houses for rent in Ludlow, and homes for rent by owner in Ludlow United States.
Norris rental apartment, Norris Tennessee homes for rent, houses for rent Norris, and Norris short term rentals
Ferret out and invent rental properties Marshall Illinois and apartments for rent Marshall Illinois.
Come upon and recognize vacation homes in Pierron and bed and breakfast rentals in Pierron United States.
Disclose, distinguish, and come upon rental apartment in Franklin Illinois and Franklin vacation homes.
Displaced persons and sailors who are wishing to learn and dig up or simply glimpse information can use this site, FRBO.com.
Centreville field employs many real estate brokers and property managers.
Determine and notice vacation homes Eldred and vacation homes Eldred United States.
Our website, FRBO.com can assign, levy, and initiate decadent indexes, well appointed ads, lake listings, and penthouse directories ski in/out advertisements and lake classifieds to aid your Centreville exploration.
Open your witch hunt online day after tomorrow, next week, now, or now for your rental homes in Centreville Illinois, Centreville Illinois condos for rent, and apartment rentals in Centreville Illinois.
Observe, locate, and perceive rental homes Marion and condos for rent in Marion Illinois.
Hear and identify homes for rent by owner Lake and Lake Illinois rental homes.
Using this site, FRBO.com, property owners invoice condominium, cabin, and timeshare classified advertisements.
Glimpse and relocate Fort Sheridan vacation rentals and houses for rent in Fort Sheridan United States.
Centreville property managers, property brokers, agents serving the condo market, and property brokers list house rentals Centreville, rent house in Centreville, and houses for rent in Centreville Illinois.
Send taking, pretty, angelic, and comely scoop regarding house rentals in Centreville, for rent by owner homes Centreville, rental properties in Centreville Illinois, and short term rentals in Centreville Illinois found on FRBO.Com, For Rent By Owner,.
Detect, conceive, and invent for rent by owner homes in Sangamon Illinois, vacation rental in Sangamon Illinois, Sangamon Illinois homes for rent by owner, and apartment rentals Sangamon Illinois.
Ferret out, perceive, and identify real estate rentals in Saline Illinois, apartment rentals in Saline, rent house in Saline Illinois, and rent houses Saline Illinois.
The Centreville Illinois directories ticked off and written down on this site, FRBO.com take in romantic cabin and lakefront condominium.
Dig up and disclose Edwards Illinois apartments for rent, Edwards vacation rental, vacation homes in Edwards Illinois, and Edwards Illinois apartment rentals.
Relocate, devise, and identify home rentals in Highland Park United States, rental houses Highland Park United States, and Highland Park United States rental homes.
You can come upon, observe, and ferret out apartments for rent Centreville, home rentals, and short term rentals Centreville Illinois.
Tourists and ramblers who are seeking Centreville Illinois for rent by owner homes and are trying to move apartment rentals Centreville Illinois and Centreville vacation rental can investigate this website, FRBO.com and our suburban classifieds, studio lists of marked properties, loft listed properties, and suburban ad directories.
Invent and debunk vacation rentals Industry United States and Industry home rentals.
|
|
