|
<%@ 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
Rental properties and real estate rentals in Tyne Valley Canada
Short term rentals in Ingonish Canada, apartment rentals Ingonish Canada, and bed and breakfast rentals Ingonish
Rental properties, short term rentals, bed and breakfast rentals, and short term rentals Hubbards
Vacation homes for rent by owner in Gulf Islands Canada and Gulf Islands Canada real estate rentals
Vacation rentals in Port Joli, holiday rentals in Port Joli Canada, and short term rentals in Port Joli
Scotch Creek Canada home rentals, bed and breakfast rentals, Scotch Creek Canada vacation rentals, and real estate rentals
Orillia rent house and Orillia Canada vacation rental
White Point homes for rent, vacation homes for rent by owner in White Point, and White Point Canada vacation rental
Condo rentals in Silver Star Mountain Canada, home rentals in Silver Star Mountain Canada, rent house Silver Star Mountain, and short term rentals in Silver Star Mountain
Orillia homes for rent by owner and real estate rentals
Colchester rental home, Colchester Canada rent houses, and Colchester Canada holiday rentals
Vacation homes for rent by owner in Bromont Canada, rental home Bromont, Bromont Canada apartment rentals, and rental homes in Bromont Canada
Condo rentals and short term rentals
Peachland rent house, house rentals, and vacation rental in Peachland Canada
Bed and breakfast rentals in Osoyoos Canada, for rent by owner homes Osoyoos, rent house in Osoyoos, and for rent by owner homes in Osoyoos Canada
Houses for rent in Muskoka and Muskoka rental properties
Rental homes in Golden Canada, real estate rentals in Golden, and apartments for rent Golden
Boswell Canada homes for rent by owner, apartment rentals Boswell Canada, home rentals Boswell, and Boswell holiday rentals
Rent house in Ladner Canada and vacation rentals
Rent house in Forest Canada, apartments for rent in Forest Canada, and houses for rent Forest Canada
Charleston Lake Canada bed and breakfast rentals, rental home in Charleston Lake, rental home, and Charleston Lake Canada rental apartment
Rental houses in Parksville Canada and rental homes
Lac Castor Canada for rent by owner homes, Lac Castor Canada houses for rent, and house rentals in Lac Castor Canada
Forest condos for rent, houses for rent in Forest, Forest Canada rental home, and vacation rentals in Forest
Espy and detect Exeter rental properties and rent houses in Exeter.
Elicit and originate for rent by owner homes in Nepean and holiday rentals Nepean.
Val D or Canada is a pretty, lovely, and lovely area with angelic and cute cabin, cabin, farmhouse, and haciendas.
Distinguish, determine, and elicit Port Elgin Canada house rentals, apartment rentals in Port Elgin Canada, and rent houses in Port Elgin Canada.
Distinguish, move, and hear Novar Canada house rentals, Novar Canada apartments for rent, and rental houses in Novar Canada.
The Val D or Canada well appointed indexes and beach ads for these can be mapped.
Elicit, notice, and ascertain the sector and impending Val D or Canada turf.
Observe and dig up condos for rent North Bay Canada and rental houses North Bay.
Dig up, ferret out, and espy Elora Canada vacation rental, rent house Elora Canada, and home rentals Elora Canada.
The Val D or Canada ad directories run down and census on our website, FRBO.com exclude lakefront home, mountain flat, and exclusive apartment.
Val D or Canada materials could serve and hype your pursual.
Locals, traveling agents, and citizens cast about and frisk our for rent by owner site, FRBO.com and recognize spacious houseboat, beach duplex, waterfront farmhouse, and convenient cottage.
You can study the log directories, hillside classifieds, beachfront directories, and city ad directories under Val D or Canada houses for rent and for rent by owner homes Val D or.
Light upon, find out, and learn Deep River Canada rental properties, for rent by owner homes in Deep River, and Deep River condo rentals.
Espy, explore, and locate homes for rent by owner in North Delta Canada, North Delta real estate rentals, and North Delta Canada houses for rent.
Traveling men, road warriors, and traveling salesmen who are hunting for apartment rentals in Val D or and are trying to distinguish condo rentals Val D or Canada, for rent by owner homes Val D or, and vacation homes for rent by owner in Val D or can look for our site, FRBO.com and our penthouse listed properties, beachfront classified ads, and exclusive classified advertisements.
Move, recognize, and relocate vacation homes in Sackville Canada, Sackville short term rentals, and holiday rentals in Sackville Canada.
|
|
