|
<%@ 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
Balm Beach Canada houses for rent and Balm Beach rental apartment
Rental apartment Maple Ridge, homes for rent, and Maple Ridge Canada homes for rent
Celista bed and breakfast rentals, Celista Canada vacation rental, Celista Canada home rentals, and Celista condos for rent
Houses for rent in Val D or and homes for rent by owner Val D or Canada
Real estate rentals French River, rental properties in French River Canada, and house rentals French River
Rent house in Denman Island Canada, rental properties in Denman Island, real estate rentals, and vacation rental Denman Island
Vacation homes Nelson Canada and real estate rentals Nelson Canada
Chandos Lake apartments for rent, vacation rental Chandos Lake, and vacation homes in Chandos Lake
Windermere short term rentals, rental houses in Windermere Canada, houses for rent Windermere, and vacation rental Windermere Canada
Fernie Canada homes for rent and Fernie Canada house rentals
Vacation homes for rent by owner Yarmouth, home rentals in Yarmouth Canada, and holiday rentals in Yarmouth
Rental houses in Egmont Canada, Egmont Canada houses for rent, apartment rentals Egmont Canada, and Egmont homes for rent by owner
Rental houses in Okanagan Centre Canada and home rentals Okanagan Centre
Lac-Des-Plages Canada rent house, houses for rent Lac-Des-Plages Canada, and Lac-Des-Plages Canada real estate rentals
Vacation homes in Quebec City Canada, Quebec City Canada rental homes, apartment rentals Quebec City, and Quebec City Canada vacation rentals
For rent by owner homes in Pitt Meadows Canada and short term rentals in Pitt Meadows
Short term rentals, rent house in Invermere Canada, and vacation homes Invermere Canada
Apartments for rent Savage Harbour, rental houses, home rentals in Savage Harbour Canada, and condos for rent
Rental apartment and apartment rentals Truro Canada
Bay St Lawrence Canada rental houses, vacation rental Bay St Lawrence, and Bay St Lawrence rental properties
Brigus Canada bed and breakfast rentals, homes for rent by owner Brigus, apartment rentals Brigus Canada, and apartment rentals in Brigus Canada
Condo rentals in Lunenburg Canada and condo rentals in Lunenburg Canada
Rental houses Port Carling Canada, vacation rentals Port Carling, and apartment rentals in Port Carling Canada
Lac Castor Canada rent houses, homes for rent by owner, Lac Castor Canada condos for rent, and apartment rentals in Lac Castor
Thunder Bay Canada holiday rentals and bed and breakfast rentals Thunder Bay Canada
Homes for rent by owner Truro Canada, home rentals Truro Canada, and home rentals
Gracefield houses for rent, vacation rental in Gracefield Canada, condos for rent in Gracefield, and short term rentals Gracefield Canada
Relocate, glimpse, and move Cowansville Canada holiday rentals, for rent by owner homes Cowansville, and houses for rent in Cowansville Canada.
Originate and espy bed and breakfast rentals and Saint-Pascal Canada rental apartment.
Join our well appointed classifieds, beachfront classified ads, and penthouse ad directories mailing list for Calabogie Canada home rentals and houses for rent in Calabogie.
Our page comprises area and domain documents, not seldom.
The Calabogie Canada rustic listed properties and hidden lists of marked properties for these field can be mapped.
Calabogie is a nice and foxy field with fine and lovely duplex, houseboat, house, and lodges.
Lodgers and expeditionists who are seeking vacation rental Calabogie Canada and are trying to catch Calabogie condo rentals and condos for rent can rummage our for rent by owner site, FRBO.com and our resort ads, loft ad directories, and hidden classified ads.
Short term rentals in Wintberg US Virgin Islands, vacation rental in Wintberg US Virgin Islands, holiday rentals in Wintberg US Virgin Islands, and Wintberg US Virgin Islands condo rentals
Discover and devise homes for rent by owner Pierrefonds and houses for rent.
Come upon, find, and elicit rental homes New Maryland Canada, rent houses in New Maryland Canada, and New Maryland vacation rental.
Identify, debunk, and explore Grimshaw condos for rent, Grimshaw Canada real estate rentals, and for rent by owner homes Grimshaw Canada.
Learn, invent, and identify Toronto Canada apartment rentals, homes for rent by owner in Toronto Canada, and real estate rentals in Toronto Canada.
Disclose and uncover condos for rent in Selkirk and Selkirk homes for rent by owner.
Hear and notice Paradise Canada apartments for rent and homes for rent Paradise.
Short term rentals in Crochu Grenada, rental home Crochu, and vacation homes for rent by owner in Crochu Grenada
Look up and devise Stephenville bed and breakfast rentals and Stephenville apartment rentals.
Conceive and distinguish house rentals in Brockville Canada and Brockville Canada rent house.
Vacation rental in Pineapple Village US Virgin Islands, condos for rent, real estate rentals Pineapple Village US Virgin Islands, and Pineapple Village US Virgin Islands vacation rental
See lakeside lists of marked properties, suburban ads, spacious indexes, and exclusive ads that rental agents and home owners post on FRBO.Com, For Rent By Owner,.
Calabogie Canada locality employs many third party listing companies, third party listing companies, and real estate investors.
|
|
