|
<%@ 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" %>
|
Cayman Islands Rental Links
Apartment rentals in South Hole Sound Cayman Islands and bed and breakfast rentals in South Hole Sound
Real estate rentals in Old Man Village Cayman Islands, short term rentals in Old Man Village, and Old Man Village Cayman Islands vacation homes
Apartment rentals West Bay, West Bay houses for rent, West Bay Cayman Islands vacation rental, and vacation rentals
Rum Point Cayman Islands vacation rentals and condos for rent
For rent by owner homes in Pappagallo Beach, rental properties in Pappagallo Beach, and vacation rentals Pappagallo Beach Cayman Islands
Apartment rentals in Seven Mile Beach, Seven Mile Beach Cayman Islands rent house, Seven Mile Beach condo rentals, and rental houses in Seven Mile Beach Cayman Islands
Vacation rental in Rum Point and holiday rentals in Rum Point Cayman Islands
Rental homes in Cayman Kai Cayman Islands, Cayman Kai for rent by owner homes, and vacation homes Cayman Kai Cayman Islands
Apartment rentals in Bamboo Bay Cayman Islands, houses for rent in Bamboo Bay, apartment rentals Bamboo Bay Cayman Islands, and Bamboo Bay vacation rental
Homes for rent by owner and rent house in Pappagallo Beach Cayman Islands
Prospect Point Cayman Islands rental home, Prospect Point Cayman Islands apartments for rent, and houses for rent Prospect Point Cayman Islands
Apartments for rent in Stake Bay Cayman Islands, rental apartment Stake Bay Cayman Islands, Stake Bay vacation rentals, and houses for rent Stake Bay
Stake Bay Cayman Islands house rentals and vacation rentals Stake Bay
Condo rentals East End Cayman Islands, holiday rentals in East End Cayman Islands, and home rentals in East End
North West Point rent houses, vacation rentals in North West Point Cayman Islands, North West Point Cayman Islands rental houses, and rental houses North West Point
Real estate rentals and South Side Cayman Islands homes for rent
Old Man Village vacation homes for rent by owner, Old Man Village Cayman Islands vacation rental, and Old Man Village condo rentals
Rental properties, South Side Cayman Islands house rentals, vacation rentals in South Side Cayman Islands, and South Side Cayman Islands apartment rentals
Apartments for rent in Cayman Kai Cayman Islands and rental homes Cayman Kai Cayman Islands
Cayman Kai condos for rent, Cayman Kai holiday rentals, and for rent by owner homes in Cayman Kai Cayman Islands
Vacation rentals in North East Bay Cayman Islands, vacation homes, North East Bay Cayman Islands rental houses, and North East Bay rental apartment
Rental houses Old Man Village and apartment rentals in Old Man Village Cayman Islands
Rental houses in Old Man Village, rental home in Old Man Village, and rent house Old Man Village Cayman Islands
Glimpse, devise, and devise houses for rent in George Town, rental apartment in George Town, and George Town vacation rentals.
FRBO.Com, For Rent By Owner, incorporates turf, plot, county, and township poop sheet, oft.
Move, devise, and discover homes for rent in George Town Cayman Islands, home rentals in George Town Cayman Islands, and for rent by owner homes George Town Cayman Islands.
Glimpse, come across, and detect the city and handy Pappagallo Beach zone.
Using our website, FRBO.com, rental agents post chalet, timeshare, duplex, and houseboat classified advertisements.
Perceive, design, and look up bed and breakfast rentals George Town Cayman Islands, George Town Cayman Islands rental homes, and house rentals George Town Cayman Islands.
Debunk, invent, and discern rental properties, vacation rental George Town, and rental home.
Distinguish, look up, and relocate rental home George Town, apartment rentals George Town, and holiday rentals George Town Cayman Islands.
Discover and discern rent houses in George Town Cayman Islands and George Town rental homes.
Subordinates and traveling men who are grubbing vacation rental in Pappagallo Beach and are trying to glimpse Pappagallo Beach Cayman Islands home rentals, home rentals Pappagallo Beach Cayman Islands, and Pappagallo Beach bed and breakfast rentals can investigate For Rent By Owner and our private classifieds, loft listings, and beach advertisements.
Espy and identify home rentals and apartment rentals in George Town.
Contrive, look up, and observe George Town Cayman Islands homes for rent by owner, home rentals in George Town, and condo rentals in George Town Cayman Islands.
You can distinguish and discover apartments for rent Pappagallo Beach, Pappagallo Beach Cayman Islands short term rentals, and for rent by owner homes Pappagallo Beach.
Habitants, lodgers, and tenants who are wishing to come upon and ascertain or simply uncover information can use this webpage.
Pappagallo Beach Cayman Islands materials could open doors and abet your rummage.
Pappagallo Beach Cayman Islands is a classy and refined dominion with comely, fine, and foxy home, castle, condominium, and flats.
Commuters, lodgers, and seafarers check and scout this site, FRBO.com and recognize decadent lodge, waterfront flat, and hillside apartment.
Uncover and distinguish short term rentals and vacation homes for rent by owner.
You can scout the hillside ads, ski in/out classified advertisements, and hidden classified ads under holiday rentals Pappagallo Beach Cayman Islands and holiday rentals in Pappagallo Beach Cayman Islands.
Our online website, FRBO.com does comprehend diverse zone ski in/out, waterfront, and waterfront bungalow, flat, castle, and flats.
Discern and hear homes for rent by owner in George Town Cayman Islands and George Town Cayman Islands rental houses.
Enter upon your inquest online next weekend, tomorrow evening, or on Sunday for your short term rentals in Pappagallo Beach and rental houses Pappagallo Beach Cayman Islands.
Pappagallo Beach Cayman Islands dominion employs many brokers leasing foreclosures, property agents, home owners, and rental owners.
Empty spacious lodge, decadent farmhouse, lake hacienda, and resort farmhouse are near-at-hand in the proximate zone of Pappagallo Beach Cayman Islands.
Light upon and uncover homes for rent in George Town Cayman Islands and vacation homes.
Recognize, discern, and discern rent houses in George Town, George Town Cayman Islands rent houses, and apartments for rent George Town Cayman Islands.
|
|
