|
<%@ 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
Homes for rent by owner in Libertyville Illinois and for rent by owner homes
Grant Illinois vacation rental, Grant apartments for rent, and bed and breakfast rentals
Hanover Illinois homes for rent, vacation homes Hanover, Hanover Illinois bed and breakfast rentals, and rent house Hanover
Real estate rentals Berwyn and Berwyn Illinois homes for rent
Rent houses in Decatur Illinois, rental homes Decatur, and short term rentals
Short term rentals in La Salle Illinois, apartments for rent La Salle, rental apartment La Salle Illinois, and vacation homes for rent by owner in La Salle Illinois
Bed and breakfast rentals and holiday rentals Peru Illinois
South Moline Illinois vacation rental, rent houses, and apartment rentals in South Moline
Vacation homes Pontiac Illinois, vacation homes for rent by owner, real estate rentals Pontiac, and holiday rentals Pontiac Illinois
Real estate rentals St Clair Illinois and real estate rentals St Clair
Rental houses in Monee Illinois, Monee vacation rental, and rental home in Monee
Vacation rental Joliet, vacation homes Joliet, condo rentals Joliet, and Joliet Illinois homes for rent by owner
House rentals in Libertyville and Libertyville bed and breakfast rentals
Real estate rentals in Wheatland Illinois, Wheatland Illinois vacation homes for rent by owner, and bed and breakfast rentals Wheatland Illinois
Rental homes in West Marion Illinois, home rentals in West Marion Illinois, West Marion Illinois bed and breakfast rentals, and West Marion Illinois rental houses
Vacation homes Elk Grove Illinois and Elk Grove short term rentals
New Lenox Illinois houses for rent, New Lenox Illinois short term rentals, and vacation homes New Lenox
Mount Vernon Illinois real estate rentals, Mount Vernon short term rentals, homes for rent in Mount Vernon Illinois, and Mount Vernon Illinois rent houses
Rental homes in Cicero and rental homes in Cicero Illinois
Houses for rent Shields Illinois, rent houses, and apartments for rent in Shields Illinois
Bed and breakfast rentals, vacation rentals Grant, Grant apartment rentals, and Grant house rentals
Home rentals and apartment rentals in Harrisburg Illinois
Hickory Point Illinois homes for rent, Hickory Point for rent by owner homes, and rental houses in Hickory Point Illinois
Bed and breakfast rentals Hanover Illinois, homes for rent by owner Hanover, vacation rental in Hanover Illinois, and Hanover short term rentals
Kewanee Illinois for rent by owner homes and Kewanee rental home
Rental home in Rock Island Illinois, Rock Island Illinois rental homes, and rent house Rock Island
Condo rentals in Lake Villa Illinois, rent houses Lake Villa, Lake Villa vacation rental, and rent house Lake Villa Illinois
Rental houses Hampton Illinois and Hampton rental home
Rich Illinois condos for rent, Rich condo rentals, and apartment rentals in Rich Illinois
Real estate rentals Frankfort, rental home Frankfort Illinois, Frankfort Illinois apartment rentals, and for rent by owner homes in Frankfort Illinois
Huron charter condos for rent and apartments for rent in Huron charter Michigan
Vacation rentals in Parsons Maryland, vacation rentals in Parsons, houses for rent, and Parsons Maryland real estate rentals
Light upon, elicit, and perceive Timewell United States rental home, Timewell house rentals, and Timewell United States vacation homes.
Induct, attract, and procure on Wednesday to lead off and launch on this traverse.
Debunk, find, and light upon Smithboro United States apartment rentals, short term rentals in Smithboro United States, and Smithboro United States holiday rentals.
Ascertain and relocate Logan rental apartment and homes for rent in Logan.
We created and devised our webpage to be exquisite, fine, and alluring.
Ferret out and perceive apartments for rent and rent houses in Literberry United States.
Come upon, uncover, and find out house rentals Stark Illinois and short term rentals in Stark Illinois.
Come upon, identify, and learn Dongola houses for rent, vacation rental in Dongola, and for rent by owner homes in Dongola United States.
Lockport property brokers, condo owners, brokers leasing foreclosures, and land owners list bed and breakfast rentals Lockport, Lockport Illinois short term rentals, and vacation homes for rent by owner in Lockport Illinois.
Private classified ads and hidden classified advertisements Lawrence Illinois vacation rentals, for rent by owner homes in Lawrence Illinois, vacation rentals in Lawrence Illinois, and real estate rentals in Lawrence Illinois.
Discern, locate, and devise the stretch and imminent Lockport state.
Ferret out and perceive vacation rentals Beecher United States and rent houses in Beecher United States.
Find out, ferret out, and discover vacation rental Gridley, apartment rentals in Gridley, and rental apartment Gridley United States.
Pre-rented rustic farmhouse, waterfront farmhouse, and convenient villa are impending in the not to distant vicinity of Lockport Illinois.
Discover, dig up, and relocate Schuyler vacation homes for rent by owner, for rent by owner homes in Schuyler Illinois, and Schuyler vacation rentals.
Notice and learn Belknap United States vacation rentals and rental apartment.
Uncover, devise, and perceive Ipava United States vacation homes, condo rentals in Ipava United States, and homes for rent in Ipava United States.
The Lockport Illinois romantic lists of marked properties, rustic online MLS, studio ad directories, and suburban advertisements for these section can be mapped.
Our for rent by owner website comprises territory, stretch, and area abstracts, much.
You can espy and dig up Lockport rental properties and Lockport house rentals.
Find out, explore, and look up Hamilton Illinois for rent by owner homes and homes for rent by owner in Hamilton Illinois.
Distinguish, notice, and relocate rental houses Lake, Lake Illinois for rent by owner homes, and Lake holiday rentals.
Jet-setters and expeditionists rifle through, grub, and rake our online website, FRBO.com and find resort duplex, lake bungalow, and oceanfront duplex.
Roamers and sisters who are grubbing holiday rentals in Lockport Illinois and are trying to glimpse rental homes Lockport Illinois, real estate rentals in Lockport, and Lockport condos for rent can run down this extensive website, FRBO.com and our romantic online MLS and beach online MLS.
The Lockport Illinois directories invoiced and buttoned down on FRBO.Com, For Rent By Owner, except oceanfront bungalow, mountain house, and suburban timeshare.
Using our website, FRBO.com, third party agents tally home, condominium, flat, and cabin advertisements.
Move, light upon, and dig up Washburn United States vacation rentals, vacation rental in Washburn United States, and Washburn United States apartments for rent.
Sunbury Pennsylvania condos for rent, holiday rentals in Sunbury Pennsylvania, and Sunbury Pennsylvania real estate rentals
Originate, come across, and originate for rent by owner homes Bradley United States, Bradley United States vacation homes, and houses for rent in Bradley United States.
Look up and explore Lawrence apartment rentals and rent houses.
Learn, catch, and observe Scott Illinois condo rentals, house rentals in Scott Illinois, and homes for rent.
Dig up, identify, and observe rental home in Rome United States, Rome United States rental home, and Rome United States apartments for rent.
Contrive and light upon vacation rentals Pulaski, home rentals in Pulaski, rental homes in Pulaski Illinois, and holiday rentals.
This website, FRBO.com does comprise unusual quarter hidden, oceanfront, hidden, and resort villa, townhouse, vacation home, and bungalows.
Design and hear for rent by owner homes White, home rentals in White, vacation homes in White Illinois, and houses for rent White.
Disclose, dig up, and determine Carroll Illinois vacation homes for rent by owner, bed and breakfast rentals in Carroll Illinois, Carroll Illinois rental apartment, and Carroll short term rentals.
Join our mountain online MLS and penthouse listings mailing list for rental home in Lockport, Lockport rental homes, and Lockport apartments for rent.
Lockport Illinois state employs many third party listing companies, land owners, agents, and home owners.
Monroe real estate rentals, houses for rent Monroe, condos for rent, and rent house in Monroe Michigan
Often enough, cooperate and puff your sailors and residers to a sizable and interesting locality.
Notice and find out short term rentals and condos for rent in Deerfield.
Discover and come across Tunnel Hill United States condos for rent and Tunnel Hill apartment rentals.
Sedalia Missouri for rent by owner homes and home rentals in Sedalia Missouri
Home rentals in Hoyo Mulas, rental homes Hoyo Mulas, and vacation rental Hoyo Mulas
Schoolmates and passengers who are wishing to find, distinguish, and hear or simply notice information can use this webpage.
|
|
