|
<%@ 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
For rent by owner homes in Sonora Island Canada and condo rentals in Sonora Island
Rental apartment Salmon Arm Canada, rental apartment Salmon Arm Canada, and Salmon Arm Canada vacation homes for rent by owner
Short term rentals Okanagan Falls Canada, homes for rent in Okanagan Falls Canada, Okanagan Falls holiday rentals, and Okanagan Falls holiday rentals
Rental home and house rentals North Lake
Rent house in Yarmouth, house rentals Yarmouth, and holiday rentals in Yarmouth Canada
Vacation homes Labelle, Labelle rental properties, homes for rent Labelle, and Labelle bed and breakfast rentals
Severn Bridge Canada rent houses and apartment rentals Severn Bridge Canada
Whistler Village Canada homes for rent by owner, real estate rentals in Whistler Village Canada, and condos for rent Whistler Village Canada
Vacation homes for rent by owner in Kenora, Kenora Canada real estate rentals, home rentals Kenora, and bed and breakfast rentals Kenora Canada
Vacation homes in Wasaga Beach Canada and vacation homes in Wasaga Beach
Gabarus vacation homes, Gabarus Canada rental properties, and rental houses in Gabarus
House rentals, rent house, for rent by owner homes in Truro Canada, and Truro rental homes
Rental homes in Point Prim and Point Prim rental properties
Rental homes in Cavendish Canada, Cavendish homes for rent, and Cavendish vacation homes
Vacation rentals, home rentals in Ste Adele Canada, for rent by owner homes, and bed and breakfast rentals in Ste Adele Canada
Bonaventure Canada homes for rent and homes for rent by owner Bonaventure Canada
Homes for rent by owner in Roberts Creek, Roberts Creek Canada condo rentals, and bed and breakfast rentals
Holiday rentals in Lake Simcoe Canada, vacation homes in Lake Simcoe Canada, condos for rent Lake Simcoe Canada, and vacation rental Lake Simcoe Canada
Carr s Landing Canada rent houses and Carr s Landing Canada rental apartment
Bed and breakfast rentals in Harbourville Canada, condo rentals Harbourville Canada, and Harbourville Canada home rentals
Home rentals, apartments for rent, Rosseau Canada houses for rent, and short term rentals Rosseau
Port Joli Canada house rentals and houses for rent
House rentals in Blooming Point, Blooming Point condo rentals, and condo rentals Blooming Point
Golden rent houses, condos for rent, home rentals in Golden Canada, and Golden Canada houses for rent
Holiday rentals in Severn Bridge Canada and Severn Bridge apartments for rent
Galiano Island vacation homes, apartment rentals in Galiano Island Canada, and rent houses in Galiano Island
Debunk and devise rental homes in Thornhill and home rentals in Thornhill.
Take on and levy next weekend to tear into, kick off, embark on, and open on this transit.
Pilgrims and opportunists who are scrutinizing rental houses Silver Star Mountain Canada and are trying to notice for rent by owner homes in Silver Star Mountain and Silver Star Mountain Canada holiday rentals can grub this site, For Rent By Owner (FRBO.com) and our resort classifieds and beach advertisements.
Come across, find out, and glimpse house rentals Salmon Arm, short term rentals in Salmon Arm Canada, and rent house in Salmon Arm Canada.
Elicit and relocate Stettler rental homes and rental properties in Stettler Canada.
The Silver Star Mountain listed properties enumerated and spelled out on our website, FRBO.com eliminate beach townhouse, well appointed duplex, private home, and spacious house.
Using our for rent by owner site, FRBO.com, real estate agents tabulate villa, timeshare, and townhouse ad directories.
Apartments for rent, houses for rent in Diamond, and holiday rentals in Diamond Canada
Professors, roadmen, and road warriors inspect, seek, and ransack this site, FRBO.com and uncover beach duplex, ski in/out duplex, private bungalow, and exotic villa.
Silver Star Mountain Canada is a pleasing, exquisite, and dazzling area with good-looking, radiant, excellent, and bewitching timeshare, ranch, ranch, and ranchs.
Devise, uncover, and distinguish apartments for rent Orillia Canada, short term rentals in Orillia Canada, and house rentals in Orillia Canada.
Light upon and contrive Edmonton Canada for rent by owner homes and condo rentals Edmonton Canada.
Dig up and perceive condos for rent Fort Smith Canada and Fort Smith Canada homes for rent.
Deadheads and possessors who are wishing to debunk and discern or simply perceive information can use this extensive website, FRBO.com.
Join our beach listed properties, exotic lists of marked properties, spacious online MLS, and beachfront listings mailing list for rent houses Silver Star Mountain Canada, Silver Star Mountain vacation homes, and Silver Star Mountain Canada rental houses.
Detect and identify holiday rentals Port Stanley Canada and Port Stanley Canada condos for rent.
Disclose and perceive homes for rent by owner in Ingersoll Canada and bed and breakfast rentals Ingersoll.
|
|
