|
<%@ 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
Rent houses in East Bideford and apartments for rent in East Bideford
Houses for rent in Port Stanton Canada, Port Stanton Canada holiday rentals, and bed and breakfast rentals in Port Stanton
Shelburne Canada rental properties, Shelburne Canada vacation homes for rent by owner, Shelburne rent houses, and vacation homes Shelburne Canada
Rent houses in East Bideford Canada and vacation homes for rent by owner East Bideford
Ladner Canada apartment rentals, Ladner holiday rentals, and Ladner Canada rental home
Rental homes Maple Ridge, rental properties Maple Ridge, Maple Ridge Canada condos for rent, and rent houses in Maple Ridge
Rent houses Tyne Valley Canada and vacation rental in Tyne Valley Canada
Rental apartment in Rossland Canada, Rossland Canada holiday rentals, and Rossland house rentals
Vacation homes in Ste Adele Canada, short term rentals in Ste Adele, vacation rental, and homes for rent by owner in Ste Adele Canada
House rentals in Lakeside Canada and apartments for rent Lakeside Canada
Oliver Canada for rent by owner homes, Oliver Canada for rent by owner homes, and rental houses in Oliver Canada
Kelowna houses for rent, vacation rentals Kelowna Canada, rental properties in Kelowna, and vacation rentals in Kelowna Canada
East Bideford homes for rent by owner and East Bideford Canada for rent by owner homes
For rent by owner homes, Port Alberni Canada vacation homes, and apartment rentals in Port Alberni Canada
Condos for rent in Souris Canada, Souris home rentals, homes for rent in Souris Canada, and apartment rentals Souris Canada
Homes for rent Port Moody and apartment rentals
Rental home, Invermere Canada rental properties, and apartment rentals in Invermere Canada
For rent by owner homes in Brampton, apartment rentals in Brampton Canada, bed and breakfast rentals in Brampton Canada, and rental houses
Holiday rentals Lac Castor Canada and Lac Castor rent house
Canoe Cove Canada real estate rentals, Canoe Cove Canada bed and breakfast rentals, and Canoe Cove real estate rentals
Holiday rentals, Musquodoboit Harbour Canada rental properties, Musquodoboit Harbour Canada condos for rent, and vacation homes for rent by owner Musquodoboit Harbour
Gabriola Island apartments for rent and short term rentals in Gabriola Island Canada
Rental apartment Halifax, Halifax Canada vacation homes, and home rentals Halifax Canada
Vacation rentals Eglington Canada, Eglington Canada vacation homes for rent by owner, Eglington Canada homes for rent, and real estate rentals in Eglington Canada
Rental houses in Pitt Meadows Canada and Pitt Meadows Canada homes for rent
For rent by owner homes Canoe Cove Canada, house rentals in Canoe Cove Canada, and Canoe Cove house rentals
Hubbards Canada homes for rent by owner, holiday rentals in Hubbards Canada, rental houses in Hubbards Canada, and rental homes Hubbards Canada
Vacation homes Anglemont and condos for rent in Anglemont Canada
Bowser rental apartment, home rentals Bowser Canada, and Bowser Canada rental apartment
Ile Verte-Green Island Canada apartment rentals, Ile Verte-Green Island Canada vacation homes, rental apartment in Ile Verte-Green Island Canada, and Ile Verte-Green Island Canada home rentals
Short term rentals in Honey Harbour and Honey Harbour Canada condo rentals
Ascertain, ferret out, and elicit Kemptville Canada real estate rentals, apartments for rent in Kemptville Canada, and Kemptville house rentals.
Disclose and distinguish rental home Saint-Rémi Canada and Saint-Rémi Canada short term rentals.
Estate Peterborg houses for rent, homes for rent by owner in Estate Peterborg US Virgin Islands, homes for rent Estate Peterborg US Virgin Islands, and rent houses in Estate Peterborg US Virgin Islands
This extensive website, FRBO.com incorporates field, territory, area, and quarter documents, periodically.
Rio Grande Puerto Rico home rentals, rental homes, and vacation homes
Glimpse, identify, and ascertain vacation homes for rent by owner in Old Crow Canada, homes for rent in Old Crow Canada, and homes for rent in Old Crow Canada.
Unused decadent hacienda and city cottage are proximate in the imminent plot of Darnley Canada.
Come across, discern, and observe Richmond Hill Canada vacation rentals, house rentals in Richmond Hill Canada, and condos for rent in Richmond Hill.
Discover and conceive vacation homes in New Minas and New Minas Canada condos for rent.
Identify, originate, and identify Ross River home rentals, rent house in Ross River Canada, and Ross River Canada condo rentals.
Rental properties Cortes Island and apartments for rent
See decadent classified ads, beach lists of marked properties, oceanfront ad directories, and beachfront indexes that land owners and property managers post on FRBO.Com, For Rent By Owner,.
Condos for rent and condos for rent in Monteverde Costa Rica
Seafarers, gypsies, and collegiates who are running down homes for rent by owner in Darnley Canada and are trying to perceive Darnley vacation homes, Darnley Canada rent house, and Darnley Canada condos for rent can look our webpage and our lake directories, studio lists of marked properties, private ads, and convenient classified advertisements.
The Darnley Canada ad directories manifested and inserted on our for rent by owner site, FRBO.com embody resort condominium, loft house, hidden cabin, and beachfront cottage.
Rental properties Sayulita and Sayulita Mexico rent house
Join our decadent lists of marked properties, ski in/out ads, oceanfront lists of marked properties, and private ad directories mailing list for rental home Darnley, condo rentals Darnley Canada, and condo rentals.
Apartment rentals, homes for rent by owner in Lake Cowichan, and bed and breakfast rentals Lake Cowichan Canada
Learn and debunk real estate rentals Richmond Hill Canada and homes for rent by owner in Richmond Hill Canada.
Look up, debunk, and determine rent houses, Sherwood Park Canada bed and breakfast rentals, and houses for rent Sherwood Park.
Discern and originate Toronto Canada rent house and vacation homes for rent by owner in Toronto Canada.
Glimpse and design the vicinity and nearby Darnley Canada dominion.
|
|
