|
<%@ 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
Creekside Canada apartment rentals and short term rentals in Creekside Canada
Rental homes in Nanaimo Canada, rental houses in Nanaimo, and rental homes
Brampton rental houses, Brampton Canada for rent by owner homes, rental houses in Brampton Canada, and homes for rent in Brampton
Vacation rental Vancouver and apartment rentals in Vancouver Canada
Blind Bay rental home, rental properties in Blind Bay Canada, and houses for rent in Blind Bay Canada
Vacation rental in Annapolis Royal Canada, home rentals in Annapolis Royal, condo rentals in Annapolis Royal Canada, and Annapolis Royal Canada holiday rentals
Home rentals in Bromont Canada and Bromont rent houses
Okanagan Centre Canada rental home, real estate rentals, and Okanagan Centre Canada vacation rentals
Point Prim Canada condos for rent, short term rentals in Point Prim, vacation rental in Point Prim Canada, and homes for rent in Point Prim
West Bay Canada short term rentals and short term rentals in West Bay Canada
Sicamous Canada apartment rentals, real estate rentals in Sicamous Canada, and Sicamous Canada condos for rent
Condo rentals, rental properties North Lake Canada, homes for rent in North Lake Canada, and North Lake apartment rentals
Rental properties Antigonish Canada and apartment rentals in Antigonish
House rentals Qualicum Beach Canada, Qualicum Beach vacation homes for rent by owner, and vacation rentals
Kelowna condos for rent, for rent by owner homes in Kelowna Canada, vacation rentals Kelowna Canada, and bed and breakfast rentals Kelowna Canada
For rent by owner homes in Severn Bridge Canada and Severn Bridge Canada condos for rent
Homes for rent in Kimberley, homes for rent by owner in Kimberley Canada, and Kimberley apartment rentals
Rental houses Creekside, short term rentals in Creekside Canada, real estate rentals in Creekside, and houses for rent in Creekside Canada
Rental homes in Ottawa Canada and rent house Ottawa Canada
Antigonish Canada vacation homes for rent by owner, vacation homes Antigonish Canada, and houses for rent in Antigonish Canada
Rental home in Chester Canada, rental properties Chester, bed and breakfast rentals in Chester Canada, and condos for rent in Chester Canada
Vacation homes in Lac Castor Canada and Lac Castor Canada apartment rentals
Charlotte s Shore Canada bed and breakfast rentals, Charlotte s Shore Canada holiday rentals, and houses for rent in Charlotte s Shore
Rental home Sidney, apartments for rent Sidney, Sidney rental apartment, and vacation homes for rent by owner Sidney Canada
Bed and breakfast rentals in Wakefield Canada and for rent by owner homes in Wakefield Canada
Quadra Island apartment rentals, condo rentals Quadra Island Canada, and Quadra Island Canada vacation homes for rent by owner
Lac Castor Canada rental properties, rent house in Lac Castor Canada, homes for rent Lac Castor, and real estate rentals Lac Castor
Locate sundry and bizarre materials in Collingwood Canada and record Collingwood Canada rental apartment.
Come upon and identify real estate rentals and vacation homes in London.
Send angelic, charming, and pleasing conclusions regarding rental houses in Collingwood Canada and Collingwood vacation homes found on this webpage.
Contrive and elicit Caledon Canada houses for rent and Caledon Canada for rent by owner homes.
Rental apartment in Lochrum Bay Anguilla, vacation rental, rental home Lochrum Bay, and house rentals Lochrum Bay Anguilla
Condo rentals South Side US Virgin Islands, South Side rental homes, condos for rent, and South Side US Virgin Islands houses for rent
Catch and identify house rentals Snag and house rentals in Snag Canada.
FRBO.com embodys locality, township, and territory knowledge, ofttimes.
Conceive, notice, and perceive Brownlee vacation homes, rental houses in Brownlee Canada, and homes for rent by owner in Brownlee Canada.
The Collingwood lists of marked properties inscribed and tallied on our for rent by owner site, FRBO.com take in waterfront cabin, private home, and beach bungalow.
Collingwood Canada is a fair, ravishing, resplendent, and graceful neighborhood with alluring, refined, enticing, and refined bungalow, hacienda, cottage, and vacation homes.
Glimpse, elicit, and locate Gananoque Canada rental properties, vacation rentals, and for rent by owner homes Gananoque Canada.
Road warriors, adventurers, and adventurers who are wishing to identify, dig up, and ferret out or simply find information can use our page.
Hear and detect houses for rent in Saint-Joseph-de-Sorel Canada and Saint-Joseph-de-Sorel apartment rentals.
Originate and hear real estate rentals in Chetwynd and Chetwynd Canada vacation homes for rent by owner.
|
|
