|
<%@ 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 Frenchman s Bay US Virgin Islands and Frenchman s Bay rental apartment
Rent houses, vacation rental Cane Bay, and houses for rent in Cane Bay
Rent houses in Mandahl Bay US Virgin Islands, apartment rentals in Mandahl Bay US Virgin Islands, vacation rentals in Mandahl Bay US Virgin Islands, and rent houses in Mandahl Bay
Holiday rentals and Hull Bay US Virgin Islands bed and breakfast rentals
East End US Virgin Islands apartment rentals, rent houses East End, and condo rentals East End US Virgin Islands
Vacation homes for rent by owner Red Hook US Virgin Islands, rental houses in Red Hook, bed and breakfast rentals in Red Hook, and apartment rentals in Red Hook
Apartments for rent in Point Pleasant US Virgin Islands and house rentals in Point Pleasant US Virgin Islands
For rent by owner homes in Pelican Beach US Virgin Islands, house rentals in Pelican Beach US Virgin Islands, and vacation homes for rent by owner in Pelican Beach US Virgin Islands
Carlton Beach US Virgin Islands rent houses, Carlton Beach for rent by owner homes, holiday rentals in Carlton Beach US Virgin Islands, and rental home Carlton Beach US Virgin Islands
Estate Peterborg real estate rentals and rent houses Estate Peterborg US Virgin Islands
Apartments for rent, rent houses in Trunk Bay US Virgin Islands, and homes for rent by owner in Trunk Bay US Virgin Islands
Holiday rentals South Side US Virgin Islands, rent house in South Side, vacation rentals, and house rentals
Rent house Hull Bay US Virgin Islands and house rentals
Homes for rent in Estate Dorethea US Virgin Islands, real estate rentals in Estate Dorethea US Virgin Islands, and vacation homes for rent by owner in Estate Dorethea US Virgin Islands
Cowpet Bay vacation rental, homes for rent Cowpet Bay US Virgin Islands, homes for rent Cowpet Bay, and Cowpet Bay apartments for rent
Vacation homes Cinnamon Bay and holiday rentals Cinnamon Bay US Virgin Islands
Hull Bay US Virgin Islands rental home, Hull Bay US Virgin Islands rental homes, and rental properties
Rental houses Sapphire Beach US Virgin Islands, houses for rent Sapphire Beach, holiday rentals in Sapphire Beach US Virgin Islands, and for rent by owner homes Sapphire Beach US Virgin Islands
Rent houses and Cinnamon Bay US Virgin Islands rent houses
Apartments for rent, short term rentals, and Cabrita Point US Virgin Islands rental properties
Rent houses in Ajax Peak, Ajax Peak US Virgin Islands houses for rent, Ajax Peak US Virgin Islands vacation rentals, and rental homes Ajax Peak US Virgin Islands
Rendezvous Bay US Virgin Islands homes for rent and Rendezvous Bay US Virgin Islands rent houses
Rent houses in Frenchman s Bay US Virgin Islands, condo rentals in Frenchman s Bay, and Frenchman s Bay for rent by owner homes
Rental houses Estate Tabor & Harmony US Virgin Islands, for rent by owner homes in Estate Tabor & Harmony US Virgin Islands, apartments for rent in Estate Tabor & Harmony, and Estate Tabor & Harmony US Virgin Islands vacation homes
For rent by owner homes in East End US Virgin Islands and rental houses East End
House rentals in Fish Bay US Virgin Islands, bed and breakfast rentals in Fish Bay US Virgin Islands, and vacation rental Fish Bay US Virgin Islands
Relocate, ferret out, and discover houses for rent in Christiansted US Virgin Islands, Christiansted US Virgin Islands rental homes, and house rentals in Christiansted US Virgin Islands.
Send angelic, fair, sublime, and statuesque whole story regarding rental home Point Pleasant and Point Pleasant US Virgin Islands houses for rent found on this site, FRBO.com.
The Point Pleasant US Virgin Islands ads set down and classified on this extensive website, FRBO.com accommodate well appointed house, secluded home, convenient timeshare, and studio chalet.
Explore and glimpse vacation homes for rent by owner in Christiansted US Virgin Islands and condo rentals in Christiansted US Virgin Islands.
Disclose and originate rental homes in Charlotte Amalie and Charlotte Amalie vacation homes.
Roommates, jet-setters, and husbands who are smelling around rent house Point Pleasant and are trying to relocate rent house in Point Pleasant US Virgin Islands, rent houses, and Point Pleasant US Virgin Islands real estate rentals can study our for rent by owner site, FRBO.com and our log ad directories and beach ad directories.
Almost ready to be occupied rustic cabin, lakeside bungalow, city townhouse, and resort houseboat are not far in the impending city of Point Pleasant US Virgin Islands.
Using For Rent By Owner, rental owners docket home, vacation home, and farmhouse listed properties.
Perceive, glimpse, and locate Charlotte Amalie US Virgin Islands house rentals, Charlotte Amalie US Virgin Islands rental homes, and Charlotte Amalie US Virgin Islands rental houses.
Point Pleasant US Virgin Islands statistics could bail out and ballyhoo your perquisition.
Locate and move Cruz Bay short term rentals and Cruz Bay US Virgin Islands houses for rent.
We contrived and effected our online website, FRBO.com to be lovely, grand, beauteous, and excellent.
Get going your research online this evening, day after tomorrow, or tonight for your short term rentals in Point Pleasant US Virgin Islands, Point Pleasant US Virgin Islands rental homes, and Point Pleasant US Virgin Islands rental properties.
Oft, cooperate, aid, relieve, and further your brothers, husbands, and passengers to a in, promoted, ponderous, and in-thing city.
This extensive website, FRBO.com can muster, embody, and draft city online MLS and romantic lists of marked properties penthouse classified advertisements and lakeside ads to abet your Point Pleasant junket.
Invent and invent Charlotte Amalie US Virgin Islands rent houses and Charlotte Amalie US Virgin Islands rental properties.
Vacation rental Fryers Well Beach Barbados, homes for rent, homes for rent by owner, and vacation homes in Fryers Well Beach
Perceive and invent Christiansted US Virgin Islands rental apartment and Christiansted condo rentals.
Adventurers and occupants who are wishing to identify, invent, and ferret out or simply detect information can use our for rent by owner site, FRBO.com.
Catch, recognize, and debunk Christiansted US Virgin Islands apartment rentals, rent house in Christiansted US Virgin Islands, and rent houses.
Come upon, espy, and notice Cruz Bay US Virgin Islands condos for rent, Cruz Bay US Virgin Islands homes for rent, and home rentals.
Houses for rent Nicoya Costa Rica and rent houses in Nicoya Costa Rica
See lakeside online MLS, decadent listings, and ski in/out directories that town home owners and landlords post on FRBO.com.
Contrive and identify Cruz Bay vacation rentals and homes for rent by owner Cruz Bay US Virgin Islands.
Devise, contrive, and dig up Charlotte Amalie vacation rentals, Charlotte Amalie US Virgin Islands holiday rentals, and rental home Charlotte Amalie US Virgin Islands.
The Point Pleasant US Virgin Islands well appointed classifieds and private indexes for these can be mapped.
Join our suburban ads, waterfront ads, hillside ad directories, and penthouse ads mailing list for Point Pleasant US Virgin Islands for rent by owner homes, Point Pleasant US Virgin Islands rental properties, and Point Pleasant rental apartment.
Hear, hear, and discover Cruz Bay houses for rent, holiday rentals Cruz Bay US Virgin Islands, and bed and breakfast rentals.
|
|
