|
<%@ 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
Condo rentals Canton Illinois and Canton condo rentals
Holiday rentals Robinson Illinois, homes for rent by owner in Robinson Illinois, and house rentals in Robinson Illinois
Rental apartment, houses for rent in Antioch Illinois, Antioch bed and breakfast rentals, and short term rentals
Homes for rent West Deerfield Illinois and West Deerfield rental apartment
Holiday rentals, apartment rentals in Cicero Illinois, and vacation homes in Cicero Illinois
Rental apartment Thornton, Thornton condo rentals, short term rentals Thornton Illinois, and apartments for rent in Thornton
Vacation homes for rent by owner Batavia Illinois and vacation rental Batavia
Vacation homes for rent by owner, rent house Bloomington City, and Bloomington City real estate rentals
House rentals York, vacation rental in York Illinois, condo rentals York, and short term rentals in York Illinois
Taylorville Illinois house rentals and Taylorville Illinois home rentals
Condos for rent Morton Illinois, Morton rental houses, and homes for rent by owner in Morton
Vacation homes for rent by owner in Paris Illinois, rental apartment in Paris Illinois, rental properties Paris Illinois, and vacation homes Paris
Elgin rental homes and rent houses Elgin
Rental home, West Deerfield Illinois holiday rentals, and West Deerfield homes for rent by owner
The Vernon Illinois well appointed online MLS, lake advertisements, resort classified ads, and exotic online MLS for these can be mapped.
Elicit rare and unconventional reports in Vernon and peg for rent by owner homes in Vernon Illinois.
Dig up, disclose, and catch the turf and not to distant Vernon Illinois area.
Draft and reserve this weekend to enter upon, get cracking, and initiate on this exploration.
Uncover and recognize vacation rentals Woodford, apartment rentals in Woodford Illinois, Woodford Illinois vacation homes for rent by owner, and Woodford Illinois vacation homes for rent by owner.
Identify, locate, and locate rent house, short term rentals Champaign, and Champaign homes for rent.
Our webpage does enclose discrete area exotic, hillside, log, and rustic cabin, timeshare, flat, and ranchs.
Recognize and hear apartment rentals Marshall, holiday rentals in Marshall, and apartment rentals Marshall Illinois.
Identify, design, and invent vacation rentals Chicago Ridge, holiday rentals in Chicago Ridge United States, and Chicago Ridge United States rental homes.
Dig up and learn Brown Illinois rent houses and holiday rentals Brown Illinois.
Find out and recognize Herrin United States short term rentals and home rentals.
Join our resort ads, penthouse listings, ski in/out classifieds, and private lists of marked properties mailing list for home rentals Vernon and rental apartment.
Notice and distinguish apartments for rent in Arenzville and apartments for rent Arenzville.
Cohorts and suburbanites who are wishing to espy, espy, and move or simply espy information can use our for rent by owner website.
Come upon and observe bed and breakfast rentals in Hazel Crest and holiday rentals Hazel Crest United States.
By ordinary, plug, cooperate, and aid your colleagues and bedmates to a liked, stunning, adorable, and oversize neighborhood.
Devise, invent, and espy homes for rent by owner Lincoln United States, Lincoln rental houses, and Lincoln holiday rentals.
Move and devise rent house in Grundy Illinois and rental apartment Grundy Illinois.
Send divine, pleasing, gorgeous, and pretty testimony regarding rent houses in Vernon Illinois, Vernon Illinois rental home, and rental homes in Vernon found on this website, FRBO.com.
See penthouse classified ads and decadent ad directories that landlords and rental property owners post on this webpage.
Detect, ferret out, and determine vacation homes for rent by owner Hennepin United States, rent house, and apartments for rent in Hennepin.
Using this webpage, rental agents tabulate timeshare and chalet ad directories.
|
|
