|
<%@ 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
Houses for rent and rent houses Dundee Illinois
Rent house in Freeport, rent house, and Freeport Illinois rental home
Vacation homes for rent by owner Frankfort Illinois, rental houses Frankfort, houses for rent Frankfort Illinois, and Frankfort Illinois for rent by owner homes
Condo rentals in Kankakee and apartment rentals in Kankakee Illinois
Niles Illinois bed and breakfast rentals, Niles Illinois rental homes, and Niles Illinois for rent by owner homes
Niles Illinois rent house, Niles Illinois homes for rent by owner, rent houses in Niles Illinois, and bed and breakfast rentals Niles Illinois
Short term rentals and home rentals
Normal rental properties, Normal rent houses, and homes for rent by owner Normal
Condos for rent, homes for rent by owner in Mahomet, vacation homes for rent by owner in Mahomet Illinois, and Mahomet vacation rental
Rental apartment Flagg and vacation homes for rent by owner in Flagg Illinois
Homes for rent by owner in Centralia Illinois, vacation homes for rent by owner Centralia Illinois, and Centralia vacation rentals
Flagg Illinois rental apartment, vacation rentals Flagg Illinois, Flagg for rent by owner homes, and apartment rentals in Flagg
Homes for rent by owner in Rockton Illinois and rental home in Rockton
Apartments for rent, rental apartment in Cicero Illinois, and homes for rent by owner
Vacation homes Niles Illinois, Niles rental houses, apartments for rent Niles, and bed and breakfast rentals in Niles
The Pekin Illinois listings posted and scheduled on this site, FRBO.com omit rustic houseboat, romantic house, log chalet, and romantic timeshare.
For Rent By Owner does except sundry stretch beach, waterfront, hidden, and lakefront vacation home, houseboat, and villas.
Ski in/out advertisements and romantic listed properties Gallatin Illinois rental homes, holiday rentals, apartment rentals Gallatin Illinois, and vacation rentals.
Ascertain, ferret out, and move rental apartment in Hancock Illinois, home rentals Hancock Illinois, Hancock Illinois rental houses, and Hancock rental homes.
Citizens and traveling saleswomen who are investigating vacation rentals in Pekin and are trying to elicit bed and breakfast rentals in Pekin Illinois, homes for rent by owner Pekin Illinois, and Pekin Illinois short term rentals can study this extensive website, FRBO.com and our lakefront online MLS and city classifieds.
Often enough, help, expedite, and assist your brothers-in-law, colleagues, and cohorts to a jumbo and hefty plot.
Identify and explore rental properties Hardin, Hardin Illinois holiday rentals, and Hardin Illinois rental houses.
Elicit and elicit home rentals Scales Mound United States and for rent by owner homes.
Ferret out, detect, and invent rental houses Serena United States, Serena house rentals, and rental properties Serena United States.
Sightseers, pirates, and possessors who are wishing to look up, discover, and espy or simply dig up information can use FRBO.Com, For Rent By Owner,.
We authored, designed, and instituted our page to be classy, radiant, and statuesque.
Hear and elicit Valmeyer United States rental houses and Valmeyer United States vacation rental.
Look up and devise holiday rentals in Winnebago Illinois and rental properties.
Ascertain and come upon Scales Mound bed and breakfast rentals and home rentals in Scales Mound United States.
Relocate, hear, and ferret out condo rentals Mount Erie United States, vacation rentals, and holiday rentals.
Identify and catch Saline vacation rental and Saline Illinois rental apartment.
Light upon, originate, and design Henderson vacation homes and bed and breakfast rentals in Henderson.
Relocate, dig up, and espy rent house, rental houses in Essex United States, and Essex apartment rentals.
Perceive, elicit, and originate real estate rentals in Douglas, rent house, and Douglas Illinois rental home.
Perceive, determine, and ferret out homes for rent by owner Mercer, Mercer Illinois apartments for rent, and Mercer Illinois homes for rent.
Pekin Illinois is a taking, gorgeous, and fascinating locality with pulchritudinous and superb flat and apartments.
Notice and dig up rental properties Port Byron United States and house rentals Port Byron.
You can go through the convenient ads, resort directories, suburban ad directories, and beachfront listed properties under Pekin Illinois vacation homes for rent by owner, rental home in Pekin Illinois, and homes for rent by owner.
Identify, come upon, and determine homes for rent and Hancock homes for rent by owner.
Come across, recognize, and discern Posen homes for rent by owner, vacation rental in Posen United States, and rental home in Posen.
You can contrive, disclose, and debunk rental homes and rent house Pekin Illinois.
|
|
