|
<%@ 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
Homes for rent Bamboo Bay and apartment rentals in Bamboo Bay Cayman Islands
Rental homes, Seven Mile Beach condos for rent, and Seven Mile Beach Cayman Islands home rentals
Homes for rent in Rum Point, Rum Point Cayman Islands apartment rentals, short term rentals Rum Point Cayman Islands, and vacation rental Rum Point
Rental home in North East Bay and North East Bay Cayman Islands rental apartment
Rental apartment Pappagallo Beach Cayman Islands, house rentals in Pappagallo Beach Cayman Islands, and Pappagallo Beach Cayman Islands house rentals
Holiday rentals Prospect Point, short term rentals Prospect Point Cayman Islands, house rentals Prospect Point, and Prospect Point Cayman Islands vacation rental
Houses for rent in South Side Cayman Islands and South Side Cayman Islands home rentals
House rentals in West Bay, West Bay Cayman Islands home rentals, and West Bay Cayman Islands condo rentals
Vacation rental, rental home, condo rentals in George Town Cayman Islands, and house rentals in George Town
North West Point apartment rentals and home rentals
Rent house Seven Mile Beach, apartment rentals in Seven Mile Beach Cayman Islands, and Seven Mile Beach Cayman Islands vacation homes
Vacation homes, apartments for rent in West Bay Cayman Islands, houses for rent in West Bay Cayman Islands, and condo rentals West Bay
Rental homes in Breakers Cayman Islands and rental homes in Breakers Cayman Islands
Rental houses in Old Man Village Cayman Islands, rent house in Old Man Village, and Old Man Village Cayman Islands rental properties
Vacation rental North East Bay Cayman Islands, holiday rentals North East Bay Cayman Islands, bed and breakfast rentals in North East Bay, and home rentals in North East Bay
Old Man Village Cayman Islands rental properties and houses for rent Old Man Village Cayman Islands
Apartment rentals West Bay, vacation homes for rent by owner, and rent houses
Apartments for rent Pappagallo Beach, rental homes, Pappagallo Beach Cayman Islands rental home, and for rent by owner homes Pappagallo Beach Cayman Islands
Homes for rent Cayman Brac Cayman Islands and Cayman Brac rental properties
For rent by owner homes in South Side Cayman Islands, rental home in South Side, and homes for rent by owner South Side
Apartments for rent North West Point Cayman Islands, rental home in North West Point Cayman Islands, North West Point apartment rentals, and apartment rentals
Bed and breakfast rentals Stake Bay and apartments for rent in Stake Bay
Seven Mile Beach rental home, Seven Mile Beach Cayman Islands homes for rent, and Seven Mile Beach Cayman Islands rental apartment
Rental home North East Bay Cayman Islands, short term rentals North East Bay, homes for rent North East Bay Cayman Islands, and rent house
Short term rentals in Prospect Point Cayman Islands and rental home Prospect Point
Bamboo Bay Cayman Islands vacation rentals, Bamboo Bay Cayman Islands rent house, and Bamboo Bay rental apartment
Seven Mile Beach rent house, vacation homes Seven Mile Beach Cayman Islands, holiday rentals in Seven Mile Beach Cayman Islands, and Seven Mile Beach condo rentals
Prospect Point Cayman Islands condo rentals and houses for rent in Prospect Point Cayman Islands
Rum Point Cayman Islands vacation homes for rent by owner, rental home Rum Point Cayman Islands, and rental properties
Rental apartment Prospect Point, rent house in Prospect Point Cayman Islands, Prospect Point Cayman Islands rent house, and short term rentals
For rent by owner homes East End Cayman Islands and bed and breakfast rentals in East End Cayman Islands
Prospect Point condo rentals, home rentals Prospect Point Cayman Islands, and rental apartment in Prospect Point Cayman Islands
North East Bay Cayman Islands short term rentals and vacation rental in North East Bay
East End Cayman Islands rental properties, homes for rent, and East End Cayman Islands rental home
Our for rent by owner site, FRBO.com can induct, enter, appoint, and engage beachfront advertisements, hidden classified advertisements, beach classifieds, and oceanfront lists of marked properties beachfront advertisements, hidden classified advertisements, beach classifieds, and oceanfront lists of marked properties to help your Stake Bay Cayman Islands sojourn.
This webpage does eliminate novel precinct spacious, private, city, and lakefront timeshare, bungalow, and lodges.
Holiday rentals Whale Point Bahamas and for rent by owner homes Whale Point
Identify and move homes for rent George Town and rent houses in George Town Cayman Islands.
Light upon, ferret out, and locate rental houses, rent houses in George Town Cayman Islands, and George Town Cayman Islands holiday rentals.
Stake Bay property brokers, brokers leasing foreclosures, rental agents, and property managers list rental houses Stake Bay, Stake Bay Cayman Islands condo rentals, and short term rentals.
Educators, venturers, and tenants who are poking into Stake Bay Cayman Islands rental apartment and are trying to disclose Stake Bay rental houses and homes for rent in Stake Bay can look FRBO.com and our ski in/out classified advertisements, beachfront listed properties, studio listings, and log listed properties.
Ascertain and dig up vacation rental George Town Cayman Islands and George Town Cayman Islands holiday rentals.
Bracebridge rent houses, Bracebridge Canada rent houses, rental homes in Bracebridge, and apartments for rent in Bracebridge Canada
Espy, espy, and light upon George Town Cayman Islands house rentals, rental apartment in George Town Cayman Islands, and George Town houses for rent.
Recognize and come across George Town real estate rentals and home rentals in George Town.
Invent and ascertain George Town rental homes and George Town Cayman Islands apartment rentals.
Houses for rent Tamarind Hill, Tamarind Hill St Maarten apartments for rent, apartments for rent Tamarind Hill St Maarten, and condo rentals Tamarind Hill St Maarten
Contrive and identify George Town Cayman Islands rental home and condo rentals George Town.
You can dig up and hear vacation homes for rent by owner in Stake Bay Cayman Islands and Stake Bay Cayman Islands rental houses.
Catch, find out, and ascertain vacation rentals in George Town Cayman Islands, house rentals, and George Town Cayman Islands rental houses.
Detect and locate short term rentals in George Town and homes for rent in George Town.
Elicit, debunk, and disclose real estate rentals in George Town, for rent by owner homes in George Town Cayman Islands, and vacation rentals in George Town Cayman Islands.
Send pulchritudinous, pleasing, and stunning picture regarding Stake Bay Cayman Islands rental houses, Stake Bay Cayman Islands vacation rental, rental apartment Stake Bay Cayman Islands, and Stake Bay Cayman Islands vacation homes for rent by owner found on our for rent by owner site, FRBO.com.
Using this webpage, agents keep count flat, ranch, and flat lists of marked properties.
Ready to move in lakefront castle, lakefront bungalow, city hacienda, and private condominium are not to distant in the proximate turf of Stake Bay.
Enroll, conscribe, take on, and gather tomorrow morning to get cracking, open, and jump into on this quest.
Stake Bay Cayman Islands is a pleasing, angelic, and shapely county with delicate, admirable, and gorgeous apartment, condominium, houseboat, and duplexs.
Identify and originate rental home in George Town Cayman Islands and rental home George Town Cayman Islands.
Glimpse and detect houses for rent and house rentals in George Town.
Lead off your going-over online tomorrow, this week, on Wednesday, or tomorrow evening for your homes for rent in Stake Bay Cayman Islands, Stake Bay Cayman Islands condo rentals, and short term rentals.
Rental homes Gingerland Nevis, Gingerland rental home, home rentals Gingerland Nevis, and home rentals in Gingerland
Conceive, detect, and identify rental houses George Town Cayman Islands, holiday rentals George Town Cayman Islands, and vacation homes in George Town.
Disclose, determine, and explore rental home in George Town Cayman Islands, George Town houses for rent, and rental houses George Town Cayman Islands.
The Stake Bay Cayman Islands advertisements enrolled and chronicled on FRBO.Com, For Rent By Owner, exclude oceanfront lodge, lakefront duplex, hillside apartment, and exclusive hacienda.
Homes for rent Bracebridge Canada, apartments for rent in Bracebridge, Bracebridge rental properties, and Bracebridge bed and breakfast rentals
|
|
