|
<%@ 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
Secret Harbour apartments for rent and Secret Harbour US Virgin Islands rental home
Vacation rental Ritz Carlton, holiday rentals in Ritz Carlton US Virgin Islands, and houses for rent Ritz Carlton
Charlotte Amalie US Virgin Islands condos for rent, condo rentals in Charlotte Amalie, Charlotte Amalie rental houses, and rental houses in Charlotte Amalie US Virgin Islands
Rental houses Estate Peterborg and Estate Peterborg US Virgin Islands rental properties
Trunk Bay US Virgin Islands for rent by owner homes, homes for rent Trunk Bay US Virgin Islands, and rental homes
Real estate rentals Bolongo Bay, rental apartment in Bolongo Bay US Virgin Islands, rental home in Bolongo Bay US Virgin Islands, and rental apartment in Bolongo Bay
Holiday rentals Mahogany Run and holiday rentals in Mahogany Run US Virgin Islands
Holiday rentals East End US Virgin Islands, vacation homes in East End US Virgin Islands, and rent house in East End US Virgin Islands
Chocolate Hole US Virgin Islands apartment rentals, condo rentals in Chocolate Hole US Virgin Islands, apartment rentals in Chocolate Hole, and rental home Chocolate Hole US Virgin Islands
Short term rentals in Hull Bay and Hull Bay vacation homes for rent by owner
Bed and breakfast rentals Charlotte Amalie, rental properties, and Charlotte Amalie US Virgin Islands rent house
Rental properties Estate Peterborg US Virgin Islands, holiday rentals in Estate Peterborg US Virgin Islands, for rent by owner homes in Estate Peterborg, and rent houses in Estate Peterborg
Bordeaux Mountain houses for rent and rental homes in Bordeaux Mountain
Water Island apartments for rent, Water Island US Virgin Islands vacation homes for rent by owner, and Water Island US Virgin Islands homes for rent
FRBO.Com, For Rent By Owner, does comprise especial hillside and beach house, farmhouse, farmhouse, and lodges.
Discover and locate condo rentals and Christiansted US Virgin Islands condo rentals.
Using our page, landlords poll townhouse, lodge, bungalow, and flat listings.
Secure and hire now to jump into, get cracking, open, and inaugurate on this junket.
Elicit special, novel, individual, and another story goods in Coral Bay and calendar rental properties.
Discover and espy Christiansted US Virgin Islands rental apartment and for rent by owner homes in Christiansted US Virgin Islands.
Send alluring and symmetrical info regarding rent houses, rental houses in Coral Bay US Virgin Islands, vacation rentals in Coral Bay US Virgin Islands, and apartments for rent Coral Bay US Virgin Islands found on our for rent by owner site, FRBO.com.
Dig up and find out Christiansted US Virgin Islands vacation rentals and house rentals Christiansted.
Coral Bay turf employs many agents serving the condo market and agents serving the condo market.
Uncover, invent, and conceive rental properties in Cruz Bay US Virgin Islands, Cruz Bay condos for rent, and bed and breakfast rentals Cruz Bay US Virgin Islands.
Identify, glimpse, and determine Christiansted for rent by owner homes, Christiansted US Virgin Islands vacation rental, and homes for rent Christiansted US Virgin Islands.
Coral Bay is a statuesque, alluring, taking, and radiant vicinity with angelic and pulchritudinous flat and farmhouses.
Find and discern vacation rentals and vacation homes in Charlotte Amalie US Virgin Islands.
Habitants and salesmen who are inspecting Coral Bay holiday rentals and are trying to identify Coral Bay US Virgin Islands rental apartment, Coral Bay US Virgin Islands vacation homes, and vacation rental in Coral Bay can explore this extensive website, FRBO.com and our hidden online MLS, beach classifieds, city ads, and well appointed classified advertisements.
Our online website, FRBO.com can reserve, inscribe, and join lakeside classified ads, decadent advertisements, private online MLS, and lake listings mountain listings, hidden ads, waterfront classified advertisements, and romantic classified advertisements to ride shotgun your Coral Bay ramble.
See studio listed properties, suburban indexes, lake directories, and rustic lists of marked properties that brokers leasing foreclosures and rental agents post on this webpage.
|
|
