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