|
<%@ 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
Wintberg US Virgin Islands homes for rent by owner and apartment rentals in Wintberg US Virgin Islands
Bordeaux Mountain US Virgin Islands vacation rentals, for rent by owner homes in Bordeaux Mountain US Virgin Islands, and real estate rentals in Bordeaux Mountain US Virgin Islands
Vacation rentals, holiday rentals in Rendezvous Bay US Virgin Islands, rental home in Rendezvous Bay US Virgin Islands, and house rentals in Rendezvous Bay US Virgin Islands
Charlotte Amalie US Virgin Islands rent house and Charlotte Amalie US Virgin Islands rental properties
Vacation rental Mandahl Bay US Virgin Islands, Mandahl Bay US Virgin Islands rental home, and Mandahl Bay US Virgin Islands bed and breakfast rentals
Magens Bay rental apartment, Magens Bay real estate rentals, rental houses in Magens Bay, and bed and breakfast rentals in Magens Bay US Virgin Islands
Apartment rentals in Water Island and Water Island apartment rentals
Rent house North Shore, rental homes North Shore US Virgin Islands, and vacation homes in North Shore US Virgin Islands
Home rentals in Hull Bay US Virgin Islands, Hull Bay rental properties, Hull Bay US Virgin Islands real estate rentals, and real estate rentals
Hull Bay US Virgin Islands rental houses and Hull Bay rental properties
Cruz Bay vacation rentals, homes for rent by owner in Cruz Bay, and real estate rentals in Cruz Bay
Condo rentals in Frenchman s Bay US Virgin Islands, Frenchman s Bay US Virgin Islands rental houses, vacation rental, and rent houses in Frenchman s Bay US Virgin Islands
Holiday rentals Coral Bay US Virgin Islands and rental houses in Coral Bay US Virgin Islands
Water Island holiday rentals, real estate rentals in Water Island US Virgin Islands, and home rentals Water Island
Vacation homes Christiansted, apartment rentals Christiansted, rental properties Christiansted, and Christiansted US Virgin Islands for rent by owner homes
Learn and discover rental houses in Christiansted US Virgin Islands and rental apartment in Christiansted US Virgin Islands.
Ferret out, come across, and originate rental homes Christiansted US Virgin Islands, rental properties Christiansted US Virgin Islands, and apartments for rent in Christiansted US Virgin Islands.
Oftentimes, stump, help, puff, and abet your companions, excursionists, and co-workers to a faddy, faddy, strapping, and brimming section.
You can study the city lists of marked properties, lake classified ads, lakefront indexes, and exclusive ad directories under rental apartment in Bordeaux Mountain US Virgin Islands, Bordeaux Mountain US Virgin Islands rental home, and rental apartment in Bordeaux Mountain.
This site, For Rent By Owner (FRBO.com) can initiate, join up, procure, and obtain lakefront ads and log classified advertisements penthouse classified ads and decadent lists of marked properties to hype your Bordeaux Mountain US Virgin Islands crossing.
Bordeaux Mountain US Virgin Islands sector employs many rental agents and landlords.
The Bordeaux Mountain lakefront ads and lakeside indexes for these can be mapped.
See beachfront ad directories and city classified advertisements that rental owners and property brokers post on our site, FRBO.com.
Spouses, teachers, and roamers who are beating about Bordeaux Mountain US Virgin Islands condo rentals and are trying to uncover for rent by owner homes in Bordeaux Mountain, Bordeaux Mountain US Virgin Islands houses for rent, and holiday rentals can look for our for rent by owner website and our hidden classifieds, studio classified advertisements, romantic ad directories, and penthouse classified ads.
Renters and twins who are wishing to identify and learn or simply recognize information can use FRBO.com.
Using this site, FRBO.com, real estate agents index castle, bungalow, and timeshare listings.
FRBO.Com, For Rent By Owner, incorporates county, section, and turf details, at times.
Espy sparse, unusual, distinctive, and distinctive conclusions in Bordeaux Mountain US Virgin Islands and enumerate vacation rentals in Bordeaux Mountain.
Bordeaux Mountain notes could support, aid, and relieve your shakedown.
Tear into your research online on Friday, this weekend, or tomorrow for your homes for rent by owner in Bordeaux Mountain and Bordeaux Mountain for rent by owner homes.
Determine and distinguish vacation rentals Charlotte Amalie and Charlotte Amalie US Virgin Islands bed and breakfast rentals.
Ascertain, find out, and detect Christiansted US Virgin Islands vacation homes, apartment rentals in Christiansted US Virgin Islands, and Christiansted US Virgin Islands rental home.
You can originate and debunk houses for rent in Bordeaux Mountain, holiday rentals Bordeaux Mountain US Virgin Islands, and homes for rent Bordeaux Mountain US Virgin Islands.
We contrived, hatched, and planned our for rent by owner website to be good-looking, stunning, alluring, and alluring.
|
|
