|
<%@ 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
Condos for rent in The Valley and The Valley British Virgin Islands rental apartment
Houses for rent in Cane Garden Bay British Virgin Islands, Cane Garden Bay British Virgin Islands rental houses, and vacation homes in Cane Garden Bay
Rental home Loblolly Bay British Virgin Islands, Loblolly Bay British Virgin Islands real estate rentals, Loblolly Bay British Virgin Islands rental apartment, and homes for rent in Loblolly Bay
House rentals and for rent by owner homes in Little Apple Bay
Cooper Island bed and breakfast rentals, homes for rent by owner Cooper Island, and vacation homes Cooper Island
Nail Bay apartments for rent, Nail Bay rental home, for rent by owner homes, and house rentals in Nail Bay British Virgin Islands
Little Apple Bay British Virgin Islands vacation homes and rent houses
Leverick Bay British Virgin Islands rental homes, condo rentals in Leverick Bay British Virgin Islands, and vacation rentals
House rentals, real estate rentals in Mahoe Bay British Virgin Islands, vacation rentals Mahoe Bay, and vacation homes for rent by owner
Holiday rentals in The Valley and The Valley rental properties
Cane Garden Bay British Virgin Islands short term rentals, Cane Garden Bay British Virgin Islands rental home, and vacation rentals Cane Garden Bay British Virgin Islands
House rentals Nail Bay British Virgin Islands, Nail Bay British Virgin Islands vacation homes for rent by owner, Nail Bay British Virgin Islands holiday rentals, and Nail Bay rent house
Vacation homes for rent by owner The Valley and rental properties
North Sound vacation rentals, homes for rent in North Sound British Virgin Islands, and North Sound British Virgin Islands apartment rentals
Cane Garden Bay rental home, Cane Garden Bay British Virgin Islands rental home, short term rentals in Cane Garden Bay, and short term rentals Cane Garden Bay British Virgin Islands
Little Apple Bay British Virgin Islands rental homes and for rent by owner homes Little Apple Bay
Smuggler s Cove rental apartment, homes for rent by owner Smuggler s Cove, and Smuggler s Cove apartments for rent
Vacation rental in Smuggler s Cove British Virgin Islands, Smuggler s Cove rental apartment, Smuggler s Cove rent house, and Smuggler s Cove British Virgin Islands holiday rentals
Leverick Bay short term rentals and Leverick Bay apartments for rent
Rent houses Mahoe Bay British Virgin Islands, Mahoe Bay British Virgin Islands apartment rentals, and short term rentals in Mahoe Bay
Home rentals in Savannah Bay British Virgin Islands, real estate rentals in Savannah Bay, rental homes in Savannah Bay British Virgin Islands, and rental houses Savannah Bay British Virgin Islands
For rent by owner homes in The Baths British Virgin Islands and homes for rent
Cooper Island rental apartment, vacation rental in Cooper Island British Virgin Islands, and Cooper Island condo rentals
Rent houses in The Valley British Virgin Islands, rental properties in The Valley, homes for rent by owner The Valley, and rent house The Valley
Vacation homes for rent by owner The Baths British Virgin Islands and rent house in The Baths British Virgin Islands
Rent houses in Cane Garden Bay, Cane Garden Bay British Virgin Islands condos for rent, and short term rentals Cane Garden Bay British Virgin Islands
Condo rentals The Baths, for rent by owner homes in The Baths British Virgin Islands, The Baths British Virgin Islands rental home, and The Baths British Virgin Islands house rentals
The Valley British Virgin Islands vacation rentals and The Valley rent houses
Vacation rentals in Nail Bay British Virgin Islands, rental home Nail Bay British Virgin Islands, and holiday rentals in Nail Bay British Virgin Islands
Savannah Bay apartment rentals, for rent by owner homes Savannah Bay British Virgin Islands, Savannah Bay British Virgin Islands bed and breakfast rentals, and condos for rent
Cane Garden Bay rental apartment and Cane Garden Bay British Virgin Islands holiday rentals
#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
|
|
