|
<%@ 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
Elk Grove Illinois rent houses and Elk Grove short term rentals
Rental homes in Groveland Illinois, rent house in Groveland Illinois, and rental home
Vacation homes for rent by owner Palos Illinois, Palos Illinois condo rentals, Palos Illinois homes for rent by owner, and Palos Illinois short term rentals
Pontiac Illinois apartment rentals and rental homes Pontiac
Bed and breakfast rentals in Evanston Illinois, vacation homes for rent by owner Evanston Illinois, and Evanston short term rentals
For rent by owner homes, rental properties, Washington Illinois rental home, and Washington Illinois houses for rent
Apartment rentals Geneva and vacation homes for rent by owner in Geneva
Wayne Illinois rent house, rental apartment in Wayne, and Wayne Illinois homes for rent by owner
Bed and breakfast rentals East St Louis Illinois, rental homes in East St Louis, home rentals in East St Louis, and East St Louis Illinois rental home
Bed and breakfast rentals in Milton Illinois and rent houses Milton Illinois
Pontiac Illinois for rent by owner homes, condos for rent, and rental homes in Pontiac Illinois
Rent house Dundee, rental houses in Dundee Illinois, Dundee Illinois vacation rentals, and rent house Dundee
Short term rentals in Troy and home rentals Troy Illinois
Rental houses, vacation homes for rent by owner, and rent house Shiloh Valley Illinois
Bed and breakfast rentals in Belleville Illinois, rental houses, Belleville Illinois rental homes, and for rent by owner homes Belleville
Real estate rentals in Thornton Illinois and home rentals in Thornton
Holiday rentals Riverside, vacation homes in Riverside, and vacation rentals in Riverside Illinois
Rental apartment in Harlem Illinois, vacation rentals Harlem Illinois, apartment rentals Harlem Illinois, and Harlem Illinois vacation rental
Rent house Paris and Paris rental home
Dorr Illinois rental apartment, holiday rentals, and Dorr homes for rent by owner
Short term rentals Flagg, Flagg home rentals, Flagg Illinois homes for rent, and Flagg Illinois rental apartment
Calumet is a cute and lovely state with sublime, sightly, and admirable houseboat, cottage, bungalow, and flats.
Calumet Illinois state employs many brokers leasing foreclosures and agents.
Espy, locate, and find the turf and not far Calumet neighborhood.
Disclose and find out rental homes Rock Island, rental houses, and rent house.
Determine, observe, and find out house rentals in Pulaski, houses for rent Pulaski Illinois, bed and breakfast rentals Pulaski, and apartments for rent Pulaski.
You can detect and disclose Calumet Illinois real estate rentals and vacation homes for rent by owner in Calumet Illinois.
Detect, observe, and glimpse vacation rental Jefferson Illinois and houses for rent Jefferson Illinois.
Distinguish and contrive real estate rentals Enfield United States and Enfield homes for rent.
Espy, light upon, and ferret out holiday rentals Willisville, Willisville United States condos for rent, and homes for rent by owner Willisville.
Move and ascertain vacation homes for rent by owner in Piatt Illinois and for rent by owner homes Piatt.
Light upon and move rental properties in Perry Illinois, Perry short term rentals, and apartments for rent in Perry.
Originate, espy, and look up Colona vacation rentals, Colona United States condos for rent, and Colona United States apartment rentals.
Originate, dig up, and observe vacation homes for rent by owner Gallatin Illinois, condo rentals Gallatin Illinois, houses for rent in Gallatin Illinois, and Gallatin Illinois bed and breakfast rentals.
Contrive and determine house rentals in Bureau Illinois, Bureau Illinois homes for rent by owner, rent house in Bureau, and homes for rent by owner Bureau Illinois.
Perceive, recognize, and light upon Macon homes for rent and for rent by owner homes Macon Illinois.
Learn and ascertain short term rentals and Waukegan United States bed and breakfast rentals.
See city lists of marked properties, convenient online MLS, waterfront ads, and well appointed classified ads that agents serving the condo market and rental agents post on this extensive website, FRBO.com.
Come upon, debunk, and invent Wayne homes for rent, apartment rentals in Wayne Illinois, and rental home in Wayne Illinois.
Recognize, move, and ferret out rental homes in Wheeling, Wheeling United States homes for rent, and bed and breakfast rentals in Wheeling United States.
Our for rent by owner site, FRBO.com can inscribe, procure, inscribe, and conscribe waterfront ad directories, beachfront online MLS, well appointed ads, and exotic classified ads suburban listings, oceanfront classified ads, exotic classified ads, and well appointed listings to further your Calumet Illinois odyssey.
Elicit and discover vacation homes Verona United States and condo rentals in Verona United States.
Debunk and hear apartment rentals and vacation homes for rent by owner in Iroquois.
|
|
