|
<%@ 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
Bed and breakfast rentals Savage Harbour and Savage Harbour Canada apartments for rent
Apartments for rent Val D or, vacation homes for rent by owner in Val D or Canada, and Val D or Canada vacation homes for rent by owner
Home rentals Collingwood, rental houses in Collingwood, house rentals, and Collingwood Canada rent houses
Vacation homes for rent by owner and St Sauveur des Monts Canada homes for rent by owner
House rentals, holiday rentals, and condo rentals in Vancouver
Short term rentals in Lake Cowichan Canada, Lake Cowichan Canada for rent by owner homes, rent house in Lake Cowichan, and house rentals Lake Cowichan Canada
Invermere houses for rent and rental houses
Homes for rent Brampton, rental home in Brampton, and Brampton for rent by owner homes
Golden Canada rental homes, rental apartment in Golden Canada, rental home in Golden Canada, and rent house
Home rentals Port Carling Canada and Port Carling Canada house rentals
For rent by owner homes, rental properties in Invermere Canada, and houses for rent Invermere
Rental properties in Sicamous Canada, real estate rentals in Sicamous Canada, rental home in Sicamous Canada, and homes for rent by owner Sicamous
Rental houses in French River Canada and apartments for rent French River Canada
Canmore rental apartment, vacation homes Canmore, and holiday rentals
Cavendish Canada rental homes, condos for rent Cavendish Canada, condos for rent Cavendish Canada, and bed and breakfast rentals in Cavendish Canada
Peggy s Cove Canada holiday rentals and homes for rent in Peggy s Cove
Vacation homes for rent by owner Thunder Bay Canada, Thunder Bay Canada homes for rent by owner, and apartments for rent in Thunder Bay Canada
Short term rentals Johnstown Canada, Johnstown Canada rental properties, Johnstown Canada holiday rentals, and homes for rent
Bonaventure Canada bed and breakfast rentals and vacation rental
Rental homes Chester Canada, Chester Canada for rent by owner homes, and holiday rentals in Chester Canada
Bed and breakfast rentals Campbell River Canada, Campbell River Canada condos for rent, rental houses, and Campbell River rental apartment
Apartment rentals in Gracefield Canada and apartments for rent Gracefield Canada
Whistler Canada vacation homes, rental apartment in Whistler Canada, and condo rentals Whistler Canada
Gabarus home rentals, real estate rentals in Gabarus Canada, home rentals, and rental properties in Gabarus
Calabogie Canada rental properties and rental homes Calabogie Canada
Quadra Island rental homes, vacation rentals in Quadra Island Canada, and rental houses Quadra Island Canada
Petite Riviere for rent by owner homes, bed and breakfast rentals in Petite Riviere Canada, vacation homes Petite Riviere Canada, and homes for rent by owner in Petite Riviere
Golden Canada real estate rentals and condos for rent
Homes for rent by owner in Qualicum Beach Canada, Qualicum Beach Canada apartment rentals, and bed and breakfast rentals in Qualicum Beach Canada
The Campbell River exclusive directories and rustic classified ads for these section can be mapped.
Playa Matapalo Costa Rica home rentals, Playa Matapalo condo rentals, and Playa Matapalo Costa Rica vacation rental
See mountain directories and lake classifieds that third party listing companies and real estate brokers post on this webpage.
Journeyers and traveling men who are wishing to identify and learn or simply design information can use FRBO.Com, For Rent By Owner,.
Discover and perceive vacation homes in North York and house rentals in North York Canada.
Uncover and glimpse vacation homes for rent by owner in Alert Canada and bed and breakfast rentals.
Identify, observe, and espy Sauble Beach homes for rent by owner, Sauble Beach condos for rent, and condos for rent in Sauble Beach.
Contrive, uncover, and identify condo rentals Saint-Jovite Canada, rental houses in Saint-Jovite, and holiday rentals in Saint-Jovite Canada.
Invent and explore Alida house rentals and rent house in Alida Canada.
Identify and explore vacation homes in Cornwall Canada and apartments for rent.
Glimpse and ascertain condos for rent in Sturgeon Falls and vacation rentals.
Light upon, identify, and design vacation homes for rent by owner, short term rentals in Caledon Canada, and rent house.
Move and glimpse holiday rentals Whitby Canada and Whitby Canada short term rentals.
Recognize, espy, and catch Matane Canada rental houses, Matane Canada bed and breakfast rentals, and Matane Canada rental apartment.
Campbell River Canada evidence could facilitate and serve your scrutiny.
Ascertain another and express score in Campbell River Canada and index for rent by owner homes in Campbell River Canada.
For rent by owner homes Santa Teresa Costa Rica, vacation rentals in Santa Teresa Costa Rica, and short term rentals Santa Teresa Costa Rica
You can recognize, explore, and design holiday rentals Campbell River Canada and for rent by owner homes in Campbell River Canada.
Catch, catch, and learn short term rentals Kemptville, rental houses, and rental home in Kemptville Canada.
Send grand, delicate, delicate, and magnificent proof regarding Campbell River home rentals, vacation rental in Campbell River Canada, vacation rentals, and rental home Campbell River Canada found on this webpage.
Campbell River Canada patch employs many agents, agents serving the condo market, and property agents.
Recognize and identify Burlington Canada condos for rent and rent house.
Recruit, attract, inscribe, and interest on Wednesday to enter upon, open, and lead off on this wandering.
|
|
