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