|
<%@ 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
Holiday rentals in Parrsboro and houses for rent in Parrsboro Canada
Vacation rental Pender Islands, homes for rent in Pender Islands, and Pender Islands rental home
Rent houses Park Corner Canada, Park Corner Canada rental apartment, apartment rentals Park Corner Canada, and for rent by owner homes in Park Corner Canada
Vacation rental Forest and Forest Canada vacation homes for rent by owner
Rental homes, Musquodoboit Harbour Canada for rent by owner homes, and condos for rent Musquodoboit Harbour Canada
Homes for rent, apartment rentals in Ayers Cliff, Ayers Cliff Canada rental properties, and real estate rentals in Ayers Cliff Canada
Vacation rentals and rental homes in Golden Canada
Vacation homes Edmonton, Edmonton rental houses, and for rent by owner homes Edmonton
Rental houses Ste Adele Canada, rental apartment in Ste Adele, apartment rentals in Ste Adele, and home rentals in Ste Adele Canada
Colchester holiday rentals and condos for rent in Colchester
Jasper Canada houses for rent, Jasper homes for rent by owner, and home rentals in Jasper
Vacation homes for rent by owner in Malpeque Canada, rent houses Malpeque, Malpeque Canada condos for rent, and houses for rent in Malpeque Canada
Houses for rent Carr s Landing and Carr s Landing homes for rent
Malpeque Canada condos for rent, homes for rent in Malpeque Canada, and condos for rent in Malpeque
Goose River Canada real estate rentals, homes for rent by owner Goose River, homes for rent by owner, and rental homes Goose River Canada
Salmon Arm Canada houses for rent and rental home in Salmon Arm Canada
Port Maitland bed and breakfast rentals, for rent by owner homes in Port Maitland, and Port Maitland Canada apartment rentals
Beach Point Canada for rent by owner homes, Beach Point Canada real estate rentals, vacation rentals Beach Point Canada, and apartments for rent in Beach Point Canada
Bed and breakfast rentals Port Joli Canada and rental properties
Holiday rentals, vacation homes for rent by owner, and vacation homes in Port Maitland Canada
Rental home Neil s Harbour, real estate rentals in Neil s Harbour, holiday rentals in Neil s Harbour Canada, and rent house Neil s Harbour
Ottawa Canada homes for rent by owner and Ottawa rent house
Rental properties in Savage Harbour Canada, Savage Harbour Canada vacation rentals, and vacation homes for rent by owner in Savage Harbour Canada
Vacation homes Gabarus Canada, vacation homes in Gabarus, Gabarus Canada houses for rent, and homes for rent by owner in Gabarus
Rent house in Denman Island Canada and Denman Island Canada holiday rentals
West Vancouver rental homes, homes for rent in West Vancouver, and West Vancouver real estate rentals
Gibsons homes for rent by owner, condo rentals, apartments for rent in Gibsons Canada, and houses for rent
Houses for rent Creekside Canada and bed and breakfast rentals Creekside
For rent by owner homes Chemong Lake, Chemong Lake Canada rent houses, and vacation homes
Short term rentals, real estate rentals in Shawnigan Lake Canada, bed and breakfast rentals in Shawnigan Lake, and home rentals Shawnigan Lake
Gravenhurst Canada picture could stump and reinforce your going-over.
Collegiates and tenants who are beating about vacation homes Gravenhurst Canada and are trying to design Gravenhurst Canada condo rentals and Gravenhurst Canada vacation homes for rent by owner can quest FRBO.com and our lake advertisements, waterfront lists of marked properties, decadent classified advertisements, and rustic classified advertisements.
Our site, FRBO.com does embrace specialized area private, loft, lakefront, and suburban houseboat, farmhouse, cabin, and chalets.
Find out and contrive for rent by owner homes Haliburton Canada and rental home Haliburton Canada.
Come upon and ascertain real estate rentals Moose Jaw and houses for rent in Moose Jaw Canada.
Move, perceive, and determine Sainte-Foy Canada rental properties, for rent by owner homes in Sainte-Foy Canada, and rent house Sainte-Foy.
The Gravenhurst Canada city classifieds, beach listed properties, beach ads, and mountain listings for these sector can be mapped.
Using our for rent by owner website, agents serving the condo market classify farmhouse and cottage ads.
Learn sparse, specific, atypical, and diverse reports in Gravenhurst and tabulate Gravenhurst Canada homes for rent.
Determine and conceive Estevan apartment rentals and condo rentals Estevan Canada.
Contrive and identify rent house in Deseronto and rent houses.
Identify, devise, and debunk Madoc rental homes, apartment rentals Madoc, and house rentals in Madoc.
Elicit and hear Exeter holiday rentals and Exeter Canada vacation homes for rent by owner.
Gravenhurst Canada is a pleasing, shapely, and pleasing quarter with resplendent, sightly, lovely, and taking houseboat and townhouses.
Launch your expedition online this evening, now, next weekend, or this evening for your Gravenhurst Canada homes for rent, apartments for rent in Gravenhurst, and rental houses in Gravenhurst.
Learn and light upon Yorkton Canada rent houses and Yorkton Canada condos for rent.
Determine and debunk home rentals and Shawinigan Canada apartment rentals.
Vacation homes in San Carlos Panama, short term rentals in San Carlos Panama, San Carlos Panama short term rentals, and apartment rentals
The Gravenhurst Canada online MLS census and manifested on this webpage involve convenient cottage, mountain castle, decadent house, and oceanfront duplex.
Observe, originate, and look up homes for rent by owner in Milton Canada, Milton Canada rental apartment, and Milton condos for rent.
Tofino Canada apartments for rent and rent house Tofino Canada
Hear, ferret out, and recognize London Canada house rentals, apartments for rent London, and short term rentals London.
Glimpse, glimpse, and learn Corner Brook condo rentals, homes for rent by owner in Corner Brook Canada, and Corner Brook Canada vacation rental.
Condo rentals Hopkins, short term rentals in Hopkins Belize, rental home in Hopkins Belize, and vacation rental Hopkins
Determine and observe rent houses in Grand Forks Canada and Grand Forks Canada condo rentals.
Great Harbour Cay Bahamas rent house, bed and breakfast rentals Great Harbour Cay Bahamas, and home rentals in Great Harbour Cay Bahamas
Identify, find out, and contrive Lennoxville Canada rental homes, rent houses Lennoxville, and apartments for rent in Lennoxville.
|
|
