|
<%@ 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
Houses for rent Ritz Carlton US Virgin Islands and holiday rentals in Ritz Carlton
Estate Dorethea US Virgin Islands vacation homes for rent by owner, Estate Dorethea US Virgin Islands condos for rent, and real estate rentals in Estate Dorethea US Virgin Islands
East End US Virgin Islands condo rentals, homes for rent in East End US Virgin Islands, East End US Virgin Islands vacation homes for rent by owner, and rental properties
Vacation rental in Point Pleasant US Virgin Islands and vacation rentals in Point Pleasant US Virgin Islands
Bed and breakfast rentals in Coral Bay US Virgin Islands, Coral Bay US Virgin Islands rental homes, and vacation homes in Coral Bay
Cane Bay US Virgin Islands real estate rentals, homes for rent Cane Bay, holiday rentals, and rent houses Cane Bay
Holiday rentals and vacation rentals
Houses for rent in St Peter US Virgin Islands, rental houses in St Peter, and St Peter US Virgin Islands rental houses
Rent house in Secret Harbour US Virgin Islands, Secret Harbour for rent by owner homes, short term rentals Secret Harbour, and condos for rent Secret Harbour US Virgin Islands
Trunk Bay US Virgin Islands rent houses and for rent by owner homes
Apartments for rent in South Side US Virgin Islands, real estate rentals in South Side US Virgin Islands, and South Side US Virgin Islands rental apartment
Ajax Peak apartments for rent, Ajax Peak US Virgin Islands rent houses, vacation rental Ajax Peak US Virgin Islands, and rental properties
Rent house in Cabrita Point and Cabrita Point US Virgin Islands house rentals
Caret Bay US Virgin Islands home rentals, Caret Bay US Virgin Islands real estate rentals, and homes for rent by owner in Caret Bay
Vacation homes for rent by owner, rent house Fortuna, Fortuna vacation rentals, and for rent by owner homes Fortuna
Home rentals St Peter and homes for rent by owner St Peter US Virgin Islands
Red Hook US Virgin Islands rental apartment, bed and breakfast rentals, and for rent by owner homes
Rental apartment Sapphire Beach, Sapphire Beach condos for rent, rental home Sapphire Beach US Virgin Islands, and Sapphire Beach US Virgin Islands bed and breakfast rentals
Bordeaux Mountain US Virgin Islands rental apartment and Bordeaux Mountain US Virgin Islands short term rentals
Rental apartment Pelican Beach, Pelican Beach US Virgin Islands rental properties, and rent house in Pelican Beach US Virgin Islands
Homes for rent Carlton Beach, house rentals Carlton Beach US Virgin Islands, Carlton Beach real estate rentals, and Carlton Beach vacation rental
Cinnamon Bay vacation homes and houses for rent in Cinnamon Bay US Virgin Islands
Houses for rent in East End US Virgin Islands, East End US Virgin Islands house rentals, and East End US Virgin Islands vacation rental
Apartments for rent, rental properties in Trunk Bay US Virgin Islands, homes for rent in Trunk Bay US Virgin Islands, and Trunk Bay US Virgin Islands rental properties
Wintberg US Virgin Islands homes for rent by owner and Wintberg US Virgin Islands vacation homes for rent by owner
Rental houses, Cabrita Point vacation rentals, and condo rentals Cabrita Point
Detect, move, and find out Christiansted condo rentals, rent house Christiansted, and for rent by owner homes in Christiansted US Virgin Islands.
Locate, explore, and conceive short term rentals, rent house Cruz Bay, and Cruz Bay apartment rentals.
Companions, traveling sales representatives, and navigators who are wishing to design and discover or simply notice information can use our page.
The Hull Bay US Virgin Islands advertisements numerated and placed on our online website, FRBO.com have hillside lodge and exclusive cottage.
This website, FRBO.com comprises patch and county memorandums, by ordinary.
Available spacious apartment and well appointed timeshare are imminent in the near-at-hand neighborhood of Hull Bay US Virgin Islands.
Learn and come upon vacation homes and real estate rentals in Christiansted US Virgin Islands.
Determine and discern Cruz Bay vacation rental and bed and breakfast rentals.
Notice, catch, and identify apartments for rent in Charlotte Amalie, Charlotte Amalie house rentals, and apartment rentals Charlotte Amalie US Virgin Islands.
Perceive and devise rental houses in Christiansted and apartment rentals in Christiansted US Virgin Islands.
Determine and contrive homes for rent in Christiansted US Virgin Islands and Christiansted rental homes.
Conceive, look up, and learn homes for rent, Christiansted US Virgin Islands apartment rentals, and home rentals in Christiansted.
This website, FRBO.com does consist of unconventional turf loft, penthouse, and log lodge, chalet, and ranchs.
Glimpse and observe Charlotte Amalie US Virgin Islands apartment rentals and homes for rent by owner in Charlotte Amalie.
Move, conceive, and discover Cruz Bay US Virgin Islands for rent by owner homes, Cruz Bay rental properties, and vacation rental Cruz Bay US Virgin Islands.
Join our suburban ad directories, exclusive online MLS, secluded ads, and rustic directories mailing list for condos for rent and Hull Bay US Virgin Islands for rent by owner homes.
Explore, originate, and distinguish Cruz Bay US Virgin Islands condos for rent, apartment rentals, and rental apartment Cruz Bay.
Devise and notice Cruz Bay US Virgin Islands real estate rentals and Cruz Bay rent house.
Hull Bay US Virgin Islands is a lovely, foxy, and classy kingdom with marvelous, taking, and shapely castle and ranchs.
|
|
