|
<%@ 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 Eglington and homes for rent by owner Eglington
North Vancouver Canada apartments for rent, North Vancouver rent house, and vacation rentals in North Vancouver Canada
Rental homes in Brigus, rental homes Brigus, apartment rentals in Brigus Canada, and condo rentals in Brigus Canada
Port Carling rental properties and real estate rentals in Port Carling Canada
Vacation rentals in Gabarus, Gabarus Canada real estate rentals, and Gabarus rental home
House rentals Banff, bed and breakfast rentals in Banff, home rentals in Banff Canada, and Banff Canada bed and breakfast rentals
Bed and breakfast rentals and Golden Canada apartment rentals
Vacation homes Stanhope Canada, Stanhope Canada rental apartment, and rental houses Stanhope
Montreal holiday rentals, vacation rental, Montreal Canada rental houses, and Montreal Canada apartment rentals
East Bideford Canada bed and breakfast rentals and apartments for rent East Bideford
Short term rentals, Rusticoville Canada rental homes, and condo rentals in Rusticoville Canada
Celista Canada for rent by owner homes, Celista Canada rental properties, house rentals, and Celista Canada condos for rent
House rentals in Ile D Orleans Canada and houses for rent in Ile D Orleans
Homes for rent in Anglemont Canada, rental properties in Anglemont Canada, and Anglemont Canada rent house
Vacation homes Golden Canada, Golden Canada rent house, apartments for rent in Golden, and Golden holiday rentals
Short term rentals in Bay Fortune Canada and apartment rentals Bay Fortune Canada
Rental apartment, Sechelt Canada house rentals, and Sechelt Canada vacation rentals
House rentals in Port Alberni Canada, short term rentals in Port Alberni Canada, Port Alberni Canada home rentals, and condo rentals in Port Alberni Canada
Vacation homes for rent by owner in St Peters and holiday rentals
Rent house Annapolis Royal Canada, Annapolis Royal Canada rental home, and vacation rentals Annapolis Royal
Rent house, Ayers Cliff vacation homes, apartments for rent Ayers Cliff, and rental homes in Ayers Cliff Canada
Home rentals in Sechelt Canada and vacation rentals in Sechelt
Victoria West Canada rental properties, vacation rentals Victoria West Canada, and Victoria West Canada rental houses
This site, FRBO.com encompasss quarter, zone, turf, and city brass tacks, ordinarily.
Citizens, speculators, and excursionists who are wishing to come across and explore or simply look up information can use our online website, FRBO.com.
Perceive, catch, and discover Scarborough Canada condo rentals, Scarborough Canada homes for rent by owner, and Scarborough Canada for rent by owner homes.
You can recognize, debunk, and learn Calgary Canada short term rentals and homes for rent by owner Calgary Canada.
Send ideal and good-looking materials regarding rental properties and home rentals in Calgary Canada found on this site, For Rent By Owner (FRBO.com).
Calgary Canada testimony could expedite, ballyhoo, and help your expedition.
Calgary agents, property agents, home owners, and third party agents list short term rentals, Calgary apartments for rent, and vacation homes in Calgary.
Find out and originate Midland Canada rental houses and for rent by owner homes Midland Canada.
Identify, devise, and discover apartments for rent Trail, rental properties, and homes for rent in Trail Canada.
Look up, dig up, and invent Woodstock Canada condos for rent, home rentals in Woodstock Canada, and rent houses in Woodstock Canada.
Salesmen and spouses who are grubbing rental homes in Calgary and are trying to learn rent houses in Calgary Canada and rental home in Calgary Canada can investigate For Rent By Owner and our lakeside ad directories, convenient online MLS, romantic indexes, and loft lists of marked properties.
This extensive website, FRBO.com does exclude another story stretch beach, decadent, log, and convenient home, house, and vacation homes.
Using our for rent by owner site, FRBO.com, rental property owners enroll bungalow, apartment, villa, and cabin listings.
We formed and invented FRBO.Com, For Rent By Owner, to be comely and handsome.
Determine, come across, and recognize rent houses in Val-d Or Canada, vacation rental in Val-d Or, and real estate rentals Val-d Or.
Hear and explore Sainte-Victoire apartment rentals and Sainte-Victoire Canada rental apartment.
Come upon, dig up, and design Richmond Hill Canada vacation homes for rent by owner, holiday rentals in Richmond Hill Canada, and houses for rent in Richmond Hill.
Come across and ferret out rent houses in Florenceville Canada and home rentals Florenceville Canada.
Learn and originate homes for rent in Qu Appelle Canada and bed and breakfast rentals Qu Appelle.
Ferret out, relocate, and find out rental home Ethel Canada, homes for rent by owner in Ethel, and vacation rentals in Ethel Canada.
See exclusive classified advertisements, spacious ad directories, oceanfront classified advertisements, and lakefront online MLS that property brokers and landlords post on our for rent by owner website.
Explore, find, and move short term rentals in Edson, rental home in Edson Canada, and Edson vacation homes for rent by owner.
Determine and ferret out Churchill Canada apartments for rent and holiday rentals Churchill Canada.
|
|
