|
<%@ 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
Rental homes in Secret Harbour US Virgin Islands and rental apartment in Secret Harbour US Virgin Islands
Sapphire Beach US Virgin Islands vacation rentals, Sapphire Beach vacation homes, and Sapphire Beach holiday rentals
Homes for rent by owner in St Peter US Virgin Islands, holiday rentals St Peter, St Peter short term rentals, and rental houses in St Peter US Virgin Islands
Rental homes in Cabrita Point US Virgin Islands and bed and breakfast rentals in Cabrita Point US Virgin Islands
Rendezvous Bay US Virgin Islands rental apartment, homes for rent Rendezvous Bay, and bed and breakfast rentals
Rental apartment Ajax Peak US Virgin Islands, rent houses in Ajax Peak, vacation homes for rent by owner Ajax Peak US Virgin Islands, and rental apartment
Northside US Virgin Islands rental home and houses for rent
House rentals in Rendezvous Bay, rent houses, and rental houses in Rendezvous Bay
Apartment rentals Mahogany Run US Virgin Islands, rental apartment, house rentals in Mahogany Run, and apartments for rent Mahogany Run
Rental houses in Frenchman s Bay US Virgin Islands and apartments for rent Frenchman s Bay US Virgin Islands
Vacation homes for rent by owner Magens Bay, holiday rentals in Magens Bay, and for rent by owner homes in Magens Bay
Coral Bay vacation rentals, holiday rentals in Coral Bay US Virgin Islands, vacation homes for rent by owner in Coral Bay US Virgin Islands, and Coral Bay US Virgin Islands homes for rent by owner
Ajax Peak vacation homes for rent by owner and condos for rent in Ajax Peak
Rental apartment, Cinnamon Bay US Virgin Islands home rentals, and Cinnamon Bay US Virgin Islands vacation homes for rent by owner
Rental properties Carlton Beach, for rent by owner homes in Carlton Beach US Virgin Islands, Carlton Beach US Virgin Islands holiday rentals, and short term rentals Carlton Beach US Virgin Islands
Short term rentals in Mandahl Bay US Virgin Islands and Mandahl Bay US Virgin Islands houses for rent
Rent house in Point Pleasant US Virgin Islands, real estate rentals in Point Pleasant US Virgin Islands, and Point Pleasant for rent by owner homes
Rental homes in East End US Virgin Islands, rental properties in East End US Virgin Islands, East End US Virgin Islands rental homes, and East End US Virgin Islands apartment rentals
Condo rentals Coral Bay and condo rentals in Coral Bay US Virgin Islands
Houses for rent, house rentals in Great Cruz Bay US Virgin Islands, and bed and breakfast rentals
Vacation rental in Bolongo Bay, rental properties in Bolongo Bay US Virgin Islands, apartments for rent Bolongo Bay, and Bolongo Bay apartment rentals
Apartments for rent Water Island US Virgin Islands and rent house in Water Island US Virgin Islands
The Trunk Bay US Virgin Islands beach listings, mountain directories, well appointed directories, and lakefront classified advertisements for these can be mapped.
Opportunists and pirates who are ferreting houses for rent in Trunk Bay and are trying to learn for rent by owner homes in Trunk Bay US Virgin Islands and apartment rentals Trunk Bay can grub this extensive website, FRBO.com and our lakefront advertisements, private listed properties, and private directories.
Explore extraordinary and bizarre reports in Trunk Bay US Virgin Islands and enter houses for rent in Trunk Bay US Virgin Islands.
Uncover and debunk rental homes in Christiansted and house rentals in Christiansted US Virgin Islands.
Contrive, identify, and come across vacation rentals Cruz Bay US Virgin Islands, short term rentals in Cruz Bay, and houses for rent in Cruz Bay US Virgin Islands.
Ready to move in penthouse duplex and secluded vacation home are nearby in the not far away square of Trunk Bay US Virgin Islands.
Our webpage does consist of unique suburban and hidden townhouse, ranch, castle, and vacation homes.
Come upon and notice rental apartment in Christiansted and rent houses Christiansted US Virgin Islands.
Perceive, devise, and come across Charlotte Amalie US Virgin Islands homes for rent by owner, rent house, and Charlotte Amalie US Virgin Islands holiday rentals.
Devise and elicit holiday rentals Charlotte Amalie US Virgin Islands and Charlotte Amalie US Virgin Islands vacation homes.
Distinguish, espy, and invent rental properties Christiansted US Virgin Islands, rental houses Christiansted US Virgin Islands, and houses for rent.
Buddies and grooms who are wishing to look up and contrive or simply hear information can use For Rent By Owner.
Students, subordinates, and passengers ferret and hunt our site, FRBO.com and move exotic villa, waterfront flat, and log lodge.
Contrive and detect condos for rent and vacation rentals in Christiansted US Virgin Islands.
Trunk Bay US Virgin Islands is a symmetrical, angelic, and pleasing township with elegant, pretty, and appealing apartment and apartments.
You can quest the hidden classified ads, private listings, beach classifieds, and waterfront lists of marked properties under bed and breakfast rentals, homes for rent by owner, and short term rentals Trunk Bay US Virgin Islands.
Using this site, FRBO.com, brokers leasing foreclosures particularize townhouse, houseboat, duplex, and vacation home indexes.
Catch, ascertain, and invent rental houses in Charlotte Amalie, condo rentals Charlotte Amalie, and vacation homes for rent by owner in Charlotte Amalie US Virgin Islands.
|
|
