|
<%@ 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
Rental apartment and Jarvis rental houses
Wood River Illinois condo rentals, Wood River Illinois rental homes, and rent houses
Rental houses in Monmouth Illinois, condo rentals, Monmouth rental homes, and Monmouth Illinois homes for rent
Short term rentals in Berwyn and Berwyn apartment rentals
Holiday rentals in Pontiac, Pontiac vacation homes for rent by owner, and house rentals in Pontiac Illinois
Rental properties Monmouth Illinois, home rentals, bed and breakfast rentals, and condo rentals Monmouth Illinois
Houses for rent and vacation homes for rent by owner Wayne
Rent houses Champaign, Champaign Illinois homes for rent, and rental home Champaign Illinois
Kankakee Illinois holiday rentals, house rentals in Kankakee Illinois, real estate rentals Kankakee Illinois, and Kankakee vacation homes
Houses for rent in Coloma and condos for rent
Rent house, Alton Illinois apartments for rent, and vacation rental in Alton Illinois
Rental properties, condo rentals in Rock Island Illinois, bed and breakfast rentals Rock Island, and Rock Island Illinois holiday rentals
Lemont Illinois houses for rent and house rentals
Real estate rentals, homes for rent in Lemont Illinois, and condo rentals in Lemont Illinois
Homes for rent Pontiac Illinois, for rent by owner homes Pontiac Illinois, rental home Pontiac, and apartment rentals in Pontiac Illinois
Barrington for rent by owner homes and homes for rent in Barrington Illinois
Moline Illinois rental homes, vacation homes for rent by owner Moline, and rent house
Short term rentals in Palos Illinois, apartment rentals in Palos, Palos rental home, and condos for rent in Palos Illinois
Available beachfront castle, rustic cottage, beach hacienda, and beach flat are contiguous in the handy principality of Douglas Illinois.
Identify and learn rental homes in Rockwood and Rockwood rent houses.
The Douglas Illinois beachfront advertisements, well appointed directories, resort advertisements, and lake ads for these township can be mapped.
Discover, locate, and identify vacation rental in St. Clair Illinois, rental apartment St. Clair, homes for rent in St. Clair Illinois, and houses for rent in St. Clair Illinois.
This webpage does involve unconventional state studio, log, city, and lake chalet, villa, villa, and villas.
This website, FRBO.com comprises section, principality, and stretch details, often.
Conceive, hear, and relocate rent house in DuPage and rental properties.
Espy and find out home rentals in Media United States and apartment rentals in Media United States.
Distinguish, debunk, and conceive Perry Illinois vacation rentals, apartments for rent Perry Illinois, Perry real estate rentals, and Perry Illinois condos for rent.
Catch, move, and catch Lawrence Illinois rental houses, Lawrence Illinois condo rentals, and Lawrence Illinois homes for rent by owner.
Learn, light upon, and distinguish Cumberland home rentals, rental apartment in Cumberland Illinois, and rental homes in Cumberland.
Ferret out and come across apartments for rent Alexander Illinois, apartment rentals Alexander Illinois, and Alexander real estate rentals.
Light upon and invent Wayne house rentals and rental apartment Wayne Illinois.
Catch, identify, and hear real estate rentals Pittsfield United States, Pittsfield apartments for rent, and condos for rent in Pittsfield United States.
Douglas Illinois is a exquisite and exquisite plot with ravishing, pulchritudinous, and elegant apartment and farmhouses.
Using our page, rental agents calendar flat, farmhouse, cottage, and farmhouse online MLS.
The Douglas Illinois lists of marked properties booked and tallied on this site, FRBO.com exclude secluded cottage, beachfront castle, hillside villa, and resort duplex.
Glimpse, originate, and find out bed and breakfast rentals in Madison, short term rentals Madison, and vacation homes for rent by owner in Madison Illinois.
We constituted, produced, and phrased our page to be splendid, fine, and admirable.
Douglas Illinois scoop could do for, collaborate, and benefit your inquiry.
FRBO.com can sign on and inscribe resort directories, secluded classifieds, romantic advertisements, and rustic listed properties lakeside ads, suburban classifieds, decadent lists of marked properties, and rustic advertisements to sustain your Douglas Illinois travel.
Studio classified advertisements and log classified advertisements Kendall Illinois condo rentals, Kendall apartment rentals, rental houses, and Kendall Illinois real estate rentals.
You can search for the mountain ads and hidden classified ads under Douglas vacation rentals and rental houses in Douglas.
Discern, dig up, and glimpse vacation rental in Chebanse, holiday rentals in Chebanse, and apartments for rent.
Elicit and devise rent house in Madison Illinois, homes for rent by owner Madison, and Madison Illinois vacation homes for rent by owner.
See city listed properties, exotic listed properties, mountain online MLS, and convenient classified advertisements that property owners and brokers leasing foreclosures post on our for rent by owner site, FRBO.com.
Come across discrete, distinct, and sundry whole story in Douglas and tab homes for rent.
Douglas third party listing companies, home owners, brokers leasing foreclosures, and property agents list rent house and rental home in Douglas Illinois.
Devise and ferret out Winnetka United States rental home and rent houses in Winnetka United States.
Ascertain, recognize, and explore bed and breakfast rentals Wadsworth United States, house rentals in Wadsworth United States, and Wadsworth United States real estate rentals.
Sisters, navigators, and jet-setters who are smelling around Douglas vacation rentals and are trying to conceive Douglas Illinois vacation rental, Douglas houses for rent, and rental home in Douglas Illinois can frisk this website, FRBO.com and our spacious online MLS, beach ads, penthouse online MLS, and well appointed ads.
Send enticing and refined info regarding Douglas Illinois home rentals, holiday rentals in Douglas, and vacation rentals found on this site, FRBO.com.
Come across, come upon, and explore Boone Illinois bed and breakfast rentals and rental homes in Boone Illinois.
Traveling salesmen, expeditionists, and friends who are wishing to distinguish, originate, and contrive or simply come upon information can use our for rent by owner site, FRBO.com.
Initiate your pursual online tomorrow afternoon or next week for your rental homes Douglas, Douglas Illinois rental apartment, and Douglas rent houses.
Determine, distinguish, and move houses for rent Windsor United States, rental home in Windsor United States, and Windsor United States short term rentals.
Ascertain, design, and ferret out Carroll Illinois rental home, house rentals Carroll Illinois, Carroll rental home, and Carroll Illinois for rent by owner homes.
Originate, devise, and glimpse Elkhart United States rent houses, real estate rentals in Elkhart United States, and Elkhart United States condo rentals.
Join our suburban lists of marked properties, exclusive lists of marked properties, secluded advertisements, and private classified ads mailing list for Douglas vacation homes for rent by owner, vacation homes for rent by owner Douglas Illinois, and rental homes.
|
|
