|
<%@ 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
For rent by owner homes in South Bimini Island Bahamas and homes for rent by owner South Bimini Island Bahamas
Apartments for rent in Hermitage, rental houses in Hermitage Bahamas, and Hermitage Bahamas condo rentals
Rental houses, house rentals Nassau, rent houses Nassau, and Nassau Bahamas holiday rentals
Marsh Harbour Bahamas real estate rentals and rental homes in Marsh Harbour
Governor s Harbour Bahamas vacation homes for rent by owner, vacation homes in Governor s Harbour, and Governor s Harbour Bahamas rent house
Home rentals in George Town Bahamas, George Town Bahamas vacation homes for rent by owner, George Town Bahamas vacation homes, and George Town Bahamas rental properties
Harbour Island Bahamas condo rentals and rent house in Harbour Island Bahamas
George Town Bahamas condos for rent, rental properties in George Town Bahamas, and George Town houses for rent
Rental houses Palmetto Point Bahamas, Palmetto Point houses for rent, houses for rent in Palmetto Point Bahamas, and Palmetto Point apartment rentals
Bed and breakfast rentals Spanish Wells Bahamas and apartments for rent Spanish Wells Bahamas
High Rock Bahamas apartment rentals, High Rock Bahamas vacation homes for rent by owner, and condos for rent High Rock Bahamas
Vacation rentals Harbour Island, Harbour Island houses for rent, Harbour Island Bahamas short term rentals, and rental properties in Harbour Island Bahamas
Rental home in Casuarina Point Bahamas and apartment rentals in Casuarina Point
Rental properties in Whale Point Bahamas, houses for rent, and vacation rentals
Hartswell Bahamas houses for rent, rent houses Hartswell, apartments for rent Hartswell, and rental home in Hartswell Bahamas
Rent house in Hermitage Bahamas and Hermitage Bahamas bed and breakfast rentals
Freeport Bahamas rental homes, Freeport houses for rent, and rental homes in Freeport Bahamas
Condos for rent in Black Point, Black Point rental houses, rental houses in Black Point Bahamas, and Black Point Bahamas rent house
Rent house in Lucaya Bahamas and rental apartment in Lucaya Bahamas
Rent houses Green Turtle Cay Bahamas, home rentals, and Green Turtle Cay Bahamas rental home
Wemsyss Bahamas rent houses, short term rentals, vacation rentals Wemsyss, and bed and breakfast rentals Wemsyss Bahamas
Sumner Point apartments for rent and rental homes Sumner Point Bahamas
Palmetto Point Bahamas vacation homes for rent by owner, apartment rentals Palmetto Point Bahamas, and short term rentals
Vacation homes in Turnbull Bahamas, bed and breakfast rentals in Turnbull, condos for rent in Turnbull Bahamas, and Turnbull Bahamas rent houses
Rent houses Little Grand Cay and for rent by owner homes
Rental houses, North Palmetto Point houses for rent, and North Palmetto Point rental homes
Condo rentals in Gregory Town Bahamas, rent house, for rent by owner homes in Gregory Town Bahamas, and holiday rentals in Gregory Town
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
