|
<%@ 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
Short term rentals in Whistler and rental houses in Whistler
For rent by owner homes in Maple Ridge Canada, house rentals Maple Ridge, and short term rentals Maple Ridge Canada
Canoe Cove apartment rentals, vacation homes Canoe Cove, Canoe Cove Canada apartments for rent, and holiday rentals
For rent by owner homes in North Rustico and for rent by owner homes in North Rustico Canada
Vacation homes, for rent by owner homes in Port Carling Canada, and bed and breakfast rentals in Port Carling
Apartment rentals Ladysmith Canada, vacation rental in Ladysmith Canada, Ladysmith Canada house rentals, and rental home in Ladysmith Canada
Homes for rent by owner in Rossland Canada and vacation homes for rent by owner in Rossland Canada
Vacation homes for rent by owner Bromont, rent houses in Bromont Canada, and Bromont Canada house rentals
Johnstown Canada houses for rent, Johnstown Canada rental properties, holiday rentals Johnstown Canada, and Johnstown houses for rent
Nelson vacation rentals and real estate rentals in Nelson
Homes for rent in Golden Canada, rent houses in Golden, and rental homes in Golden Canada
Rental apartment White Rock, White Rock houses for rent, vacation homes, and White Rock holiday rentals
Condo rentals Musquodoboit Harbour and house rentals in Musquodoboit Harbour
Chemong Lake vacation homes for rent by owner, Chemong Lake apartments for rent, and rental homes in Chemong Lake Canada
Cortes Island Canada real estate rentals, Cortes Island Canada rental apartment, Cortes Island Canada rental homes, and rental homes in Cortes Island Canada
The Chase Canada advertisements scheduled and pegged on our for rent by owner website arrange lake bungalow, log home, beachfront condominium, and lakeside houseboat.
Romantics and pirates who are hunting Chase for rent by owner homes and are trying to disclose vacation homes Chase Canada, home rentals Chase, and holiday rentals Chase can ransack our webpage and our studio indexes, city ads, and exclusive ads.
Ascertain and recognize Deer Lake short term rentals and vacation rentals in Deer Lake Canada.
Pre-leased city lodge, beachfront villa, well appointed condominium, and studio cottage are contiguous in the nearest zone of Chase Canada.
Come across, locate, and find South River short term rentals, real estate rentals South River, and South River Canada rent house.
Relocate, light upon, and catch Chesley Canada houses for rent, short term rentals in Chesley, and home rentals Chesley Canada.
You can grub the lakeside lists of marked properties, beach classified advertisements, waterfront indexes, and suburban indexes under rent houses in Chase Canada, rent house in Chase Canada, and home rentals in Chase.
Invent, find out, and invent the sector and nearby Chase Canada domain.
See beachfront listings, hillside online MLS, and romantic lists of marked properties that agents and rental property owners post on this webpage.
Identify, observe, and light upon rental home in Dolbeau Canada, Dolbeau Canada houses for rent, and holiday rentals in Dolbeau Canada.
Initiate your inquest online on Sunday, in the morning, day after tomorrow, or this week for your rental houses and real estate rentals.
Identify unconventional and specialized statistics in Chase and enumerate condos for rent in Chase Canada.
Join our log directories, convenient classified advertisements, and city listings mailing list for homes for rent by owner, rental houses in Chase Canada, and Chase bed and breakfast rentals.
Chase property managers, brokers leasing foreclosures, property brokers, and property brokers list rental properties Chase Canada, house rentals in Chase Canada, and Chase Canada short term rentals.
Find and discern rental home in High Level Canada and vacation rental.
Chase Canada abstracts could serve, serve, facilitate, and collaborate your perquisition.
|
|
