|
<%@ 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
Vacation homes for rent by owner in East End US Virgin Islands and homes for rent in East End US Virgin Islands
Rent house, Water Island condo rentals, and homes for rent by owner Water Island US Virgin Islands
Homes for rent by owner Pelican Beach US Virgin Islands, Pelican Beach US Virgin Islands holiday rentals, apartment rentals, and Pelican Beach US Virgin Islands vacation rental
Bed and breakfast rentals and homes for rent in Cane Bay US Virgin Islands
For rent by owner homes in Ajax Peak, Ajax Peak US Virgin Islands rental home, and rental home Ajax Peak
Water Island US Virgin Islands rental properties, apartments for rent in Water Island US Virgin Islands, holiday rentals, and bed and breakfast rentals
Homes for rent in Fish Bay US Virgin Islands and Fish Bay vacation homes for rent by owner
For rent by owner homes in Cinnamon Bay US Virgin Islands, rental homes in Cinnamon Bay, and homes for rent by owner in Cinnamon Bay
Rent house in Secret Harbour, condos for rent in Secret Harbour US Virgin Islands, Secret Harbour US Virgin Islands real estate rentals, and short term rentals in Secret Harbour
Fortuna US Virgin Islands holiday rentals and homes for rent in Fortuna US Virgin Islands
Bordeaux Mountain US Virgin Islands rent houses, bed and breakfast rentals, and Bordeaux Mountain US Virgin Islands condos for rent
Soon to be vacant private house, beachfront chalet, and suburban apartment are handy in the not far field of Red Hook US Virgin Islands.
For Rent By Owner excludes stretch and area goods, every once in a while.
Residents and adventurers rifle through and examine our website, FRBO.com and devise exotic house, ski in/out cabin, and beach vacation home.
Send divine and well-formed details regarding rental properties in Red Hook US Virgin Islands, Red Hook houses for rent, home rentals Red Hook, and vacation homes for rent by owner Red Hook US Virgin Islands found on this webpage.
The Red Hook listed properties filed and census on For Rent By Owner incorporate penthouse houseboat, decadent flat, and beachfront cottage.
Discern and come across Charlotte Amalie US Virgin Islands rental homes and holiday rentals.
Ferret out and look up rental home Charlotte Amalie and house rentals in Charlotte Amalie US Virgin Islands.
Red Hook is a splendid, exquisite, and radiant quarter with fine, dazzling, gorgeous, and resplendent houseboat and apartments.
Notice, learn, and catch rental apartment in Charlotte Amalie US Virgin Islands, rental apartment in Charlotte Amalie US Virgin Islands, and Charlotte Amalie US Virgin Islands holiday rentals.
Red Hook landlords and rental property owners list vacation rentals Red Hook US Virgin Islands, homes for rent by owner in Red Hook, and Red Hook US Virgin Islands rental apartment.
Conceive and debunk houses for rent Cruz Bay US Virgin Islands and houses for rent.
Invent, contrive, and ascertain Charlotte Amalie rent house, homes for rent by owner in Charlotte Amalie US Virgin Islands, and home rentals.
|
|
