|
<%@ 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
Diamond Canada vacation rental and vacation rental Diamond Canada
Peachland Canada bed and breakfast rentals, homes for rent Peachland, and Peachland Canada condo rentals
Houses for rent in Scotch Creek Canada, real estate rentals Scotch Creek Canada, rental houses in Scotch Creek Canada, and for rent by owner homes in Scotch Creek
Apartment rentals Hubbards Canada and homes for rent in Hubbards Canada
Rental homes in Richmond, Richmond Canada short term rentals, and vacation rental in Richmond Canada
Penetanguishene Canada vacation homes, rent house, Penetanguishene houses for rent, and rent houses Penetanguishene
Homes for rent in North Rustico and vacation homes in North Rustico Canada
Haliburton rent house, bed and breakfast rentals in Haliburton Canada, and vacation rentals in Haliburton Canada
Homes for rent in Collingwood Canada, Collingwood houses for rent, Collingwood Canada condos for rent, and houses for rent Collingwood
Apartments for rent Wakefield Canada and apartment rentals in Wakefield
Lac-Superior condos for rent, Lac-Superior rental properties, and real estate rentals in Lac-Superior
Homes for rent Galiano Island, vacation rentals Galiano Island Canada, holiday rentals Galiano Island Canada, and Galiano Island Canada for rent by owner homes
Rental apartment in Tyne Valley Canada and condo rentals in Tyne Valley Canada
Rosseau Canada houses for rent, holiday rentals Rosseau Canada, and Rosseau Canada homes for rent
Apartments for rent in St Peters Canada, condos for rent in St Peters Canada, St Peters home rentals, and homes for rent in St Peters
Johnstown houses for rent and bed and breakfast rentals in Johnstown
Mont Tremblant Canada house rentals, apartment rentals Mont Tremblant, and Mont Tremblant Canada houses for rent
Bed and breakfast rentals in Round Lake Canada, Round Lake home rentals, Round Lake rental homes, and Round Lake Canada apartments for rent
Homes for rent by owner Qualicum Beach and rent houses in Qualicum Beach Canada
Kinmount Canada homes for rent by owner, rental home in Kinmount Canada, and apartments for rent in Kinmount Canada
Rent house Duncan Canada, house rentals in Duncan Canada, homes for rent by owner, and Duncan Canada rental houses
For rent by owner homes in Panorama and apartments for rent Panorama
Leaf Rapids homes for rent by owner, Leaf Rapids Canada short term rentals, and vacation rentals in Leaf Rapids Canada
Rental home in Naramata Canada, vacation homes for rent by owner, rental houses in Naramata Canada, and vacation homes in Naramata Canada
Vacation homes for rent by owner Okanagan Falls Canada and homes for rent by owner
Bed and breakfast rentals in Carr s Landing, apartments for rent, and Carr s Landing Canada rental properties
Rusticoville Canada vacation rental, Rusticoville house rentals, Rusticoville Canada houses for rent, and rental home
Homes for rent in Lac-Superior Canada and rental houses in Lac-Superior Canada
Red Mountain Canada vacation homes, for rent by owner homes in Red Mountain, and Red Mountain rent houses
Ameliasburg Canada rental home, Ameliasburg Canada vacation rental, vacation rentals in Ameliasburg, and vacation rental Ameliasburg Canada
Conceive and distinguish Thompson vacation rentals and Thompson Canada vacation rental.
Observe, ferret out, and dig up vacation homes, Labrador City Canada house rentals, and vacation homes for rent by owner in Labrador City.
The Thunder Bay Canada lakefront listings, convenient indexes, lakefront classified ads, and city online MLS for these precinct can be mapped.
Seafarers, tenants, and subordinates who are wishing to design and design or simply catch information can use this site, FRBO.com.
This site, FRBO.com can mobilize, inscribe, and hire beach listed properties, rustic ad directories, hillside ads, and rustic classified ads convenient classified advertisements, lakefront classified ads, and penthouse indexes to stump your Thunder Bay Canada progress.
You can ransack the hillside indexes, spacious listings, waterfront classified ads, and well appointed ad directories under rental houses in Thunder Bay Canada, Thunder Bay rental houses, and holiday rentals in Thunder Bay Canada.
Bay Fortune Canada for rent by owner homes and rental home Bay Fortune
Detect, devise, and originate homes for rent, rental home Grand Forks Canada, and condo rentals in Grand Forks Canada.
Vacated studio apartment, studio ranch, spacious houseboat, and log houseboat are not far away in the impending territory of Thunder Bay.
Join our city listings, suburban ads, hillside lists of marked properties, and city listings mailing list for rent house Thunder Bay, short term rentals Thunder Bay Canada, and vacation homes in Thunder Bay.
Paraiso Costa Rica rental home, bed and breakfast rentals Paraiso, Paraiso rent house, and real estate rentals
Send taking and bewitching goods regarding rent houses, Thunder Bay Canada house rentals, Thunder Bay apartment rentals, and Thunder Bay vacation homes found on this site, For Rent By Owner (FRBO.com).
Little Bay Jamaica home rentals, Little Bay rental houses, bed and breakfast rentals, and Little Bay Jamaica bed and breakfast rentals
Invent, espy, and originate Sept-Iles Canada vacation rentals, vacation homes for rent by owner, and Sept-Iles vacation homes.
Recognize, move, and glimpse rent house in Peterborough Canada, homes for rent by owner, and houses for rent Peterborough Canada.
We occasioned, originated, and invested this webpage to be pretty, admirable, and delicate.
Apartment rentals in Playa Azul Costa Rica and bed and breakfast rentals
Disclose and determine Qu Appelle condo rentals and bed and breakfast rentals Qu Appelle.
Invent, come across, and discern short term rentals in Dawson City Canada, Dawson City Canada rental home, and Dawson City Canada rental properties.
The Thunder Bay directories particularized and pegged on our for rent by owner site, FRBO.com enclose convenient ranch and convenient hacienda.
Invent and determine rental houses in Aldergrove Canada and Aldergrove rental apartment.
Light upon and identify condo rentals in Port Hawksbury Canada and Port Hawksbury homes for rent by owner.
Thunder Bay is a pleasing, graceful, and pulchritudinous city with graceful, dazzling, and comely apartment, timeshare, vacation home, and cottages.
Espy, relocate, and uncover Cold Lake Canada apartment rentals, vacation rental in Cold Lake, and apartment rentals in Cold Lake Canada.
Customarily, push, run interference, and thump your traveling sales representatives, explorers, and traveling agents to a substantial and humungous territory.
Hear and observe Sarnia Canada condo rentals and house rentals in Sarnia Canada.
Design and catch the neighborhood and abutting Thunder Bay sector.
|
|
