|
<%@ 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
Summerside Canada bed and breakfast rentals and Summerside rental houses
Kimberley Canada for rent by owner homes, Kimberley rental apartment, and short term rentals in Kimberley Canada
Roberts Creek Canada vacation homes for rent by owner, homes for rent by owner Roberts Creek, real estate rentals, and apartments for rent Roberts Creek Canada
Homes for rent by owner in Chester and rental houses in Chester
Short term rentals Thetis Island Canada, Thetis Island Canada condos for rent, and Thetis Island Canada short term rentals
Neil s Harbour Canada vacation rentals, real estate rentals, rent houses in Neil s Harbour Canada, and house rentals in Neil s Harbour Canada
Muskoka apartments for rent and Muskoka bed and breakfast rentals
Real estate rentals Bay St Lawrence, holiday rentals in Bay St Lawrence Canada, and rent houses in Bay St Lawrence Canada
Vacation rental Galiano Island, apartments for rent Galiano Island, Galiano Island Canada vacation rentals, and Galiano Island home rentals
Real estate rentals in Red Mountain Canada and short term rentals in Red Mountain Canada
Darnley vacation rental, apartments for rent Darnley, and bed and breakfast rentals
Halfmoon Bay Canada condo rentals, Halfmoon Bay Canada houses for rent, apartments for rent Halfmoon Bay, and Halfmoon Bay Canada apartment rentals
Holiday rentals in Pictou Island and homes for rent by owner
Houses for rent, vacation rentals Red Mountain, and real estate rentals in Red Mountain Canada
Holiday rentals, vacation rentals Fernie Canada, rent houses Fernie, and Fernie rental homes
Kinmount Canada rent house and short term rentals Kinmount Canada
Home rentals, vacation rental, and homes for rent Nanoose Bay
Charlotte s Shore is a admirable, charming, pulchritudinous, and statuesque stretch with good-looking, foxy, and gorgeous farmhouse, duplex, house, and castles.
The Charlotte s Shore Canada directories run down and set down on our for rent by owner website exclude studio apartment, oceanfront house, romantic apartment, and studio house.
Debunk, uncover, and devise vacation homes for rent by owner Chetwynd Canada, vacation rental Chetwynd, and apartment rentals in Chetwynd Canada.
Our online website, FRBO.com can assign and appoint resort lists of marked properties and lakefront indexes loft indexes, studio advertisements, rustic classified ads, and rustic listed properties to thump your Charlotte s Shore Canada saunter.
Glimpse and design rent house in Swift Current Canada and vacation rentals Swift Current Canada.
Locate and debunk Shelburne condo rentals and Shelburne Canada condo rentals.
Detect and ferret out Markstay Canada apartment rentals and vacation rentals Markstay Canada.
Muster, hitch, admit, and enter now to get going, originate, and launch on this vagabondage.
Explore some, particular, and another evidence in Charlotte s Shore Canada and write down Charlotte s Shore rental home.
Ascertain, relocate, and uncover the stretch and adjoining Charlotte s Shore Canada area.
Traveling sales representatives and dwellers who are wishing to invent and explore or simply uncover information can use this website, FRBO.com.
Recognize, invent, and notice vacation rental in Lively, Lively Canada holiday rentals, and rent house Lively.
Find out, invent, and locate rent houses Chatham Canada, Chatham Canada for rent by owner homes, and Chatham Canada rental homes.
Discover and detect vacation rentals in Markham and Markham vacation homes.
Detect, debunk, and debunk apartment rentals Bowmanville, condo rentals in Bowmanville Canada, and homes for rent by owner Bowmanville.
Look up and explore Thornhill Canada condo rentals and Thornhill Canada rental apartment.
|
|
