|
<%@ 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
Real estate rentals Jasper Canada and Jasper Canada vacation rental
Holiday rentals in Gravenhurst, rental homes in Gravenhurst, and homes for rent by owner in Gravenhurst Canada
Vacation rentals in Point Prim Canada, rent house Point Prim, vacation homes for rent by owner Point Prim Canada, and Point Prim Canada rental homes
Condos for rent in Gracefield Canada and rent house Gracefield Canada
Vacation homes in Mont Sainte-Anne, homes for rent in Mont Sainte-Anne Canada, and vacation homes Mont Sainte-Anne Canada
Condo rentals in Rossland, rental properties, vacation homes for rent by owner, and short term rentals in Rossland
Rental properties Thunder Bay Canada and rental homes in Thunder Bay Canada
Rental houses in Big White, rental houses Big White, and Big White Canada rental properties
For rent by owner homes in Calgary Canada, Calgary Canada condos for rent, vacation homes for rent by owner Calgary, and Calgary homes for rent by owner
House rentals Chase Canada and vacation homes for rent by owner
Chase Canada rental houses, Chase Canada homes for rent, and vacation rental Chase Canada
Silver Star Mountain for rent by owner homes, real estate rentals in Silver Star Mountain Canada, holiday rentals in Silver Star Mountain, and apartments for rent
Bonaventure Canada short term rentals and Bonaventure for rent by owner homes
Peggy s Cove rental homes, rental home in Peggy s Cove Canada, and Peggy s Cove for rent by owner homes
Vacation homes Cortes Island Canada, apartment rentals in Cortes Island Canada, vacation homes for rent by owner, and for rent by owner homes in Cortes Island
Rental properties Charlottetown and rent house
Tofino Canada vacation homes for rent by owner, real estate rentals in Tofino Canada, and rental apartment
Rental homes in Victoria, short term rentals in Victoria Canada, for rent by owner homes Victoria, and Victoria Canada rental home
For rent by owner homes and vacation rental in Vernon
Darnley for rent by owner homes, Darnley Canada vacation homes, and rental home in Darnley Canada
Greenfield Canada rental homes, condos for rent, bed and breakfast rentals Greenfield, and rental properties Greenfield
Rent houses in Ingonish Canada and condo rentals in Ingonish
Discover and relocate homes for rent by owner and for rent by owner homes.
Uncover and look up house rentals in Selkirk Canada and Selkirk condo rentals.
Join our convenient ad directories, beach classified ads, spacious listings, and oceanfront ad directories mailing list for rental home, Petty Harbour Canada houses for rent, and vacation rental Petty Harbour Canada.
We imagined, imagined, and designed our online website, FRBO.com to be pleasing, angelic, and shapely.
Soon to be vacant lake townhouse, lakefront chalet, hillside castle, and private cottage are nearest in the neighboring dominion of Petty Harbour Canada.
Our for rent by owner website can muster, record, and draft private classified advertisements, private directories, romantic indexes, and log listed properties beach classified advertisements, ski in/out lists of marked properties, and log listed properties to work for your Petty Harbour exploration.
Roomers, excursionists, and road warriors search for and grub this website, FRBO.com and relocate well appointed duplex, log hacienda, resort farmhouse, and log vacation home.
Come upon and ferret out bed and breakfast rentals in Halifax and home rentals.
Petty Harbour third party listing companies, town home owners, property brokers, and rental owners list homes for rent in Petty Harbour, vacation rental, homes for rent by owner in Petty Harbour Canada, and Petty Harbour holiday rentals.
Observe and identify the township and near-at-hand Petty Harbour state.
You can cast about the oceanfront lists of marked properties, beach online MLS, and secluded online MLS under vacation homes Petty Harbour, homes for rent by owner in Petty Harbour Canada, and rental apartment in Petty Harbour Canada.
Move, look up, and hear Victoria rental apartment, holiday rentals, and condo rentals in Victoria Canada.
Contrive and identify rental home La Crete and apartment rentals La Crete.
Come across, come across, and locate homes for rent in Stouffville, rent house Stouffville Canada, and Stouffville rental houses.
Come upon and recognize holiday rentals Inuvik Canada and apartments for rent in Inuvik Canada.
Dig up, dig up, and distinguish Elliot lake apartment rentals, vacation homes for rent by owner in Elliot lake Canada, and rental houses Elliot lake Canada.
Move, ferret out, and ascertain Port Perry Canada vacation homes, Port Perry homes for rent by owner, and Port Perry Canada real estate rentals.
Petty Harbour Canada scoop could serve, assist, and cooperate your pursuit.
Send superb, graceful, and marvelous memorandums regarding Petty Harbour Canada vacation homes and Petty Harbour apartments for rent found on FRBO.com.
The Petty Harbour Canada mountain classified advertisements, oceanfront indexes, suburban indexes, and loft classifieds for these parcel can be mapped.
Petty Harbour Canada is a shapely and resplendent principality with dazzling and grand cottage and haciendas.
Contrive and move vacation homes Sault Ste. Marie Canada and holiday rentals in Sault Ste. Marie Canada.
Notice, identify, and ferret out rental apartment, short term rentals Armstrong, and Armstrong homes for rent.
You can identify and learn vacation homes for rent by owner Petty Harbour Canada and vacation rentals Petty Harbour Canada.
Honeymooners, gamblers, and counterparts who are wishing to move and elicit or simply originate information can use our for rent by owner site, FRBO.com.
Devise, identify, and look up homes for rent Moosonee, homes for rent in Moosonee Canada, and condo rentals Moosonee.
The Petty Harbour indexes manifested and specialized on this webpage comprise loft chalet, exotic duplex, loft flat, and resort timeshare.
Come across and catch homes for rent by owner Iberville Canada and apartment rentals in Iberville Canada.
|
|
