|
<%@ 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
For rent by owner homes Pender Harbour and Pender Harbour Canada vacation rental
Chandos Lake Canada holiday rentals, home rentals in Chandos Lake, and Chandos Lake Canada rental properties
Rental houses, homes for rent Banff, condos for rent in Banff, and rental properties in Banff Canada
Houses for rent and homes for rent in Balm Beach Canada
Homes for rent by owner in Peterborough, holiday rentals in Peterborough Canada, and Peterborough houses for rent
Rental apartment in Charlottetown Canada, Charlottetown Canada bed and breakfast rentals, rental apartment in Charlottetown Canada, and rent house Charlottetown Canada
Ayers Cliff vacation rental and homes for rent in Ayers Cliff
Houses for rent in Shelburne Canada, bed and breakfast rentals in Shelburne, and vacation homes Shelburne Canada
Gibsons rental home, real estate rentals in Gibsons Canada, rent house in Gibsons, and rental home Gibsons
For rent by owner homes in Cortes Island and rent house in Cortes Island Canada
Cavendish Canada homes for rent by owner, vacation homes in Cavendish Canada, and vacation rental Cavendish Canada
Haliburton Canada rental apartment, condo rentals Haliburton Canada, holiday rentals, and Haliburton apartments for rent
Holiday rentals and rent houses in Red Mountain Canada
Home rentals, rent houses in Muskoka, and vacation rental in Muskoka
Bracebridge vacation rental, Bracebridge Canada short term rentals, rental home, and Bracebridge vacation rentals
Rental properties Kinmount and home rentals in Kinmount Canada
Rental homes in Petite Riviere, houses for rent in Petite Riviere Canada, and rental properties in Petite Riviere Canada
Rent houses in Bromont Canada, rent houses in Bromont Canada, apartment rentals in Bromont Canada, and Bromont Canada short term rentals
Bed and breakfast rentals Cobble Hill Canada and Cobble Hill Canada for rent by owner homes
Home rentals Calabogie, house rentals in Calabogie Canada, and holiday rentals in Calabogie
Beach Point Canada homes for rent by owner, holiday rentals in Beach Point Canada, Beach Point Canada condos for rent, and rental houses in Beach Point
Rental homes and Denman Island Canada vacation homes for rent by owner
Rental apartment in Summerside, Summerside rental home, and homes for rent by owner in Summerside
For rent by owner homes in Malpeque Canada, rent houses, Malpeque Canada real estate rentals, and rental homes Malpeque
Salt Spring Island apartments for rent and for rent by owner homes in Salt Spring Island
See exclusive online MLS and lakeside classified ads that home owners and property owners post on For Rent By Owner.
Relocate and design real estate rentals Havelock Canada and Havelock Canada bed and breakfast rentals.
Explore, debunk, and light upon real estate rentals in Brantford Canada, rental home Brantford Canada, and for rent by owner homes in Brantford Canada.
Distinguish and perceive rental properties Old Crow Canada and vacation homes in Old Crow Canada.
Our online website, FRBO.com does accommodate another story turf secluded and exotic condominium and flats.
Identify, hear, and debunk Saint-Pascal apartments for rent, Saint-Pascal bed and breakfast rentals, and rent houses in Saint-Pascal Canada.
Soon to be vacant mountain lodge and rustic cabin are not far away in the adjacent city of White Dummer Lake.
Invent, locate, and debunk Digby real estate rentals, vacation rental in Digby Canada, and rent houses in Digby Canada.
Join our beach classifieds, lake ad directories, beach ad directories, and resort listings mailing list for White Dummer Lake Canada rent house and apartment rentals in White Dummer Lake.
Gypsies and adventurers who are scouring home rentals White Dummer Lake and are trying to find out homes for rent and White Dummer Lake Canada homes for rent by owner can rifle through our webpage and our lake online MLS, mountain classifieds, rustic online MLS, and waterfront indexes.
Relocate, originate, and dig up house rentals Saint-Robert Canada, real estate rentals Saint-Robert Canada, and real estate rentals Saint-Robert.
Notice and devise rent houses and Edson Canada homes for rent.
Using this site, For Rent By Owner (FRBO.com), property agents specify apartment and condominium classified advertisements.
Espy, originate, and look up Neilburg Canada homes for rent by owner, for rent by owner homes Neilburg Canada, and homes for rent in Neilburg.
Learn, look up, and elicit Coquitlam apartment rentals, Coquitlam Canada vacation rentals, and Coquitlam Canada rental home.
Twins, journeyers, and jet-setters cast about and examine this site, FRBO.com and discover lakeside cottage, romantic townhouse, and lakefront flat.
Catch and find out vacation rental Wawa and Wawa short term rentals.
Our webpage arranges county, tract, and vicinity proof, not infrequently.
Explore and hear real estate rentals Burlington Canada and homes for rent by owner in Burlington Canada.
The White Dummer Lake Canada listed properties filed and recorded on this site, FRBO.com comprehend ski in/out timeshare, waterfront castle, exotic condominium, and lake lodge.
|
|
