|
<%@ 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" %>
|
US Virgin Islands Rental Links
For rent by owner homes in Caret Bay and vacation homes Caret Bay
Magens Bay vacation rentals, rental properties Magens Bay, and Magens Bay US Virgin Islands rent house
Homes for rent in Sapphire Beach US Virgin Islands, Sapphire Beach short term rentals, Sapphire Beach rental properties, and rental homes Sapphire Beach US Virgin Islands
Pineapple Village real estate rentals and Pineapple Village houses for rent
Apartments for rent Ajax Peak, Ajax Peak US Virgin Islands vacation rentals, and Ajax Peak US Virgin Islands homes for rent
Homes for rent by owner, apartments for rent in Great Cruz Bay, for rent by owner homes in Great Cruz Bay US Virgin Islands, and Great Cruz Bay vacation rentals
Rental homes in Frenchman s Bay US Virgin Islands and Frenchman s Bay US Virgin Islands short term rentals
Rental homes, holiday rentals in South Side US Virgin Islands, and homes for rent
Apartments for rent, bed and breakfast rentals St Peter, homes for rent in St Peter, and rental houses St Peter US Virgin Islands
Apartment rentals in Caret Bay US Virgin Islands and apartment rentals Caret Bay
Rental apartment in Cane Bay US Virgin Islands, short term rentals in Cane Bay US Virgin Islands, and rental houses Cane Bay
Home rentals in Mahogany Run US Virgin Islands, home rentals Mahogany Run US Virgin Islands, houses for rent in Mahogany Run, and rental houses
Condos for rent in Cabrita Point and for rent by owner homes in Cabrita Point US Virgin Islands
Fortuna US Virgin Islands vacation homes for rent by owner, vacation rental in Fortuna, and rental apartment Fortuna US Virgin Islands
Holiday rentals Secret Harbour US Virgin Islands, rental home, for rent by owner homes Secret Harbour US Virgin Islands, and Secret Harbour US Virgin Islands for rent by owner homes
Vacation rental Estate Peterborg US Virgin Islands and homes for rent Estate Peterborg US Virgin Islands
Home rentals in Rendezvous Bay, bed and breakfast rentals Rendezvous Bay, and Rendezvous Bay US Virgin Islands bed and breakfast rentals
Estate Dorethea apartments for rent, home rentals in Estate Dorethea US Virgin Islands, rent house in Estate Dorethea US Virgin Islands, and Estate Dorethea rent house
Homes for rent by owner Magens Bay and rental home Magens Bay US Virgin Islands
The Charlotte Amalie beach ad directories, lakefront ads, secluded listings, and decadent classified ads for these can be mapped.
Elicit and dig up condos for rent and vacation homes Christiansted US Virgin Islands.
Identify and learn rental apartment Cruz Bay and Cruz Bay house rentals.
See spacious classifieds, convenient advertisements, loft ads, and private classifieds that property agents and property owners post on FRBO.com.
Kick off your inquiry online now or tomorrow morning for your Charlotte Amalie apartment rentals, condo rentals in Charlotte Amalie, and Charlotte Amalie US Virgin Islands vacation homes.
Charlotte Amalie US Virgin Islands is a elegant, classy, and fine square with appealing, ideal, and grand timeshare and timeshares.
The Charlotte Amalie US Virgin Islands classified ads registered and numerated on our for rent by owner website hold secluded lodge, suburban bungalow, penthouse hacienda, and studio farmhouse.
Distinguish and discover Cruz Bay rental homes and Cruz Bay US Virgin Islands rental properties.
Glimpse, elicit, and find vacation rental Christiansted, bed and breakfast rentals Christiansted US Virgin Islands, and Christiansted US Virgin Islands rental home.
Ferret out, notice, and identify Christiansted US Virgin Islands homes for rent, Christiansted US Virgin Islands condos for rent, and bed and breakfast rentals.
Learn and relocate rent house in Cruz Bay US Virgin Islands and apartments for rent Cruz Bay.
You can forage the beach advertisements, resort classified advertisements, and waterfront ads under short term rentals Charlotte Amalie US Virgin Islands, house rentals in Charlotte Amalie US Virgin Islands, and Charlotte Amalie US Virgin Islands rental houses.
Charlotte Amalie US Virgin Islands square employs many land owners and rental property owners.
Look up, recognize, and look up condo rentals in Christiansted US Virgin Islands, vacation rentals in Christiansted, and Christiansted US Virgin Islands rental homes.
Originate and dig up for rent by owner homes Charlotte Amalie US Virgin Islands and Charlotte Amalie US Virgin Islands real estate rentals.
Identify and contrive Christiansted US Virgin Islands real estate rentals and Christiansted US Virgin Islands rental properties.
|
|
