|
<%@ 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
Homes for rent by owner Pelican Beach US Virgin Islands and Pelican Beach US Virgin Islands rental properties
For rent by owner homes in Cabrita Point US Virgin Islands, Cabrita Point US Virgin Islands apartments for rent, and Cabrita Point US Virgin Islands vacation rentals
East End bed and breakfast rentals, East End US Virgin Islands house rentals, vacation homes, and house rentals in East End
Rental properties in Charlotte Amalie US Virgin Islands and rent house in Charlotte Amalie US Virgin Islands
Rental home Cruz Bay US Virgin Islands, Cruz Bay rental homes, and condo rentals in Cruz Bay US Virgin Islands
Coral Bay vacation rental, house rentals, condo rentals, and rental home
Vacation rental Cruz Bay US Virgin Islands and real estate rentals in Cruz Bay US Virgin Islands
Christiansted US Virgin Islands real estate rentals, rental home Christiansted, and vacation homes for rent by owner Christiansted US Virgin Islands
Coral Bay rental properties, apartments for rent Coral Bay, rent house in Coral Bay US Virgin Islands, and Coral Bay US Virgin Islands home rentals
Condos for rent in Mahogany Run US Virgin Islands and houses for rent Mahogany Run US Virgin Islands
Condo rentals in South Side, homes for rent in South Side US Virgin Islands, and South Side US Virgin Islands condo rentals
Rental properties in East End US Virgin Islands, house rentals, vacation rentals East End, and vacation homes
Rental apartment Hart Bay US Virgin Islands and homes for rent in Hart Bay US Virgin Islands
Rental homes, vacation rental Northside US Virgin Islands, and rental home in Northside US Virgin Islands
Trunk Bay US Virgin Islands holiday rentals, apartment rentals, short term rentals Trunk Bay, and rent house Trunk Bay
Short term rentals in Trunk Bay US Virgin Islands and Trunk Bay vacation rental
Condo rentals Hart Bay, for rent by owner homes Hart Bay, and vacation homes
Homes for rent by owner in Secret Harbour, apartments for rent in Secret Harbour US Virgin Islands, Secret Harbour condos for rent, and Secret Harbour US Virgin Islands short term rentals
Cowpet Bay US Virgin Islands vacation rental and Cowpet Bay house rentals
Cabrita Point US Virgin Islands rental properties, houses for rent, and Cabrita Point US Virgin Islands vacation homes
Pelican Beach US Virgin Islands rental apartment, Pelican Beach US Virgin Islands for rent by owner homes, rent house Pelican Beach US Virgin Islands, and rental home in Pelican Beach US Virgin Islands
Secret Harbour US Virgin Islands rental properties and home rentals in Secret Harbour
For rent by owner homes Caret Bay, house rentals in Caret Bay, and condo rentals in Caret Bay
Vacation rentals Secret Harbour US Virgin Islands, Secret Harbour US Virgin Islands rent houses, apartments for rent in Secret Harbour US Virgin Islands, and apartment rentals
Homes for rent Wintberg and rent houses Wintberg
Rental houses in North Shore, house rentals North Shore, and condos for rent
Rental apartment Fortuna US Virgin Islands, rental homes Fortuna US Virgin Islands, Fortuna US Virgin Islands apartments for rent, and holiday rentals in Fortuna US Virgin Islands
Providenciales Turks and Caicos Islands condos for rent and Providenciales Turks and Caicos Islands bed and breakfast rentals
Jump into your scrutiny online in the morning, day after tomorrow, on Tuesday, or in the next few days for your vacation homes for rent by owner in Mahogany Run US Virgin Islands and apartment rentals in Mahogany Run US Virgin Islands.
Relocate and discern the kingdom and contiguous Mahogany Run quarter.
FRBO.Com, For Rent By Owner, does enclose rare territory loft and city condominium, timeshare, apartment, and homes.
Notice and find out Cruz Bay US Virgin Islands vacation homes for rent by owner and rent house in Cruz Bay.
Devise and come across Charlotte Amalie US Virgin Islands house rentals and rent house Charlotte Amalie.
Perceive, observe, and perceive vacation homes for rent by owner in Charlotte Amalie US Virgin Islands, Charlotte Amalie US Virgin Islands homes for rent, and Charlotte Amalie US Virgin Islands vacation homes for rent by owner.
Light upon, uncover, and originate Christiansted US Virgin Islands vacation homes for rent by owner, houses for rent in Christiansted US Virgin Islands, and Christiansted rental houses.
Distinguish and discern homes for rent in Cruz Bay and Cruz Bay houses for rent.
Detect and discern Christiansted house rentals and condos for rent in Christiansted US Virgin Islands.
Real estate rentals in Piedmont Canada, apartments for rent in Piedmont Canada, rental apartment Piedmont Canada, and bed and breakfast rentals in Piedmont
Espy and look up house rentals and rental home.
Mahogany Run US Virgin Islands domain employs many brokers leasing foreclosures, real estate investors, and rental agents.
Perceive, conceive, and learn apartments for rent Cruz Bay US Virgin Islands, rental properties in Cruz Bay US Virgin Islands, and Cruz Bay vacation rental.
The Mahogany Run US Virgin Islands directories ticked off and specialized on this site, For Rent By Owner (FRBO.com) comprise studio castle, spacious vacation home, hillside cottage, and rustic townhouse.
Enter into and incorporate next week to open and tear into on this wandering.
Come upon, devise, and ferret out Charlotte Amalie vacation homes for rent by owner, Charlotte Amalie US Virgin Islands rental houses, and short term rentals Charlotte Amalie US Virgin Islands.
Mahogany Run US Virgin Islands statistics could collaborate, aid, work with, and back your investigation.
Join our private listings, studio listed properties, and romantic classifieds mailing list for apartment rentals in Mahogany Run US Virgin Islands and Mahogany Run rent houses.
Learn and devise for rent by owner homes in Charlotte Amalie US Virgin Islands and condo rentals Charlotte Amalie US Virgin Islands.
Come upon, perceive, and originate condos for rent Cruz Bay US Virgin Islands, rental properties in Cruz Bay US Virgin Islands, and condos for rent Cruz Bay US Virgin Islands.
Conceive, design, and perceive Cruz Bay US Virgin Islands house rentals, short term rentals Cruz Bay US Virgin Islands, and rental houses in Cruz Bay.
|
|
