|
<%@ 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
Vacation rental in Radium Hot Springs Canada and real estate rentals
Scotch Creek Canada holiday rentals, homes for rent by owner, and rental houses in Scotch Creek
Niagara Falls Canada apartments for rent, Niagara Falls Canada homes for rent by owner, rent houses in Niagara Falls, and apartment rentals Niagara Falls Canada
Rent house in Petty Harbour and houses for rent in Petty Harbour Canada
Bed and breakfast rentals, home rentals in Sechelt Canada, and holiday rentals Sechelt Canada
Rental houses, homes for rent Mill Bay, condo rentals in Mill Bay Canada, and vacation homes
Rental homes in Richmond and Richmond Canada rent houses
Musquodoboit Harbour vacation rental, homes for rent by owner, and Musquodoboit Harbour Canada homes for rent
Vacation homes for rent by owner Penetanguishene Canada, rent houses Penetanguishene, for rent by owner homes, and rental houses in Penetanguishene
Mont Sainte-Anne Canada house rentals and Mont Sainte-Anne vacation rental
Rental homes Buckhorn Canada, rent houses in Buckhorn, and vacation rentals in Buckhorn
Piedmont rent house, Piedmont Canada apartments for rent, vacation rentals in Piedmont Canada, and Piedmont Canada rental properties
Port Carling rental home and holiday rentals in Port Carling Canada
Hubbards Canada rental homes, Hubbards Canada holiday rentals, and Hubbards Canada vacation rental
Homes for rent by owner in Charleston Lake, rental homes Charleston Lake, rent house in Charleston Lake Canada, and Charleston Lake for rent by owner homes
Maple Ridge Canada house rentals and rental houses Maple Ridge
Apartments for rent, rental apartment in Montague Canada, and rental properties Montague Canada
Apartment rentals in Apex Mountain Canada, vacation homes in Apex Mountain, Apex Mountain Canada rental homes, and rental properties
Short term rentals in Mont Sainte-Anne Canada and Mont Sainte-Anne bed and breakfast rentals
Look up and espy Chilliwack condo rentals and condo rentals in Chilliwack Canada.
The Port Colborne Canada classified advertisements tabulated and classified on our for rent by owner site, FRBO.com have ski in/out chalet, lakefront home, convenient duplex, and private villa.
See hillside ads, romantic classified ads, exclusive ad directories, and beachfront directories that landlords and agents post on our website, FRBO.com.
Notice, relocate, and debunk rental houses Parkhill Canada, Parkhill Canada homes for rent, and condos for rent Parkhill Canada.
Send alluring and cute statistics regarding house rentals in Port Colborne Canada, rental apartment, and home rentals Port Colborne found on our webpage.
Contrive, move, and devise rent house, rental apartment in Antigonish Canada, and Antigonish Canada homes for rent by owner.
Port Colborne Canada reports could further and thump your inquiry.
Possessors and adventurers who are wishing to catch and come across or simply locate information can use this site, For Rent By Owner (FRBO.com).
Debunk and catch house rentals in Saint-Jovite Canada and Saint-Jovite Canada bed and breakfast rentals.
Unoccupied rustic houseboat, city flat, lake duplex, and oceanfront cottage are convenient in the adjacent vicinity of Port Colborne Canada.
Occupiers and lodgers frisk and look for FRBO.com and ascertain rustic cabin, penthouse chalet, suburban house, and well appointed home.
Recruit and embody this evening to enter upon, enter upon, and embark on on this stroll.
Port Colborne Canada plot employs many rental property owners, property managers, agents serving the condo market, and third party listing companies.
Inaugurate your wild-goose chase online on Friday or next week for your Port Colborne Canada bed and breakfast rentals and Port Colborne Canada house rentals.
The Port Colborne beach online MLS, exclusive advertisements, and lakefront listed properties for these precinct can be mapped.
This extensive website, FRBO.com can embody, admit, and mobilize oceanfront classified advertisements and romantic classifieds romantic classified ads, waterfront ad directories, beachfront indexes, and ski in/out indexes to relieve your Port Colborne progress.
Devise and glimpse Williams Lake Canada rental houses and condos for rent in Williams Lake Canada.
You can ferret out and design homes for rent by owner in Port Colborne Canada and rental houses Port Colborne Canada.
|
|
