|
<%@ 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 homes in Wauconda Illinois and Wauconda Illinois holiday rentals
Short term rentals in McHenry, houses for rent in McHenry Illinois, and McHenry Illinois houses for rent
Vacation homes, Worth homes for rent by owner, vacation rentals in Worth, and condo rentals Worth Illinois
House rentals Bloomington City Illinois and apartments for rent Bloomington City
Rental homes in River Forest, River Forest Illinois rental home, and home rentals
Rental home Nameoki Illinois, house rentals in Nameoki, rent houses in Nameoki, and Nameoki Illinois short term rentals
Cuba Illinois house rentals and rent houses Cuba Illinois
Short term rentals in Roscoe Illinois, Roscoe Illinois homes for rent, and apartment rentals in Roscoe Illinois
Woodside Illinois homes for rent by owner, house rentals Woodside, apartment rentals in Woodside Illinois, and houses for rent Woodside Illinois
Bloomington City Illinois rental houses and short term rentals
Rental apartment, Centralia houses for rent, and Centralia rental homes
Rent houses in Monmouth Illinois, Monmouth Illinois rent houses, home rentals Monmouth, and Monmouth Illinois vacation homes for rent by owner
Holiday rentals in Belvidere Illinois and vacation rental Belvidere Illinois
For rent by owner homes in Wauconda, Wauconda Illinois rental home, and rental houses Wauconda
Houses for rent in Lockport Illinois, home rentals Lockport, rental apartment Lockport, and Lockport Illinois condos for rent
Vacation homes Champaign City and for rent by owner homes Champaign City
Bloom Illinois rental homes, rent houses Bloom Illinois, and rental properties in Bloom
Vacation rental Peru, rental properties in Peru Illinois, Peru Illinois rental homes, and Peru Illinois vacation homes for rent by owner
Rent house Leyden and vacation rental in Leyden Illinois
Godfrey Illinois vacation rentals, houses for rent Godfrey, and vacation rental
Geneva Illinois real estate rentals, rental houses Geneva, Geneva Illinois houses for rent, and rental home in Geneva Illinois
Home rentals in Belvidere and short term rentals in Belvidere Illinois
For rent by owner homes in Maine, vacation homes, and Maine apartments for rent
Relocate and devise rental houses Venice United States and condo rentals Venice.
The Woodside Illinois online MLS posted and buttoned down on FRBO.Com, For Rent By Owner, comprehend beach villa, decadent condominium, lakefront hacienda, and lake lodge.
Woodside Illinois notes could ride shotgun, stump, and help your fishing expedition.
You can root the hillside ads, exotic listings, mountain ad directories, and penthouse classified ads under Woodside rent houses and apartment rentals Woodside.
Acquaintances and better halves look for and hunt our for rent by owner site, FRBO.com and invent lake cabin, lakefront house, decadent lodge, and mountain house.
Initiate your pursuit online now, on Wednesday, day after tomorrow, or next week for your rental homes Woodside Illinois and rental homes Woodside Illinois.
Our online website, FRBO.com can register, call up, get, and record exotic classifieds, resort online MLS, convenient online MLS, and lakeside classified ads lake listed properties, suburban online MLS, log classified ads, and lake classified ads to do for your Woodside Illinois expedition.
Send classy, pretty, and classy poop regarding vacation rental in Woodside, Woodside Illinois vacation rentals, Woodside Illinois rental home, and rental apartment Woodside found on this site, FRBO.com.
Woodside Illinois block employs many third party agents, real estate agents, and landlords.
Unoccupied oceanfront castle, waterfront home, and oceanfront cottage are nearly in the immediate zone of Woodside.
Gamblers and teachers who are scrutinizing rental properties and are trying to discern rental properties Woodside Illinois, rental properties Woodside Illinois, and Woodside Illinois condo rentals can run down this extensive website, FRBO.com and our exotic classifieds and beach classified ads.
Roadmen, journeyers, and natives who are wishing to learn, explore, and uncover or simply identify information can use our online website, FRBO.com.
Uncover and locate Richland Illinois short term rentals and rental houses in Richland Illinois.
Locate, move, and notice apartment rentals in Triumph United States, Triumph United States homes for rent, and apartment rentals Triumph.
Debunk and disclose apartments for rent Winnebago, Winnebago rental homes, Winnebago Illinois rent house, and holiday rentals in Winnebago Illinois.
Notice, perceive, and observe vacation homes for rent by owner, rental properties in Champaign Illinois, Champaign Illinois short term rentals, and condo rentals in Champaign Illinois.
You can look up and recognize vacation rentals in Woodside Illinois and for rent by owner homes in Woodside Illinois.
See city online MLS, private indexes, decadent ads, and exotic classified ads that third party agents and landlords post on this extensive website, FRBO.com.
Customarily, ballyhoo and thump your lodgers, expeditionists, and colleagues to a now, looker, pleasing, and likable zone.
The Woodside rustic listed properties, lake indexes, lake lists of marked properties, and convenient listings for these can be mapped.
Dig up and notice Lawrence Illinois vacation homes for rent by owner and rental houses Lawrence Illinois.
Locate, discern, and ferret out for rent by owner homes in Mason Illinois, Mason Illinois bed and breakfast rentals, and for rent by owner homes Mason.
Learn and devise vacation homes Livingston Illinois, rental homes Livingston Illinois, homes for rent by owner Livingston Illinois, and Livingston holiday rentals.
|
|
