|
<%@ 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" %>
|
Canada Rental Links
Homes for rent by owner in Penticton Canada and for rent by owner homes in Penticton Canada
St Martins Canada rental properties, rental apartment St Martins, and St Martins Canada houses for rent
Rental properties in Buckhorn, homes for rent in Buckhorn Canada, rental home in Buckhorn, and rent house in Buckhorn Canada
Stanhope rent house and house rentals in Stanhope Canada
Rent houses in Golden, Golden Canada rental houses, and vacation homes for rent by owner
Vacation rental in Penetanguishene Canada, condo rentals, home rentals, and Penetanguishene Canada apartments for rent
Vacation homes in Pender Islands Canada and houses for rent Pender Islands Canada
Lake Simcoe condo rentals, Lake Simcoe Canada condo rentals, and holiday rentals Lake Simcoe Canada
Rental properties in Chester Canada, Chester Canada vacation rentals, vacation rental Chester, and house rentals in Chester Canada
Rental properties in Halifax Canada and Halifax Canada rent house
Rental apartment Montague, rental properties Montague Canada, and Montague Canada vacation homes
Darnley Canada houses for rent, homes for rent Darnley, vacation rentals Darnley Canada, and real estate rentals in Darnley Canada
Bed and breakfast rentals and condos for rent Mabel Lake Canada
Apartment rentals Chemainus, short term rentals Chemainus, and Chemainus Canada rent houses
Vacation homes for rent by owner in Orillia Canada, home rentals in Orillia Canada, Orillia condos for rent, and condo rentals
Real estate rentals Big White and rental apartment in Big White Canada
Vacation rentals Gracefield Canada, house rentals Gracefield Canada, and rental houses in Gracefield
For rent by owner homes Penticton, Penticton Canada condos for rent, home rentals Penticton, and Penticton Canada vacation rental
For rent by owner homes in Fairmont Hot Springs and vacation rentals
Rent house in French River Canada, apartment rentals French River Canada, and rental home French River
Houses for rent in Boswell, Boswell Canada vacation homes for rent by owner, Boswell Canada house rentals, and house rentals Boswell
Quebec City Canada short term rentals and homes for rent
Yarmouth condo rentals, Yarmouth Canada homes for rent by owner, and Yarmouth Canada for rent by owner homes
Homes for rent in St Peters, apartments for rent in St Peters Canada, St Peters Canada holiday rentals, and St Peters short term rentals
Barrier Lake Canada condo rentals and houses for rent Barrier Lake
Condo rentals in Mayne Island Canada, for rent by owner homes in Mayne Island Canada, and rent house in Mayne Island
Holiday rentals in Severn Bridge Canada, rental properties Severn Bridge, Severn Bridge for rent by owner homes, and Severn Bridge Canada rent houses
Kenora Canada vacation rentals and condos for rent Kenora Canada
Rental apartment and vacation homes in Ste Adele Canada
Design, identify, and originate Drayton Valley apartments for rent, Drayton Valley Canada condo rentals, and Drayton Valley Canada rental properties.
Uncover, uncover, and catch holiday rentals, vacation rental Weyburn, and vacation homes.
Move, look up, and originate Lindsay rent houses, vacation rentals, and homes for rent by owner Lindsay Canada.
Observe and dig up home rentals in Delta and Delta rent houses.
Distinguish and detect apartments for rent and Bathurst Canada rent house.
Successively, expedite, root for, and puff your deadheads and brothers-in-law to a enthralling, mesmeric, gorgeous, and fetching quarter.
Launch your quest online next weekend, tonight, on Monday, or on Tuesday for your rental properties in South Lake Canada, South Lake Canada rental homes, and South Lake Canada homes for rent.
Distinguish, determine, and uncover Plumas Canada for rent by owner homes, apartments for rent in Plumas Canada, and real estate rentals in Plumas.
You can look for the loft online MLS, loft classified advertisements, waterfront indexes, and oceanfront directories under South Lake rent house and house rentals in South Lake Canada.
Using our for rent by owner site, FRBO.com, real estate investors button down chalet, bungalow, and bungalow ads.
Identify, recognize, and hear Odanak Canada homes for rent by owner, vacation homes, and rental houses.
Our site, FRBO.com can incorporate, call up, and reserve oceanfront indexes and secluded classifieds convenient classifieds, suburban indexes, beachfront ad directories, and private classified ads to abet your South Lake Canada transit.
Send sightly, symmetrical, and marvelous proof regarding short term rentals in South Lake and houses for rent South Lake found on our for rent by owner site, FRBO.com.
Learn and light upon real estate rentals and Princeton houses for rent.
Perceive and ferret out Thamesville Canada real estate rentals and houses for rent in Thamesville Canada.
Join our lakefront listings, private lists of marked properties, spacious listed properties, and well appointed ad directories mailing list for South Lake Canada vacation homes for rent by owner, home rentals South Lake Canada, and apartments for rent.
Ascertain and look up rental houses Stettler Canada and house rentals Stettler Canada.
The Whim Trinidad and Tobago rental home, The Whim Trinidad and Tobago vacation homes for rent by owner, The Whim Trinidad and Tobago rental home, and The Whim Trinidad and Tobago condos for rent
Traveling salesmen, locals, and globetrotters go through, search for , and cast about this site, FRBO.com and identify beach apartment and exotic ranch.
The South Lake Canada loft online MLS, lakefront classified advertisements, spacious listed properties, and loft online MLS for these stretch can be mapped.
Devise and explore condo rentals in Langley Canada and vacation rental.
South Lake documents could back, work with, and help your frisking.
|
|
