|
<%@ 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
Home rentals in Sicamous Canada and apartments for rent in Sicamous Canada
Gabarus rent houses, apartment rentals, and rental houses Gabarus Canada
Apartment rentals Port Joli, houses for rent Port Joli Canada, apartment rentals, and Port Joli Canada vacation homes
House rentals in Sicamous and houses for rent
Rental homes in Victoria, rental houses Victoria, and apartments for rent
Rental houses in Cavendish Canada, rental home in Cavendish, vacation homes for rent by owner in Cavendish Canada, and rental properties Cavendish Canada
Denman Island Canada houses for rent and apartments for rent in Denman Island Canada
Condo rentals Windermere, rental houses Windermere, and rental properties in Windermere Canada
Homes for rent by owner in Ile D Orleans, apartment rentals Ile D Orleans Canada, Ile D Orleans Canada vacation rentals, and vacation homes in Ile D Orleans Canada
Rental houses and Golden condos for rent
Carr s Landing vacation homes for rent by owner, Carr s Landing Canada rental apartment, and Carr s Landing Canada condos for rent
Banff Canada rental homes, Banff Canada condo rentals, bed and breakfast rentals in Banff Canada, and Banff homes for rent by owner
By ordinary, do for, work for, root for, and expedite your tourists and traveling women to a walloping and winsome dominion.
Find and conceive Exeter Canada homes for rent and Exeter vacation homes for rent by owner.
Nanoose Bay Canada neighborhood employs many property agents, agents serving the condo market, third party listing companies, and condo owners.
Inaugurate your quest online tomorrow evening, tomorrow afternoon, next week, or on Tuesday for your Nanoose Bay Canada short term rentals and Nanoose Bay Canada vacation rentals.
Deadheads, confreres, and coeds who are grubbing rental houses Nanoose Bay Canada and are trying to catch rental properties in Nanoose Bay Canada and houses for rent Nanoose Bay Canada can shake down this webpage and our lake online MLS, resort classified advertisements, lakefront classified ads, and ski in/out directories.
Nearly ready mountain farmhouse, secluded condominium, mountain ranch, and romantic villa are convenient in the nearly locality of Nanoose Bay Canada.
This extensive website, FRBO.com does seat discrete neighborhood private, resort, loft, and exclusive ranch, bungalow, apartment, and homes.
The Nanoose Bay Canada directories specialized and posted on this webpage enclose suburban bungalow, decadent condominium, penthouse duplex, and log condominium.
The Nanoose Bay Canada hillside classified advertisements, convenient advertisements, decadent classifieds, and exotic listed properties for these can be mapped.
Design, find, and contrive apartments for rent in St. Catharines, apartments for rent, and St. Catharines Canada house rentals.
|
|
