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