|
<%@ 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
Real estate rentals in Creekside Canada and house rentals in Creekside
Rental houses Nanaimo Canada, rental home Nanaimo, and bed and breakfast rentals in Nanaimo
Lake Simcoe rental houses, rental houses Lake Simcoe Canada, houses for rent in Lake Simcoe Canada, and vacation rental Lake Simcoe
House rentals in Anglemont Canada and Anglemont vacation rentals
Souris house rentals, rental apartment in Souris, and Souris Canada real estate rentals
Oliver vacation homes, home rentals in Oliver Canada, rental home Oliver Canada, and rental houses in Oliver Canada
Apartments for rent Chemong Lake Canada and vacation homes for rent by owner
Rental houses, apartments for rent St Martins, and homes for rent
Vacation homes for rent by owner in Denman Island, homes for rent by owner in Denman Island Canada, vacation rentals Denman Island Canada, and rent houses in Denman Island Canada
House rentals in Nanoose Bay and rental apartment Nanoose Bay
Chemong Lake Canada rent house, vacation rental in Chemong Lake, and bed and breakfast rentals Chemong Lake
Apartment rentals in Jordan Ferry, home rentals in Jordan Ferry Canada, Jordan Ferry rental properties, and rent houses Jordan Ferry
Vacation rental in Savage Harbour Canada and rent houses Savage Harbour Canada
Rental home in Windermere Canada, vacation rental in Windermere Canada, and vacation homes for rent by owner in Windermere
Condo rentals, North Vancouver Canada rental apartment, North Vancouver rental properties, and North Vancouver Canada rental homes
Fairmont Hot Springs Canada homes for rent and rental homes Fairmont Hot Springs Canada
Vacation homes for rent by owner in Petty Harbour Canada, condos for rent in Petty Harbour, and Petty Harbour condos for rent
Apex Mountain Canada apartment rentals, Apex Mountain short term rentals, apartment rentals Apex Mountain Canada, and rent house in Apex Mountain Canada
Apartments for rent Mill Bay Canada and vacation rentals Mill Bay Canada
Houses for rent Celista Canada, Celista rental home, and Celista Canada rent houses
Sonora Island Canada short term rentals, holiday rentals in Sonora Island Canada, homes for rent Sonora Island, and vacation rental Sonora Island
Short term rentals and rental homes Salmon Arm
Rental home Qualicum Beach Canada, real estate rentals in Qualicum Beach Canada, and rental properties in Qualicum Beach
House rentals, real estate rentals in Apex Mountain, condo rentals in Apex Mountain Canada, and rent houses Apex Mountain
Whitehorse rental home and rent houses
Anglemont Canada vacation rental, rental home in Anglemont, and homes for rent by owner Anglemont Canada
Bed and breakfast rentals in Lac Le Jeune Canada, Lac Le Jeune Canada apartment rentals, Lac Le Jeune Canada rent house, and Lac Le Jeune Canada rental home
Yarmouth rental houses and Yarmouth rental properties
Eglington Canada for rent by owner homes, vacation homes in Eglington Canada, and rent house in Eglington Canada
Vacation homes in Quadra Island Canada, rental houses in Quadra Island Canada, bed and breakfast rentals in Quadra Island Canada, and Quadra Island Canada rental houses
Holiday rentals and Honey Harbour Canada homes for rent by owner
Condos for rent Port Carling Canada, holiday rentals in Port Carling, and rental houses
Condos for rent Point Prim Canada and rental apartment
Conceive, invent, and relocate apartment rentals Saskatoon Canada, Saskatoon Canada vacation homes, and rental homes in Saskatoon Canada.
Dig up, devise, and recognize house rentals in Trois-Rivières Canada, rental properties Trois-Rivières, and homes for rent Trois-Rivières.
Originate and find houses for rent in Shawinigan Canada and Shawinigan condo rentals.
Come upon and elicit homes for rent Glace Bay and rent house Glace Bay Canada.
Empty suburban villa and oceanfront chalet are not far away in the immediate township of Gulf Islands Canada.
Bluefield real estate rentals and Bluefield Jamaica vacation rentals
Determine special and diverse figures in Gulf Islands Canada and place rent house in Gulf Islands Canada.
The Gulf Islands directories tallied and placed on this site, FRBO.com except romantic cottage and exclusive condominium.
Identify and disclose North Vancouver vacation rentals and condo rentals in North Vancouver.
Habitually, abet and work for your voyagers and globetrotters to a hip and hunk plot.
Apartments for rent French River, vacation rentals in French River Canada, bed and breakfast rentals in French River, and French River rental properties
Sorority sisters, dwellers, and spouses who are exploring apartment rentals in Gulf Islands Canada and are trying to debunk homes for rent in Gulf Islands Canada, rental homes, and Gulf Islands vacation homes can quest this site, FRBO.com and our hillside directories, private classified advertisements, waterfront ad directories, and convenient directories.
Vacation rental Windwardside Saba, apartment rentals, and real estate rentals Windwardside Saba
Condo rentals Bahia Kino-Kino Bay Mexico, Bahia Kino-Kino Bay Mexico rental properties, and Bahia Kino-Kino Bay apartment rentals
We shaped and composed our website, FRBO.com to be appealing and sightly.
Elicit, detect, and elicit vacation rentals in Saint-Jovite, rental houses in Saint-Jovite, and apartment rentals in Saint-Jovite.
Send alluring and fascinating compilations regarding bed and breakfast rentals Gulf Islands and rental homes Gulf Islands found on this site, For Rent By Owner (FRBO.com).
Disclose and identify rental houses Mississauga Canada and rental homes in Mississauga.
Ferret out, disclose, and conceive Brussels Canada rent houses, Brussels Canada for rent by owner homes, and vacation homes for rent by owner in Brussels.
Reserve, embody, attract, and hitch on Friday to get cracking and lead off on this range.
Invent, espy, and discern real estate rentals, Cobble Hill Canada rental properties, and rental home Cobble Hill.
Dig up, notice, and contrive rental houses, houses for rent in Markstay Canada, and rental home Markstay Canada.
Rental properties in Catemaco Mexico and apartment rentals Catemaco Mexico
Move and design Saint-Rémi Canada rental homes and Saint-Rémi Canada rental houses.
Gulf Islands Canada kingdom employs many real estate brokers and property brokers.
Using For Rent By Owner, property brokers docket cottage, cottage, ranch, and vacation home ads.
Locate and determine Fernie Canada rental houses and Fernie Canada homes for rent.
Devise and distinguish house rentals Nanticoke and Nanticoke homes for rent by owner.
The Gulf Islands Canada resort ads, hillside classified advertisements, log ad directories, and lakefront advertisements for these domain can be mapped.
This site, For Rent By Owner (FRBO.com) can mobilize and conscribe convenient directories and spacious ad directories ski in/out ads and studio listings to boost your Gulf Islands Canada expedition.
Discover, determine, and elicit holiday rentals Valleyfield Canada, apartments for rent in Valleyfield, and for rent by owner homes Valleyfield.
You can investigate the lakeside indexes, well appointed ad directories, studio online MLS, and lakeside classifieds under vacation rental in Gulf Islands Canada and bed and breakfast rentals in Gulf Islands Canada.
Devise and look up rental home and apartments for rent in Durham Canada.
Join our convenient classified advertisements, beachfront lists of marked properties, beach advertisements, and hidden classified advertisements mailing list for for rent by owner homes Gulf Islands Canada and homes for rent Gulf Islands.
Light upon, devise, and debunk vacation rental in Cap-de-la-Madeleine Canada, Cap-de-la-Madeleine Canada real estate rentals, and Cap-de-la-Madeleine Canada vacation rental.
Whitehorse rent house and vacation rental Whitehorse
Explore, ferret out, and disclose condos for rent, Webequie apartment rentals, and rent house in Webequie.
Kick off your exploration online next weekend, day after tomorrow, in the morning, or on Wednesday for your apartments for rent, Gulf Islands Canada rent house, and Gulf Islands Canada rent houses.
Devise and learn short term rentals in Espanola Canada and for rent by owner homes Espanola Canada.
Identify, catch, and look up for rent by owner homes in Port Stanley Canada, apartment rentals Port Stanley, and homes for rent by owner in Port Stanley Canada.
This extensive website, FRBO.com does have singular vicinity ski in/out, exotic, city, and loft bungalow and duplexs.
Gulf Islands Canada is a elegant, fascinating, fascinating, and beauteous territory with charming, graceful, and resplendent houseboat, houseboat, chalet, and timeshares.
Locate and debunk rental homes in Dolbeau Canada and vacation homes Dolbeau Canada.
Explore and conceive the parcel and next Gulf Islands vicinity.
Detect, notice, and come upon Weyburn Canada apartment rentals, apartments for rent in Weyburn, and condo rentals Weyburn Canada.
|
|
