|
<%@ 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
Holiday rentals Caret Bay US Virgin Islands and Caret Bay rental apartment
Rental apartment in Estate Peterborg, apartment rentals Estate Peterborg US Virgin Islands, and apartment rentals in Estate Peterborg
Apartments for rent Hart Bay, apartment rentals in Hart Bay, short term rentals in Hart Bay US Virgin Islands, and Hart Bay US Virgin Islands home rentals
Apartment rentals in Secret Harbour US Virgin Islands and vacation rentals in Secret Harbour US Virgin Islands
Houses for rent Pineapple Village US Virgin Islands, apartment rentals, and houses for rent Pineapple Village
House rentals Fish Bay US Virgin Islands, Fish Bay rental apartment, rental homes, and Fish Bay US Virgin Islands for rent by owner homes
For rent by owner homes in Mahogany Run and Mahogany Run for rent by owner homes
Rental apartment Magens Bay, Magens Bay US Virgin Islands bed and breakfast rentals, and apartment rentals Magens Bay US Virgin Islands
Homes for rent by owner in Mandahl Bay US Virgin Islands, rental apartment in Mandahl Bay, apartment rentals in Mandahl Bay, and rental properties Mandahl Bay US Virgin Islands
Apartments for rent Pelican Beach US Virgin Islands and Pelican Beach US Virgin Islands vacation homes for rent by owner
For rent by owner homes, vacation rentals, and East End US Virgin Islands rent house
Homes for rent by owner in Cane Bay US Virgin Islands, rent houses in Cane Bay US Virgin Islands, Cane Bay homes for rent by owner, and Cane Bay US Virgin Islands rental homes
Bed and breakfast rentals in Cane Bay and rental houses in Cane Bay US Virgin Islands
Rental apartment in Mahogany Run US Virgin Islands, condo rentals Mahogany Run, and Mahogany Run holiday rentals
Rental properties Secret Harbour, holiday rentals Secret Harbour US Virgin Islands, vacation rentals in Secret Harbour US Virgin Islands, and rental apartment Secret Harbour
We invested and designed our website, FRBO.com to be elegant, exquisite, resplendent, and foxy.
The South Side US Virgin Islands ad directories inscribed and itemized on For Rent By Owner subsume romantic lodge and city apartment.
Discern rare, discrete, and rare reports in South Side US Virgin Islands and itemize homes for rent in South Side US Virgin Islands.
The South Side beachfront ads, studio ad directories, and loft lists of marked properties for these can be mapped.
Find, discern, and notice the state and imminent South Side US Virgin Islands sector.
Periodically, sustain and expedite your venturers and gypsies to a bulky, substantial, and charming zone.
See beach indexes, oceanfront ads, suburban classifieds, and waterfront classified advertisements that home owners and real estate agents post on our page.
South Side dossier could sustain and aid your research.
You can conceive, conceive, and learn houses for rent in South Side, real estate rentals in South Side US Virgin Islands, and apartments for rent South Side US Virgin Islands.
Get, incorporate, enroll, and assign in the morning to originate, enter upon, and initiate on this safari.
Spouses and tenants hunt for, seek, and inspect our for rent by owner website and discover suburban hacienda, lake cabin, hillside bungalow, and spacious chalet.
Ascertain and catch Cruz Bay US Virgin Islands for rent by owner homes and Cruz Bay US Virgin Islands bed and breakfast rentals.
South Side US Virgin Islands section employs many agents serving the condo market, real estate investors, agents serving the condo market, and third party listing companies.
Join our convenient listed properties, log ad directories, and decadent indexes mailing list for vacation rentals South Side US Virgin Islands, home rentals, and South Side US Virgin Islands rent house.
Originate, discern, and observe homes for rent by owner, apartment rentals Charlotte Amalie US Virgin Islands, and Charlotte Amalie US Virgin Islands vacation rentals.
Design, discern, and originate houses for rent Christiansted US Virgin Islands, real estate rentals in Christiansted US Virgin Islands, and short term rentals.
Observe, discover, and devise Christiansted US Virgin Islands rent houses, rent house in Christiansted US Virgin Islands, and real estate rentals in Christiansted.
Uncover and originate apartment rentals in Charlotte Amalie US Virgin Islands and Charlotte Amalie US Virgin Islands vacation rentals.
|
|
