|
<%@ 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 Sault Ste Marie and condo rentals Sault Ste Marie Canada
Vacation rentals Edmonton, Edmonton houses for rent, and holiday rentals
Rental apartment in Quebec City, Quebec City house rentals, real estate rentals in Quebec City, and vacation rental Quebec City Canada
Brackley Beach Canada rental properties and home rentals Brackley Beach
House rentals Rusticoville Canada, houses for rent, and rental apartment in Rusticoville
Niagara-on-the-Lake houses for rent, Niagara-on-the-Lake Canada for rent by owner homes, homes for rent, and holiday rentals in Niagara-on-the-Lake Canada
Rent houses in Montreal Canada and Montreal short term rentals
Homes for rent Naramata, condo rentals, and rental apartment Naramata Canada
Homes for rent Kelowna, homes for rent in Kelowna, rental apartment in Kelowna Canada, and rental homes
Thetis Island rental homes and Thetis Island Canada real estate rentals
Petite Riviere rent houses, rental properties Petite Riviere Canada, and Petite Riviere rental properties
Homes for rent by owner Sechelt Canada, Sechelt real estate rentals, Sechelt Canada vacation rentals, and condos for rent Sechelt Canada
Bed and breakfast rentals in West Bay Canada and West Bay rental houses
Labelle for rent by owner homes, Labelle holiday rentals, and vacation rentals Labelle
Real estate rentals in Okanagan Centre Canada, homes for rent by owner in Okanagan Centre Canada, houses for rent in Okanagan Centre, and rental homes in Okanagan Centre Canada
Rent house Diamond Canada and short term rentals Diamond
Condo rentals Kimberley, house rentals in Kimberley Canada, and Kimberley rental houses
Rent house, vacation homes for rent by owner in Fernie Canada, rental home in Fernie Canada, and Fernie bed and breakfast rentals
Holiday rentals Malpeque and Malpeque rental apartment
Rent houses Bowen Island Canada, rental properties Bowen Island, and rental homes in Bowen Island Canada
Eglington Canada house rentals, Eglington real estate rentals, Eglington Canada condo rentals, and short term rentals
Egmont Canada condos for rent and condo rentals Egmont
Holiday rentals in Whistler Village, condo rentals in Whistler Village Canada, and condos for rent Whistler Village Canada
Labelle vacation homes, for rent by owner homes in Labelle Canada, bed and breakfast rentals Labelle, and apartment rentals in Labelle Canada
Recognize, discern, and ascertain condo rentals in Ponoka Canada, Ponoka Canada short term rentals, and rental home Ponoka Canada.
We concocted and devised this extensive website, FRBO.com to be alluring, delicate, and shapely.
Join our beach classified advertisements and exclusive directories mailing list for short term rentals Rusticoville, Rusticoville Canada short term rentals, and Rusticoville vacation rentals.
See resort ads, hillside ads, and exclusive classified ads that agents serving the condo market and agents post on this site, For Rent By Owner (FRBO.com).
You can disclose, determine, and identify rental houses in Rusticoville Canada and Rusticoville Canada rent houses.
Assign, attract, obtain, and assign tonight to embark on, lead off, and inaugurate on this peregrination.
Relocate, ascertain, and locate rent houses Tobermory Canada, Tobermory vacation homes for rent by owner, and Tobermory Canada houses for rent.
The Rusticoville Canada well appointed ads and hidden classified advertisements for these sector can be mapped.
Unoccupied romantic cottage, romantic houseboat, ski in/out cottage, and resort houseboat are imminent in the impending quarter of Rusticoville Canada.
Rusticoville Canada area employs many property agents, rental agents, home owners, and property agents.
Rusticoville Canada testimony could bail out, back, facilitate, and abet your expedition.
Find out and explore rent house Alert Canada and vacation rental.
Discern, identify, and locate vacation homes, holiday rentals, and Shelburne house rentals.
Dig up and come across Burk s Falls condo rentals and rental houses Burk s Falls.
Send exquisite, pulchritudinous, and taking materials regarding rental home Rusticoville and apartment rentals Rusticoville Canada found on For Rent By Owner.
|
|
