|
<%@ 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 Peru and homes for rent by owner Peru
Rent houses, Champaign City homes for rent by owner, and Champaign City homes for rent
Rental properties Edwardsville, Edwardsville holiday rentals, rent house in Edwardsville Illinois, and Edwardsville Illinois vacation rental
Homes for rent by owner Hampton Illinois and rental apartment in Hampton Illinois
Stookey Illinois houses for rent, vacation homes, and Stookey Illinois rental properties
Rental properties in Bremen Illinois, houses for rent, vacation rental, and Bremen Illinois vacation homes
Dundee short term rentals and house rentals in Dundee Illinois
Rental home Frankfort, rent house in Frankfort, and rent houses in Frankfort
Bloomington City Illinois rent houses, real estate rentals in Bloomington City Illinois, Bloomington City Illinois rent houses, and Bloomington City Illinois apartment rentals
For rent by owner homes Wayne and Wayne real estate rentals
Vacation homes for rent by owner Cherry Valley Illinois, vacation rental Cherry Valley Illinois, and for rent by owner homes in Cherry Valley Illinois
Berwyn Illinois vacation homes for rent by owner, house rentals in Berwyn Illinois, rental homes Berwyn Illinois, and vacation rentals Berwyn
Thornton short term rentals and rental homes
Harlem Illinois home rentals, real estate rentals in Harlem, and rent house in Harlem
Stickney bed and breakfast rentals, Stickney Illinois rental home, bed and breakfast rentals Stickney Illinois, and vacation homes for rent by owner in Stickney Illinois
Perceive, learn, and catch condos for rent in Fox Valley United States, Fox Valley United States apartment rentals, and Fox Valley United States homes for rent.
Find, light upon, and elicit apartment rentals in Atkinson United States, Atkinson United States real estate rentals, and Atkinson United States bed and breakfast rentals.
Get going your shakedown online this weekend, tomorrow morning, or now for your short term rentals in Flagg Illinois and short term rentals in Flagg.
You can distinguish and discern bed and breakfast rentals and homes for rent.
Conceive and dig up vacation homes in Lacon United States and homes for rent in Lacon.
Pre-rented log duplex, hillside vacation home, romantic cottage, and private lodge are not far in the adjoining vicinity of Flagg Illinois.
Design, catch, and learn house rentals Shumway, Shumway United States rent house, and vacation homes Shumway.
Ski in/out listings and studio listings Pike rental home, vacation homes for rent by owner in Pike, apartments for rent Pike, and homes for rent by owner Pike.
You can rummage the ski in/out advertisements and log lists of marked properties under Flagg Illinois condos for rent, Flagg houses for rent, and rental homes in Flagg.
Identify, determine, and find out Jersey Illinois rental houses, Jersey Illinois homes for rent, Jersey Illinois rental home, and condo rentals Jersey.
Oftentimes, sustain, aid, ride shotgun, and expedite your suburbanites and residents to a crowd-pleaser, hip, and lovable parcel.
Our for rent by owner website can oblige, muster, interest, and procure secluded listings, exotic classified ads, decadent listings, and suburban classifieds ski in/out indexes, lakeside directories, hillside listings, and resort listed properties to plug your Flagg Illinois run.
Detect, look up, and come across rent houses in Godfrey United States, rent houses in Godfrey United States, and rental houses Godfrey.
Companions, ramblers, and commuters who are wishing to dig up and come upon or simply locate information can use this site, FRBO.com.
Our webpage does enclose specialized resort and private home, vacation home, houseboat, and bungalows.
Identify, light upon, and devise Carroll Illinois houses for rent, Carroll Illinois rental houses, Carroll real estate rentals, and rent houses in Carroll Illinois.
Contrive, discern, and uncover Nokomis United States home rentals, Nokomis United States rental houses, and condo rentals Nokomis United States.
Ferret out, find out, and find Jo Daviess Illinois rent houses, holiday rentals in Jo Daviess Illinois, and rent houses Jo Daviess.
Discern and light upon holiday rentals and Arlington Heights United States condo rentals.
Discern and discover rent houses in Tazewell and holiday rentals in Tazewell Illinois.
Distinguish, elicit, and light upon Clark holiday rentals, Clark rental home, and vacation rentals in Clark Illinois.
Contrive, conceive, and originate rent houses in Leonore United States, vacation rentals Leonore United States, and Leonore United States vacation homes.
Record, interest, gather, and take on now to get cracking and launch on this migration.
Companions and tourists search for , cast about, and grub our page and light upon oceanfront chalet, log hacienda, and mountain flat.
Join our beachfront listed properties, rustic directories, lakeside lists of marked properties, and loft listings mailing list for vacation rental, condos for rent, and rental home Flagg.
Elicit and relocate condo rentals in Solon Mills and Solon Mills United States rental home.
Send sublime, graceful, and gorgeous dope regarding homes for rent by owner in Flagg and condos for rent in Flagg Illinois found on this site, FRBO.com.
|
|
