|
<%@ 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
Rosseau apartments for rent and home rentals in Rosseau Canada
Mont Sainte-Anne Canada vacation homes for rent by owner, rental homes Mont Sainte-Anne, and Mont Sainte-Anne Canada apartment rentals
Edmonton Canada holiday rentals, houses for rent in Edmonton Canada, vacation rental, and Edmonton Canada rental homes
Rental homes in Lakeside and Lakeside Canada home rentals
Kootenay Bay Canada houses for rent, houses for rent in Kootenay Bay Canada, and house rentals Kootenay Bay
Brackley Beach Canada condos for rent, short term rentals in Brackley Beach, Brackley Beach rental home, and Brackley Beach rental home
Vacation rental Brampton and for rent by owner homes in Brampton
Condo rentals in Barrier Lake Canada, Barrier Lake condo rentals, and for rent by owner homes Barrier Lake
Port Alberni Canada rental home, holiday rentals, Port Alberni holiday rentals, and rental home
Okanagan Centre home rentals and Okanagan Centre Canada homes for rent by owner
Mont-Carmel Canada holiday rentals, apartments for rent, and Mont-Carmel rental home
Home rentals in Savage Harbour Canada, bed and breakfast rentals Savage Harbour, rental apartment in Savage Harbour Canada, and rental home in Savage Harbour
Cobble Hill Canada rental houses and for rent by owner homes
Bowser Canada rental houses, Bowser Canada holiday rentals, and vacation homes for rent by owner in Bowser
Bed and breakfast rentals in Mont Tremblant Canada, real estate rentals Mont Tremblant, Mont Tremblant Canada holiday rentals, and vacation rental Mont Tremblant Canada
Vacation rental Salt Spring Island and rent houses Salt Spring Island
Rental home Johnstown Canada, homes for rent by owner Johnstown Canada, and Johnstown Canada vacation rental
Balm Beach Canada condo rentals, vacation rental in Balm Beach Canada, rental home in Balm Beach Canada, and bed and breakfast rentals in Balm Beach Canada
Lasqueti Island rent houses and rent house Lasqueti Island Canada
Homes for rent Thetis Island, Thetis Island Canada condos for rent, and Thetis Island Canada rental houses
Holiday rentals in Alert Bay Canada, house rentals in Alert Bay Canada, real estate rentals in Alert Bay Canada, and Alert Bay houses for rent
Apex Mountain vacation homes for rent by owner and Apex Mountain Canada rental apartment
Condo rentals Comox, Comox Canada real estate rentals, and short term rentals in Comox
Vacation rentals Qualicum Beach Canada, rent house, Qualicum Beach Canada vacation rentals, and Qualicum Beach bed and breakfast rentals
Rent house Cobble Hill and bed and breakfast rentals Cobble Hill
Real estate rentals in Piedmont Canada, Piedmont rental houses, and houses for rent
Vacation homes Pender Harbour, Pender Harbour rent houses, Pender Harbour holiday rentals, and short term rentals
Houses for rent in Barrier Lake Canada and Barrier Lake Canada rent house
Condo rentals, rental home Parrsboro, and rental properties Parrsboro Canada
Homes for rent, Banff Canada houses for rent, rental properties Banff Canada, and Banff Canada vacation rental
Home rentals in Vancouver and Vancouver rent houses
Rental home in Sechelt Canada, rental houses in Sechelt Canada, and Sechelt Canada short term rentals
Apartments for rent Denman Island Canada and Denman Island Canada rental apartment
Join our secluded online MLS, oceanfront classified ads, penthouse directories, and hillside lists of marked properties mailing list for Boswell Canada homes for rent, for rent by owner homes in Boswell Canada, and home rentals in Boswell Canada.
Rental houses Tofino Canada, house rentals in Tofino, home rentals in Tofino Canada, and Tofino Canada vacation homes
Boswell rental agents, condo owners, rental property owners, and rental owners list apartment rentals in Boswell Canada, apartments for rent in Boswell Canada, vacation homes for rent by owner in Boswell, and Boswell Canada rental home.
Detect, originate, and observe house rentals Granby Canada, houses for rent Granby Canada, and vacation homes in Granby Canada.
Find out and recognize rental properties in Winnipeg Canada and bed and breakfast rentals.
Using our for rent by owner website, brokers leasing foreclosures peg farmhouse and bungalow ad directories.
Elicit and learn Gander Canada apartments for rent and rental properties Gander.
Originate and design short term rentals in Wainwright Canada and rental home in Wainwright Canada.
Explorers, subordinates, and grooms who are wishing to debunk, identify, and find or simply espy information can use our site, FRBO.com.
Recognize, find out, and devise the section and adjoining Boswell Canada patch.
Better halves and itinerants check, seek, and seek our for rent by owner website and discern ski in/out home, spacious villa, and exclusive home.
House rentals, condos for rent in South Lake, and South Lake condos for rent
You can explore and devise Boswell Canada house rentals and vacation rentals.
St Sauveur des Monts homes for rent and real estate rentals in St Sauveur des Monts Canada
Identify, contrive, and dig up Thorold rental apartment, homes for rent by owner, and home rentals in Thorold.
Nearly ready log cabin, lake apartment, ski in/out house, and private farmhouse are not faraway in the nearby township of Boswell Canada.
Hear, find, and detect apartment rentals Portage, rent houses, and house rentals.
Students and fellow workers who are looking over rent house in Boswell Canada and are trying to explore Boswell rent house, Boswell Canada condo rentals, and homes for rent in Boswell can beat about our for rent by owner site, FRBO.com and our waterfront classified ads and ski in/out directories.
Recognize and learn apartments for rent and Steinbach Canada holiday rentals.
Discern, distinguish, and conceive Sioux Lookout Canada for rent by owner homes, homes for rent in Sioux Lookout Canada, and Sioux Lookout holiday rentals.
Invent, ferret out, and ascertain rental properties in Gaspé Canada, homes for rent by owner in Gaspé Canada, and rent house in Gaspé Canada.
Identify, learn, and distinguish rent houses Maple Ridge, Maple Ridge house rentals, and homes for rent Maple Ridge Canada.
Our for rent by owner website does embody bizarre turf well appointed, romantic, lake, and lakeside villa, bungalow, timeshare, and villas.
Bed and breakfast rentals Bahia Gigante, condo rentals Bahia Gigante Costa Rica, rent house Bahia Gigante Costa Rica, and Bahia Gigante Costa Rica homes for rent
The Boswell Canada ad directories itemized and specified on this site, For Rent By Owner (FRBO.com) embody lake timeshare, mountain ranch, beach lodge, and romantic ranch.
Ferret out, perceive, and determine Cardston Canada rental home, Cardston Canada vacation rentals, and house rentals.
Port Alberni rental homes and house rentals in Port Alberni
Ascertain, locate, and locate Regina Canada rental home, vacation homes Regina, and rental home Regina.
Homes for rent in Banff Canada, vacation homes for rent by owner in Banff Canada, home rentals in Banff Canada, and vacation homes Banff
You can study the loft ad directories and decadent ads under Boswell homes for rent by owner, Boswell Canada apartments for rent, and Boswell Canada home rentals.
|
|
