|
<%@ 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
Truro Canada house rentals and Truro Canada vacation rental
East Bideford Canada bed and breakfast rentals, East Bideford Canada homes for rent by owner, and houses for rent East Bideford
Apartment rentals in North Vancouver, homes for rent by owner North Vancouver Canada, North Vancouver Canada rental apartment, and bed and breakfast rentals in North Vancouver
Houses for rent Hubbards and vacation rentals Hubbards Canada
Rental properties in Hubbards, Hubbards Canada rental home, and Hubbards Canada real estate rentals
Homes for rent in Ile Verte-Green Island Canada, apartment rentals in Ile Verte-Green Island Canada, Ile Verte-Green Island Canada real estate rentals, and Ile Verte-Green Island vacation homes for rent by owner
Rental apartment Kenora Canada and vacation homes for rent by owner Kenora
House rentals in Whistler Village Canada, vacation rentals in Whistler Village Canada, and Whistler Village Canada real estate rentals
Condos for rent in North Hatley Canada, house rentals, homes for rent by owner in North Hatley Canada, and North Hatley Canada bed and breakfast rentals
Houses for rent Tyne Valley and rental apartment
Mont Ste-Marie Canada rental properties, short term rentals in Mont Ste-Marie Canada, and rental apartment
Vacation homes Annapolis Royal, vacation rental in Annapolis Royal, holiday rentals in Annapolis Royal, and Annapolis Royal Canada home rentals
Apartments for rent and homes for rent by owner in Niagara Falls Canada
Rental properties Balm Beach, short term rentals Balm Beach, and for rent by owner homes in Balm Beach
Sun Peaks Canada home rentals, Sun Peaks Canada vacation homes, rental homes Sun Peaks, and rent houses in Sun Peaks
Big Tancook Island Canada rental houses and rent houses in Big Tancook Island Canada
Homes for rent by owner Stanhope, condo rentals in Stanhope, and Stanhope Canada bed and breakfast rentals
Rental houses in Penticton, Penticton Canada rental properties, Penticton Canada rental homes, and vacation rental in Penticton Canada
Rental properties Sault Ste Marie Canada and Sault Ste Marie Canada houses for rent
Real estate rentals in Labelle Canada, bed and breakfast rentals in Labelle, and for rent by owner homes in Labelle
Home rentals in Shawnigan Lake, rental home, Shawnigan Lake Canada apartments for rent, and Shawnigan Lake short term rentals
Rent house in Sicamous and apartment rentals Sicamous Canada
Rental homes, apartment rentals Augustine Cove, and apartment rentals in Augustine Cove
Ayers Cliff short term rentals, condos for rent in Ayers Cliff, vacation homes for rent by owner, and Ayers Cliff rental homes
You can light upon and explore rent houses in Tyne Valley Canada, Tyne Valley Canada rental home, and houses for rent Tyne Valley Canada.
We planned and phrased this webpage to be ravishing, pleasing, sightly, and good-looking.
Glimpse and originate vacation rentals and homes for rent by owner New Westminster Canada.
Disclose, distinguish, and come upon house rentals in Moncton, Moncton real estate rentals, and homes for rent by owner in Moncton.
Send excellent and symmetrical memorandums regarding rental properties, Tyne Valley Canada condos for rent, apartments for rent in Tyne Valley, and condo rentals Tyne Valley Canada found on this website, FRBO.com.
Relocate and discern rental homes Laval Canada and rent houses in Laval Canada.
Perceive, dig up, and catch rental properties in Sherwood Park Canada, Sherwood Park Canada vacation homes for rent by owner, and vacation rental in Sherwood Park Canada.
Householders and locals who are wishing to discover and conceive or simply distinguish information can use our for rent by owner site, FRBO.com.
Catch and contrive rental homes in Ethel Canada and rental houses in Ethel Canada.
Devise, observe, and explore apartment rentals Buckingham Canada, Buckingham Canada rent house, and Buckingham Canada rent houses.
This webpage holds dominion, patch, turf, and zone dope, generally.
Using this extensive website, FRBO.com, rental owners enroll farmhouse and bungalow online MLS.
Light upon and identify rental properties in Ajax Canada and homes for rent by owner Ajax Canada.
Move and elicit vacation rental in Pierrefonds Canada and vacation homes for rent by owner in Pierrefonds Canada.
Tyne Valley is a splendid and stunning tract with graceful, well-formed, and sightly ranch, cottage, condominium, and timeshares.
Better halves and spouses who are ferreting condo rentals in Tyne Valley and are trying to invent apartments for rent in Tyne Valley Canada and vacation homes for rent by owner Tyne Valley Canada can cast about our webpage and our beach directories and romantic classifieds.
Join our hillside online MLS and romantic online MLS mailing list for houses for rent in Tyne Valley Canada and Tyne Valley Canada house rentals.
Tyne Valley land owners, condo owners, agents serving the condo market, and agents serving the condo market list rental properties Tyne Valley, short term rentals Tyne Valley, and holiday rentals in Tyne Valley.
Nearly ready resort home, beach timeshare, penthouse home, and lake home are nearby in the approaching zone of Tyne Valley Canada.
Get going your expedition online in the next few days or on Saturday for your rental apartment Tyne Valley, short term rentals Tyne Valley Canada, and Tyne Valley Canada vacation rental.
Conceive, design, and design house rentals Hearst Canada, rental home in Hearst Canada, and houses for rent Hearst Canada.
Debunk, locate, and devise rental houses Tobermory Canada, short term rentals, and apartment rentals Tobermory Canada.
|
|
