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