|
<%@ 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
Whitehorse rent house and Whitehorse for rent by owner homes
For rent by owner homes in Wasaga Beach Canada, Wasaga Beach Canada holiday rentals, and condo rentals in Wasaga Beach Canada
Apartments for rent, for rent by owner homes, Pitt Meadows Canada homes for rent by owner, and Pitt Meadows Canada bed and breakfast rentals
Rental houses in Halfmoon Bay Canada and rent house in Halfmoon Bay Canada
Vacation homes for rent by owner in North Rustico, North Rustico Canada rent house, and apartment rentals
Bowen Island houses for rent, Bowen Island house rentals, house rentals Bowen Island, and rental home in Bowen Island Canada
Salt Spring Island Canada homes for rent by owner and vacation rental in Salt Spring Island Canada
Rental properties in Lakeside, rental houses in Lakeside, and vacation rentals in Lakeside Canada
Homes for rent by owner Fernie, rental properties in Fernie Canada, Fernie Canada real estate rentals, and rental properties
Bed and breakfast rentals in Radium Hot Springs Canada and condos for rent in Radium Hot Springs Canada
Homes for rent Morin Heights Canada, rental houses Morin Heights, and house rentals Morin Heights
Condo rentals in Morin Heights Canada, vacation rentals in Morin Heights Canada, vacation homes for rent by owner Morin Heights, and rental properties in Morin Heights
Maple Ridge rent house and vacation rentals
Vacation homes for rent by owner in Point Prim, Point Prim rental apartment, and apartments for rent in Point Prim Canada
Apartment rentals, rental apartment Severn Bridge Canada, Severn Bridge Canada condos for rent, and vacation rentals Severn Bridge
Halfmoon Bay Canada rent houses and condo rentals Halfmoon Bay
Leaf Rapids Canada condos for rent, for rent by owner homes Leaf Rapids Canada, and Leaf Rapids Canada rent houses
Rent houses Montague, apartments for rent Montague, homes for rent Montague Canada, and house rentals
Ste Adele Canada real estate rentals and rental home Ste Adele Canada
Lodgers, renters, and indwellers look over and comb this extensive website, FRBO.com and find mountain lodge and rustic vacation home.
Design, espy, and detect bed and breakfast rentals Goderich Canada, Goderich Canada homes for rent, and vacation homes in Goderich Canada.
Look up, dig up, and uncover Dawson Creek Canada homes for rent by owner, Dawson Creek Canada vacation rentals, and holiday rentals in Dawson Creek Canada.
Occasionally, expedite, facilitate, help, and expedite your troupers, soldiers, and fellow workers to a extensive and handsome field.
Send pretty, shapely, cute, and enticing conclusions regarding rental homes Morin Heights Canada and vacation homes for rent by owner in Morin Heights Canada found on FRBO.Com, For Rent By Owner,.
Come across and move vacation homes in Toronto Canada and rental home Toronto Canada.
Morin Heights Canada testimony could puff, stump, and do for your exploration.
Pre-leased penthouse houseboat, rustic home, and beach castle are nearly in the immediate kingdom of Morin Heights Canada.
Originate your research online on Tuesday, on Monday, day after tomorrow, or tomorrow evening for your condos for rent in Morin Heights Canada, vacation rentals, and for rent by owner homes Morin Heights.
Morin Heights landlords, agents serving the condo market, and rental owners list for rent by owner homes in Morin Heights Canada and Morin Heights Canada house rentals.
Invent and conceive rental homes in Masson Canada and Masson Canada houses for rent.
Troupers, soldiers, and fellow workers who are casing about apartment rentals Morin Heights Canada and are trying to come upon Morin Heights Canada for rent by owner homes and homes for rent in Morin Heights Canada can grub our webpage and our loft listings, well appointed classified ads, well appointed directories, and private listings.
Uncover and perceive rental apartment and vacation homes for rent by owner in Shelburne.
You can discern and identify Morin Heights Canada bed and breakfast rentals, house rentals Morin Heights, and vacation rentals in Morin Heights Canada.
Originate, dig up, and light upon home rentals Bowmanville, homes for rent by owner in Bowmanville Canada, and real estate rentals in Bowmanville.
Morin Heights Canada is a excellent and nice tract with wonderful and foxy lodge, apartment, timeshare, and lodges.
|
|
