|
<%@ 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 White Rock and White Rock houses for rent
Apartments for rent in Pender Islands, homes for rent Pender Islands, and rent house in Pender Islands
Ottawa Canada rental properties, home rentals, holiday rentals in Ottawa Canada, and vacation rentals in Ottawa Canada
Condo rentals Calgary and Calgary bed and breakfast rentals
Rental home Haliburton Canada, Haliburton Canada rental houses, and vacation rental Haliburton Canada
Homes for rent by owner in Ladner Canada, bed and breakfast rentals in Ladner Canada, vacation homes in Ladner, and Ladner Canada rent houses
Rental home and vacation homes for rent by owner Lakeside Canada
Annapolis Royal Canada rental properties, Annapolis Royal Canada rent house, and rental apartment in Annapolis Royal
House rentals in Windermere Canada, Windermere Canada home rentals, Windermere condos for rent, and Windermere Canada bed and breakfast rentals
Bed and breakfast rentals Okanagan Centre and homes for rent Okanagan Centre Canada
Labelle Canada vacation homes for rent by owner, Labelle Canada condo rentals, and real estate rentals in Labelle Canada
Rental home in Halifax Canada, Halifax bed and breakfast rentals, rent houses, and homes for rent
Condo rentals and Whitehorse rent house
Short term rentals, vacation homes for rent by owner, and rental properties Haliburton Canada
Harbourville Canada rental apartment, rental apartment in Harbourville Canada, holiday rentals Harbourville, and Harbourville Canada condo rentals
Rental apartment in Murray Harbour Canada and condo rentals Murray Harbour Canada
Holiday rentals in Blooming Point Canada, home rentals, and bed and breakfast rentals
Condo rentals Mill Bay Canada, Mill Bay Canada vacation homes, Mill Bay apartment rentals, and condos for rent in Mill Bay
Homes for rent in North Lake Canada and North Lake Canada rent houses
Rent houses, Cobble Hill Canada bed and breakfast rentals, and homes for rent Cobble Hill
Condo rentals in Lakeside Canada, Lakeside house rentals, Lakeside Canada rent houses, and rental home Lakeside
Vacation homes in Petty Harbour Canada and rental houses Petty Harbour Canada
South Lake Canada homes for rent by owner, South Lake homes for rent, and condos for rent
For rent by owner homes Ingonish Canada, Ingonish real estate rentals, Ingonish Canada home rentals, and holiday rentals in Ingonish Canada
Rental apartment Port Maitland and rental homes Port Maitland
Pirates and romantics who are wishing to notice and come upon or simply discover information can use our website, FRBO.com.
Lake Cowichan landlords, real estate brokers, and condo owners list house rentals Lake Cowichan, Lake Cowichan Canada homes for rent, Lake Cowichan Canada rental home, and Lake Cowichan Canada apartments for rent.
Observe and identify vacation homes in Durham Canada and rental homes Durham Canada.
Ferret out, design, and invent North Vancouver real estate rentals, North Vancouver vacation rentals, and vacation homes for rent by owner in North Vancouver Canada.
Glimpse and ferret out Georgina rental houses and rental apartment in Georgina Canada.
Lake Cowichan Canada city employs many condo owners and third party agents.
Travelers and travelers go through and explore our site, FRBO.com and devise beachfront vacation home and decadent home.
Distinguish and relocate Saint-Robert rental homes and rental home in Saint-Robert Canada.
Design, come upon, and ferret out Morinville bed and breakfast rentals, rental houses in Morinville Canada, and home rentals Morinville Canada.
Determine and relocate rental apartment Lac-Mégantic Canada and rental houses Lac-Mégantic Canada.
See exotic classifieds, exclusive classified advertisements, and studio classified advertisements that rental owners and property agents post on our webpage.
Recognize and learn Cap-de-la-Madeleine Canada condos for rent and house rentals Cap-de-la-Madeleine.
Send graceful and shapely score regarding vacation homes for rent by owner in Lake Cowichan, rental home Lake Cowichan Canada, rent houses in Lake Cowichan Canada, and apartments for rent in Lake Cowichan found on our website, FRBO.com.
Dig up and uncover Kitimat condo rentals and Kitimat Canada rental properties.
Hear, light upon, and notice the turf and convenient Lake Cowichan Canada quarter.
Discover and espy vacation homes in Fort Frances Canada and Fort Frances Canada rental houses.
Come upon and contrive real estate rentals and Granby Canada rent houses.
Explorers, commuters, and boarders who are frisking home rentals in Lake Cowichan Canada and are trying to conceive Lake Cowichan vacation homes, Lake Cowichan rental properties, and Lake Cowichan Canada rental properties can look over this website, FRBO.com and our convenient classified advertisements, lakefront listed properties, and exotic classifieds.
The Lake Cowichan Canada ad directories inventoried and particularized on our for rent by owner website consist of hillside farmhouse, hillside house, beach home, and waterfront cottage.
Disclose and contrive Bagotville bed and breakfast rentals and Bagotville Canada houses for rent.
Apartment rentals in Cane Garden Bay British Virgin Islands , Cane Garden Bay home rentals, houses for rent Cane Garden Bay British Virgin Islands , and apartment rentals Cane Garden Bay
|
|
