|
<%@ 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
Holiday rentals in Lac-Superior and vacation homes in Lac-Superior
Vacation homes in Golden Canada, Golden Canada rent houses, and vacation rentals Golden Canada
Rental apartment in Hubbards Canada, rent house Hubbards, rental apartment Hubbards, and Hubbards Canada vacation homes
Apartments for rent and Mont Tremblant rental homes
Homes for rent Orillia Canada, bed and breakfast rentals in Orillia Canada, and rental apartment Orillia
Homes for rent by owner in Lac-Superior, Lac-Superior Canada house rentals, Lac-Superior Canada vacation homes for rent by owner, and vacation rental Lac-Superior
Mont Tremblant Canada for rent by owner homes and short term rentals in Mont Tremblant
Park Corner vacation rental, Park Corner Canada real estate rentals, and real estate rentals Park Corner
Vacation homes Pictou Island Canada, short term rentals in Pictou Island, for rent by owner homes Pictou Island, and rental apartment in Pictou Island Canada
Bed and breakfast rentals in Quebec City Canada and Quebec City Canada homes for rent
Rental houses Peachland, vacation rentals Peachland Canada, and rental apartment Peachland
Vacation rentals Lac Castor Canada, Lac Castor Canada rent houses, vacation rental in Lac Castor, and homes for rent Lac Castor
Home rentals in Whistler Canada and real estate rentals Whistler
Homes for rent by owner in Ladner Canada, Ladner Canada holiday rentals, and home rentals Ladner
Short term rentals Kenora Canada, Kenora Canada holiday rentals, Kenora Canada homes for rent by owner, and homes for rent Kenora Canada
Vancouver rental houses and vacation homes
Rental homes in Piedmont, rent houses Piedmont, and Piedmont Canada rental homes
Condo rentals Rusticoville, house rentals in Rusticoville, Rusticoville Canada home rentals, and condos for rent in Rusticoville
Severn Bridge holiday rentals and rental apartment Severn Bridge
Homes for rent in Sechelt, Sechelt Canada vacation homes, and homes for rent by owner Sechelt Canada
Holiday rentals Stanhope Canada, Stanhope vacation homes for rent by owner, Stanhope rental houses, and condos for rent Stanhope Canada
Apartments for rent Petite Riviere and vacation homes Petite Riviere Canada
Condos for rent Big Tancook Island Canada, Big Tancook Island vacation homes for rent by owner, and Big Tancook Island Canada rental properties
Celista Canada vacation rental, Celista Canada homes for rent by owner, bed and breakfast rentals in Celista Canada, and rental apartment in Celista
Vacation rentals Anglemont and bed and breakfast rentals in Anglemont
Vacation rental in North Rustico Canada, rental homes in North Rustico Canada, and North Rustico vacation rental
Port Alberni vacation rental, homes for rent in Port Alberni Canada, holiday rentals, and rental homes in Port Alberni Canada
Apartment rentals in Galiano Island and homes for rent Galiano Island Canada
Condo rentals in Goose River Canada, home rentals in Goose River, and Goose River Canada home rentals
Calabogie vacation homes for rent by owner, home rentals, condo rentals, and apartment rentals
Vacation homes in Sooke Canada and rental apartment in Sooke Canada
Calgary Canada short term rentals, Calgary Canada homes for rent, and rent houses in Calgary Canada
Get, join, and hitch tomorrow afternoon to originate, tear into, enter upon, and open on this trip.
Tamarind Hill homes for rent by owner, Tamarind Hill bed and breakfast rentals, and vacation homes in Tamarind Hill St Maarten
Discern and debunk the kingdom and impending Whistler Village Canada locality.
Learn and glimpse home rentals in Langley Canada and houses for rent Langley Canada.
Light upon and debunk High Level Canada vacation homes for rent by owner and vacation rentals High Level Canada.
Debunk and come upon Peterborough Canada vacation homes for rent by owner and home rentals in Peterborough Canada.
Distinguish, come across, and contrive vacation homes for rent by owner in Peterborough Canada, house rentals Peterborough, and real estate rentals in Peterborough Canada.
The Whistler Village Canada decadent ads, convenient lists of marked properties, and hillside ads for these vicinity can be mapped.
Condo rentals, apartments for rent Corona Del Mar Mexico, Corona Del Mar Mexico home rentals, and apartments for rent in Corona Del Mar
Perceive and recognize Ingersoll Canada bed and breakfast rentals and Ingersoll Canada for rent by owner homes.
Glimpse and recognize New Westminster Canada vacation homes and condo rentals in New Westminster Canada.
Our online website, FRBO.com haves sector, kingdom, parcel, and plot measurements, intermittently.
Come upon and design vacation rentals Blenheim Canada and condo rentals in Blenheim Canada.
Dig up, debunk, and notice apartments for rent in Quesnel Canada, Quesnel Canada houses for rent, and Quesnel home rentals.
See private advertisements and waterfront advertisements that real estate agents and property owners post on FRBO.Com, For Rent By Owner,.
You can look for the beach ads and mountain indexes under rent houses Whistler Village and Whistler Village condos for rent.
Launch your frisking online in the morning, now, or this week for your for rent by owner homes Whistler Village, Whistler Village Canada vacation rental, and Whistler Village apartment rentals.
Whistler Village block employs many third party agents, land owners, agents, and home owners.
Relocate, glimpse, and determine house rentals Nepean Canada, vacation rentals in Nepean, and Nepean Canada houses for rent.
Vacation homes for rent by owner Cortes Island and short term rentals Cortes Island Canada
The Whistler Village Canada advertisements classified and filed on our site, FRBO.com arrange secluded house, mountain hacienda, convenient vacation home, and private villa.
Possessors, boarders, and jet-setters grub, quest, and forage our page and come across beach apartment, well appointed cottage, well appointed bungalow, and suburban condominium.
Whistler Village agents, brokers leasing foreclosures, home owners, and home owners list Whistler Village Canada apartments for rent, rental homes in Whistler Village, and rental homes in Whistler Village Canada.
For rent by owner homes in Pointe Milou St Barthelemy, Pointe Milou holiday rentals, and vacation rentals in Pointe Milou
Look up, find, and find out Markham Canada rental apartment, apartments for rent Markham Canada, and vacation rentals in Markham Canada.
Detect, distinguish, and elicit rent houses in Terrebonne Canada, rent houses, and real estate rentals in Terrebonne Canada.
Disclose and design Edys Mills Canada rental home and Edys Mills for rent by owner homes.
Uncover, determine, and find out Sudbury for rent by owner homes, Sudbury Canada rent house, and real estate rentals Sudbury.
Notice, ferret out, and disclose house rentals in Terrace Canada, for rent by owner homes in Terrace Canada, and Terrace Canada rental apartment.
Uncover and recognize short term rentals in Standard Canada and vacation rental in Standard Canada.
Find out and conceive Cobble Hill houses for rent and home rentals Cobble Hill Canada.
Rental properties in Halifax and Halifax Canada vacation rental
You can conceive and devise rent houses in Whistler Village Canada and apartment rentals in Whistler Village Canada.
|
|
