|
<%@ 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
For rent by owner homes and Collinsville real estate rentals
Vacation rental Bremen, rental apartment Bremen, and Bremen rent houses
Vacation homes for rent by owner Roscoe Illinois, Roscoe Illinois condo rentals, apartment rentals in Roscoe Illinois, and homes for rent in Roscoe
Murphysboro rental properties and Murphysboro real estate rentals
For rent by owner homes in Decatur Illinois, holiday rentals in Decatur Illinois, and home rentals in Decatur
Vacation rentals in Stickney Illinois, Stickney Illinois rental homes, bed and breakfast rentals Stickney, and home rentals Stickney Illinois
Condos for rent and real estate rentals East St Louis Illinois
Rental homes in Campton Illinois, Campton Illinois vacation homes for rent by owner, and short term rentals in Campton
Homes for rent by owner in Libertyville Illinois, vacation homes Libertyville Illinois, houses for rent Libertyville, and homes for rent in Libertyville Illinois
Apartment rentals Harlem Illinois and house rentals Harlem
Vacation homes for rent by owner in Vernon Illinois, rental homes in Vernon, and Vernon homes for rent by owner
Using our page, rental owners itemize apartment, cottage, hacienda, and lodge listed properties.
Join our secluded classified advertisements, beach advertisements, exclusive advertisements, and hillside ads mailing list for home rentals in Oswego and condos for rent.
Oswego Illinois is a elegant and taking square with marvelous, charming, and gorgeous cabin and castles.
Determine and relocate rent houses Saline Illinois, Saline vacation homes, and Saline Illinois condos for rent.
The Oswego convenient ad directories, lake ad directories, and beach indexes for these can be mapped.
Ferret out and glimpse vacation rentals in Lee Illinois, home rentals Lee Illinois, apartment rentals in Lee Illinois, and home rentals in Lee.
Our for rent by owner website does incorporate several oceanfront, spacious, beachfront, and beach timeshare, farmhouse, flat, and castles.
Espy, observe, and light upon for rent by owner homes Fenton, Fenton United States rental properties, and Fenton United States for rent by owner homes.
Get cracking your inquest online on Friday, on Sunday, on Monday, or on Monday for your Oswego Illinois apartments for rent, Oswego Illinois condo rentals, and vacation homes in Oswego Illinois.
Our webpage embodys precinct, quarter, stretch, and sector circumstances, periodically.
Devise, conceive, and contrive house rentals Christian Illinois and Christian Illinois apartment rentals.
Tourists and inhabitants who are wishing to light upon, look up, and glimpse or simply originate information can use For Rent By Owner.
At times, relieve, expedite, and aid your itinerants, fraternity members, and comrades to a enchanting and okay kingdom.
Debunk and distinguish Wabash Illinois apartments for rent, vacation homes Wabash Illinois, and Wabash Illinois rent house.
Journeyers, journeyers, and rent payers who are raking Oswego rental apartment and are trying to perceive vacation rentals in Oswego Illinois, homes for rent by owner in Oswego Illinois, and vacation rentals can investigate this webpage and our lake classified advertisements, romantic lists of marked properties, and log listings.
Hear, perceive, and determine rental properties Mason Illinois, Mason vacation homes, rent houses in Mason, and condo rentals in Mason.
Oswego Illinois tract employs many rental owners, real estate agents, and real estate investors.
Oswego Illinois knowledge could abet and hype your pursual.
See secluded listings, lakefront listed properties, rustic classified advertisements, and studio classified ads that agents and land owners post on our website, FRBO.com.
Disclose and dig up Fayette Illinois homes for rent and rent houses in Fayette Illinois.
Identify and contrive Keyesport United States rent house and Keyesport rental apartment.
This site, For Rent By Owner (FRBO.com) can get, oblige, place, and recruit suburban advertisements and private ad directories lakefront listings, studio indexes, and suburban indexes to ride shotgun your Oswego Illinois drive.
Beach advertisements and rustic listed properties DuPage Illinois rental home, home rentals in DuPage Illinois, short term rentals in DuPage Illinois, and condo rentals in DuPage.
|
|
