|
<%@ 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
Home rentals in Ritz Carlton US Virgin Islands and homes for rent by owner in Ritz Carlton US Virgin Islands
Bed and breakfast rentals, bed and breakfast rentals in Cruz Bay, and Cruz Bay US Virgin Islands rental homes
Wintberg US Virgin Islands rental home, Wintberg US Virgin Islands holiday rentals, rent house in Wintberg US Virgin Islands, and Wintberg apartment rentals
Short term rentals and Pelican Beach US Virgin Islands bed and breakfast rentals
Condo rentals Cane Bay, rent houses in Cane Bay, and Cane Bay US Virgin Islands for rent by owner homes
Rental properties, holiday rentals Carlton Beach US Virgin Islands, Carlton Beach US Virgin Islands rental apartment, and Carlton Beach US Virgin Islands rental apartment
Hart Bay US Virgin Islands homes for rent and rental houses
Sapphire Beach US Virgin Islands rent house, houses for rent in Sapphire Beach US Virgin Islands, and condo rentals
Pineapple Village US Virgin Islands for rent by owner homes, rent houses in Pineapple Village US Virgin Islands, Pineapple Village US Virgin Islands rental homes, and short term rentals in Pineapple Village US Virgin Islands
Trunk Bay US Virgin Islands short term rentals and Trunk Bay US Virgin Islands rental properties
Rental houses Magens Bay US Virgin Islands, vacation rental, and Magens Bay US Virgin Islands rental apartment
Vacation homes in Caret Bay US Virgin Islands, homes for rent Caret Bay, apartments for rent Caret Bay, and holiday rentals
You can find out, contrive, and ascertain vacation homes in Chocolate Hole US Virgin Islands and vacation homes.
Ascertain, disclose, and find out condos for rent in Cruz Bay, vacation rental, and vacation homes.
Join our resort advertisements and beach classified advertisements mailing list for Chocolate Hole vacation rental, condo rentals in Chocolate Hole US Virgin Islands, and Chocolate Hole rental home.
Disclose and recognize bed and breakfast rentals in Christiansted US Virgin Islands and rental apartment Christiansted.
Every now and then, plug, ride shotgun, cooperate, and do for your salesmen and rent payers to a accepted and hulking section.
Discover novel, sparse, and another story measurements in Chocolate Hole US Virgin Islands and button down Chocolate Hole rent house.
The Chocolate Hole US Virgin Islands classified advertisements enrolled and set down on this website, FRBO.com exclude lakeside condominium, suburban vacation home, romantic vacation home, and secluded ranch.
Detect, uncover, and identify Cruz Bay US Virgin Islands rental home, real estate rentals in Cruz Bay US Virgin Islands, and Cruz Bay vacation homes for rent by owner.
Send enticing, beauteous, foxy, and admirable documents regarding Chocolate Hole rental apartment, vacation rentals in Chocolate Hole US Virgin Islands, and short term rentals Chocolate Hole US Virgin Islands found on this website, FRBO.com.
Perceive, discover, and light upon rental home Cruz Bay US Virgin Islands, Cruz Bay US Virgin Islands rental properties, and rental properties Cruz Bay.
See beach ad directories, loft classifieds, beachfront indexes, and well appointed classified ads that condo owners and real estate investors post on our site, FRBO.com.
Chocolate Hole US Virgin Islands is a fair and cute tract with graceful, wonderful, angelic, and sublime ranch, apartment, houseboat, and timeshares.
Detect and relocate Charlotte Amalie rental home and Charlotte Amalie US Virgin Islands vacation rentals.
|
|
