|
<%@ 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" %>
|
Bahamas Rental Links
Marsh Harbour Bahamas short term rentals and for rent by owner homes in Marsh Harbour
Dunmore Town Bahamas vacation rentals, Dunmore Town Bahamas condos for rent, and rent houses
Vacation rental in Pelican Point, for rent by owner homes Pelican Point Bahamas, bed and breakfast rentals Pelican Point, and Pelican Point Bahamas rental home
Black Point Bahamas short term rentals and holiday rentals
House rentals in Marsh Harbour Bahamas, bed and breakfast rentals in Marsh Harbour Bahamas, and Marsh Harbour Bahamas vacation homes
Houses for rent Whale Point Bahamas, Whale Point rental apartment, bed and breakfast rentals in Whale Point, and home rentals in Whale Point Bahamas
Rent houses in Black Point and Black Point Bahamas vacation homes for rent by owner
Nassau Bahamas house rentals, Nassau Bahamas homes for rent by owner, and for rent by owner homes
Whale Point Bahamas holiday rentals, Whale Point vacation rentals, condos for rent, and Whale Point rental homes
Vacation rentals and Little Grand Cay Bahamas rental houses
Condo rentals in Lucaya, Lucaya Bahamas rental home, and apartment rentals
Rental home in North Palmetto Point, holiday rentals in North Palmetto Point Bahamas, for rent by owner homes, and homes for rent North Palmetto Point
Rental homes Little Harbour Bahamas and bed and breakfast rentals
Rent houses Lucaya, Lucaya Bahamas condos for rent, and Lucaya Bahamas vacation rentals
Rental houses Harbour Island Bahamas, vacation homes for rent by owner in Harbour Island Bahamas, homes for rent by owner in Harbour Island Bahamas, and homes for rent by owner Harbour Island
Clarence Town Bahamas rental houses and Clarence Town Bahamas rent houses
Rental houses in Black Point, rental houses, and short term rentals in Black Point Bahamas
Apartment rentals South Bimini Island, apartment rentals, rental properties South Bimini Island Bahamas, and vacation homes for rent by owner South Bimini Island Bahamas
Staniel Cay vacation homes and short term rentals Staniel Cay
Real estate rentals in Wemsyss Bahamas, for rent by owner homes in Wemsyss, and vacation rental
Stella Maris Bahamas condo rentals, apartment rentals in Stella Maris Bahamas, bed and breakfast rentals Stella Maris Bahamas, and Stella Maris Bahamas rental houses
Rental apartment Whale Point and holiday rentals in Whale Point Bahamas
Little Harbour house rentals, vacation rentals Little Harbour, and vacation homes
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
