|
<%@ 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
Shelburne Canada homes for rent and rental home in Shelburne Canada
Houses for rent, holiday rentals Quebec City, and Quebec City Canada for rent by owner homes
Roblin condos for rent, houses for rent Roblin, Roblin Canada apartment rentals, and houses for rent Roblin
Vacation homes for rent by owner Shawnigan Lake and Shawnigan Lake Canada homes for rent
Holiday rentals in Boswell Canada, vacation homes in Boswell Canada, and Boswell Canada rent houses
Rent house in Banff Canada, Banff Canada vacation homes for rent by owner, short term rentals Banff, and Banff rental houses
Homes for rent by owner in Halfmoon Bay Canada and home rentals Halfmoon Bay
Apartments for rent in Blooming Point Canada, homes for rent by owner in Blooming Point Canada, and condo rentals in Blooming Point Canada
Murray Harbour Canada homes for rent by owner, Murray Harbour Canada homes for rent, Murray Harbour Canada house rentals, and Murray Harbour Canada apartment rentals
Canmore short term rentals and rental houses in Canmore Canada
Real estate rentals Lac-Superior Canada, Lac-Superior vacation homes, and Lac-Superior for rent by owner homes
Vacation rental in Port Maitland Canada, rent house Port Maitland Canada, Port Maitland vacation rentals, and Port Maitland Canada holiday rentals
Vacation homes for rent by owner Port Moody and Port Moody Canada rental apartment
Egmont Canada bed and breakfast rentals, Egmont Canada short term rentals, and Egmont Canada rental apartment
Condo rentals in Pitt Meadows Canada, vacation rental, Pitt Meadows Canada short term rentals, and vacation rental in Pitt Meadows Canada
Rent houses Nanaimo and home rentals in Nanaimo
Thunder Bay Canada for rent by owner homes, Thunder Bay rental home, and holiday rentals in Thunder Bay Canada
Short term rentals in Labelle, apartments for rent in Labelle, holiday rentals Labelle Canada, and Labelle bed and breakfast rentals
Vacation homes for rent by owner in Richmond Canada and vacation homes Richmond Canada
Thunder Bay Canada condos for rent, rental home in Thunder Bay, and short term rentals Thunder Bay Canada
Yarmouth Canada homes for rent, for rent by owner homes, apartments for rent Yarmouth, and Yarmouth rental houses
Rental apartment in Naramata Canada and short term rentals
Peterborough apartment rentals, vacation rentals Peterborough Canada, and homes for rent by owner Peterborough
Rental properties Mayne Island Canada, Mayne Island Canada rent house, Mayne Island Canada houses for rent, and Mayne Island Canada vacation rentals
Rental properties in Charlottetown Canada and rental houses in Charlottetown Canada
Homes for rent Panorama Canada, holiday rentals in Panorama, and Panorama Canada houses for rent
Greenfield homes for rent, short term rentals in Greenfield Canada, apartments for rent Greenfield Canada, and houses for rent Greenfield Canada
Rental apartment, house rentals, Severn Bridge holiday rentals, and Severn Bridge Canada rental homes
Identify and perceive rental apartment Chilliwack Canada and for rent by owner homes Chilliwack.
Find, relocate, and discover home rentals Bracebridge, Bracebridge Canada rent houses, and Bracebridge homes for rent by owner.
We reared and formulated our site, FRBO.com to be fine and sublime.
Determine and light upon short term rentals in Mission and house rentals Mission.
Using FRBO.Com, For Rent By Owner,, home owners peg condominium, duplex, farmhouse, and hacienda ad directories.
Ascertain, notice, and devise the vicinity and not far away Qualicum Beach Canada sector.
Identify, devise, and locate condos for rent Saint-Hubert Canada, Saint-Hubert Canada rental houses, and Saint-Hubert Canada for rent by owner homes.
See well appointed directories, beach directories, and hillside directories that real estate agents and town home owners post on this site, For Rent By Owner (FRBO.com).
Ferret out and move houses for rent Portuguese Cove and rental properties Portuguese Cove Canada.
Come across and discern Golden Canada rent house and rental properties.
Glimpse and come across houses for rent in Etobicoke and rental apartment Etobicoke Canada.
Dig up and ascertain short term rentals in Toronto Canada and Toronto Canada holiday rentals.
Our for rent by owner website accommodates parcel and block measurements, regularly.
Come across, find, and look up apartments for rent, Quebec condo rentals, and Quebec short term rentals.
Come upon and come upon Inuvik condos for rent and homes for rent.
Glimpse and find out condo rentals in Longueuil and Longueuil vacation rental.
Rental home in Monte Santo Hills and apartments for rent in Monte Santo Hills
You can inspect the ski in/out listings, ski in/out online MLS, beach lists of marked properties, and secluded classifieds under short term rentals and vacation homes for rent by owner.
Vacation rentals, real estate rentals in Punta Gorda, bed and breakfast rentals, and rent houses in Punta Gorda Belize
Our website, FRBO.com does encompass particular turf well appointed, beach, convenient, and log ranch, hacienda, duplex, and condominiums.
Send handsome, sublime, nice, and fair input regarding rental homes in Qualicum Beach Canada, Qualicum Beach Canada house rentals, and house rentals in Qualicum Beach found on this extensive website, FRBO.com.
Discern, devise, and move rental apartment, rent houses in White Rock Canada, and for rent by owner homes in White Rock Canada.
Dig up and devise holiday rentals in White Rock Canada and White Rock Canada rental properties.
Vacated beach duplex, studio townhouse, mountain hacienda, and hillside vacation home are nearest in the contiguous tract of Qualicum Beach Canada.
Espy, find, and contrive Edson Canada homes for rent by owner, Edson rental home, and rental home Edson Canada.
|
|
