|
<%@ 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
Apartment rentals St Peters Canada and bed and breakfast rentals St Peters
White Point Canada rent house, White Point for rent by owner homes, and White Point Canada vacation homes for rent by owner
Rental home in West Bay, rent house West Bay, West Bay Canada apartment rentals, and rental apartment
Vancouver Canada vacation rentals and rental houses Vancouver Canada
For rent by owner homes in Chester Canada, Chester Canada holiday rentals, and Chester Canada vacation rentals
Apartment rentals in Duncan Canada, Duncan Canada vacation rental, Duncan Canada apartment rentals, and Duncan Canada homes for rent
Montague Canada rental homes and rental properties in Montague Canada
Rental properties, homes for rent East Bideford, and rental homes in East Bideford
Rent houses Maple Ridge Canada, Maple Ridge Canada for rent by owner homes, rental properties Maple Ridge Canada, and Maple Ridge Canada houses for rent
Homes for rent by owner Bowser Canada and rental homes Bowser Canada
Houses for rent in Calgary Canada, rental properties Calgary Canada, and rent houses in Calgary Canada
Parrsboro Canada bed and breakfast rentals, for rent by owner homes in Parrsboro Canada, Parrsboro Canada vacation rentals, and homes for rent by owner in Parrsboro
Rent houses and Truro Canada apartments for rent
Homes for rent, rental houses Salmon Arm, and Salmon Arm for rent by owner homes
Thetis Island Canada rent house, rental houses Thetis Island Canada, rental homes Thetis Island Canada, and house rentals in Thetis Island Canada
Cortes Island apartments for rent and Cortes Island Canada vacation homes
For rent by owner homes, condos for rent in Jasper, and condos for rent
Canmore real estate rentals, Canmore Canada homes for rent, holiday rentals, and bed and breakfast rentals in Canmore
House rentals in Victoria West Canada and Victoria West Canada condo rentals
House rentals in Gabarus Canada, rental homes in Gabarus, and real estate rentals in Gabarus
Condo rentals Scotch Creek, Scotch Creek Canada short term rentals, Scotch Creek Canada homes for rent by owner, and home rentals in Scotch Creek Canada
Rental homes Margaretsville Canada and Margaretsville Canada condos for rent
For rent by owner homes Petty Harbour, homes for rent in Petty Harbour Canada, and rental properties in Petty Harbour
Rental apartment Sutton Canada, Sutton Canada rental apartment, Sutton Canada vacation rentals, and Sutton short term rentals
Houses for rent in Brigus and vacation rentals in Brigus
Bed and breakfast rentals in Big White Canada, rental home in Big White Canada, and Big White Canada apartments for rent
Homes for rent by owner Kootenay Bay Canada, Kootenay Bay homes for rent by owner, Kootenay Bay apartments for rent, and vacation rentals in Kootenay Bay
Vacation homes for rent by owner Ameliasburg Canada and homes for rent Ameliasburg Canada
Galiano Island Canada rental homes, rent house in Galiano Island Canada, and vacation homes for rent by owner Galiano Island Canada
Using For Rent By Owner, landlords manifest condominium, condominium, and duplex indexes.
The Port Joli Canada online MLS set down and calendar on our page accommodate private duplex, resort chalet, well appointed vacation home, and decadent chalet.
Discover, discern, and hear condos for rent Prescott Canada, vacation homes for rent by owner in Prescott, and rent houses in Prescott Canada.
Espy, recognize, and conceive Cornwall Canada homes for rent by owner, condo rentals Cornwall Canada, and Cornwall Canada apartments for rent.
Join our ski in/out classified advertisements, exclusive directories, and spacious listings mailing list for holiday rentals in Port Joli Canada and Port Joli Canada rent houses.
Learn and discover rental houses Dawson Creek Canada and Dawson Creek Canada rental properties.
Hear, detect, and contrive Lacombe vacation homes for rent by owner, Lacombe Canada apartment rentals, and rent house Lacombe.
House rentals in Lac-Des-Plages, holiday rentals, Lac-Des-Plages Canada vacation homes, and Lac-Des-Plages Canada rent house
Discover, identify, and recognize vacation homes Chatham, house rentals in Chatham Canada, and condo rentals Chatham Canada.
Observe and come across bed and breakfast rentals Summerside and vacation homes for rent by owner in Summerside Canada.
Possessors and confreres who are smelling around Port Joli for rent by owner homes and are trying to invent rental properties Port Joli and rent houses in Port Joli can explore For Rent By Owner and our lakefront directories, penthouse online MLS, and decadent classified ads.
Identify and hear the section and next Port Joli Canada area.
Discover and disclose vacation rental in Qualicum Beach and Qualicum Beach homes for rent by owner.
Come upon, uncover, and locate Mont-laurier Canada rental houses, Mont-laurier Canada apartments for rent, and Mont-laurier Canada condo rentals.
Identify and recognize bed and breakfast rentals in Matane Canada and short term rentals in Matane Canada.
Devise and ascertain home rentals in Dunrobin Canada and Dunrobin bed and breakfast rentals.
Port Joli property brokers, condo owners, real estate investors, and town home owners list Port Joli Canada homes for rent by owner, Port Joli condo rentals, and house rentals in Port Joli Canada.
|
|
