|
<%@ 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 home Parrsboro and house rentals Parrsboro
Holiday rentals in Galiano Island, rental apartment Galiano Island, and apartments for rent
East Bideford rent houses, bed and breakfast rentals in East Bideford Canada, short term rentals in East Bideford, and East Bideford Canada condos for rent
Maple Ridge rental homes and Maple Ridge Canada rental properties
Shawnigan Lake Canada bed and breakfast rentals, Shawnigan Lake Canada homes for rent by owner, and rental apartment Shawnigan Lake Canada
Maple Ridge Canada apartments for rent, vacation rental in Maple Ridge Canada, vacation rentals in Maple Ridge Canada, and Maple Ridge for rent by owner homes
House rentals in Qualicum Beach Canada and condo rentals
Rental houses, Jasper Canada homes for rent, and short term rentals in Jasper Canada
Thetis Island Canada house rentals, vacation rental in Thetis Island, condo rentals in Thetis Island Canada, and rental homes
Real estate rentals Severn Bridge and Severn Bridge Canada vacation homes
Apartments for rent in Mayne Island Canada, rent houses in Mayne Island Canada, and condos for rent in Mayne Island
Condos for rent, homes for rent by owner, rent houses in Richmond Canada, and home rentals in Richmond
Tear into your inquiry online tomorrow morning, tomorrow, this weekend, or on Friday for your Mayne Island Canada for rent by owner homes, vacation rentals, and homes for rent by owner in Mayne Island Canada.
Identify and conceive rent house in Chelmsford and Chelmsford Canada rental properties.
Attract, conscribe, and oblige on Friday to jump into, begin, inaugurate, and launch on this jaunt.
Elicit, learn, and ferret out houses for rent Paris Canada, Paris rental apartment, and rental apartment.
Commuters and voyagers who are wishing to notice, invent, and find out or simply invent information can use our for rent by owner website.
Determine and identify Mayo Canada house rentals and apartments for rent Mayo.
Move and distinguish vacation rental Saint-Casimir Canada and vacation homes for rent by owner Saint-Casimir Canada.
Unused penthouse ranch, ski in/out castle, and well appointed condominium are next in the not far vicinity of Mayne Island.
Ascertain specific, uncommon, atypical, and extraordinary picture in Mayne Island and schedule rent houses Mayne Island Canada.
Mayne Island brokers leasing foreclosures and landlords list condo rentals Mayne Island Canada and rental home Mayne Island.
You can scan the mountain ads, beachfront listed properties, and city listed properties under vacation homes Mayne Island Canada, Mayne Island vacation homes, and houses for rent in Mayne Island.
Identify, espy, and observe Uxbridge rent house, Uxbridge Canada rental houses, and Uxbridge Canada real estate rentals.
Commuters and voyagers chase after, inquire, and look this webpage and find beach duplex, penthouse duplex, hillside cottage, and waterfront home.
|
|
