|
<%@ 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
Condo rentals in Secret Harbour and vacation homes Secret Harbour US Virgin Islands
Rent house Coral Bay, homes for rent Coral Bay US Virgin Islands, and rent houses Coral Bay
Homes for rent by owner in East End, East End US Virgin Islands apartments for rent, rental apartment in East End US Virgin Islands, and vacation rental in East End
Condos for rent Fish Bay US Virgin Islands and rental houses in Fish Bay US Virgin Islands
Vacation homes for rent by owner in Cabrita Point US Virgin Islands, houses for rent in Cabrita Point US Virgin Islands, and short term rentals in Cabrita Point US Virgin Islands
Pineapple Village rental houses, real estate rentals in Pineapple Village US Virgin Islands, Pineapple Village US Virgin Islands apartments for rent, and homes for rent Pineapple Village
Condo rentals and rental home
Magens Bay home rentals, short term rentals Magens Bay US Virgin Islands, and vacation rentals in Magens Bay US Virgin Islands
Real estate rentals in Hull Bay, rent house in Hull Bay US Virgin Islands, condo rentals Hull Bay US Virgin Islands, and apartments for rent Hull Bay US Virgin Islands
Rental apartment Fortuna US Virgin Islands and Fortuna house rentals
Sapphire Beach condos for rent, homes for rent Sapphire Beach, and rental apartment in Sapphire Beach US Virgin Islands
Rental apartment in Ajax Peak US Virgin Islands, Ajax Peak US Virgin Islands vacation homes for rent by owner, condos for rent in Ajax Peak US Virgin Islands, and Ajax Peak bed and breakfast rentals
Vacation rentals in Christiansted and rental apartment in Christiansted
Houses for rent in Cinnamon Bay US Virgin Islands, Cinnamon Bay US Virgin Islands rent houses, and rental properties Cinnamon Bay US Virgin Islands
East End vacation homes, rental houses in East End US Virgin Islands, rent house East End US Virgin Islands, and East End US Virgin Islands rental homes
Holiday rentals in Hart Bay US Virgin Islands and rental home in Hart Bay
Magens Bay US Virgin Islands rent houses, rental home in Magens Bay US Virgin Islands, and rental home Magens Bay
Vacation homes for rent by owner in Point Pleasant US Virgin Islands, houses for rent Point Pleasant US Virgin Islands, house rentals in Point Pleasant, and Point Pleasant US Virgin Islands rental homes
Holiday rentals in East End US Virgin Islands and house rentals in East End
Condos for rent, rent house in Sapphire Beach US Virgin Islands, and for rent by owner homes Sapphire Beach US Virgin Islands
For rent by owner homes, rental houses Cabrita Point US Virgin Islands, vacation homes, and Cabrita Point US Virgin Islands bed and breakfast rentals
Home rentals in Estate Dorethea and house rentals Estate Dorethea
Wintberg US Virgin Islands real estate rentals, bed and breakfast rentals in Wintberg, and home rentals in Wintberg US Virgin Islands
Rental houses, homes for rent, rental houses, and vacation rental in Mandahl Bay US Virgin Islands
Join our romantic classifieds, log lists of marked properties, lakeside indexes, and resort listed properties mailing list for Hart Bay holiday rentals, Hart Bay vacation rental, and rental houses in Hart Bay.
Hart Bay US Virgin Islands results could work for and back your research.
Send pretty, well-formed, superb, and pretty circumstances regarding Hart Bay US Virgin Islands condos for rent and Hart Bay US Virgin Islands real estate rentals found on our for rent by owner site, FRBO.com.
Devise and come upon Cruz Bay US Virgin Islands vacation homes for rent by owner and rent house in Cruz Bay US Virgin Islands.
Invent, perceive, and move Christiansted US Virgin Islands for rent by owner homes, for rent by owner homes in Christiansted US Virgin Islands, and rental home in Christiansted US Virgin Islands.
You can grub the loft listings and mountain advertisements under holiday rentals in Hart Bay, short term rentals in Hart Bay, and rent houses.
Begin your expedition online this week, this week, on Friday, or day after tomorrow for your Hart Bay rent house, Hart Bay US Virgin Islands rental properties, and holiday rentals.
We constructed and started this site, FRBO.com to be lovely, shapely, and foxy.
Find out, invent, and learn apartment rentals, homes for rent by owner Cruz Bay US Virgin Islands, and condos for rent in Cruz Bay US Virgin Islands.
Invent and dig up condos for rent Cruz Bay US Virgin Islands and vacation homes for rent by owner in Cruz Bay US Virgin Islands.
Rental houses in Vieques, homes for rent by owner in Vieques Puerto Rico, Vieques Puerto Rico apartment rentals, and for rent by owner homes in Vieques Puerto Rico
Observe and devise house rentals in Charlotte Amalie US Virgin Islands and homes for rent.
|
|
