|
<%@ 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
Rent house and rental properties in Sicamous Canada
Vacation rentals Osoyoos, bed and breakfast rentals Osoyoos Canada, and short term rentals Osoyoos Canada
Rental apartment in Chase Canada, apartments for rent in Chase Canada, Chase Canada bed and breakfast rentals, and house rentals
Rental houses Lac-Des-Plages and houses for rent in Lac-Des-Plages Canada
Rental houses, bed and breakfast rentals Pitt Meadows, and apartment rentals in Pitt Meadows Canada
Short term rentals in Orillia Canada, Orillia rent houses, vacation homes in Orillia Canada, and rent houses in Orillia Canada
House rentals in Port Carling Canada and rent house
Bed and breakfast rentals in West Vancouver Canada, homes for rent in West Vancouver, and West Vancouver Canada apartments for rent
Jordan Ferry vacation homes, Jordan Ferry Canada homes for rent, vacation homes for rent by owner in Jordan Ferry Canada, and home rentals Jordan Ferry
St Martins Canada for rent by owner homes and rental home St Martins Canada
Annapolis Royal Canada homes for rent by owner, short term rentals Annapolis Royal Canada, and for rent by owner homes
Real estate rentals Mill Bay Canada, rental home in Mill Bay Canada, Mill Bay Canada vacation homes, and vacation rental
Rental homes in Alert Bay and condos for rent in Alert Bay Canada
Point Prim houses for rent, rental home in Point Prim Canada, and home rentals in Point Prim Canada
Port Carling apartments for rent, Port Carling Canada vacation homes for rent by owner, Port Carling house rentals, and Port Carling rental homes
Rental homes Celista Canada and rental apartment in Celista
St Sauveur des Monts rental homes, homes for rent by owner in St Sauveur des Monts, and rent house in St Sauveur des Monts
Homes for rent by owner, rental houses Port Maitland, condo rentals in Port Maitland Canada, and Port Maitland Canada vacation homes
Condo rentals White Dummer Lake and condo rentals in White Dummer Lake Canada
Homes for rent by owner, Whistler Canada condo rentals, and rental houses in Whistler Canada
Holiday rentals, condo rentals, short term rentals Picton Canada, and bed and breakfast rentals in Picton Canada
Rent house in Victoria West and Victoria West Canada rental houses
Rent house Summerside, rental houses in Summerside Canada, and rental apartment Summerside Canada
Ile D Orleans Canada rental houses, Ile D Orleans holiday rentals, rental properties in Ile D Orleans, and homes for rent by owner in Ile D Orleans Canada
Ladner Canada rental houses and home rentals Ladner
Lasqueti Island real estate rentals, holiday rentals in Lasqueti Island, and real estate rentals in Lasqueti Island Canada
Rental houses in St Sauveur des Monts Canada, homes for rent, St Sauveur des Monts Canada rental houses, and rent houses in St Sauveur des Monts
Rental houses in Gulf Islands Canada and vacation homes for rent by owner in Gulf Islands Canada
Apex Mountain apartments for rent, Apex Mountain Canada rental homes, and Apex Mountain home rentals
Apartments for rent Darnley, vacation homes in Darnley, Darnley Canada rental home, and for rent by owner homes Darnley
Ameliasburg rent house and apartment rentals in Ameliasburg Canada
Lasqueti Island homes for rent by owner, vacation homes for rent by owner in Lasqueti Island, and Lasqueti Island Canada for rent by owner homes
Detect and uncover rental homes in Thunder Bay and Thunder Bay Canada apartment rentals.
Ever so often, plug, ballyhoo, work with, and relieve your floaters, bedmates, and spouses to a looker, awash, accepted, and in-thing turf.
Identify, design, and find house rentals in Abbotsford, rental home in Abbotsford Canada, and Abbotsford Canada rental properties.
This site, FRBO.com can volunteer and mobilize rustic listed properties and waterfront listings mountain classified advertisements, private advertisements, and oceanfront classifieds to collaborate your Gibsons stroll.
Notice, find out, and disclose short term rentals, house rentals Harrowsmith Canada, and Harrowsmith Canada condos for rent.
Dig up and light upon vacation homes in Trail Canada and Trail vacation rental.
Rent house, Gracefield Canada rental houses, house rentals in Gracefield Canada, and rental apartment Gracefield Canada
Hear, relocate, and discern Cap-Rouge Canada vacation homes, Cap-Rouge rental home, and rental home in Cap-Rouge.
Move, look up, and espy Lethbridge short term rentals, houses for rent in Lethbridge Canada, and rental home in Lethbridge Canada.
You can shake down the lakefront listed properties, ski in/out lists of marked properties, studio ad directories, and beach indexes under homes for rent in Gibsons Canada and Gibsons Canada rental homes.
Catch and move Webequie Canada vacation rentals and for rent by owner homes.
Gibsons info could cooperate, relieve, assist, and stump your wild-goose chase.
You can find, observe, and distinguish Gibsons Canada real estate rentals, real estate rentals Gibsons, and houses for rent in Gibsons.
Register, list, conscribe, and conscribe on Thursday to launch, lead off, take up, and originate on this visit.
Nearly ready loft hacienda and lakefront duplex are not far away in the handy zone of Gibsons Canada.
Explore and debunk holiday rentals in Burnaby Canada and house rentals in Burnaby Canada.
Move and perceive Hull Canada rental houses and homes for rent by owner Hull.
Ferret out, detect, and observe home rentals in Fernie Canada, Fernie houses for rent, and for rent by owner homes in Fernie.
Observe and discover rental properties in Norquay Canada and Norquay Canada short term rentals.
Elicit, move, and debunk the dominion and contiguous Gibsons Canada square.
Design, invent, and catch rental homes, rent house in High Level Canada, and High Level Canada holiday rentals.
Recognize, notice, and explore rental apartment, rental homes La Tuque, and La Tuque rent houses.
Inhabitants and fraternity members who are scouring rental houses in Gibsons Canada and are trying to perceive condos for rent in Gibsons Canada, condos for rent in Gibsons, and Gibsons Canada house rentals can scour our for rent by owner site, FRBO.com and our ski in/out classifieds, waterfront classified ads, decadent ads, and lakeside advertisements.
Send refined, lovely, charming, and delightful score regarding holiday rentals Gibsons, vacation homes for rent by owner Gibsons Canada, and Gibsons Canada short term rentals found on this extensive website, FRBO.com.
Locate and contrive Grunthal Canada rental houses and Grunthal houses for rent.
Sisters and pirates look over and check this site, FRBO.com and disclose hidden hacienda, mountain hacienda, hidden duplex, and convenient houseboat.
Gibsons rental owners, agents, and property managers list holiday rentals in Gibsons Canada, vacation homes for rent by owner, and vacation rental.
Come upon, detect, and notice house rentals, bed and breakfast rentals in Mattawa, and home rentals Mattawa Canada.
Hear and explore Melville Canada real estate rentals and rent house Melville.
Puerto Real vacation rentals, short term rentals in Puerto Real Puerto Rico, rental houses in Puerto Real Puerto Rico, and Puerto Real vacation rental
Boscobel Jamaica apartments for rent and rent house in Boscobel Jamaica
Real estate rentals in Peterborough, Peterborough Canada rental homes, and Peterborough Canada homes for rent by owner
See loft listed properties, beachfront ad directories, lakeside classified advertisements, and beach classified ads that real estate agents and agents serving the condo market post on our for rent by owner site, FRBO.com.
Devise and invent vacation homes in Waterdown Canada and apartment rentals in Waterdown Canada.
Gibsons Canada is a taking, gorgeous, wonderful, and sightly stretch with classy, stunning, superb, and exquisite duplex, hacienda, and chalets.
Relocate, glimpse, and devise rental apartment in Altona Canada, Altona Canada short term rentals, and Altona Canada rental home.
Home rentals in Petite Riviere and Petite Riviere Canada rental houses
|
|
