|
<%@ 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" %>
|
British Virgin Islands Rental Links
Leverick Bay vacation homes for rent by owner and Leverick Bay condos for rent
Mahoe Bay British Virgin Islands rental houses, apartment rentals in Mahoe Bay, and rental houses
Rent houses Cooper Island British Virgin Islands, homes for rent Cooper Island, vacation homes Cooper Island British Virgin Islands, and Cooper Island houses for rent
Home rentals in The Valley and rental home
Apartment rentals in Little Apple Bay British Virgin Islands, rental homes, and vacation homes Little Apple Bay
For rent by owner homes Cane Garden Bay, rental home in Cane Garden Bay British Virgin Islands, homes for rent by owner Cane Garden Bay British Virgin Islands, and Cane Garden Bay British Virgin Islands for rent by owner homes
Holiday rentals Cane Garden Bay British Virgin Islands and Cane Garden Bay British Virgin Islands apartments for rent
Apartments for rent in North Sound British Virgin Islands, rent houses North Sound British Virgin Islands, and North Sound homes for rent by owner
Homes for rent in Long Bay British Virgin Islands, rental properties in Long Bay British Virgin Islands, Long Bay British Virgin Islands bed and breakfast rentals, and Long Bay British Virgin Islands holiday rentals
North Sound British Virgin Islands vacation rental and rent houses in North Sound British Virgin Islands
Rental apartment Savannah Bay British Virgin Islands, rent house, and apartments for rent in Savannah Bay
Vacation homes in The Valley British Virgin Islands, The Valley rent houses, rental apartment in The Valley British Virgin Islands, and The Valley British Virgin Islands rent houses
Bed and breakfast rentals in The Baths British Virgin Islands and homes for rent by owner The Baths British Virgin Islands
Rental properties in The Baths, The Baths apartments for rent, and short term rentals in The Baths British Virgin Islands
House rentals in Little Apple Bay, vacation rentals in Little Apple Bay British Virgin Islands, Little Apple Bay vacation rental, and rental apartment in Little Apple Bay
Holiday rentals Little Apple Bay British Virgin Islands and vacation homes in Little Apple Bay
Vacation rental Mahoe Bay, Mahoe Bay British Virgin Islands rent houses, and Mahoe Bay British Virgin Islands bed and breakfast rentals
Rental home in Little Apple Bay British Virgin Islands, for rent by owner homes in Little Apple Bay British Virgin Islands, Little Apple Bay British Virgin Islands homes for rent, and home rentals Little Apple Bay
Savannah Bay homes for rent and short term rentals Savannah Bay
Rental properties in Cooper Island British Virgin Islands, homes for rent in Cooper Island British Virgin Islands, and Cooper Island British Virgin Islands homes for rent by owner
Cooper Island British Virgin Islands vacation homes, for rent by owner homes in Cooper Island British Virgin Islands, Cooper Island rental homes, and rental home
Apartment rentals in Loblolly Bay British Virgin Islands and home rentals in Loblolly Bay British Virgin Islands
Houses for rent The Baths British Virgin Islands, apartment rentals in The Baths British Virgin Islands, and rental home The Baths British Virgin Islands
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
