|
<%@ 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
Homes for rent Wasaga Beach Canada and Wasaga Beach rental houses
House rentals in White Rock, vacation homes, and White Rock Canada rent houses
Rent house Parrsboro, bed and breakfast rentals Parrsboro, short term rentals Parrsboro, and condos for rent in Parrsboro Canada
Petty Harbour Canada real estate rentals and apartments for rent
Pictou Island Canada real estate rentals, Pictou Island Canada house rentals, and Pictou Island Canada home rentals
Muskoka homes for rent by owner, rent houses in Muskoka Canada, for rent by owner homes in Muskoka, and holiday rentals Muskoka
Homes for rent in Ottawa Canada and holiday rentals Ottawa Canada
Morin Heights Canada rental apartment, Morin Heights Canada vacation homes for rent by owner, and apartment rentals
Rossland rental home, Rossland houses for rent, vacation rentals Rossland Canada, and for rent by owner homes Rossland Canada
Salmon Arm Canada rental houses and rental houses Salmon Arm
Pitt Meadows Canada bed and breakfast rentals, Pitt Meadows Canada real estate rentals, and for rent by owner homes Pitt Meadows Canada
Homes for rent, vacation homes for rent by owner, apartments for rent, and Nelson Canada rent house
Rental home in Kootenay Bay Canada and rental homes in Kootenay Bay
Lunenburg Canada condo rentals, apartments for rent Lunenburg, and rent houses in Lunenburg Canada
Beach Point homes for rent by owner, condos for rent Beach Point Canada, apartment rentals Beach Point Canada, and homes for rent by owner in Beach Point Canada
Homes for rent by owner Wreck Cove Canada and Wreck Cove Canada rental houses
Bed and breakfast rentals in Roberts Creek Canada, homes for rent by owner in Roberts Creek Canada, and Roberts Creek rent house
Houses for rent in Ottawa, house rentals Ottawa Canada, homes for rent by owner Ottawa Canada, and real estate rentals Ottawa Canada
Originate and detect the city and not far Port Stanton territory.
Elicit and disclose Aylmer Canada rental homes and rent house Aylmer.
Our page can induct, appoint, and enter into secluded listings and romantic classifieds studio ad directories and romantic listed properties to relieve your Port Stanton exploration.
Uncover, contrive, and discern apartments for rent, vacation rentals in North Delta Canada, and North Delta Canada condos for rent.
Identify and notice Slocan bed and breakfast rentals and Slocan real estate rentals.
Ferret out, light upon, and distinguish holiday rentals Kingston Canada, vacation homes Kingston Canada, and Kingston Canada for rent by owner homes.
Join our oceanfront online MLS, secluded classified advertisements, and loft ads mailing list for rental home in Port Stanton and for rent by owner homes in Port Stanton.
Using our online website, FRBO.com, rental owners manifest villa, chalet, and condominium classified ads.
Discover and originate condo rentals Pointe-Au-Pere and homes for rent by owner.
Dig up, hear, and come upon homes for rent by owner in Petrolia, apartments for rent in Petrolia Canada, and Petrolia house rentals.
Port Stanton land owners and home owners list rental properties in Port Stanton, for rent by owner homes in Port Stanton Canada, rental apartment in Port Stanton, and vacation rental Port Stanton Canada.
See romantic lists of marked properties, studio listed properties, and hillside ad directories that property owners and real estate investors post on this site, FRBO.com.
Port Stanton is a graceful, good-looking, alluring, and ravishing county with grand, dazzling, good-looking, and superb house, farmhouse, ranch, and timeshares.
|
|
