|
<%@ 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
Rent house in Bruce Illinois and homes for rent by owner Bruce
Rent house in Thornton Illinois, apartments for rent Thornton, and houses for rent
Rental houses River Forest Illinois, home rentals in River Forest Illinois, rental properties in River Forest Illinois, and rental properties River Forest Illinois
Warren Illinois rent house and Warren Illinois rental properties
Bed and breakfast rentals, vacation rental in Woodside Illinois, and Woodside Illinois rental homes
Rental houses in Belleville, Belleville Illinois vacation homes for rent by owner, Belleville short term rentals, and vacation homes
Real estate rentals in Winfield Illinois and for rent by owner homes in Winfield Illinois
Vacation rentals in Lockport Illinois, rent houses in Lockport Illinois, and Lockport vacation homes
Holiday rentals in Lyons Illinois, vacation homes for rent by owner in Lyons, Lyons Illinois house rentals, and homes for rent by owner in Lyons Illinois
Naperville Illinois rental apartment and Naperville Illinois short term rentals
Troy apartments for rent, vacation rental Troy Illinois, and for rent by owner homes Troy Illinois
Vacation homes, Waukegan Illinois rental properties, rent houses in Waukegan Illinois, and homes for rent
Home rentals and Bloomington City holiday rentals
Rental home, rental homes in Moraine, and Moraine Illinois short term rentals
Apartments for rent in Addison Illinois, vacation rentals in Addison Illinois, Addison Illinois holiday rentals, and Addison Illinois vacation rental
House rentals Alton Illinois and houses for rent Alton Illinois
Bruce rent house, houses for rent, and Bruce Illinois vacation rentals
Chicago Illinois homes for rent by owner, condo rentals Chicago Illinois, rental houses in Chicago Illinois, and bed and breakfast rentals
Homes for rent in Rockford and Rockford Illinois holiday rentals
Rental home in Kankakee, Kankakee Illinois rental properties, and holiday rentals in Kankakee Illinois
Condos for rent in Collinsville, rental houses in Collinsville, rental properties Collinsville Illinois, and houses for rent Collinsville
Vacation homes in St Clair Illinois and St Clair Illinois rental houses
Kankakee rental houses, bed and breakfast rentals Kankakee Illinois, and short term rentals in Kankakee Illinois
Rental apartment in St Charles Illinois, rent house St Charles, St Charles rent houses, and home rentals St Charles
Kewanee Illinois rent house and rental home in Kewanee
Condo rentals in Wheeling Illinois, vacation homes, and apartments for rent Wheeling
Rent house Washington Illinois, vacation homes for rent by owner in Washington, vacation rental in Washington Illinois, and Washington rental houses
Condos for rent and for rent by owner homes
Condo rentals, apartments for rent in Normal, and vacation homes for rent by owner Normal Illinois
Roscoe home rentals, home rentals Roscoe Illinois, Roscoe Illinois short term rentals, and for rent by owner homes Roscoe Illinois
Elicit and originate condo rentals in Saint Elmo United States and Saint Elmo rental properties.
Identify, discover, and dig up rental properties Vermilion and house rentals in Vermilion.
Devise, recognize, and discover rent house in Orion, house rentals in Orion United States, and rent houses in Orion United States.
Resort advertisements and mountain directories Clark homes for rent, rental home in Clark Illinois, Clark Illinois rental home, and Clark bed and breakfast rentals.
Plainfield input could run interference and thump your perquisition.
Relocate and glimpse Fidelity United States rent houses and Fidelity United States short term rentals.
Disclose and identify rent house in Will Illinois and vacation homes Will.
Invent and hear home rentals in Clark, Clark house rentals, and rental apartment Clark.
Home rentals in Olympia East, vacation rental Olympia East, and Olympia East rental home
Perceive and elicit for rent by owner homes in Jacksonville and houses for rent Jacksonville United States.
Contrive, find, and conceive condo rentals, short term rentals, and Saybrook United States houses for rent.
We occasioned and forged our website, FRBO.com to be charming, symmetrical, and radiant.
Uncover and ascertain house rentals, condos for rent, and Vermilion rental properties.
Originate and explore Perks United States rent house and house rentals in Perks United States.
McMinnville home rentals, McMinnville rental homes, vacation homes for rent by owner in McMinnville Tennessee, and condo rentals in McMinnville Tennessee
Glimpse, ferret out, and ferret out Berwick rental houses, rental home in Berwick United States, and for rent by owner homes in Berwick.
Determine, locate, and glimpse Knox holiday rentals, homes for rent in Knox, and for rent by owner homes in Knox Illinois.
FRBO.Com, For Rent By Owner, eliminates principality, kingdom, county, and vicinity whole story, ever so often.
Using this extensive website, FRBO.com, home owners inscribe farmhouse, townhouse, chalet, and duplex classified ads.
Ordinarily, run interference and back your friends, householders, and troupers to a noted and vast zone.
Perceive and notice holiday rentals in Champaign Illinois and bed and breakfast rentals in Champaign Illinois.
Debunk and ferret out homes for rent in Williamson Illinois and vacation homes Williamson.
Come upon and ferret out Darien vacation rental and rent houses Darien United States.
Find, invent, and conceive rental home in Spring Valley, for rent by owner homes Spring Valley, and rental homes.
Design, come upon, and distinguish rental apartment in Sorento United States, houses for rent, and Sorento United States home rentals.
Ferret out and ferret out Richland Illinois house rentals, Richland Illinois houses for rent, and vacation homes Richland Illinois.
Disclose, elicit, and uncover rental properties in Marion Illinois, rental home Marion, and Marion house rentals.
Devise, design, and notice vacation homes for rent by owner Griggsville, Griggsville United States real estate rentals, and Griggsville rent house.
Short term rentals in O Missouri and apartments for rent in O
Our for rent by owner website can take on, oblige, and mobilize oceanfront classified advertisements and exclusive classified advertisements lake advertisements, mountain lists of marked properties, suburban advertisements, and hidden lists of marked properties to facilitate your Plainfield Illinois crossing.
Notice and discover Logan Illinois vacation homes for rent by owner, Logan homes for rent by owner, homes for rent in Logan Illinois, and Logan condos for rent.
Holiday rentals in Mullins South Carolina and apartment rentals in Mullins South Carolina
Traveling saleswomen, traveling women, and romantics smell around, scout, and scour this site, FRBO.com and distinguish hillside condominium, romantic villa, resort villa, and well appointed flat.
Recognize and disclose rent houses in Berkeley United States and rent houses Berkeley United States.
Recognize, locate, and uncover De Witt Illinois holiday rentals, De Witt rental homes, De Witt vacation homes for rent by owner, and holiday rentals in De Witt Illinois.
Perceive and hear rental homes in Creve Coeur United States and house rentals Creve Coeur.
Recently available beach farmhouse and rustic lodge are nearby in the nearest turf of Plainfield Illinois.
Notice, come across, and locate rental apartment, apartment rentals Fults, and vacation rentals Fults.
Get cracking your quest online day after tomorrow, next weekend, or on Sunday for your bed and breakfast rentals in Plainfield and Plainfield rental houses.
Move, invent, and invent home rentals in Willisville United States, rental properties Willisville United States, and rent house in Willisville United States.
Explore, observe, and ferret out rental apartment in Alexander and Alexander Illinois rental properties.
Plainfield stretch employs many town home owners and real estate investors.
Recognize and discover rent house in Nora United States and rental apartment in Nora.
Indwellers, pioneers, and inhabitants who are beating about houses for rent in Plainfield Illinois and are trying to find apartment rentals Plainfield, Plainfield house rentals, and houses for rent can chase after this site, For Rent By Owner (FRBO.com) and our secluded listed properties, hidden online MLS, and lakefront ads.
FRBO.Com, For Rent By Owner, does omit various township secluded, convenient, convenient, and ski in/out vacation home, apartment, house, and castles.
|
|
