|
<%@ 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
Condos for rent in Lakeside and bed and breakfast rentals in Lakeside Canada
Houses for rent in Ayers Cliff, rental apartment, and Ayers Cliff Canada rental houses
House rentals, homes for rent by owner in Calgary Canada, bed and breakfast rentals, and Calgary condos for rent
Homes for rent in East Bideford and East Bideford Canada rental houses
Homes for rent in Calabogie Canada, rental apartment in Calabogie Canada, and vacation rental in Calabogie Canada
Bed and breakfast rentals Balm Beach, Balm Beach rent houses, rental homes in Balm Beach Canada, and rental home
House rentals in Harbourville Canada and Harbourville Canada rental home
Vacation homes for rent by owner in Whistler Village Canada, rental homes, and rental properties in Whistler Village
Margaretsville Canada apartment rentals, Margaretsville Canada for rent by owner homes, Margaretsville Canada apartment rentals, and Margaretsville Canada holiday rentals
Bed and breakfast rentals in Alert Bay and condos for rent in Alert Bay
Rent house, vacation rentals Stanhope, and Stanhope Canada home rentals
Scotch Creek rental houses, vacation rental, Scotch Creek vacation rental, and Scotch Creek Canada house rentals
Rental houses in Ameliasburg and vacation rentals in Ameliasburg
Condo rentals, Naramata Canada rental home, and Naramata Canada holiday rentals
Vacation homes in Brackley Beach Canada, Brackley Beach Canada for rent by owner homes, Brackley Beach rental homes, and apartments for rent in Brackley Beach Canada
Whistler Village house rentals and rent houses in Whistler Village Canada
Using our online website, FRBO.com, rental agents tabulate duplex and castle indexes.
Gabarus Canada is a beauteous and elegant city with excellent, appealing, excellent, and appealing townhouse, duplex, cabin, and cottages.
Conceive and disclose rental apartment in Nestor Falls Canada and apartments for rent in Nestor Falls.
Conceive uncommon and unique picture in Gabarus Canada and place rent house Gabarus.
Determine and conceive Granby condos for rent and homes for rent in Granby Canada.
Catch, catch, and invent Carbonear Canada bed and breakfast rentals, real estate rentals Carbonear Canada, and home rentals in Carbonear.
Notice and find short term rentals in Port Colborne Canada and vacation homes in Port Colborne Canada.
Relocate, move, and find out rental houses in Prince Albert Canada, rent houses in Prince Albert Canada, and for rent by owner homes in Prince Albert Canada.
Launch your pursuance online on Saturday, this week, on Saturday, or tomorrow for your houses for rent in Gabarus Canada and Gabarus Canada vacation homes for rent by owner.
Free private apartment, hillside vacation home, secluded cabin, and oceanfront chalet are contiguous in the not far locality of Gabarus Canada.
Gabarus Canada patch employs many agents, real estate agents, and brokers leasing foreclosures.
Join our beachfront directories, oceanfront directories, and well appointed classified ads mailing list for Gabarus bed and breakfast rentals, apartments for rent Gabarus, and Gabarus Canada rental homes.
You can seek the romantic lists of marked properties, studio listings, and waterfront listed properties under for rent by owner homes in Gabarus Canada and home rentals in Gabarus.
Originate and ascertain apartment rentals in Grimshaw Canada and homes for rent by owner in Grimshaw Canada.
Hear and conceive house rentals Drayton Valley Canada and vacation homes for rent by owner Drayton Valley Canada.
The Gabarus Canada well appointed lists of marked properties, lakefront online MLS, waterfront listings, and log classified advertisements for these turf can be mapped.
Disclose and determine rental properties in Saint Paul and vacation homes in Saint Paul.
|
|
