|
<%@ 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
Coral Bay US Virgin Islands condos for rent and home rentals Coral Bay
Home rentals in Cinnamon Bay US Virgin Islands, Cinnamon Bay US Virgin Islands short term rentals, and Cinnamon Bay US Virgin Islands homes for rent by owner
Short term rentals, homes for rent Ajax Peak, for rent by owner homes in Ajax Peak US Virgin Islands, and rent house
Houses for rent in Cabrita Point US Virgin Islands and apartments for rent
Real estate rentals Secret Harbour US Virgin Islands, short term rentals in Secret Harbour US Virgin Islands, and rental houses in Secret Harbour
Hull Bay US Virgin Islands house rentals, Hull Bay US Virgin Islands rental home, vacation rentals, and condo rentals in Hull Bay US Virgin Islands
Trunk Bay US Virgin Islands apartments for rent and Trunk Bay US Virgin Islands vacation rental
Bordeaux Mountain vacation homes for rent by owner, holiday rentals Bordeaux Mountain, and rental houses in Bordeaux Mountain US Virgin Islands
Water Island rent houses, rental home in Water Island US Virgin Islands, vacation homes in Water Island US Virgin Islands, and Water Island rental apartment
Rental home in Mandahl Bay and Mandahl Bay US Virgin Islands vacation homes
Homes for rent by owner, houses for rent in Pineapple Village, and Pineapple Village for rent by owner homes
For rent by owner homes in Caret Bay US Virgin Islands, home rentals in Caret Bay, houses for rent in Caret Bay, and Caret Bay condos for rent
Estate Tabor & Harmony US Virgin Islands holiday rentals and condo rentals in Estate Tabor & Harmony US Virgin Islands
Rental apartment in Hart Bay, rent house in Hart Bay, and rental apartment Hart Bay
House rentals Magens Bay, house rentals, rental homes in Magens Bay, and Magens Bay US Virgin Islands bed and breakfast rentals
Bordeaux Mountain US Virgin Islands rental home and homes for rent in Bordeaux Mountain US Virgin Islands
House rentals in South Side US Virgin Islands, apartments for rent in South Side, and homes for rent by owner in South Side US Virgin Islands
Fortuna condo rentals, Fortuna vacation rental, vacation rental in Fortuna US Virgin Islands, and Fortuna US Virgin Islands house rentals
Mahogany Run rent house and vacation rental in Mahogany Run US Virgin Islands
Short term rentals Red Hook, rent houses in Red Hook, and Red Hook condo rentals
Trunk Bay houses for rent, rental apartment in Trunk Bay, vacation rental, and houses for rent in Trunk Bay
Bed and breakfast rentals Christiansted US Virgin Islands and bed and breakfast rentals Christiansted US Virgin Islands
Rental homes East End, for rent by owner homes East End US Virgin Islands, and homes for rent by owner in East End
Fish Bay for rent by owner homes, vacation homes in Fish Bay US Virgin Islands, rent house in Fish Bay US Virgin Islands, and rent houses in Fish Bay US Virgin Islands
Rental houses Mahogany Run and rental properties in Mahogany Run US Virgin Islands
The Carlton Beach US Virgin Islands indexes polled and recorded on our for rent by owner website accommodate penthouse house and beachfront houseboat.
Contrive and find Cruz Bay US Virgin Islands vacation rental and apartment rentals in Cruz Bay US Virgin Islands.
Distinguish, originate, and identify rent houses in Cruz Bay US Virgin Islands, apartment rentals Cruz Bay US Virgin Islands, and for rent by owner homes Cruz Bay US Virgin Islands.
Determine, originate, and come across short term rentals Cruz Bay US Virgin Islands, Cruz Bay US Virgin Islands rental houses, and homes for rent by owner Cruz Bay.
Jump into your expedition online next weekend or on Monday for your Carlton Beach vacation rentals and Carlton Beach rental houses.
Look up and learn Cruz Bay US Virgin Islands for rent by owner homes and Cruz Bay US Virgin Islands homes for rent by owner.
We actualize and produced our webpage to be pulchritudinous and dazzling.
This site, FRBO.com can volunteer, levy, sign on, and engage mountain listed properties, mountain indexes, oceanfront classifieds, and oceanfront online MLS lakefront lists of marked properties, waterfront lists of marked properties, and resort ads to facilitate your Carlton Beach US Virgin Islands travel.
Recognize, uncover, and relocate Charlotte Amalie US Virgin Islands condos for rent, Charlotte Amalie rent house, and short term rentals Charlotte Amalie US Virgin Islands.
Learn and detect Charlotte Amalie US Virgin Islands homes for rent by owner and homes for rent by owner in Charlotte Amalie.
Originate, design, and contrive apartments for rent in Charlotte Amalie, short term rentals Charlotte Amalie US Virgin Islands, and Charlotte Amalie US Virgin Islands vacation homes for rent by owner.
Dig up and contrive apartment rentals Charlotte Amalie and Charlotte Amalie holiday rentals.
Wanderers and sisters-in-law root and look over our site, FRBO.com and notice exotic timeshare, exotic castle, and spacious condominium.
Carlton Beach US Virgin Islands vicinity employs many property owners and rental owners.
Design and perceive rent houses and condos for rent.
Roamers, gypsies, and tourists who are wishing to explore and discern or simply find out information can use our for rent by owner site, FRBO.com.
Perceive unconventional, rare, specific, and specific evidence in Carlton Beach US Virgin Islands and peg apartments for rent.
Dig up, uncover, and distinguish rent houses Christiansted US Virgin Islands, rent house Christiansted US Virgin Islands, and home rentals Christiansted US Virgin Islands.
Dig up and debunk Christiansted US Virgin Islands rental home and Christiansted US Virgin Islands home rentals.
|
|
