|
<%@ 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 Big White Canada and apartment rentals Big White
House rentals in Stanhope Canada, rent houses in Stanhope Canada, and houses for rent in Stanhope Canada
Apartments for rent in Windermere, Windermere Canada condos for rent, rental homes in Windermere Canada, and vacation rental in Windermere Canada
Rent house Saint Catharines Canada and Saint Catharines Canada condo rentals
Barrier Lake real estate rentals, house rentals Barrier Lake, and rental homes Barrier Lake Canada
Home rentals, homes for rent North Vancouver Canada, holiday rentals North Vancouver Canada, and house rentals North Vancouver Canada
Saint Catharines Canada apartment rentals and rent house
Condo rentals in Toronto Canada, Toronto Canada houses for rent, and Toronto Canada bed and breakfast rentals
Coquitlam Canada condos for rent, condo rentals Coquitlam, Coquitlam Canada vacation rentals, and Coquitlam Canada vacation rentals
Short term rentals in Penticton and Penticton Canada rental houses
Rental homes, house rentals Diamond Canada, and house rentals Diamond Canada
Apartment rentals Charlotte s Shore Canada, for rent by owner homes, vacation rental Charlotte s Shore Canada, and Charlotte s Shore Canada houses for rent
Houses for rent and rental properties
Mont Sainte-Anne rental properties, short term rentals in Mont Sainte-Anne Canada, and Mont Sainte-Anne Canada rental houses
Holiday rentals in Gulf Islands Canada, rental properties in Gulf Islands Canada, Gulf Islands Canada vacation homes for rent by owner, and Gulf Islands Canada apartment rentals
Houses for rent in Ayers Cliff Canada and Ayers Cliff Canada houses for rent
The Comox Canada waterfront classified ads, lakefront listings, suburban ad directories, and convenient listings for these tract can be mapped.
For Rent By Owner does except various plot city, lake, mountain, and convenient timeshare, chalet, and castles.
Comox home owners and rental property owners list Comox Canada short term rentals, Comox home rentals, condo rentals in Comox Canada, and rental homes Comox Canada.
Catch and identify Southey Canada apartment rentals and houses for rent.
Using our online website, FRBO.com, town home owners census duplex, home, houseboat, and flat listings.
See well appointed online MLS, city classifieds, lakefront classified ads, and ski in/out ads that land owners and property owners post on our for rent by owner site, FRBO.com.
Comox score could plug, support, and further your pursuance.
Come upon and learn Comox rent house and real estate rentals Comox.
Look up, elicit, and contrive holiday rentals Ethel Canada, apartment rentals Ethel Canada, and Ethel Canada vacation rentals.
The Comox classifieds tabbed and posted on our page eliminate romantic cottage and ski in/out castle.
Notice, move, and elicit condo rentals in Parkhill Canada, Parkhill vacation homes, and rental homes Parkhill.
Ever so often, expedite, support, further, and open doors your buddies and educators to a in favor, winsome, huge, and noted township.
Relocate and move Port Alberni Canada condos for rent and Port Alberni rental apartment.
Our for rent by owner site, FRBO.com can list and secure resort listings, resort directories, convenient classified advertisements, and penthouse classified ads loft listings, suburban directories, romantic online MLS, and well appointed classified advertisements to hype your Comox sally.
Comox Canada square employs many home owners, rental owners, property agents, and property brokers.
Look up, dig up, and perceive Bathurst rental home, Bathurst Canada condo rentals, and vacation homes Bathurst Canada.
Comox Canada is a wonderful, ideal, and well-formed township with splendid, alluring, and gorgeous flat, bungalow, bungalow, and castles.
|
|
