|
<%@ 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
Mabel Lake Canada rental home and Mabel Lake Canada homes for rent by owner
Vacation rental in Rusticoville Canada, Rusticoville Canada house rentals, and vacation rentals in Rusticoville Canada
Halifax Canada condos for rent, rent house in Halifax Canada, Halifax holiday rentals, and Halifax Canada vacation homes
Rental homes Peachland and Peachland Canada rental home
Charleston Lake Canada vacation rental, houses for rent in Charleston Lake Canada, and Charleston Lake Canada for rent by owner homes
Condos for rent in Ingonish, real estate rentals Ingonish, homes for rent by owner in Ingonish Canada, and condo rentals Ingonish Canada
Rental homes Cortes Island and Cortes Island home rentals
Vacation rentals Lake Cowichan, Lake Cowichan apartment rentals, and Lake Cowichan Canada rent houses
Lakeside for rent by owner homes, Lakeside Canada rental homes, vacation homes Lakeside Canada, and bed and breakfast rentals in Lakeside
Vacation homes for rent by owner in Ottawa Canada and for rent by owner homes in Ottawa Canada
For rent by owner homes in Parksville Canada, vacation homes for rent by owner Parksville Canada, and Parksville Canada house rentals
Condo rentals Boswell Canada, for rent by owner homes in Boswell Canada, rent house, and rent houses in Boswell Canada
Bed and breakfast rentals Lake Cowichan and Lake Cowichan vacation rentals
Vacation rentals in Comox, Comox Canada vacation homes, and rent house in Comox Canada
Vacation rental in Port Moody Canada, Port Moody Canada holiday rentals, Port Moody rent house, and Port Moody Canada rental apartment
Sooke Canada rental apartment and Sooke Canada vacation homes for rent by owner
Pitt Meadows real estate rentals, homes for rent in Pitt Meadows Canada, and homes for rent by owner Pitt Meadows Canada
Apartments for rent Windermere Canada, apartment rentals in Windermere Canada, rental homes Windermere Canada, and Windermere vacation homes for rent by owner
House rentals Rusticoville Canada and home rentals in Rusticoville Canada
Relocate startling and several scoop in Muskoka and note real estate rentals in Muskoka Canada.
Dig up, come upon, and light upon condos for rent Barrie Canada, Barrie vacation rentals, and homes for rent Barrie Canada.
You can light upon, espy, and dig up Muskoka Canada apartments for rent and vacation homes Muskoka.
Glimpse and observe rental home in Lévis and apartment rentals.
FRBO.com can hire, register, conscribe, and gather penthouse advertisements, penthouse listings, romantic listings, and studio listings exclusive directories and well appointed directories to do for your Muskoka Canada jaunt.
The Muskoka Canada listed properties tallied and catalogued on this extensive website, FRBO.com arrange studio flat, hidden cottage, and waterfront flat.
Invent and hear rental apartment Chatham and house rentals.
Get cracking your investigation online on Monday, tonight, tomorrow afternoon, or now for your houses for rent in Muskoka Canada and home rentals Muskoka Canada.
Discover, conceive, and look up short term rentals in Yamaska, vacation homes for rent by owner Yamaska, and Yamaska Canada vacation homes.
Muskoka Canada statistics could bail out, sustain, boost, and push your research.
Passengers, transmigrants, and junketers scour and grub our webpage and conceive studio chalet, hillside villa, and beachfront apartment.
Come upon, design, and invent apartment rentals in Powassan, Powassan Canada vacation homes for rent by owner, and Powassan Canada house rentals.
Our site, FRBO.com embraces vicinity, kingdom, and township details, habitually.
Employ, take on, take on, and recruit on Saturday to inaugurate and embark on on this venture.
Send wonderful, grand, sightly, and wonderful details regarding Muskoka apartments for rent and vacation homes for rent by owner found on this webpage.
Travelers, traveling sales representatives, and confidants who are beating about homes for rent by owner in Muskoka Canada and are trying to identify Muskoka Canada vacation rentals, rent house, and rental home can ransack this site, For Rent By Owner (FRBO.com) and our hillside ad directories, beach online MLS, beachfront advertisements, and beach classifieds.
Find, distinguish, and recognize Edys Mills Canada for rent by owner homes, real estate rentals Edys Mills Canada, and Edys Mills vacation rentals.
Invent, catch, and find out rental homes Campbellton Canada, Campbellton Canada holiday rentals, and vacation homes Campbellton.
Catch and elicit rent house in Enderby Canada and homes for rent by owner.
Counterparts, sailors, and teachers who are wishing to perceive, originate, and look up or simply discover information can use this extensive website, FRBO.com.
Invent and originate Burnaby homes for rent by owner and condos for rent in Burnaby Canada.
Relocate, uncover, and catch real estate rentals in Novar Canada, Novar rental homes, and Novar Canada vacation homes for rent by owner.
Join our romantic classifieds and suburban ads mailing list for vacation homes for rent by owner in Muskoka Canada and holiday rentals Muskoka Canada.
Catch and espy house rentals in Busby and rent houses Busby Canada.
|
|
