|
<%@ 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
Rent house in Hubbards Canada and rent houses Hubbards
Port Moody rental houses, rental houses in Port Moody Canada, and apartments for rent in Port Moody
Rental home in Chase, Chase houses for rent, homes for rent in Chase Canada, and short term rentals in Chase Canada
Bed and breakfast rentals in Murray Harbour and vacation rental in Murray Harbour Canada
Vacation rental in Nanaimo Canada, apartment rentals, and vacation homes for rent by owner
Ile D Orleans Canada for rent by owner homes, Ile D Orleans Canada vacation rentals, rent houses in Ile D Orleans, and Ile D Orleans vacation homes
Rent house in Margaretsville Canada and rent house Margaretsville
Margaretsville Canada short term rentals, homes for rent by owner Margaretsville Canada, and Margaretsville vacation homes for rent by owner
Apartments for rent Peggy s Cove Canada, Peggy s Cove vacation homes, rental homes in Peggy s Cove Canada, and vacation homes in Peggy s Cove Canada
Rental houses Round Lake and Round Lake Canada homes for rent by owner
Apartment rentals Lasqueti Island Canada, short term rentals Lasqueti Island, and apartments for rent
Apartments for rent in Fairmont Hot Springs, apartment rentals in Fairmont Hot Springs Canada, house rentals in Fairmont Hot Springs Canada, and rent houses
Apartments for rent in Tyne Valley Canada and Tyne Valley Canada homes for rent by owner
Rental properties in Mill Bay Canada, for rent by owner homes in Mill Bay Canada, and vacation rental Mill Bay Canada
Port Maitland Canada condo rentals, vacation rental in Port Maitland, for rent by owner homes in Port Maitland Canada, and short term rentals
Boswell vacation homes for rent by owner and for rent by owner homes
Kootenay Bay vacation homes, house rentals in Kootenay Bay, and Kootenay Bay Canada rental houses
Holiday rentals, holiday rentals in Sutton Canada, Sutton Canada rental apartment, and Sutton rent house
For rent by owner homes Brigus and apartment rentals in Brigus
Kinmount Canada rent house, apartment rentals Kinmount Canada, and Kinmount rent houses
Rent houses in Coquitlam Canada, Coquitlam Canada rent houses, houses for rent in Coquitlam Canada, and condo rentals in Coquitlam Canada
Yarmouth Canada rental home and Yarmouth Canada condo rentals
Real estate rentals in Carr s Landing, rental home in Carr s Landing Canada, and vacation homes Carr s Landing
Rental homes in Calgary Canada, bed and breakfast rentals Calgary Canada, holiday rentals in Calgary, and for rent by owner homes Calgary
Apartment rentals in Point Prim Canada and Point Prim Canada vacation rental
Rental apartment Mill Bay Canada, rental houses in Mill Bay Canada, and Mill Bay Canada vacation rental
Fairmont Hot Springs Canada vacation rental, rental home in Fairmont Hot Springs Canada, homes for rent in Fairmont Hot Springs, and rental properties in Fairmont Hot Springs Canada
Nelson rental apartment and house rentals in Nelson Canada
Rental apartment, Oliver Canada house rentals, and rental home Oliver Canada
Rental home, rent house Golden Canada, Golden Canada condos for rent, and Golden Canada condos for rent
Rent house in Celista Canada and homes for rent by owner Celista Canada
Bed and breakfast rentals in Ladner Canada, condo rentals Ladner Canada, and real estate rentals in Ladner Canada
Brackley Beach for rent by owner homes and houses for rent
Windermere home owners and property managers list vacation rentals Windermere Canada, condos for rent, bed and breakfast rentals in Windermere Canada, and homes for rent Windermere Canada.
Locate, ascertain, and determine rent house Kemptville, Kemptville Canada condo rentals, and vacation homes for rent by owner.
Induct, get, and call up next week to originate, open, originate, and lead off on this vagrancy.
Come across and look up apartments for rent Trois-Rivières Canada and rental houses in Trois-Rivières.
Originate, uncover, and recognize vacation rental Fort Saskatchewan Canada, rent house Fort Saskatchewan, and short term rentals Fort Saskatchewan.
Design and elicit holiday rentals in Victoria Canada and house rentals Victoria.
Ascertain and identify rental properties and real estate rentals in Powell River.
Rental houses in Escazu Costa Rica, vacation rentals, and houses for rent in Escazu Costa Rica
Ferret out and find real estate rentals in Kitchener Canada and rental homes.
Glimpse, invent, and glimpse home rentals in Cold Lake Canada, apartment rentals, and Cold Lake vacation homes for rent by owner.
You can poke into the waterfront classified advertisements, hillside listed properties, and waterfront directories under rental properties Windermere Canada, vacation rental in Windermere Canada, and Windermere real estate rentals.
You can determine, relocate, and disclose houses for rent Windermere Canada and rental home.
House rentals Bejuco Costa Rica and vacation rental in Bejuco Costa Rica
Find and disclose rental apartment La Crete and La Crete vacation rental.
Rental home in Nelson and real estate rentals
Notice and find out rental houses in Altona and real estate rentals.
Houses for rent Anglemont Canada, house rentals in Anglemont Canada, holiday rentals Anglemont Canada, and vacation homes
Luquillo real estate rentals, vacation homes for rent by owner in Luquillo Puerto Rico, homes for rent Luquillo, and vacation homes in Luquillo Puerto Rico
The Windermere Canada directories booked and specialized on this extensive website, FRBO.com involve private home and beach vacation home.
Espy and ascertain rent house Gatineau Canada and short term rentals in Gatineau Canada.
Contrive, ascertain, and dig up Squamish Canada rental home, Squamish Canada house rentals, and for rent by owner homes Squamish.
Journeyers and sailors probe and rifle through our website, FRBO.com and dig up hillside home and decadent apartment.
|
|
