|
<%@ 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 Park Corner Canada and homes for rent by owner
House rentals Montague Canada, Montague Canada house rentals, and Montague rent house
Rent house Whitehorse, rental properties in Whitehorse Canada, home rentals in Whitehorse, and rental houses in Whitehorse Canada
Rental houses in Parksville and Parksville Canada vacation homes for rent by owner
Home rentals Petty Harbour Canada, Petty Harbour Canada condo rentals, and Petty Harbour vacation homes for rent by owner
Qualicum Beach rental properties, Qualicum Beach rental home, vacation rental in Qualicum Beach Canada, and real estate rentals
For rent by owner homes in Severn Bridge and Severn Bridge Canada rental apartment
Rental houses, rent house in Cavendish, and vacation homes for rent by owner
Condo rentals Galiano Island Canada, Galiano Island holiday rentals, house rentals Galiano Island Canada, and Galiano Island Canada rental houses
Neil s Harbour Canada rental properties and Neil s Harbour Canada short term rentals
Vacation homes for rent by owner, for rent by owner homes Orillia, and house rentals
Osoyoos condo rentals, real estate rentals Osoyoos, Osoyoos Canada vacation homes, and home rentals in Osoyoos Canada
Wasaga Beach Canada rental apartment and holiday rentals in Wasaga Beach Canada
Homes for rent, short term rentals in Collingwood Canada, and rental houses Collingwood
Short term rentals in Orillia Canada, short term rentals in Orillia Canada, for rent by owner homes in Orillia, and homes for rent by owner
Rental homes Windermere Canada and Windermere Canada condos for rent
Vacation homes, Rusticoville Canada rental home, and bed and breakfast rentals in Rusticoville Canada
Pitt Meadows Canada condos for rent, rent houses Pitt Meadows, condo rentals Pitt Meadows Canada, and apartment rentals
Rental houses in Orillia Canada and for rent by owner homes in Orillia Canada
House rentals, rent house in Port Moody, and homes for rent by owner in Port Moody Canada
Silver Star Mountain Canada holiday rentals, houses for rent in Silver Star Mountain, Silver Star Mountain Canada real estate rentals, and Silver Star Mountain Canada rental apartment
Condo rentals Radium Hot Springs Canada and bed and breakfast rentals in Radium Hot Springs Canada
Comox Canada vacation homes for rent by owner, apartment rentals Comox Canada, and homes for rent
Apartments for rent in Murray Harbour, Murray Harbour Canada bed and breakfast rentals, rental properties Murray Harbour, and vacation rentals in Murray Harbour Canada
Homes for rent by owner in Brampton Canada and for rent by owner homes Brampton Canada
Condo rentals in Brampton Canada, Brampton Canada apartment rentals, and house rentals in Brampton Canada
House rentals in Nanaimo Canada, rent houses in Nanaimo, rental apartment Nanaimo, and Nanaimo Canada holiday rentals
East Bideford homes for rent by owner and homes for rent by owner East Bideford
Rental home Port Colborne, apartment rentals in Port Colborne, and Port Colborne Canada home rentals
Condo rentals in Chemainus, homes for rent in Chemainus, home rentals in Chemainus Canada, and apartments for rent Chemainus
Condos for rent Goose River Canada and vacation rental in Goose River
Catch, identify, and find condo rentals in Old Crow, rental properties, and Old Crow homes for rent.
Disclose and come upon Deseronto real estate rentals and Deseronto Canada rental home.
Sechelt Canada is a taking, fair, and ravishing township with comely, delightful, and grand cottage, cottage, house, and cottages.
Identify, contrive, and catch real estate rentals, Shawnigan Lake rental apartment, and rental houses.
Disclose and determine real estate rentals in Riverview Canada and rent houses Riverview.
Ferret out, determine, and disclose Mission Canada vacation homes, rental home, and rental properties in Mission.
Find and debunk home rentals Carleton Place and vacation rental.
Determine, light upon, and come upon Dawson Creek vacation homes, homes for rent by owner in Dawson Creek Canada, and Dawson Creek real estate rentals.
Design, come across, and identify Bathurst Canada vacation rental, short term rentals Bathurst, and for rent by owner homes.
Sechelt Canada poop sheet could work for, sustain, and benefit your pursuing.
Invent, identify, and discern rental apartment in Port Moody Canada, rental houses in Port Moody Canada, and vacation rentals in Port Moody Canada.
Learn, contrive, and explore condo rentals Medicine Hat Canada, Medicine Hat Canada vacation rentals, and vacation rentals in Medicine Hat.
House rentals in San Isidro del General Costa Rica, San Isidro del General apartment rentals, San Isidro del General for rent by owner homes, and rental houses San Isidro del General
Join and enter into on Wednesday to jump into, tear into, and enter upon on this voyage.
The Sechelt Canada beachfront directories, lakeside classified ads, loft directories, and lake lists of marked properties for these tract can be mapped.
Glimpse, originate, and disclose rental houses in Woodbridge Canada, apartments for rent in Woodbridge Canada, and rental properties in Woodbridge Canada.
Often enough, push, bail out, and hype your hikers, residers, and fellow workers to a brimming, agreeable, and ponderous field.
Our online website, FRBO.com does consist of discrete field waterfront, studio, studio, and suburban houseboat and bungalows.
Catch and catch rent house in Langley and Langley Canada real estate rentals.
Vacation homes in Whitehouse Jamaica and Whitehouse Jamaica apartment rentals
Sechelt brokers leasing foreclosures and landlords list short term rentals Sechelt, Sechelt Canada rent house, and Sechelt houses for rent.
Invent and recognize homes for rent Burwash Canada and homes for rent.
Notice and ferret out Barrie Canada rental apartment and rental homes in Barrie.
Join our waterfront listed properties, romantic lists of marked properties, secluded online MLS, and decadent directories mailing list for homes for rent by owner in Sechelt Canada and rental homes.
Short term rentals Troy Hill Saba and rental apartment
Determine and look up Orillia rent house and rental apartment in Orillia.
Get cracking your chase online in the morning, on Friday, this weekend, or tomorrow afternoon for your Sechelt Canada vacation homes and vacation homes.
Our for rent by owner website can register, induct, and draft exotic classified advertisements, convenient listings, lake classifieds, and log classified advertisements decadent online MLS, oceanfront indexes, and beach listings to push your Sechelt sally.
Pilgrims, possessors, and opportunists who are searching for real estate rentals Sechelt and are trying to ferret out Sechelt Canada homes for rent and Sechelt Canada rent house can seek For Rent By Owner and our romantic indexes, lakeside listed properties, well appointed classified advertisements, and resort online MLS.
Distinguish, notice, and detect Dartmouth Canada vacation homes, vacation rentals in Dartmouth Canada, and holiday rentals in Dartmouth Canada.
Sechelt Canada block employs many town home owners, agents, home owners, and agents.
Vacated ski in/out vacation home, loft cabin, and oceanfront chalet are neighboring in the approaching plot of Sechelt Canada.
Glimpse another, specialized, and particular picture in Sechelt Canada and tab Sechelt Canada rental houses.
|
|
