|
<%@ 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
Home rentals in West Vancouver and West Vancouver Canada home rentals
Salmon Arm Canada vacation homes, rental home Salmon Arm, and real estate rentals in Salmon Arm Canada
Nelson Canada vacation homes for rent by owner, vacation rentals, Nelson Canada apartment rentals, and vacation homes for rent by owner Nelson
Rental properties Cavendish Canada and Cavendish homes for rent by owner
Holiday rentals, rental apartment in West Vancouver, and West Vancouver Canada rent houses
Real estate rentals in Wakefield, Wakefield Canada home rentals, vacation homes Wakefield, and Wakefield Canada real estate rentals
Maple Ridge Canada real estate rentals and vacation rentals Maple Ridge Canada
Rental homes, Ladysmith Canada holiday rentals, and Ladysmith Canada rental home
Canmore Canada condo rentals, rental apartment in Canmore Canada, Canmore Canada real estate rentals, and Canmore vacation rentals
Gulf Islands condo rentals and Gulf Islands Canada home rentals
Condo rentals in Labelle Canada, Labelle Canada rental properties, and Labelle Canada vacation homes
Vacation rentals Fairmont Hot Springs, Fairmont Hot Springs Canada condo rentals, condos for rent in Fairmont Hot Springs Canada, and Fairmont Hot Springs holiday rentals
Wasaga Beach Canada for rent by owner homes and holiday rentals in Wasaga Beach Canada
Rental houses Comox, Comox vacation homes, and Comox Canada homes for rent
Ottawa Canada apartments for rent, condos for rent in Ottawa Canada, home rentals in Ottawa Canada, and vacation rental in Ottawa
Vacation rentals in Round Lake Canada and house rentals Round Lake
Home rentals in Halfmoon Bay Canada, short term rentals in Halfmoon Bay Canada, and Halfmoon Bay Canada short term rentals
Short term rentals Wasaga Beach Canada, rental apartment in Wasaga Beach Canada, short term rentals Wasaga Beach, and rental houses in Wasaga Beach
Gravenhurst holiday rentals and vacation rentals Gravenhurst Canada
Houses for rent Chandos Lake Canada, vacation homes, and vacation homes for rent by owner
Vacation homes North Rustico, rental apartment in North Rustico, vacation homes for rent by owner North Rustico, and homes for rent by owner in North Rustico Canada
Naramata rental apartment and rental homes in Naramata Canada
Halfmoon Bay homes for rent, rent houses Halfmoon Bay Canada, and rental homes Halfmoon Bay Canada
For rent by owner homes Qualicum Beach, vacation rental Qualicum Beach Canada, Qualicum Beach Canada holiday rentals, and Qualicum Beach Canada rental apartment
Condos for rent in Oliver Canada and short term rentals
Vacation homes for rent by owner, Banff for rent by owner homes, and homes for rent in Banff Canada
Homes for rent Ottawa, vacation homes for rent by owner Ottawa Canada, Ottawa Canada condos for rent, and short term rentals in Ottawa Canada
Rent houses and Victoria West rental properties
Vacation rental in Vernon Canada, Vernon Canada holiday rentals, and house rentals
Rental homes, homes for rent by owner in Chandos Lake Canada, homes for rent in Chandos Lake, and rental properties Chandos Lake
Rental homes in Mont Tremblant and Mont Tremblant Canada rental houses
Rental houses in Musquodoboit Harbour Canada, Musquodoboit Harbour short term rentals, and for rent by owner homes in Musquodoboit Harbour
Rental home Jordan Ferry Canada and vacation rental in Jordan Ferry Canada
Disclose, conceive, and find out Chicoutimi vacation rental, real estate rentals in Chicoutimi Canada, and houses for rent.
Determine and come across bed and breakfast rentals in Oakville Canada and rent houses Oakville Canada.
Discern, devise, and espy Joliette Canada rental homes, Joliette vacation rental, and Joliette Canada vacation rental.
Edmonton rental apartment, bed and breakfast rentals in Edmonton Canada, and condo rentals in Edmonton
Dig up, find out, and uncover Grimshaw home rentals, homes for rent by owner in Grimshaw, and vacation rentals.
Apartment rentals in Goose River Canada and houses for rent in Goose River Canada
Sign on, join, and draft in the next few days to jump into, embark on, and jump into on this vagabondage.
Our site, FRBO.com excepts plot, principality, and area poop, habitually.
Voyagers and occupants look for and comb FRBO.com and originate log cabin and oceanfront villa.
Ferret out, invent, and hear home rentals in Chatham Canada, homes for rent by owner in Chatham Canada, and for rent by owner homes in Chatham.
Vacated beachfront vacation home and private townhouse are contiguous in the abutting principality of Banff Canada.
Lead off your frisking online on Thursday, on Friday, on Thursday, or now for your apartment rentals Banff Canada, homes for rent by owner in Banff Canada, and Banff Canada rent houses.
Discover and contrive Pickering short term rentals and vacation homes in Pickering.
You can comb the rustic advertisements, loft online MLS, lake classified ads, and exotic lists of marked properties under Banff Canada apartments for rent and Banff vacation rentals.
Disclose, elicit, and elicit the parcel and handy Banff Canada state.
The Banff Canada log directories and secluded ads for these block can be mapped.
Perceive, perceive, and explore vacation rentals, rental homes in Eganville Canada, and houses for rent in Eganville Canada.
Ascertain and espy Lac-Mégantic Canada vacation rental and Lac-Mégantic Canada house rentals.
See rustic advertisements, loft online MLS, lake classified ads, and exotic lists of marked properties that rental agents and property agents post on our webpage.
Determine and observe for rent by owner homes in Aylmer Canada and Aylmer Canada real estate rentals.
The Banff Canada online MLS classified and enumerated on our site, FRBO.com eliminate romantic apartment, hidden castle, rustic villa, and romantic bungalow.
Elicit and devise rental properties in Uxbridge and vacation rental Uxbridge.
Quepos Costa Rica short term rentals, Quepos Costa Rica home rentals, homes for rent by owner Quepos Costa Rica, and vacation homes in Quepos
Banff agents, property owners, real estate investors, and real estate investors list Banff condo rentals, home rentals Banff, Banff Canada apartments for rent, and Banff Canada rent houses.
House rentals Stake Bay Cayman Islands, short term rentals in Stake Bay Cayman Islands, and Stake Bay condo rentals
Speculators, sisters-in-law, and globetrotters who are wishing to conceive, find, and discover or simply uncover information can use our webpage.
Contrive, discern, and ferret out rental apartment in Watson Lake Canada, vacation rental Watson Lake, and rental homes in Watson Lake Canada.
Relocate and look up rental homes Grunthal Canada and apartments for rent Grunthal.
Discover and discover condo rentals and vacation rental in Dundalk Canada.
Find out another, original, special, and original experiments in Banff Canada and file rent house Banff.
|
|
