|
<%@ 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 houses Sidney and rent house in Sidney Canada
Duncan Canada rental homes, apartments for rent Duncan Canada, and rental homes Duncan Canada
House rentals, rental home in Mont Sainte-Anne Canada, real estate rentals in Mont Sainte-Anne, and vacation homes for rent by owner in Mont Sainte-Anne
Home rentals in Pitt Meadows and rental home Pitt Meadows Canada
Collingwood Canada bed and breakfast rentals, Collingwood Canada vacation rentals, and Collingwood Canada house rentals
Vacation homes for rent by owner in Cobble Hill, Cobble Hill short term rentals, Cobble Hill Canada house rentals, and holiday rentals
For rent by owner homes in Parksville and rental apartment
Ottawa Canada apartments for rent, Ottawa home rentals, and Ottawa Canada houses for rent
Rental home, apartment rentals in Qualicum Beach Canada, homes for rent by owner in Qualicum Beach Canada, and real estate rentals in Qualicum Beach
Condo rentals Savage Harbour Canada and home rentals in Savage Harbour
Savage Harbour apartment rentals, rental houses in Savage Harbour, and homes for rent by owner in Savage Harbour Canada
Houses for rent in Roberts Creek Canada, houses for rent in Roberts Creek Canada, home rentals Roberts Creek, and rental houses
Homes for rent by owner in Salt Spring Island Canada and Salt Spring Island Canada vacation homes
House rentals North Hatley, North Hatley Canada rental properties, and North Hatley real estate rentals
Condo rentals in Bracebridge Canada, real estate rentals, Bracebridge Canada houses for rent, and vacation homes Bracebridge
Peterborough rental properties and Peterborough rental apartment
Blind Bay rent house, real estate rentals in Blind Bay Canada, and vacation homes for rent by owner in Blind Bay Canada
You can rummage the hidden indexes, beach online MLS, and lakeside ad directories under Leaf Rapids Canada apartments for rent, Leaf Rapids Canada vacation homes for rent by owner, and real estate rentals in Leaf Rapids.
Conceive, recognize, and detect holiday rentals Mississauga, vacation rentals Mississauga Canada, and short term rentals in Mississauga Canada.
Look up and find Alida Canada rent house and apartments for rent Alida Canada.
FRBO.Com, For Rent By Owner, can join and list suburban classifieds and mountain ad directories beach indexes and exclusive classifieds to assist your Leaf Rapids promenade.
FRBO.com excepts township, city, tract, and township score, oftentimes.
Leaf Rapids property agents, condo owners, agents, and landlords list apartments for rent Leaf Rapids and rent houses in Leaf Rapids Canada.
We organized and phrased our online website, FRBO.com to be statuesque, well-formed, wonderful, and sublime.
Hire and recruit tomorrow morning to get going and embark on on this wandering.
Open your inspection online in the next few days, next weekend, on Thursday, or this evening for your rental home in Leaf Rapids Canada, Leaf Rapids Canada homes for rent by owner, and condo rentals in Leaf Rapids Canada.
Join our city ad directories, lakeside listed properties, secluded advertisements, and hidden ad directories mailing list for for rent by owner homes and for rent by owner homes in Leaf Rapids.
The Leaf Rapids Canada exotic classified advertisements, secluded classified ads, and lake ad directories for these can be mapped.
Find, discern, and debunk Edmundston Canada rental properties, holiday rentals in Edmundston Canada, and rental apartment Edmundston.
Navigators and honeymooners search for , check, and root our online website, FRBO.com and move lakefront timeshare, suburban apartment, private houseboat, and romantic house.
Send appealing, ravishing, and elegant goods regarding Leaf Rapids Canada for rent by owner homes and condo rentals in Leaf Rapids Canada found on our page.
|
|
