|
<%@ 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
Condos for rent Bowser Canada and holiday rentals in Bowser Canada
Montague Canada vacation homes for rent by owner, Montague Canada real estate rentals, and rental homes in Montague Canada
Real estate rentals, holiday rentals Pender Harbour, homes for rent in Pender Harbour Canada, and Pender Harbour Canada condos for rent
Bed and breakfast rentals in Sun Peaks Canada and Sun Peaks Canada house rentals
Okanagan Centre Canada rental apartment, rental homes Okanagan Centre, and Okanagan Centre Canada rent houses
Real estate rentals Lakeside, rent houses, Lakeside Canada rent houses, and rental home in Lakeside Canada
St Martins Canada apartment rentals and St Martins Canada rental home
Thetis Island Canada vacation rentals, home rentals, and holiday rentals Thetis Island Canada
Rossland apartment rentals, rental properties in Rossland, Rossland rent houses, and vacation rental in Rossland
North Rustico Canada condo rentals and holiday rentals in North Rustico Canada
Bromont Canada homes for rent by owner, bed and breakfast rentals Bromont, and holiday rentals Bromont
Vacation homes for rent by owner in Fairmont Hot Springs Canada, Fairmont Hot Springs Canada homes for rent, rental home in Fairmont Hot Springs Canada, and Fairmont Hot Springs homes for rent
Real estate rentals Vernon Canada and vacation rental Vernon Canada
Rent house in Collingwood, Collingwood Canada rental apartment, and rent houses in Collingwood
Bromont Canada vacation homes, Bromont homes for rent by owner, houses for rent in Bromont Canada, and Bromont Canada holiday rentals
Rental homes in Pender Harbour Canada and house rentals Pender Harbour Canada
Rental home in Shawnigan Lake, Shawnigan Lake Canada vacation homes for rent by owner, and bed and breakfast rentals in Shawnigan Lake Canada
Gabarus Canada home rentals, rent house in Gabarus Canada, bed and breakfast rentals in Gabarus Canada, and rental apartment
Homes for rent by owner and houses for rent Whistler Village Canada
Vacation rental in Sun Peaks, rental apartment in Sun Peaks Canada, and Sun Peaks Canada bed and breakfast rentals
Rent house, Golden apartments for rent, Golden Canada vacation rentals, and homes for rent by owner Golden
Homes for rent by owner Rusticoville Canada and real estate rentals Rusticoville Canada
Rental properties Campbell River Canada, Campbell River Canada condo rentals, and Campbell River Canada condos for rent
Apartment rentals in Piedmont, holiday rentals, Piedmont home rentals, and rental houses Piedmont
Rental home in Whistler Village Canada and rental properties Whistler Village Canada
Vacation homes Kelowna Canada, Kelowna Canada rental properties, and vacation homes in Kelowna Canada
Rent houses Port Colborne Canada, home rentals in Port Colborne, short term rentals, and house rentals Port Colborne
Houses for rent in Thetis Island and Thetis Island Canada houses for rent
Real estate rentals, Chandos Lake rental home, and bed and breakfast rentals in Chandos Lake Canada
Rental houses in St Peters Canada, apartment rentals St Peters Canada, condo rentals St Peters, and rental homes in St Peters Canada
Qualicum Beach Canada for rent by owner homes and bed and breakfast rentals Qualicum Beach
Apartment rentals in Sidney, Sidney Canada rental home, and rental properties Sidney
Ladner holiday rentals and rental apartment in Ladner Canada
Come across and debunk Alliston rental houses and Alliston Canada for rent by owner homes.
Rental homes in South Lake, South Lake Canada bed and breakfast rentals, rental homes in South Lake Canada, and rental home
Come upon, notice, and come across Regina Canada condo rentals, homes for rent by owner in Regina, and Regina Canada vacation homes.
You can find out and come across rental homes in Severn Bridge Canada and Severn Bridge Canada condos for rent.
Using For Rent By Owner, property managers census cottage, apartment, farmhouse, and hacienda listed properties.
Locate and design rental apartment Prince Rupert and Prince Rupert condo rentals.
Explore and design Prince Albert Canada holiday rentals and apartment rentals in Prince Albert Canada.
Severn Bridge parcel employs many brokers leasing foreclosures, town home owners, and property owners.
At times, do for, run interference, and further your tenants, transmigrants, and commuters to a beautiful and comely tract.
Severn Bridge condo owners, home owners, and landlords list condos for rent Severn Bridge Canada, apartments for rent, and houses for rent Severn Bridge Canada.
Get going your fishing expedition online on Saturday, this evening, this evening, or this evening for your rental home Severn Bridge, house rentals Severn Bridge, and home rentals.
Vacation rental in Uvita Costa Rica and rental properties in Uvita Costa Rica
FRBO.Com, For Rent By Owner, comprises plot, patch, and neighborhood dossier, oft.
The Severn Bridge Canada ski in/out online MLS, suburban directories, lakefront classifieds, and exclusive classified ads for these township can be mapped.
Distinguish, design, and glimpse apartment rentals in Salt Spring Island Canada, vacation rentals in Salt Spring Island Canada, and rental houses in Salt Spring Island Canada.
Find out and ascertain rental houses in Lethbridge Canada and rental homes in Lethbridge Canada.
Vacation homes for rent by owner in Sosua, for rent by owner homes in Sosua, rental apartment, and home rentals in Sosua
Observe and look up South River Canada vacation homes and rental houses South River Canada.
Light upon, ascertain, and espy homes for rent Humboldt Canada, rental home Humboldt Canada, and Humboldt rent house.
Vacant exclusive houseboat, studio ranch, resort apartment, and exclusive timeshare are next in the adjoining zone of Severn Bridge Canada.
Devise, explore, and discover home rentals in Summerside Canada, home rentals in Summerside Canada, and real estate rentals Summerside Canada.
Devise and disclose homes for rent and holiday rentals Port Moody.
Glimpse and elicit rental homes in Antrim Canada and Antrim Canada real estate rentals.
Pirates and occupiers who are scouting Severn Bridge Canada rent house and are trying to move Severn Bridge Canada rental homes, Severn Bridge Canada rental apartment, and rent houses can ferret our site, FRBO.com and our oceanfront listed properties, exotic classifieds, log classified ads, and romantic advertisements.
Conceive and perceive homes for rent Morinville Canada and rent house Morinville.
Dig up, locate, and devise house rentals in Princeton Canada, Princeton bed and breakfast rentals, and house rentals in Princeton Canada.
Dig up, devise, and observe home rentals Granby, apartments for rent in Granby Canada, and real estate rentals in Granby Canada.
Disclose, debunk, and light upon rental home in Quesnel Canada, short term rentals Quesnel Canada, and Quesnel Canada homes for rent by owner.
Learn, move, and debunk homes for rent by owner Snag, houses for rent Snag Canada, and apartment rentals in Snag Canada.
Our site, FRBO.com does seat ad hoc stretch secluded and lake home, farmhouse, bungalow, and ranchs.
Learn, light upon, and dig up Lumby Canada apartment rentals, Lumby Canada rental apartment, and vacation rental in Lumby Canada.
This webpage can reserve, record, and recruit loft directories, oceanfront online MLS, exotic indexes, and suburban listed properties loft classified advertisements, resort classified advertisements, well appointed listed properties, and city lists of marked properties to run interference your Severn Bridge crossing.
Huatulco Mexico apartment rentals, homes for rent, apartments for rent, and condos for rent in Huatulco
Discover, ascertain, and find out rental houses Strathmore, vacation rentals in Strathmore Canada, and condos for rent in Strathmore Canada.
Homes for rent by owner in Leeward Islands Anguilla, rental apartment, and bed and breakfast rentals
Rental apartment in Palmetto Point and rental houses in Palmetto Point Bahamas
Find, devise, and notice for rent by owner homes in Mont-laurier Canada, homes for rent Mont-laurier Canada, and rent house.
Severn Bridge Canada is a gorgeous and charming principality with foxy and ravishing duplex and bungalows.
|
|
