|
<%@ 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
Mabel Lake Canada vacation homes and apartment rentals
Holiday rentals in Point Prim, vacation rentals in Point Prim Canada, and Point Prim Canada vacation rental
Vacation rental, home rentals in Port Carling, Port Carling Canada rent houses, and Port Carling apartment rentals
Rental homes West Bay Canada and houses for rent in West Bay
For rent by owner homes in Summerside Canada, rental apartment Summerside Canada, and vacation homes for rent by owner
Homes for rent in Whistler Canada, vacation homes, houses for rent in Whistler, and Whistler homes for rent by owner
Rental properties Brigus and condo rentals Brigus Canada
Port Joli Canada vacation homes for rent by owner, Port Joli Canada rent house, and apartment rentals in Port Joli Canada
Bed and breakfast rentals in Bracebridge, Bracebridge Canada rental properties, condos for rent in Bracebridge Canada, and Bracebridge Canada vacation homes
House rentals in Windermere Canada and vacation rental in Windermere Canada
Colchester Canada homes for rent by owner, apartments for rent, and for rent by owner homes in Colchester Canada
Lakeside rent houses, apartments for rent Lakeside, house rentals, and Lakeside Canada rent houses
Homes for rent by owner in Apex Mountain Canada and Apex Mountain Canada rental home
Apartment rentals in Boswell Canada, houses for rent, and vacation rental Boswell Canada
Vacation homes for rent by owner in Lac-Superior, for rent by owner homes, Lac-Superior rental houses, and vacation homes for rent by owner in Lac-Superior Canada
Homes for rent Kinmount Canada and Kinmount vacation rental
Houses for rent Harbourville, bed and breakfast rentals in Harbourville Canada, and rental apartment in Harbourville Canada
Rent house, vacation rentals in Port Stanton, vacation rentals in Port Stanton, and vacation homes for rent by owner Port Stanton Canada
Rental apartment in Chemong Lake and real estate rentals in Chemong Lake Canada
Rental homes, apartments for rent in Parrsboro Canada, and Parrsboro rental home
Vacation homes for rent by owner in Courtenay Canada, vacation rental Courtenay Canada, Courtenay vacation rentals, and for rent by owner homes Courtenay Canada
The Whistler Canada directories manifested and manifested on this webpage comprehend beach duplex, beach house, beach chalet, and beachfront houseboat.
Troupers, opportunists, and speculators comb and scour this webpage and ascertain loft vacation home, secluded lodge, and romantic cottage.
Detect and devise rental homes and Marathon Canada apartment rentals.
Light upon and ascertain condo rentals in Rexdale and houses for rent in Rexdale.
This webpage does accommodate unique precinct rustic, rustic, lakefront, and resort ranch, vacation home, hacienda, and houseboats.
Using FRBO.com, home owners button down farmhouse and houseboat classified advertisements.
Glimpse and discern rent houses and rental apartment Enderby.
Uncover, glimpse, and dig up Tillsonburg rental homes, rental properties, and vacation homes for rent by owner.
Discern, find out, and originate the principality and not remote Whistler domain.
You can discern and find out short term rentals Whistler and condo rentals Whistler Canada.
Dig up, ferret out, and elicit Nanaimo Canada condo rentals, Nanaimo vacation rentals, and house rentals in Nanaimo.
Whistler is a superb, beauteous, fascinating, and lovely principality with good-looking and resplendent cottage, cottage, farmhouse, and vacation homes.
Get, incorporate, and serve in the morning to inaugurate, open, launch, and take up on this safari.
Whistler town home owners, rental property owners, and rental owners list homes for rent Whistler and rental apartment in Whistler Canada.
Open your pursual online in the next few days, tomorrow, or tomorrow evening for your short term rentals Whistler and real estate rentals in Whistler Canada.
Debunk uncommon, various, distinctive, and several figures in Whistler Canada and specify rental apartment in Whistler Canada.
Join our romantic classified ads, suburban ad directories, decadent directories, and mountain classifieds mailing list for Whistler Canada real estate rentals, condo rentals Whistler Canada, and rent house Whistler.
Our online website, FRBO.com embraces area, neighborhood, tract, and state whole story, very often.
|
|
