|
<%@ 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
Bed and breakfast rentals in White Point Canada and White Point Canada rental houses
Rental home Golden, homes for rent in Golden Canada, and rent house
Sechelt for rent by owner homes, Sechelt short term rentals, short term rentals Sechelt Canada, and Sechelt Canada vacation homes
Vacation rentals Chandos Lake and vacation rental in Chandos Lake
Egmont Canada vacation homes, condo rentals in Egmont, and apartment rentals in Egmont Canada
Salt Spring Island Canada vacation homes, Salt Spring Island Canada rental houses, holiday rentals in Salt Spring Island Canada, and apartments for rent in Salt Spring Island Canada
Apartments for rent Canmore and Canmore rent houses
Apartments for rent, homes for rent by owner, and vacation rentals
Rent house, vacation rental Jordan Ferry, rental properties Jordan Ferry Canada, and homes for rent by owner in Jordan Ferry
North Vancouver Canada rent house and vacation homes for rent by owner in North Vancouver
Bed and breakfast rentals Bracebridge, apartments for rent Bracebridge, and Bracebridge Canada real estate rentals
Transmigrants and better halves scan, forage, and ferret FRBO.com and light upon decadent chalet, oceanfront castle, convenient castle, and convenient timeshare.
This webpage excepts county, area, block, and domain dope, spasmodically.
Join our beachfront listed properties, beachfront indexes, waterfront directories, and lakefront online MLS mailing list for houses for rent, North Vancouver Canada apartments for rent, and houses for rent in North Vancouver Canada.
North Vancouver Canada precinct employs many real estate agents, agents, brokers leasing foreclosures, and rental property owners.
You can shake down the mountain lists of marked properties, log ads, mountain ads, and beach lists of marked properties under apartments for rent and rental homes in North Vancouver Canada.
North Vancouver Canada dossier could facilitate, expedite, boost, and puff your expedition.
Ascertain, hear, and learn homes for rent Iroquois Falls, Iroquois Falls Canada rental apartment, and real estate rentals.
The North Vancouver Canada lists of marked properties written down and tabbed on For Rent By Owner exclude decadent townhouse, romantic farmhouse, and beach townhouse.
Conceive and observe Truro Canada homes for rent by owner and Truro apartments for rent.
North Vancouver land owners and property agents list rent house in North Vancouver, North Vancouver Canada condos for rent, and rental houses North Vancouver.
North Vancouver is a sublime, excellent, and exquisite stretch with ravishing and excellent house, house, and castles.
Originate distinct and several notes in North Vancouver and tick off rental houses in North Vancouver Canada.
Disclose and locate vacation rentals in Timmins and Timmins Canada condos for rent.
Move, hear, and conceive real estate rentals Tahsis, rent house in Tahsis Canada, and Tahsis Canada home rentals.
|
|
