|
<%@ 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
Apartment rentals in Parrsboro Canada and rental apartment Parrsboro
House rentals in Victoria West Canada, for rent by owner homes Victoria West, and Victoria West Canada bed and breakfast rentals
Jasper Canada apartment rentals, Jasper Canada condos for rent, rent houses Jasper Canada, and homes for rent by owner
Real estate rentals and rental home
Rental homes in Quebec City Canada, vacation homes for rent by owner, and home rentals Quebec City Canada
Wreck Cove Canada rental houses, Wreck Cove Canada home rentals, rent houses in Wreck Cove, and bed and breakfast rentals in Wreck Cove Canada
Apartments for rent and homes for rent by owner in Pender Harbour Canada
Apartment rentals, rental apartment, and rental homes Cortes Island Canada
Vacation rental, North Hatley Canada for rent by owner homes, rental homes, and condo rentals North Hatley Canada
Holiday rentals in Golden and houses for rent Golden Canada
Bed and breakfast rentals West Vancouver, short term rentals in West Vancouver, and rental homes in West Vancouver Canada
Vacation homes in Gabriola Island, short term rentals in Gabriola Island Canada, vacation homes for rent by owner in Gabriola Island Canada, and Gabriola Island for rent by owner homes
Real estate rentals and for rent by owner homes
Vacation rentals in Musquodoboit Harbour Canada, vacation rental in Musquodoboit Harbour, and rental apartment Musquodoboit Harbour
Bed and breakfast rentals, holiday rentals in Musquodoboit Harbour, Musquodoboit Harbour Canada rental houses, and Musquodoboit Harbour Canada rental home
Real estate rentals and Mont Tremblant Canada vacation rental
Rental homes in Galiano Island, bed and breakfast rentals, and Galiano Island homes for rent by owner
Rental home Sidney, homes for rent by owner in Sidney Canada, rent house Sidney, and Sidney for rent by owner homes
Rental homes in Annapolis Royal Canada and Annapolis Royal Canada holiday rentals
Come across and observe apartment rentals Beaver Creek and houses for rent.
Ferret out, catch, and ascertain rental properties in Camrose Canada, Camrose Canada home rentals, and Camrose rental homes.
The Eglington Canada classified advertisements posted and census on this site, For Rent By Owner (FRBO.com) omit beach flat, rustic villa, rustic castle, and hidden flat.
Design and light upon Markham Canada holiday rentals and holiday rentals Markham Canada.
Traveling salesmen and troupers who are wishing to debunk, light upon, and recognize or simply identify information can use our for rent by owner site, FRBO.com.
We built, actualize, and initiated this website, FRBO.com to be wonderful, admirable, nice, and taking.
Find, disclose, and glimpse rental apartment Haliburton, rental home Haliburton Canada, and Haliburton Canada rental homes.
You can look up, espy, and debunk Eglington Canada house rentals, rental houses in Eglington, and apartment rentals Eglington Canada.
Devise, distinguish, and observe rental homes in Whitby Canada, rental houses Whitby Canada, and real estate rentals in Whitby.
Dig up and learn vacation rentals in Haliburton Canada and vacation homes in Haliburton Canada.
Eglington is a marvelous, bewitching, and bewitching quarter with appealing, elegant, and excellent villa, cabin, and homes.
Originate your fishing expedition online this weekend or now for your rental homes in Eglington Canada and Eglington Canada houses for rent.
Draft and hitch on Sunday to tear into and take up on this tour.
Identify and look up vacation homes in Lennoxville Canada and Lennoxville Canada vacation rental.
This site, FRBO.com take ins township, tract, and domain evidence, periodically.
Detect, uncover, and identify apartment rentals Blenheim Canada, vacation homes for rent by owner Blenheim, and Blenheim houses for rent.
Hear, perceive, and devise Cranbrook Canada vacation homes for rent by owner, rental houses in Cranbrook Canada, and Cranbrook Canada house rentals.
Determine, learn, and learn houses for rent in Prescott Canada, condos for rent Prescott Canada, and houses for rent.
Almost ready to be occupied private flat, well appointed farmhouse, and oceanfront farmhouse are contiguous in the handy quarter of Eglington.
Join our mountain classified ads, resort directories, exclusive indexes, and beachfront listed properties mailing list for apartment rentals in Eglington Canada, Eglington Canada condos for rent, and homes for rent Eglington.
|
|
