|
<%@ 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
Rental apartment in Panorama Canada and vacation rentals in Panorama Canada
Real estate rentals Haliburton Canada, Haliburton Canada rental apartment, and Haliburton Canada condo rentals
Condo rentals in St Martins, rent house in St Martins, house rentals in St Martins Canada, and vacation homes St Martins Canada
Homes for rent Bowser Canada and rental home in Bowser
Toronto rental houses, rental apartment in Toronto Canada, and homes for rent by owner
Nelson Canada condos for rent, Nelson Canada vacation rental, rental houses Nelson Canada, and rental houses Nelson
Rental home and homes for rent by owner
Real estate rentals in Saint Catharines Canada, short term rentals in Saint Catharines Canada, and vacation homes for rent by owner Saint Catharines
Thetis Island Canada vacation rentals, bed and breakfast rentals Thetis Island Canada, rental houses, and condos for rent in Thetis Island Canada
Summerside homes for rent by owner and rental houses in Summerside Canada
Rental apartment, Bromont apartment rentals, and Bromont Canada house rentals
Rental houses, rental home Kelowna, houses for rent in Kelowna, and for rent by owner homes in Kelowna Canada
Vacation homes Windermere Canada and Windermere Canada vacation homes for rent by owner
West Bay Canada for rent by owner homes, condo rentals, and rental home in West Bay
Orillia Canada rental houses, Orillia Canada rent houses, condos for rent Orillia Canada, and rental homes in Orillia
Calabogie Canada rental home and short term rentals in Calabogie
Picton Canada bed and breakfast rentals, rental home, and condos for rent in Picton Canada
Lakeside vacation rental, Lakeside Canada condos for rent, vacation homes in Lakeside Canada, and Lakeside condos for rent
Homes for rent in Round Lake Canada and Round Lake Canada rental homes
Better halves and coeds check and search for our for rent by owner website and find oceanfront house, exotic bungalow, and oceanfront lodge.
The Cape Sable Island Canada ads pegged and numerated on our webpage embody romantic chalet, well appointed duplex, mountain vacation home, and romantic cottage.
Free log timeshare, city chalet, studio villa, and city condominium are impending in the abutting kingdom of Cape Sable Island Canada.
Contrive and explore the zone and imminent Cape Sable Island Canada turf.
Determine, relocate, and look up apartment rentals in Marathon Canada, rent house in Marathon Canada, and Marathon Canada houses for rent.
Move and explore real estate rentals in Cap-de-la-Madeleine Canada and home rentals Cap-de-la-Madeleine.
Usually, support, sustain, and reinforce your drifters, co-workers, and globetrotters to a likable, pleasant, approved, and extensive principality.
Find out, distinguish, and elicit rental houses, Iqaluit Canada condos for rent, and rental homes Iqaluit Canada.
Hear, conceive, and elicit rental apartment Comox Canada, Comox Canada rental houses, and Comox Canada for rent by owner homes.
Cape Sable Island Canada section employs many rental property owners, brokers leasing foreclosures, and property managers.
Perceive, identify, and relocate short term rentals Saint-Robert, holiday rentals, and short term rentals Saint-Robert Canada.
Cape Sable Island whole story could support, run interference, and expedite your pursual.
Originate and discover rent houses Cobble Hill Canada and rental home Cobble Hill.
Identify and find out for rent by owner homes in Bracebridge Canada and rental homes in Bracebridge.
Determine and detect Boucherville Canada rental homes and holiday rentals in Boucherville Canada.
|
|
