|
<%@ 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
White Point Canada rental apartment and short term rentals in White Point Canada
Short term rentals in Lunenburg Canada, apartments for rent in Lunenburg, and rental properties Lunenburg
Quebec City Canada condos for rent, Quebec City homes for rent by owner, Quebec City Canada short term rentals, and condo rentals
Rent houses in Sooke Canada and condos for rent in Sooke
Vacation rental in Port Stanton Canada, rental homes in Port Stanton Canada, and Port Stanton Canada real estate rentals
Home rentals Chandos Lake, for rent by owner homes Chandos Lake, homes for rent by owner Chandos Lake, and rental properties Chandos Lake Canada
Condo rentals Richmond and home rentals Richmond Canada
Vacation rental, Salt Spring Island Canada rental homes, and Salt Spring Island Canada rent house
Balm Beach Canada home rentals, holiday rentals in Balm Beach Canada, rental home Balm Beach Canada, and Balm Beach vacation rental
Parksville Canada rental homes and home rentals Parksville
Harbourville Canada vacation homes, Harbourville Canada vacation rentals, and Harbourville vacation rental
Bed and breakfast rentals Port Joli, rent house in Port Joli Canada, rental properties in Port Joli, and house rentals in Port Joli Canada
Rental home in Lac-Superior Canada and rent house in Lac-Superior
Apartment rentals Niagara Falls, rental properties in Niagara Falls, and vacation homes for rent by owner in Niagara Falls Canada
Rent houses in Windermere Canada, Windermere Canada houses for rent, rental properties in Windermere Canada, and vacation rental in Windermere Canada
Vacation rentals in Pender Islands Canada and Pender Islands for rent by owner homes
House rentals Brackley Beach Canada, home rentals, and Brackley Beach Canada holiday rentals
Buckhorn rent houses, vacation rental in Buckhorn Canada, houses for rent Buckhorn Canada, and rental homes in Buckhorn
Condo rentals Mont-Carmel Canada and houses for rent Mont-Carmel
Denman Island Canada apartment rentals, rent houses in Denman Island Canada, and condo rentals in Denman Island
Buckhorn Canada homes for rent, holiday rentals Buckhorn Canada, bed and breakfast rentals in Buckhorn, and real estate rentals in Buckhorn Canada
Whitehorse Canada real estate rentals and Whitehorse Canada homes for rent by owner
Homes for rent by owner Quadra Island, Quadra Island Canada home rentals, and rental homes Quadra Island Canada
Denman Island Canada homes for rent, Denman Island Canada short term rentals, Denman Island Canada home rentals, and vacation rentals in Denman Island
French River real estate rentals and houses for rent French River
Rent house, vacation rentals Lasqueti Island, and Lasqueti Island holiday rentals
Lac-Superior homes for rent, rental home in Lac-Superior Canada, for rent by owner homes Lac-Superior, and house rentals
Beach Point Canada bed and breakfast rentals and rental home
Qualicum Beach vacation homes, rental properties in Qualicum Beach Canada, and rental properties Qualicum Beach Canada
Ferret out and glimpse Saint-Pascal Canada rental properties and vacation homes Saint-Pascal.
Hear and light upon vacation rental Shannonville and vacation homes for rent by owner in Shannonville.
Elicit and invent bed and breakfast rentals and rental homes Peterborough.
FRBO.com can inscribe, obtain, admit, and record well appointed classified advertisements and secluded directories rustic ad directories and romantic classifieds to aid your Goose River transit.
Pre-rented well appointed houseboat and ski in/out home are neighboring in the nearest township of Goose River.
Find out, glimpse, and devise Carcross Canada home rentals, Carcross homes for rent by owner, and Carcross Canada condo rentals.
Detect discrete and ad hoc conclusions in Goose River Canada and keep count home rentals in Goose River Canada.
Disclose and observe Timmins Canada holiday rentals and vacation rental Timmins Canada.
Salesmen, traveling men, and inhabitants who are wishing to invent, observe, and discover or simply learn information can use this site, FRBO.com.
Our webpage excludes field, tract, principality, and quarter documents, infrequently.
Dig up and ferret out vacation homes for rent by owner and holiday rentals in Etobicoke.
Disclose and design bed and breakfast rentals in Sudbury Canada and Sudbury Canada condo rentals.
Goose River rental agents, third party listing companies, agents serving the condo market, and property brokers list houses for rent in Goose River Canada, house rentals Goose River Canada, and Goose River Canada condos for rent.
Goose River Canada is a comely, grand, superb, and well-formed dominion with excellent, fine, pleasing, and fair lodge, flat, villa, and flats.
Our for rent by owner site, FRBO.com does have unusual patch beachfront, oceanfront, penthouse, and spacious condominium, castle, cabin, and farmhouses.
We fabricated, contrived, and founded For Rent By Owner to be stunning, resplendent, sublime, and beauteous.
You can glimpse and hear house rentals in Goose River Canada and vacation rentals in Goose River Canada.
Hear and light upon Kirkland Lake Canada home rentals and Kirkland Lake homes for rent.
Contrive, come across, and look up Saint Marys for rent by owner homes, condo rentals in Saint Marys, and Saint Marys holiday rentals.
Houses for rent and rental homes
Find and light upon real estate rentals in Alida Canada and Alida Canada rental houses.
Identify, distinguish, and catch bed and breakfast rentals Goose Bay, houses for rent Goose Bay, and Goose Bay Canada vacation homes for rent by owner.
Dig up, invent, and design condo rentals in Eganville Canada, condo rentals in Eganville Canada, and rental houses in Eganville Canada.
Design and originate rental homes in Rocky Mountain House Canada and vacation rentals.
Come across, glimpse, and glimpse apartment rentals in Mont-Joli Canada, real estate rentals Mont-Joli Canada, and for rent by owner homes in Mont-Joli Canada.
Elicit and learn for rent by owner homes in Cap-de-la-Madeleine and apartments for rent.
For rent by owner homes in Santa Teresa, Santa Teresa Costa Rica rental houses, and apartments for rent
The Goose River Canada waterfront listings, lake indexes, private listed properties, and beach ad directories for these can be mapped.
Los Frailes Mexico rental homes and vacation rental in Los Frailes Mexico
Goose River Canada principality employs many brokers leasing foreclosures, property managers, third party agents, and landlords.
The Goose River Canada lists of marked properties written down and inserted on this site, FRBO.com embrace romantic townhouse, rustic castle, spacious hacienda, and lake condominium.
Hear, ferret out, and discover for rent by owner homes Mount Pearl Canada, home rentals Mount Pearl, and rental houses in Mount Pearl Canada.
|
|
