Hotels with a beachfront pool make it easy to enjoy the beach but hang out by a swimming pool, flowing easily between the two. Especially great if you are traveling with kids who want to play on the beach. Beachfront pools let everyone hang out together.
SELECT h.* FROM hotels h, amenitytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.AmenityID=980 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5
For those craving complete self-rejuvenation, Aleenta Resort and Spa is truly unbeatable. Located right on the beach, just off the Andaman coast, all rooms have floor-to-ceiling windows to frame its exotic view. The stunning beauty of Phang-Nga Bay came to fame in the James Bond film, The Man with the Golden Gun. Just 15 minutes away, set on the beach by the Andaman Sea, is Aleenta Resort and Spa. Aleenta breaks with sybaritic conformity; you come here for the self-renewal of energy. It is a stimulating and rewarding experience that combines with good food, traditional spa therapies, relaxation by the pool, exploring the hongs local bay caves and much more. Its palatial residences, rooms and villas are given every amenity so you can enjoy the tropical ambience. For the grand finale, sit back and watch the sunset from the Ocean View Lounge. Located on a quiet and unspoiled Natai Beach on the West Coast of Thailand and only 25 minutes from Phuket International Airport. Within short distance to local attractions such as Yacht Haven, Phang Nga Bay Natinoal Park and world class Blue Canyon Golf Course. Aleenta Resort and Spa is a Small Luxury Hotels of the World property.
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Balcony
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Shower (Private for the Room)
Bath: Separate Bathtub and Shower
Bath: Tub with a View
BBQ Area
Beach Bar
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Pool
Beachfront Restaurant
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Bedrooms: 3 Bedrooms
Beds with Views
Beds: Sofa Bed in Room
Bikes to Use
Blackout Drapes/Curtains
Business Center
Butler Service
Cable/Satellite TV
Car Rental
Chauffeured Car
Complimentary Breakfast
Concierge Services
Connecting Rooms
Cool Lounging Spot
Currency Exchange
Desk
Dining Area in the Room
Extra Romantic
Fireplace in the Room
Fireplace to Enjoy
Fitness Center
Gardens on the Property
Green Hotel
Hairdryer
In Room Movies
Internet: Available
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
Kids Menu
Kitchen: Coffee Maker
Kitchen: Dishwasher
Kitchen: Full Kitchen in the Unit
Kitchen: Kitchenette
Kitchen: Microwave
Kitchen: Refrigerator
Laundry - Washer/Dryer in Unit
Laundry/ Dry Cleaning Service
Limousine Service
Luxury Loaner Cars
Meeting Facilities
Microwave
Mini Bar
Non-Smoking Room
Ocean View Dining
Outdoor Dining
Outdoor Massage
Patio
Personal Concierge Available
Pool
Pool - Outdoor
Pool Cabanas
Poolside Food & Drink Service
Privacy
Private BBQ Area
Private Beach Dining
Private Boat Available
Private Chef Availalbe
Private Deck/Patio/Terrace
Private Dining Cool Spot
Private Garden with Room
Private Outdoor Hot Tub (with room)
Private Pool (Private Pool with the Room)
Restaurant On Property
Romantic Bed
Room Service (Limited)
Room Type: Beachfront Rooms
Room Type: Beachfront Villas
Room Type: Family Rooms
Room Type: Good for 2 Couples
Room Type: Indoor Outdoor Rooms
Room Type: Ocean View Rooms
Room Type: Pool Villas
Room Type: Stand Alone Single Unit
Room Type: Villa
Room Type: Waterfront Rooms
Safe Deposit Box
Safe: In-Room Safe
Sauna on Property
Self Parking - Uncovered
Separate Sitting Area
Slippers
Spa/Massage on Property
Stunning Settings
Telephone in Room
Turndown Service
Uniformed Security on Site
Valet Parking - Uncovered
View: Rooms with Ocean View
View: Rooms wtih Water Views
Wake-up Service
On the shores of the mediterranean and overlooking Port Olympic, the recently renovated hotel Arts Barcelona offers the ultimate experience in luxury. Panoramic views of the city and the sea can be enjoyed from all of the 483 guest rooms and suites. The 27 duplex apartments located on the top ten floors offer the ultimate in luxury. The Hotel is known for its superb service, a wealth of indoor and outdoor dining options, including the renowned Arola restaurant of the spainsh chef Sergi Arola ( Michelin-atarred chef) and luxuriously appointed rooms and suites with every amenity sophesticated travelers expect like Marble bathrooms,luxury bathrooms essentials, Bang & olufsen TV with satellite channes and DVD, Bang & Olufsen audiocenter with Ipod pluged in. Leisure facilities include a fitness center, swimming pool, beuty salon, hairdressers and boutiques selling designer clothes and jewellery. The hotel also offers a dual-level spa on the 42nd floor with amazing views and a wide range of treatment.
Juicy Tidbits Travel + Leisure says..."Stay in this tower of blue glass and steel that rises 44 stories in Vila OlAmpica (the Olympic Port) with stunning views of the city, water, and Frank Gehry's Fish sculpture. Some Catalonians find American architect Bruce Graham's ambitious design a bit too, well, American for their tastes, but visitors will welcome the many amenities, notably the efficient check-in, unparalleled Ritz-Carlton in this service-challenged city. The lobby affords an always-entertaining scene, as do the pool and alfresco restaurant, which have impressive views of both sea and skyline. There's also a well-equipped gym, a feature that cannot be found in other hotels (perhaps because chain-smoking remains this city's favorite form of exercise). Be sure to check out the hotel's notable art collection as well as potential celebrity guests." -From Travel + Leisure
Conde Nast Traveler says..."The 44-story Olympic Village glass-and-steel tower has rooms with stone, walnut wood, and cotton fabrics in chocolate and metallic tones. Duplex apartments on the top 10 floors come with butler service. Enoteca serves squid, lobster, and Iberian ham; the recently added Champagne Bar uncorks more than 40 types of bubbly. Service is "always impeccable." " -From Conde Nast Traveler
Juicy Details
Amenties
Air Conditioned/Climate Control
Art Collection
ATM/Bank on Property
Babysitting or Child Care
Barber/Hair Stylist
Beach
Beachfront Hotels
Beachfront Pool
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Bedrooms: 3 Bedrooms
Beds with Views
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Bus/RV Parking
Business Center
Cable/Satellite TV
Car Rental
Complimentary Newspaper
Concierge Services
Connecting Rooms
Cribs Available
Currency Exchange
Desk
Dining Area in the Room
Elevators
Fax Machine Available For Guests
Fitness Center
Golf Course on Property
Hairdryer
Internet: Available
Internet: WiFi in Public Areas
Iron/Ironing Board
Jogging Track
Kid Friendly
Kids Programs/Club
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Refrigerator
Laundry Room Available
Limousine Service
Maid Service
Marina
Meeting Facilities
Mini Bar
News Stand
Non-Smoking Room
Ocean View Dining
Outdoor Dining
Personal Concierge Available
Pet Friendly - Size Limit
Pets Allowed
Pool
Pool - Outdoor
Poolside Food & Drink Service
Restaurant On Property
Rollaway Beds Available
Room Service (24 Hours)
Room Service (Limited)
Room Type: Ocean View Rooms
Safe Deposit Box
Safe: In-Room Safe
Sauna on Property
Secretarial Services
Separate Sitting Area
Telephone in Room
Turndown Service
View: Rooms with City Views
View: Rooms with Ocean View
View: Rooms wtih Water Views
Wake-up Service
The Biras Creek Resort- which can only be reached by boat or helicopter is a secret address on the tiny island of Virgin Gorda. A paradise of greens and blues with its tropical plants and lagoons- also famous for its -Baths- formed by the spherical granite rocks dotted along the beach. The hotel offers 31 elegant and colourful suites with fabulous sea views. Share your time among the spa- the water sports on offer and the delicious cuisine. You can discover the island by Jet Ski- windsurf- boat or bicycle to really get a feel for this little corner of paradise.
Juicy Tidbits National Geographic Traveler says..."A 140-acre isthmus resort with water galore: calm lagoon, Caribbean bay, pounding Atlantic. Ocean waves do the entertaining just beyond the simply furnished suites (some TV-free) with private verandas, big windows, outdoor garden showers. Captain a Boston Whaler for island hopping, bike on trails lined by wild nutmeg and frangipani. Island-born chef infuses the menu with flavorsome Caribbean attitude. 31 suites." -From National Geographic Traveler
Conde Nast Traveler says..."Our experience surpassed our wildest expectations." This stone resort accessible only by boat or helicopter means "no hustle and bustle." At the hilltop restaurant, the "food and desserts are to die for!" "Service is impeccable." From rooms in white and turquoise, with bright Caribbean artwork and furnished verandas, the views of the Atlantic are "simply breathtaking." " -From Conde Nast Traveler
Juicy Details
Amenties
Air Conditioned/Climate Control
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Shower (Private for the Room)
Bath: Tub with a View
Beach
Beach Bar
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Pool
Beachfront Restaurant
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Beds with Views
Beds: Rooms with King Beds
Bikes to Use
Boat to Hotel
Business Center
Charm up the Wazoo
Concierge Services
Connecting Rooms
Dock Your Boat
Extra Romantic
Fitness Center
Green Hotel
Hairdryer
Hammocks to Hang Out On
Helicopter Access
Internet: Available
Internet: High Speed Outlet in Room
Internet: WiFi in Public Areas
iPod Docking Station
Iron/Ironing Board
Jogging Track
Kitchen: Coffee Maker
Kitchen: Refrigerator
Maid Service
Mini Bar
News Stand
No TV in the Room
Personal Concierge Available
Pillow Top Mattreses
Pool
Privacy
Private Beach Cabanas
Private Boat Available
Private Deck/Patio/Terrace
Romantic Bed
Room Type: Beachfront Rooms
Room Type: Bungalows
Room Type: Cottages
Room Type: Family Rooms
Room Type: Ocean View Rooms
Room Type: Stand Alone Single Unit
Room Type: Villa
Safe: In-Room Safe
Seaplane to Hotel
Small Plane Access
Stunning Settings
View: Rooms with Ocean View
View: Rooms wtih Water Views
Wake-up Service
Windows: Windows Open in the Room
A perfect sybaritic escape-secluded, peaceful, attentive service, sophisticated, and luxurious. Its graceful domes etch silhouettes against the deep-blue Anguillan sky. Moorish arches frame views of palms and bougainvillea, frangipani, and jasmine. A veritable paradise set on 179acres. Children of all ages are welcome year round, with no additional fees outside Dec 18th 2009 thru Jan 4th, 2010, and Dec 18th 2010 thru Jan 4th 2011.
Juicy Tidbits Travel + Leisure says..."Located on spectacular Maundays Bay, this 179-acre Caribbean resort with its striking Moorish architecture has long been a favorite of everyone from honeymooners to Hollywood A-listers. A recent renovation freshened public spaces as well as the interiors of its 97 rooms and suites and six private pool villasaknown for their Morocco-meets-West Indies dAcor (dark-wood louvered windows and white-tiled floors paired with colorful silk pillows and arched doorways). The lodgings are spread along two miles of sugary white-sand beach, as are the three restaurants, five cabana bars (where servers dole out free snacks), a spectacular domed open-air lounge, a wine bar, and a pool." -From Travel + Leisure
Juicy Details
Amenties
Air Conditioned/Climate Control
Balcony
Bath: Bathtub
Bath: Outdoor Shower (Private for the Room)
Bath: Private Bathroom
Bath: Separate Bathtub and Shower
Bath: Tub with a View
Beach
Beach Bar
Beach Good for Kids
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Pool
Beachfront Restaurant
Bedding: Down Comforter
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Bedrooms: 3 Bedrooms
Bedrooms: 4 Bedrooms
Bedrooms: 5 Bedrooms
Beds with Views
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Bikes to Use
Boat to Hotel
Boutique Shops
Business Center
Cable/Satellite TV
Car Rental
Complimentary Breakfast
Complimentary Newspaper
Concierge Services
Connecting Rooms
Cool Bath Tubs
Cool Lounging Spot
Cribs Available
Currency Exchange
Deadbolts and Locks in Rooms
Desk
Dining Area in the Room
Extra Romantic
Fax Machine Available For Guests
Fitness Center
Fitness Equipment
Gardens on the Property
Gift Shop
Golf Course on Property
Green Hotel
Hairdryer
Hammocks to Hang Out On
In Room Movies
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: Free Wireless
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi At the Beach
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
iPod Docking Station
Iron/Ironing Board
Jogging Track
Kid Friendly
Kids - Good for Teens
Kids Menu
Kids Programs/Club
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Refrigerator
Laundry/ Dry Cleaning Service
Live Music on Property
Meeting Facilities
Mini Bar
Non-smoking Property
Outdoor Dining
Outdoor Massage
Parking Area Patrolled
Parking Area Well Lit
Patio
Personal Concierge Available
Pool
Pool - Outdoor
Pool Cabanas
Privacy
Private Beach Dining
Private Boat Available
Private Pool (Private Pool with the Room)
Restaurant On Property
Rollaway Beds Available
Romantic Bed
Room Service (Limited)
Room Type: Beachfront Rooms
Room Type: Family Rooms
Room Type: Good for 2 Couples
Room Type: Good for 3 Couples
Room Type: Ocean View Rooms
Room Type: Pool Villas
Room Type: Villa
Safe Deposit Box
Safe: In-Room Safe
Self Parking - Uncovered
Separate Sitting Area
Sexy Bathrooms
Spa/Massage on Property
Telephone in Room
Tropical Vibe
Turndown Service
Uniformed Security on Site
VCR/VCP
View: Rooms with Ocean View
View: Rooms wtih Water Views
Voicemail
Windows: Windows Open in the Room
Pure escapist fantasy is the hallmark of the Conrad Maldives Rangali Island; 'the epitome of every tropical paradise fantasy' to quote British Elle magazine. This is a stunning, romantic island resort offering sophisticated barefoot luxury, surrounded by glorious natural beauty. Situated in a picturesque corner of the Maldives, the Conrad Maldives Rangali Island is a sybaritic combination of three luxury resorts spread across two islands, surrounded by a vibrant coral reef and lagoon. This luxury resort boasts the worlds only all-glass undersea restaurant; the largest Beach Villas in the Indian Ocean, as well as the country's only destination spa, complemented by a second spa with glass-floored treatment rooms over the ocean. Frequently winning awards and accolades, it is home to 50 of the most luxurious water villas in the country, 79 exotic beach villas and 21 fabulous spa water villas with private treatment rooms. A Gourmet's Paradise: Food lovers will find themselves at home amongst the seven restaurants, while wine connoisseurs will be happy to hear that over 10,000 bottles of wine, 700 labels from all around the world await discovery in the three bars. The seven restaurants and three bars are superb, offering outstanding cuisine served in stunning Locations: the famous undersea restaurant Ithaa offering fusion western/Maldivian cuisine in a dramatic setting 5 metres below the waves; ? la carte dining at Vilu by the lagoon's edge; and Japanese style teppanyaki at the Koko Grill. Atoll Market offers diners the chance to explore the best of the world's cuisine from eight different kitchens in the sand-floored restaurant, while the over-water Sunset Grill is the place for memorable meals under the stars. The underground Wine Cellar is home to over 5,000 bottles of wines selected by the resort's Wine Master and the setting for stunning d? gustation gourmet wine dinners hosted by Chef and the Sommelier; while the over-water Mandhoo restaurant in the Spa Retreat is.
Juicy Tidbits Travel + Leisure says... "The Setting: Overlook the Indian Ocean from the ultra-private two-person, 104-degree hot tub outside of Conrad Maldives Beach Villa on Rangalifinolhu Island. The resort is set on two private islands, linked by a bridge, and surrounded by a vibrant coral reef, among miles of idyllic white-sand beaches. Each secluded tub gives guests uninterrupted views of the bright blue water. Bonus: Hotel staffers provide guests with cool aromatic towels and fresh papaya and coconut juices."
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Airport Shuttle
Balcony
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Shower (Private for the Room)
Bath: Separate Bathtub and Shower
Bath: Tub with a View
BBQ Area
Beach Bar
Beach Good for Kids
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Pool
Beachfront Restaurant
Bedding: Fine Linens
Bedding: Pillow Menu
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Beds with Views
Beds: 2 Twin Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Beds: Sofa Bed in Room
Business Center
Butler Service
Cable/Satellite TV
Childrens Playground
Clothing Optional
Concierge Services
Connecting Rooms
Currency Exchange
Dock Your Boat
Extra Romantic
Fitness Center
Gardens on the Property
Hairdryer
Hammocks to Hang Out On
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
Internet: Available
Internet: Free Wireless
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi At the Beach
Internet: WiFi By the Pool
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
Jogging Track
Kid Friendly
Kids Menu
Kids Programs/Club
Kitchen: Coffee Maker
Laundry/ Dry Cleaning Service
Live Music on Property
Local Shuttle Service
Meeting Facilities
News Stand
Non-Smoking Room
Ocean View Dining
Patio
Personal Concierge Available
Photocopy Service
Pool
Pool - Extra Cool Kid Pool
Private BBQ Area
Private Beach Dining
Private Island
Private Outdoor Hot Tub (with room)
Private Pool (Private Pool with the Room)
Restaurant On Property
Room Service (Limited)
Room Type: Beachfront Rooms
Room Type: Bungalows
Room Type: Family Rooms
Room Type: Good for 2 Couples
Room Type: Ocean View Rooms
Room Type: Overwater Bungalows
Safe Deposit Box
Safe: In-Room Safe
Seaplane to Hotel
Self Parking - Uncovered
Separate Sitting Area
Slippers
Telephone in Room
View: Rooms with Ocean View
View: Rooms wtih Water Views
Waterfront Hotel Dining
Windows: Windows Open in the Room