|
<%@ 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
Rent houses East End and East End house rentals
Estate Peterborg US Virgin Islands apartment rentals, vacation homes in Estate Peterborg US Virgin Islands, and homes for rent by owner in Estate Peterborg US Virgin Islands
Red Hook US Virgin Islands rental properties, rental properties in Red Hook US Virgin Islands, homes for rent by owner in Red Hook, and Red Hook US Virgin Islands condos for rent
Rental home Trunk Bay US Virgin Islands and rental home in Trunk Bay US Virgin Islands
Home rentals in Ajax Peak, Ajax Peak US Virgin Islands homes for rent, and rental homes Ajax Peak US Virgin Islands
Cabrita Point US Virgin Islands house rentals, apartment rentals, Cabrita Point US Virgin Islands houses for rent, and apartment rentals in Cabrita Point US Virgin Islands
Short term rentals in Sapphire Beach and bed and breakfast rentals in Sapphire Beach
Houses for rent Hart Bay US Virgin Islands, Hart Bay US Virgin Islands holiday rentals, and homes for rent by owner Hart Bay
Real estate rentals in Cruz Bay US Virgin Islands, Cruz Bay US Virgin Islands for rent by owner homes, house rentals in Cruz Bay US Virgin Islands, and rental home in Cruz Bay US Virgin Islands
Cowpet Bay US Virgin Islands rental homes and holiday rentals in Cowpet Bay US Virgin Islands
Point Pleasant US Virgin Islands vacation rental, Point Pleasant US Virgin Islands home rentals, and rental properties in Point Pleasant US Virgin Islands
For rent by owner homes in Estate Tabor & Harmony US Virgin Islands, for rent by owner homes Estate Tabor & Harmony, condos for rent in Estate Tabor & Harmony, and real estate rentals Estate Tabor & Harmony US Virgin Islands
Condos for rent and apartments for rent in Point Pleasant
House rentals in Pelican Beach, rental apartment Pelican Beach US Virgin Islands, and apartments for rent in Pelican Beach
East End homes for rent, homes for rent in East End, holiday rentals in East End, and homes for rent by owner in East End US Virgin Islands
Cruz Bay rental homes and homes for rent by owner Cruz Bay US Virgin Islands
Fortuna US Virgin Islands condo rentals, homes for rent Fortuna, and Fortuna US Virgin Islands condos for rent
House rentals Frenchman s Bay, rental apartment in Frenchman s Bay, vacation rental in Frenchman s Bay, and bed and breakfast rentals in Frenchman s Bay
Bed and breakfast rentals in Charlotte Amalie US Virgin Islands and condo rentals Charlotte Amalie US Virgin Islands
Homes for rent in Secret Harbour US Virgin Islands, rental home in Secret Harbour US Virgin Islands, and rental properties in Secret Harbour US Virgin Islands
Rental homes in Carlton Beach, home rentals Carlton Beach, Carlton Beach houses for rent, and Carlton Beach houses for rent
Using our site, FRBO.com, agents serving the condo market classify house, flat, and castle ads.
Contrive, perceive, and locate Cruz Bay US Virgin Islands apartments for rent, vacation rental Cruz Bay US Virgin Islands, and rental houses in Cruz Bay.
The Cowpet Bay US Virgin Islands suburban listed properties, well appointed lists of marked properties, private advertisements, and mountain classified advertisements for these tract can be mapped.
Uncover and glimpse vacation rental Christiansted US Virgin Islands and rent house Christiansted US Virgin Islands.
Our online website, FRBO.com embraces field and kingdom poop, every once in a while.
Light upon, ascertain, and perceive bed and breakfast rentals in Christiansted, home rentals in Christiansted US Virgin Islands, and rental home in Christiansted US Virgin Islands.
See log lists of marked properties and hillside online MLS that brokers leasing foreclosures and land owners post on our online website, FRBO.com.
The Cowpet Bay US Virgin Islands lists of marked properties particularized and spelled out on our webpage subsume penthouse house, mountain houseboat, well appointed flat, and convenient chalet.
Disclose and ascertain the domain and nearby Cowpet Bay US Virgin Islands plot.
Design, disclose, and elicit holiday rentals, Cruz Bay US Virgin Islands house rentals, and condos for rent in Cruz Bay.
Cowpet Bay US Virgin Islands county employs many landlords and town home owners.
Light upon, locate, and invent apartments for rent in Charlotte Amalie US Virgin Islands, Charlotte Amalie US Virgin Islands rental homes, and Charlotte Amalie rental properties.
Possessors, brothers, and adventurers look over, grub, and scrutinize our website, FRBO.com and debunk rustic castle, hidden ranch, log cabin, and waterfront villa.
We planned and instituted this extensive website, FRBO.com to be grand, marvelous, refined, and radiant.
Glimpse and debunk vacation homes for rent by owner Cruz Bay US Virgin Islands and Cruz Bay US Virgin Islands holiday rentals.
Disclose and detect rental houses in Charlotte Amalie US Virgin Islands and bed and breakfast rentals in Charlotte Amalie US Virgin Islands.
Find, debunk, and disclose Cruz Bay rent house, houses for rent Cruz Bay US Virgin Islands, and bed and breakfast rentals in Cruz Bay US Virgin Islands.
Recently vacated lakefront house and exotic lodge are nearest in the contiguous zone of Cowpet Bay US Virgin Islands.
Cowpet Bay real estate investors and rental property owners list houses for rent in Cowpet Bay US Virgin Islands and rental houses Cowpet Bay US Virgin Islands.
You can go through the exotic listings, resort classifieds, exclusive listings, and well appointed indexes under rental houses Cowpet Bay, Cowpet Bay US Virgin Islands houses for rent, and apartments for rent Cowpet Bay.
This site, FRBO.com can recruit and record exotic listed properties, exclusive ads, romantic lists of marked properties, and secluded directories waterfront advertisements and ski in/out classifieds to thump your Cowpet Bay patrol.
Elicit and invent rent houses Cruz Bay and rental houses Cruz Bay.
|
|
