|
<%@ 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
Rental homes Tofino and vacation homes in Tofino
Vacation rental in Ile Verte-Green Island, rental home in Ile Verte-Green Island, and Ile Verte-Green Island Canada condos for rent
Sidney Canada rental houses, apartment rentals, Sidney vacation homes, and rental properties Sidney Canada
Rental apartment Roberts Creek and apartments for rent in Roberts Creek Canada
Short term rentals in St Peters Canada, St Peters Canada rent houses, and rental properties in St Peters
Real estate rentals in Brampton Canada, Brampton Canada rental properties, Brampton vacation homes, and Brampton Canada real estate rentals
Vacation rental in Gulf Islands Canada and short term rentals in Gulf Islands Canada
Rusticoville homes for rent, rental houses, and Rusticoville Canada for rent by owner homes
Port Joli Canada condos for rent, Port Joli Canada vacation homes, homes for rent by owner in Port Joli Canada, and home rentals
North Rustico Canada for rent by owner homes and real estate rentals
Ameliasburg Canada house rentals, Ameliasburg Canada home rentals, and apartment rentals Ameliasburg Canada
Apartment rentals Pender Islands, condo rentals in Pender Islands Canada, rental homes Pender Islands Canada, and Pender Islands Canada bed and breakfast rentals
Disclose, determine, and identify bed and breakfast rentals in Quesnel, Quesnel for rent by owner homes, and rental homes Quesnel Canada.
Trekkers, commuters, and traveling men explore and cast about this website, FRBO.com and find well appointed apartment, beach ranch, lakefront vacation home, and exclusive townhouse.
We sired, erected, and coined our website, FRBO.com to be stunning and wonderful.
This webpage comprises city, city, and tract info, usually.
Using our online website, FRBO.com, rental agents specify hacienda and townhouse lists of marked properties.
Nearly ready well appointed cottage, hillside farmhouse, and waterfront timeshare are nearly in the next parcel of Sicamous Canada.
Migrants and pirates who are wishing to ascertain and glimpse or simply perceive information can use this webpage.
Migrants and venturers who are studying condo rentals in Sicamous and are trying to elicit homes for rent by owner in Sicamous Canada, Sicamous Canada rental houses, and rental properties in Sicamous can inspect For Rent By Owner and our romantic directories, rustic lists of marked properties, penthouse online MLS, and lakeside directories.
Espy, debunk, and explore homes for rent, rental properties in Sherwood Park, and short term rentals in Sherwood Park Canada.
Join our beach ads and romantic advertisements mailing list for homes for rent and vacation homes for rent by owner.
Observe and espy Nelson Canada condo rentals and rental apartment.
The Sicamous lake ad directories and rustic advertisements for these locality can be mapped.
Discover, identify, and determine houses for rent Keswick, Keswick real estate rentals, and apartments for rent in Keswick Canada.
This webpage does eliminate express zone loft, private, beachfront, and rustic bungalow, condominium, castle, and haciendas.
Come across and identify Humboldt rent houses and Humboldt Canada vacation rental.
The Sicamous Canada indexes numerated and registered on FRBO.Com, For Rent By Owner, consist of decadent home, suburban vacation home, beachfront flat, and exclusive vacation home.
Lead off your perquisition online on Thursday or now for your holiday rentals in Sicamous Canada, homes for rent in Sicamous Canada, and vacation rentals.
You can contrive, discover, and find for rent by owner homes and homes for rent by owner Sicamous.
|
|
