|
<%@ 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
Long Bay British Virgin Islands vacation homes and house rentals Long Bay British Virgin Islands
Rental properties, vacation homes for rent by owner, and North Sound British Virgin Islands rental properties
The Baths rental homes, vacation homes The Baths, The Baths real estate rentals, and house rentals in The Baths British Virgin Islands
The Baths apartments for rent and bed and breakfast rentals The Baths
Short term rentals in Nail Bay British Virgin Islands, for rent by owner homes Nail Bay British Virgin Islands, and for rent by owner homes in Nail Bay British Virgin Islands
Apartments for rent in Savannah Bay, Savannah Bay British Virgin Islands holiday rentals, Savannah Bay British Virgin Islands houses for rent, and apartment rentals in Savannah Bay British Virgin Islands
Short term rentals and Smuggler s Cove British Virgin Islands vacation homes
Vacation homes in Mahoe Bay British Virgin Islands, vacation homes for rent by owner in Mahoe Bay, and house rentals Mahoe Bay
Vacation homes in The Valley British Virgin Islands, The Valley British Virgin Islands vacation rental, The Valley British Virgin Islands condo rentals, and holiday rentals
Mahoe Bay British Virgin Islands vacation homes for rent by owner and apartment rentals in Mahoe Bay
Rent houses, rent houses Nail Bay British Virgin Islands, and Nail Bay British Virgin Islands vacation homes
Real estate rentals in The Valley, The Valley British Virgin Islands holiday rentals, rental houses The Valley, and The Valley British Virgin Islands condos for rent
Bed and breakfast rentals in North Sound British Virgin Islands and apartments for rent in North Sound British Virgin Islands
Long Bay rent house, Long Bay condo rentals, and houses for rent
Rental apartment, vacation rentals in Cooper Island British Virgin Islands, Cooper Island British Virgin Islands apartment rentals, and houses for rent Cooper Island
Nail Bay house rentals and Nail Bay houses for rent
Nail Bay British Virgin Islands rental properties, real estate rentals in Nail Bay, and Nail Bay British Virgin Islands real estate rentals
Bed and breakfast rentals in Savannah Bay British Virgin Islands, rental properties, house rentals, and rental apartment in Savannah Bay British Virgin Islands
Leverick Bay British Virgin Islands home rentals and rental properties Leverick Bay
Little Apple Bay vacation rental, Little Apple Bay British Virgin Islands homes for rent by owner, and rental home
Smuggler s Cove British Virgin Islands houses for rent, house rentals in Smuggler s Cove, homes for rent in Smuggler s Cove British Virgin Islands, and home rentals in Smuggler s Cove British Virgin Islands
South Sound British Virgin Islands rental houses and apartment rentals in South Sound British Virgin Islands
Bed and breakfast rentals South Sound, home rentals South Sound, and condo rentals in South Sound British Virgin Islands
Vacation rentals Little Apple Bay, rent houses in Little Apple Bay British Virgin Islands, Little Apple Bay British Virgin Islands short term rentals, and Little Apple Bay British Virgin Islands vacation rental
Home rentals Nail Bay and Nail Bay British Virgin Islands vacation rental
Rental apartment in North Sound British Virgin Islands, North Sound British Virgin Islands condos for rent, and rental home North Sound British Virgin Islands
Apartment rentals in Cooper Island British Virgin Islands, Cooper Island condos for rent, Cooper Island bed and breakfast rentals, and Cooper Island homes for rent by owner
Rent house The Valley and condo rentals in The Valley British Virgin Islands
Rental apartment in Nail Bay British Virgin Islands, short term rentals Nail Bay British Virgin Islands, and short term rentals in Nail Bay British Virgin Islands
Savannah Bay British Virgin Islands apartment rentals, Savannah Bay British Virgin Islands apartment rentals, homes for rent by owner in Savannah Bay British Virgin Islands, and for rent by owner homes in Savannah Bay
Nail Bay British Virgin Islands vacation homes and rent houses in Nail Bay British Virgin Islands
Smuggler s Cove rental properties, Smuggler s Cove British Virgin Islands rental home, and vacation homes in Smuggler s Cove
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
