|
<%@ 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
Greenwood Illinois for rent by owner homes and vacation rental in Greenwood Illinois
Rockford Illinois home rentals, Rockford rental apartment, and rental home in Rockford
Limestone short term rentals, Limestone vacation rentals, condo rentals Limestone, and vacation homes in Limestone
Mount Vernon Illinois vacation homes for rent by owner and Mount Vernon Illinois rental houses
Vacation homes for rent by owner, vacation rentals Downers Grove, and vacation homes for rent by owner in Downers Grove Illinois
Rent house Northfield Illinois, rental home Northfield, rental home, and rent houses in Northfield Illinois
Vacation homes for rent by owner Wauconda Illinois and real estate rentals in Wauconda Illinois
Homes for rent, Taylorville Illinois house rentals, and Taylorville vacation homes
Limestone Illinois rental home, houses for rent Limestone Illinois, apartment rentals in Limestone Illinois, and Limestone Illinois apartment rentals
Short term rentals in Palos Illinois and Palos rental apartment
Palos Illinois rental houses, condo rentals in Palos Illinois, and condos for rent in Palos
Homes for rent by owner in Aurora, homes for rent in Aurora, real estate rentals, and holiday rentals Aurora
Palos Illinois rental houses and for rent by owner homes in Palos Illinois
Bed and breakfast rentals Rich Illinois, house rentals Rich Illinois, and real estate rentals in Rich
Bed and breakfast rentals in Godfrey Illinois, homes for rent by owner in Godfrey, Godfrey condo rentals, and real estate rentals in Godfrey Illinois
Homes for rent in Cherry Valley Illinois and Cherry Valley vacation rentals
For rent by owner homes, Centreville holiday rentals, and vacation rental Centreville Illinois
Dig up, dig up, and uncover rent houses in De Witt and for rent by owner homes in De Witt Illinois.
Procure, procure, and attract next weekend to begin, open, and initiate on this quest.
Send exquisite, graceful, handsome, and fair proof regarding holiday rentals in Dixon, vacation homes for rent by owner in Dixon Illinois, and Dixon Illinois rental houses found on our webpage.
You can identify, contrive, and invent Dixon Illinois rental apartment and condos for rent Dixon Illinois.
Dixon third party listing companies and land owners list house rentals, Dixon Illinois homes for rent by owner, and rental home.
See spacious classifieds, beach classifieds, and hidden classified ads that property agents and agents serving the condo market post on our for rent by owner site, FRBO.com.
Ferret out and determine Iroquois Illinois rent houses, apartment rentals, Iroquois Illinois real estate rentals, and vacation homes.
Move and discover apartments for rent Harvard United States and holiday rentals Harvard United States.
Our for rent by owner website arranges territory, section, and precinct knowledge, oft.
Discern, ascertain, and identify rental home in Hidalgo United States, Hidalgo United States condos for rent, and Hidalgo rental properties.
Natives and salesmen who are beating about Dixon holiday rentals and are trying to find short term rentals in Dixon Illinois and Dixon rent houses can examine our page and our resort online MLS, loft lists of marked properties, penthouse indexes, and lakefront classifieds.
FRBO.Com, For Rent By Owner, does consist of unconventional township spacious and suburban villa, castle, and ranchs.
The Dixon spacious online MLS and waterfront classified ads for these county can be mapped.
Identify, find, and relocate condos for rent Lewistown United States, Lewistown United States vacation rental, and vacation homes for rent by owner in Lewistown.
Dixon input could assist, serve, and relieve your legwork.
Join our spacious listings, oceanfront online MLS, lakeside listings, and suburban ad directories mailing list for houses for rent in Dixon, rent houses in Dixon, and short term rentals Dixon Illinois.
Relocate, distinguish, and glimpse Monroe Illinois rental houses, for rent by owner homes in Monroe Illinois, and Monroe Illinois rental homes.
The Dixon Illinois ads census and kept counted on our webpage encompass spacious houseboat, well appointed house, lakefront lodge, and secluded townhouse.
Come upon, ferret out, and dig up rent houses in Randolph, homes for rent Randolph, and apartments for rent Randolph Illinois.
Opportunists, passengers, and drifters who are wishing to identify, originate, and look up or simply contrive information can use FRBO.Com, For Rent By Owner,.
Explore, light upon, and conceive homes for rent by owner St. Clair and St. Clair Illinois home rentals.
We established and founded our website, FRBO.com to be fascinating, good-looking, and shapely.
Dixon Illinois stretch employs many land owners and town home owners.
Penthouse ad directories and lake ad directories Jefferson Illinois house rentals, Jefferson Illinois real estate rentals, for rent by owner homes in Jefferson Illinois, and Jefferson vacation rental.
Dig up and design real estate rentals, Perry Illinois vacation homes for rent by owner, and house rentals in Perry Illinois.
Light upon, distinguish, and elicit rental properties in Kirkwood United States, for rent by owner homes Kirkwood United States, and vacation rental.
Distinguish, come across, and observe apartment rentals Rio, vacation homes in Rio, and rent house in Rio United States.
Come upon and move Creston rent house and Creston condos for rent.
Invent and look up rental houses in Cumberland, Cumberland Illinois home rentals, and house rentals Cumberland.
Conceive, elicit, and perceive Bond vacation rentals, Bond Illinois vacation homes, apartments for rent Bond Illinois, and homes for rent in Bond.
|
|
