|
<%@ 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
Sault Ste Marie condos for rent and Sault Ste Marie rental houses
Ste Adele Canada vacation homes for rent by owner, vacation homes for rent by owner in Ste Adele Canada, and Ste Adele Canada vacation homes for rent by owner
Homes for rent in Ameliasburg, rental homes in Ameliasburg Canada, Ameliasburg Canada vacation homes, and vacation rental Ameliasburg Canada
Halifax Canada condo rentals and apartment rentals in Halifax Canada
Short term rentals Gabriola Island Canada, house rentals in Gabriola Island Canada, and apartments for rent Gabriola Island
Rental houses Kootenay Bay, rent houses Kootenay Bay, rental properties in Kootenay Bay, and Kootenay Bay Canada houses for rent
Rental properties in Kenora Canada and condo rentals Kenora Canada
House rentals Ladysmith, house rentals Ladysmith Canada, and rent houses Ladysmith Canada
White Point Canada vacation rentals, rental houses in White Point, White Point Canada vacation homes for rent by owner, and home rentals in White Point
Vacation homes and apartments for rent Murray Harbour
Forest bed and breakfast rentals, house rentals in Forest Canada, and Forest vacation rental
Boswell Canada condos for rent, home rentals Boswell Canada, short term rentals in Boswell Canada, and rent house Boswell
Sault Ste Marie vacation homes for rent by owner and Sault Ste Marie Canada vacation homes
House rentals in Nelson Canada, vacation homes, and short term rentals in Nelson Canada
For rent by owner homes in Blooming Point, home rentals, rent houses Blooming Point, and rental houses in Blooming Point Canada
Homes for rent Lac Le Jeune and short term rentals
Savage Harbour rental houses, rental houses in Savage Harbour Canada, and Savage Harbour Canada rent houses
Home rentals in Severn Bridge Canada, for rent by owner homes Severn Bridge, homes for rent by owner in Severn Bridge Canada, and apartments for rent
Short term rentals Port Maitland Canada and rental houses
For rent by owner homes Parksville Canada, Parksville Canada rent houses, and Parksville Canada bed and breakfast rentals
Rental homes Qualicum Beach, rental houses in Qualicum Beach Canada, rental home in Qualicum Beach Canada, and Qualicum Beach Canada holiday rentals
Rental apartment in Mabel Lake and rental home Mabel Lake
Send classy and good-looking documents regarding Port Maitland Canada apartment rentals, Port Maitland Canada rent house, and apartments for rent in Port Maitland found on our website, FRBO.com.
Using this website, FRBO.com, property managers numerate vacation home, hacienda, lodge, and duplex classified advertisements.
Discover and locate vacation rental and homes for rent by owner.
Ascertain, find out, and observe holiday rentals Parry Sound, vacation homes in Parry Sound, and rent house in Parry Sound Canada.
See well appointed lists of marked properties, rustic ads, and beachfront advertisements that rental agents and real estate investors post on this webpage.
Learn, elicit, and learn Norquay Canada vacation rental, rental houses in Norquay, and vacation homes for rent by owner.
FRBO.Com, For Rent By Owner, does incorporate discrete well appointed, private, rustic, and oceanfront cottage, flat, cottage, and houseboats.
Confidants, displaced persons, and confreres quest, ransack, and quest our site, FRBO.com and dig up ski in/out vacation home, secluded apartment, penthouse home, and lake houseboat.
Gather and join up now to tear into, get cracking, and open on this tramp.
Lead off your inquiry online day after tomorrow or in the morning for your Port Maitland Canada condos for rent, house rentals in Port Maitland Canada, and bed and breakfast rentals in Port Maitland.
Perceive and relocate Aurora Canada rental houses and for rent by owner homes in Aurora.
Discern, find, and come upon Woodbridge rental apartment, Woodbridge Canada bed and breakfast rentals, and real estate rentals in Woodbridge Canada.
Our for rent by owner site, FRBO.com can take on, enter, and conscribe romantic classifieds, beach listed properties, well appointed listings, and private directories waterfront ads, lake advertisements, and lake indexes to support your Port Maitland Canada safari.
Explore and uncover homes for rent in Timmins Canada and rental apartment in Timmins Canada.
|
|
