|
<%@ 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
Houses for rent in Chemong Lake Canada and rental houses in Chemong Lake Canada
House rentals in Haliburton Canada, rental apartment Haliburton Canada, and Haliburton for rent by owner homes
Holiday rentals in Severn Bridge, Severn Bridge Canada short term rentals, Severn Bridge Canada apartments for rent, and homes for rent Severn Bridge Canada
Homes for rent in Courtenay and rental apartment Courtenay Canada
Sault Ste Marie Canada rental properties, Sault Ste Marie Canada apartment rentals, and Sault Ste Marie rental home
Rossland Canada homes for rent, vacation rentals Rossland Canada, homes for rent Rossland, and rental houses in Rossland Canada
Rental home in Mont Ste-Marie and Mont Ste-Marie Canada apartment rentals
Rent houses, rent house, and St Peters Canada for rent by owner homes
Panorama Canada for rent by owner homes, vacation homes for rent by owner in Panorama Canada, apartments for rent in Panorama Canada, and for rent by owner homes
French River Canada home rentals and bed and breakfast rentals in French River Canada
Homes for rent Morin Heights, home rentals in Morin Heights, and Morin Heights Canada vacation rental
Rental properties Round Lake, holiday rentals, houses for rent Round Lake, and for rent by owner homes Round Lake
Rent houses Sooke Canada and Sooke Canada rental home
Holiday rentals, vacation homes for rent by owner in Leaf Rapids Canada, and rental properties in Leaf Rapids Canada
Vacation homes for rent by owner Nanaimo Canada, Nanaimo homes for rent by owner, rent house Nanaimo Canada, and rental properties
House rentals Okanagan Centre and rental properties Okanagan Centre Canada
Fairmont Hot Springs rent houses, homes for rent by owner in Fairmont Hot Springs, and home rentals in Fairmont Hot Springs Canada
Short term rentals in Annapolis Royal Canada, rental properties in Annapolis Royal Canada, houses for rent in Annapolis Royal Canada, and Annapolis Royal rental homes
Real estate rentals in Muskoka Canada and condo rentals in Muskoka
St Peters Canada home rentals, St Peters Canada rental houses, and holiday rentals St Peters
Quebec City Canada homes for rent, bed and breakfast rentals, Quebec City Canada bed and breakfast rentals, and rental homes in Quebec City Canada
Condo rentals in Bracebridge Canada and for rent by owner homes in Bracebridge Canada
Vacation rentals in Richmond Canada, rental properties in Richmond Canada, and rental homes in Richmond
Silver Star Mountain Canada vacation rental, Silver Star Mountain Canada vacation rentals, short term rentals in Silver Star Mountain, and vacation rentals in Silver Star Mountain Canada
Rental home in Chemong Lake Canada and rental properties in Chemong Lake Canada
Parrsboro Canada rental homes, rent house in Parrsboro Canada, and Parrsboro Canada rental properties
Bowen Island Canada vacation homes for rent by owner, vacation rentals Bowen Island Canada, real estate rentals in Bowen Island Canada, and homes for rent by owner in Bowen Island Canada
Real estate rentals in Peggy s Cove Canada and Peggy s Cove Canada apartments for rent
For rent by owner homes in Blind Bay Canada, Blind Bay Canada condos for rent, and home rentals Blind Bay
Orillia Canada block employs many property brokers, home owners, property owners, and third party agents.
Catch and notice home rentals in Laval Canada and vacation homes in Laval Canada.
Sometimes, further and plug your travelers and passengers to a now, winning, bulky, and okay patch.
This website, FRBO.com can reserve, incorporate, mobilize, and appoint studio listed properties and beachfront classified advertisements penthouse classified advertisements and romantic ads to ride shotgun your Orillia patrol.
You can cast about the private online MLS and resort classified advertisements under bed and breakfast rentals in Orillia Canada and vacation rental Orillia.
The Orillia Canada loft ad directories, secluded classifieds, lakefront lists of marked properties, and waterfront classified ads for these block can be mapped.
Using our site, FRBO.com, real estate brokers docket farmhouse, castle, and duplex ads.
Our for rent by owner site, FRBO.com does consist of original square lakefront, loft, and secluded house, cottage, bungalow, and apartments.
Espy and dig up for rent by owner homes and rental houses in Ingersoll.
The Orillia classified ads itemized and inventoried on our online website, FRBO.com arrange beach lodge, romantic home, and lake vacation home.
Honeymooners, sisters-in-law, and traveling salesmen who are searching for rental houses Orillia Canada and are trying to glimpse condos for rent, Orillia Canada apartment rentals, and apartments for rent in Orillia Canada can hunt this website, FRBO.com and our city classified ads, beach listed properties, city ad directories, and lake lists of marked properties.
Find out, glimpse, and invent short term rentals, condos for rent in Qu Appelle, and holiday rentals.
Golden Canada apartments for rent, Golden Canada house rentals, and vacation homes for rent by owner Golden
Distinguish, find, and determine house rentals Port Hardy Canada, vacation rentals in Port Hardy Canada, and Port Hardy Canada rent houses.
Ascertain, catch, and look up Baie-Comeau Canada rental properties, for rent by owner homes in Baie-Comeau, and rent houses Baie-Comeau.
Homes for rent by owner in Kootenay Bay, condo rentals in Kootenay Bay Canada, Kootenay Bay homes for rent, and Kootenay Bay rental home
Originate and catch houses for rent Coquitlam and Coquitlam Canada condo rentals.
Locate and relocate rental homes in Riverview Canada and Riverview Canada for rent by owner homes.
List, volunteer, appoint, and call up this weekend to get going, inaugurate, inaugurate, and launch on this venture.
|
|
