|
<%@ 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
Vacation rental Port Stanton and Port Stanton Canada apartments for rent
White Rock Canada vacation homes, White Rock Canada real estate rentals, and White Rock rental apartment
Home rentals in Banff, bed and breakfast rentals Banff Canada, apartment rentals Banff, and Banff Canada real estate rentals
Whistler Canada houses for rent and Whistler vacation homes for rent by owner
Homes for rent by owner Sidney, Sidney Canada homes for rent by owner, and Sidney Canada vacation rentals
Musquodoboit Harbour Canada homes for rent, Musquodoboit Harbour Canada houses for rent, Musquodoboit Harbour Canada home rentals, and holiday rentals Musquodoboit Harbour
Shelburne Canada vacation rentals and Shelburne Canada short term rentals
Beach Point Canada homes for rent, apartment rentals Beach Point Canada, and Beach Point Canada homes for rent by owner
Holiday rentals Egmont, bed and breakfast rentals Egmont Canada, vacation homes for rent by owner in Egmont Canada, and vacation homes for rent by owner in Egmont Canada
Rent house Golden Canada and Golden holiday rentals
Vacation rental, rent houses in Stanhope Canada, and houses for rent in Stanhope Canada
Rental apartment, house rentals Courtenay Canada, apartments for rent Courtenay, and condos for rent
Egmont rental homes and Egmont vacation homes for rent by owner
Lake Cowichan Canada condos for rent, holiday rentals in Lake Cowichan Canada, and rental houses in Lake Cowichan
Duncan Canada rental homes, short term rentals in Duncan Canada, bed and breakfast rentals, and rental homes Duncan
Rent houses in Chester Canada and rental properties in Chester Canada
Home rentals in Big White Canada, rent houses, and holiday rentals Big White
Apartments for rent in Chase, Chase Canada homes for rent by owner, rental homes Chase Canada, and vacation homes
Rental houses in Sutton and short term rentals Sutton Canada
Ile D Orleans apartments for rent, rental houses Ile D Orleans Canada, and home rentals in Ile D Orleans Canada
French River Canada rent house, vacation homes in French River, rent houses French River, and French River rent house
Bed and breakfast rentals and Fernie Canada bed and breakfast rentals
Duncan holiday rentals, Duncan Canada real estate rentals, and rental apartment Duncan
Homes for rent by owner Osoyoos, apartments for rent in Osoyoos, Osoyoos Canada short term rentals, and holiday rentals in Osoyoos Canada
Chandos Lake Canada vacation rental and Chandos Lake Canada homes for rent by owner
Vacation homes in Barrier Lake, rental houses in Barrier Lake, and holiday rentals
Rental apartment Margaretsville Canada, rental properties in Margaretsville, Margaretsville Canada holiday rentals, and vacation homes for rent by owner Margaretsville
Apartment rentals Brigus Canada and Brigus Canada houses for rent
Homes for rent Sidney Canada, Sidney vacation homes for rent by owner, and vacation homes Sidney
Big White city employs many agents, rental owners, real estate agents, and property owners.
The Big White indexes enrolled and classified on our webpage have studio chalet, rustic farmhouse, and rustic chalet.
Catch and devise Salt Spring Island Canada vacation rentals and Salt Spring Island homes for rent.
You can scan the mountain listed properties, loft classified advertisements, and waterfront classifieds under Big White Canada real estate rentals, short term rentals, and Big White Canada rent houses.
Conceive and come upon for rent by owner homes in Ethel Canada and vacation homes for rent by owner in Ethel Canada.
Hitch, register, and gather this weekend to kick off, jump into, and initiate on this traveling.
Move, dig up, and elicit rental properties Medicine Hat Canada, houses for rent Medicine Hat, and apartment rentals in Medicine Hat Canada.
Send wonderful and comely results regarding for rent by owner homes Big White, vacation homes in Big White, homes for rent Big White, and house rentals in Big White Canada found on our site, FRBO.com.
Come across and find out condo rentals and rental home Edson Canada.
Relocate, originate, and identify rental apartment in Beaumont Canada, apartments for rent in Beaumont Canada, and rent house Beaumont.
Conceive and find vacation rentals in New Liskeard Canada and rental houses in New Liskeard Canada.
Big White property owners, land owners, real estate investors, and rental agents list short term rentals in Big White Canada, Big White Canada vacation rental, and apartments for rent in Big White Canada.
Find some, distinctive, and sparse dossier in Big White and itemize Big White Canada apartments for rent.
Leeward Islands Anguilla rental apartment, Leeward Islands Anguilla vacation rental, and home rentals in Leeward Islands Anguilla
Big White is a sublime, handsome, and nice state with enticing, beauteous, stunning, and grand cottage, hacienda, apartment, and cabins.
Discover and find out Island Lake for rent by owner homes and Island Lake Canada apartments for rent.
La Jolla de Rosarito Mexico apartments for rent and apartments for rent La Jolla de Rosarito
Observe, identify, and discern rental houses, Lethbridge Canada vacation rental, and rental apartment.
Our website, FRBO.com omits territory, quarter, and area results, ordinarily.
Learn, uncover, and catch house rentals Campbellford, condo rentals in Campbellford Canada, and Campbellford Canada holiday rentals.
|
|
