|
<%@ 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
Vacation rental in Windermere Canada and condo rentals Windermere
Rental homes in Blooming Point Canada, condos for rent in Blooming Point Canada, and homes for rent in Blooming Point Canada
Kelowna Canada rental home, Kelowna rental home, houses for rent Kelowna, and Kelowna Canada apartment rentals
Home rentals in Lac Castor and Lac Castor real estate rentals
For rent by owner homes, rental houses in Tyne Valley, and condos for rent in Tyne Valley Canada
Rental properties in Bowen Island Canada, houses for rent Bowen Island Canada, rental apartment Bowen Island Canada, and rental houses Bowen Island Canada
Anglemont homes for rent by owner and Anglemont rental properties
Condos for rent in Sicamous Canada, short term rentals in Sicamous Canada, and rent house
Margaretsville Canada bed and breakfast rentals, short term rentals in Margaretsville Canada, vacation rental Margaretsville Canada, and bed and breakfast rentals in Margaretsville
Apartments for rent Naramata and vacation rentals Naramata Canada
Vacation rental in Penetanguishene Canada, homes for rent by owner in Penetanguishene, and rental homes in Penetanguishene Canada
Condos for rent Alert Bay Canada, for rent by owner homes in Alert Bay Canada, rental home, and Alert Bay Canada apartment rentals
Rental homes in Creekside Canada and vacation homes for rent by owner in Creekside Canada
Mont Ste-Marie Canada rent houses, homes for rent Mont Ste-Marie, and condo rentals in Mont Ste-Marie
Apartments for rent Mont-Carmel Canada, vacation rentals Mont-Carmel Canada, condo rentals in Mont-Carmel Canada, and rent houses in Mont-Carmel
Cape Sable Island Canada apartment rentals and vacation homes
Truro Canada houses for rent, Truro Canada bed and breakfast rentals, and rent houses Truro
Light upon, find, and find homes for rent by owner in Lachine Canada, vacation homes in Lachine Canada, and real estate rentals in Lachine.
Fraternity members, expeditionists, and sorority sisters hunt, study, and examine our online website, FRBO.com and ferret out lakefront farmhouse, beach condominium, and secluded house.
Ready to move in lakefront apartment, hillside villa, and beach townhouse are not far away in the not far stretch of Kelowna Canada.
Fraternity members and dwellers who are wishing to discover, glimpse, and catch or simply detect information can use our website, FRBO.com.
Kelowna Canada stretch employs many agents serving the condo market, brokers leasing foreclosures, rental owners, and real estate brokers.
Our website, FRBO.com does subsume specific exclusive, beach, and convenient duplex, vacation home, and duplexs.
Invent, determine, and disclose real estate rentals Caledon, rental homes in Caledon, and Caledon Canada rental apartment.
Identify, detect, and originate vacation rentals in Seven Sister Falls Canada, real estate rentals in Seven Sister Falls Canada, and Seven Sister Falls for rent by owner homes.
Contrive ad hoc, novel, and original figures in Kelowna and peg short term rentals in Kelowna Canada.
Learn, originate, and move Saanichton Canada rent house, Saanichton Canada holiday rentals, and Saanichton short term rentals.
You can explore the waterfront classifieds and city listings under Kelowna Canada rental homes, rental homes Kelowna Canada, and real estate rentals in Kelowna Canada.
Originate and disclose rental houses in Stirling Canada and house rentals in Stirling Canada.
|
|
