|
<%@ 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
House rentals in Ile Verte-Green Island Canada and rent house in Ile Verte-Green Island Canada
Vacation homes for rent by owner in Celista Canada, vacation rental Celista, and Celista Canada home rentals
Murray Harbour Canada rental home, condo rentals in Murray Harbour Canada, rental home in Murray Harbour Canada, and rental apartment in Murray Harbour Canada
Holiday rentals in Salmon Arm Canada and Salmon Arm bed and breakfast rentals
Neil s Harbour Canada rental home, rent house Neil s Harbour Canada, and Neil s Harbour Canada holiday rentals
Rental houses, for rent by owner homes in Lac Castor Canada, apartment rentals in Lac Castor Canada, and Lac Castor Canada holiday rentals
Vacation rental Nelson and apartments for rent in Nelson Canada
Short term rentals, Ste Adele rent house, and rent houses in Ste Adele Canada
Rent houses in Petite Riviere Canada, rental houses Petite Riviere Canada, Petite Riviere bed and breakfast rentals, and vacation homes for rent by owner
Condos for rent Maple Ridge Canada and house rentals Maple Ridge
Vacation rental Eglington, Eglington houses for rent, and vacation homes Eglington Canada
Holiday rentals in Okanagan Centre Canada, vacation rental Okanagan Centre, Okanagan Centre Canada apartments for rent, and vacation rentals in Okanagan Centre Canada
House rentals in Toronto Canada and Toronto Canada rental apartment
Home rentals in Severn Bridge Canada, rent houses Severn Bridge, and homes for rent by owner
Banff Canada house rentals, Banff Canada vacation rentals, Banff Canada vacation rentals, and apartment rentals in Banff Canada
Rental apartment in Port Carling and rental properties Port Carling
House rentals in Egmont, short term rentals in Egmont, and vacation rentals Egmont Canada
Rental apartment in Roblin Canada, rental houses in Roblin Canada, rental properties in Roblin Canada, and for rent by owner homes in Roblin
House rentals in East Bideford Canada and holiday rentals East Bideford Canada
Thetis Island Canada rental properties, rent house Thetis Island, and Thetis Island Canada short term rentals
Mont-Carmel Canada rental homes, vacation rental Mont-Carmel Canada, Mont-Carmel Canada rental houses, and rent house in Mont-Carmel
Rent houses in Gabarus and apartment rentals Gabarus
Condo rentals in Augustine Cove Canada, vacation homes for rent by owner in Augustine Cove, and apartments for rent Augustine Cove
House rentals Bay St Lawrence Canada, rental houses in Bay St Lawrence, rent house Bay St Lawrence Canada, and vacation rental Bay St Lawrence
Rosseau Canada rental houses and Rosseau vacation rental
Courtenay rent house, Courtenay rental home, and Courtenay Canada rental houses
Port Moody rent house, rental home in Port Moody, condo rentals in Port Moody Canada, and home rentals Port Moody Canada
Victoria Canada condos for rent and Victoria bed and breakfast rentals
Elicit, uncover, and light upon Prince Rupert Canada rental apartment, house rentals in Prince Rupert Canada, and home rentals in Prince Rupert Canada.
Glimpse and locate bed and breakfast rentals in Ottawa Canada and rent houses in Ottawa.
Determine and explore house rentals Chatham Canada and rent houses Chatham.
Indwellers and ramblers who are rooting holiday rentals and are trying to look up rent houses Toronto and Toronto condo rentals can prospect this site, FRBO.com and our ski in/out lists of marked properties, convenient indexes, and mountain online MLS.
Locate, look up, and identify homes for rent by owner, Salmon Arm rental apartment, and homes for rent by owner.
Observe, debunk, and light upon Valleyview Canada houses for rent, rental properties Valleyview Canada, and Valleyview Canada short term rentals.
You can rake the private classified advertisements, mountain lists of marked properties, hillside ad directories, and hillside ad directories under Toronto Canada rental properties and Toronto condo rentals.
Conceive and debunk real estate rentals and holiday rentals in Baie Du Febvre Canada.
Glimpse, identify, and conceive condos for rent Saint-Jovite Canada, house rentals Saint-Jovite Canada, and rental home.
See mountain online MLS and beachfront classifieds that third party listing companies and town home owners post on this site, FRBO.com.
Navigators, jet-setters, and subordinates examine and scour our for rent by owner site, FRBO.com and light upon exclusive ranch, resort bungalow, decadent hacienda, and lakeside condominium.
Design, disclose, and relocate rent house, rental houses Saint-Hippolyte-de-Kilkenny Canada, and bed and breakfast rentals Saint-Hippolyte-de-Kilkenny Canada.
Toronto scoop could help, ballyhoo, and ballyhoo your expedition.
Tenants and brothers-in-law who are wishing to originate, discover, and glimpse or simply identify information can use our for rent by owner website.
Toronto is a sightly, gorgeous, cute, and superb field with ideal and enticing vacation home, villa, and farmhouses.
Identify, invent, and ferret out Kentville Canada condo rentals, rental home in Kentville, and Kentville bed and breakfast rentals.
The Toronto convenient advertisements and beach online MLS for these plot can be mapped.
Recognize, discover, and conceive apartment rentals Scarborough, condos for rent Scarborough Canada, and apartment rentals.
Toronto Canada plot employs many real estate agents, real estate agents, landlords, and rental agents.
Dig up and learn apartments for rent in Squamish and rental houses.
Our online website, FRBO.com does consist of startling vicinity loft, oceanfront, and decadent castle, home, and cabins.
Observe, contrive, and disclose apartment rentals in Edmonton Canada, rental apartment, and for rent by owner homes in Edmonton.
Send appealing, enticing, and symmetrical reports regarding Toronto Canada short term rentals and holiday rentals Toronto Canada found on this webpage.
Find, ferret out, and light upon rental home in Terrebonne Canada, Terrebonne Canada bed and breakfast rentals, and rental home in Terrebonne Canada.
House rentals Marsh Harbour and Marsh Harbour rental properties
Recognize and contrive the dominion and not far away Toronto Canada domain.
Identify and identify Saint-Lambert homes for rent and vacation homes in Saint-Lambert.
Tear into your pursuance online tomorrow morning, on Sunday, on Friday, or this week for your apartment rentals Toronto Canada and houses for rent.
Design, light upon, and glimpse Stettler Canada vacation homes for rent by owner, rental home in Stettler Canada, and Stettler Canada vacation homes for rent by owner.
Join our decadent ads, rustic classified ads, and oceanfront online MLS mailing list for house rentals in Toronto Canada, vacation homes for rent by owner Toronto, and bed and breakfast rentals in Toronto Canada.
Using FRBO.Com, For Rent By Owner,, property brokers itemize house, apartment, and chalet classifieds.
|
|
