SELECT h.* FROM hotels h, amenitytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.AmenityID=923 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5
The spectacular Burj Al Arab-designed to resemble the graceful sails of an Arabian dhow-soars to a height of three hundred and twenty one meters-dominating the Dubai coastline-The all suite hotel is situated on a man made island some two hundred and eighty meters-offshore and is linked to the mainland by a slender-gently curving causeway-Each of the two hundred and two suites is arranged over two floors and all with floor to ceiling-wall to wall windows and tranquil views of the sea-The highest standards of personal service are enhanced by private reception desks on every floor-In-suite check-in-a brigade of exclusive butlers that provide around the clock assistance and unrivaled attention never ceases to amaze our guests.
Juicy Tidbits Conde Nast Traveler says..."Get used to out of the ordinary at this sail-shaped, fiberglass landmark on the Persian Gulf. Aside from the "very gold and very loud decor, the roomsaall duplex suitesaoffer floor-to-ceiling windows and Hermes amenities. At Junsui, Asian dishes are prepared at 12 cooking stations. "I couldn't figure out how every staff member knew my name within minutes of my arrival." -From Conde Nast Traveler
Travel + Leisure says..."This iconic, sail-shaped hotelawhich soars 1,053 feet over the Persian Gulf, on an artificial island off Jumeirah Beachaliterally epitomizes Dubai's over-the-topness. And though the property, which was completed in 1999, is ancient by local standards, guests still stop to gawk at the self-professed “seven-stara hotel's 600-foot-high atrium when they first enter (many do so after arriving via helicopter or chauffeur-driven Rolls-Royce Silver Seraph limo). The 202 massive suites (which start at 1,830 square feet and go all the way to 8,396) are all bilevel, with floor-to-ceiling glass windows; dedicated butler service; fully equipped private bars; offices with automated everything; and bed linens, furniture, and window treatments upholstered in opulent velvets and satins. The sprawling baths are stocked with full-size Hermès toiletries (other little gifts, like La Prairie night cream and aromatherapy “sleep spray,a arrive in guests' suites each night). The property's common areas are equally excessive; of the six restaurants, Al Mahara, serving high-end seafood, is designed to look as if it were underwater, with a huge aquarium and a dining room accessible via simulated submarine ride from the lobby." -From Travel + Leisure
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Shower (Private for the Room)
Bath: Private Bathroom
Bathrooms: 2 Bathrooms
Beach Bar
Beach Good for Kids
Beach Service
Beachfront Hotels
Beachfront Restaurant
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Bedrooms: 3 Bedrooms
Beds with Views
Beds: Rooms with King Beds
Business Center
Butler Service
Chauffeured Car
Childrens Playground
Concierge Services
Cool Pool Views
Cool Rooftop Bar
Desk
Dining Area in the Room
Electronic Key
Extra Romantic
Fitness Center
Gardens on the Property
Green Hotel
Helicopter Access
Internet: Available
Internet: Free Wireless
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi in the Guest Rooms
iPod Docking Station
Kid Friendly
Kids Menu
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Refrigerator
Limousine Service
Live Music on Property
Luxury Loaner Cars
Meeting Facilities
Non-smoking Property
Ocean View Dining
Outdoor Dining
Personal Concierge Available
Pillow Top Mattreses
Pool
Pool - Extra Cool Kid Pool
Pool - Lazy River
Pool Cabanas
Poolside Food & Drink Service
Privacy
Private BBQ Area
Private Beach Cabanas
Private Beach Dining
Private Boat Available
Private Chef Availalbe
Private Dining Cool Spot
Restaurant On Property
Room Service (Limited)
Room Type: Family Rooms
Room Type: Good for 2 Couples
Room Type: Good for 3 Couples
Room Type: Ocean View Rooms
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Separate Sitting Area
Spa/Massage on Property
Spiritual Renewal
Strollers Available to Use
Stunning Settings
Swim Up Bar
Telephone in Room
View: Rooms with Ocean View
View: Rooms wtih Water Views
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
The Divani Apollon Palace and Spa is the ideal place to explore Athens for business or leisure and the perfect choice for the seeker of sophistication and beauty. This imposing structure, with its contemporary design blends harmoniously with extensive gardens, two outdoor swimming pools and spacious sundecks, to create a unique environment. Luxurious rooms offer furnished balconies with panoramic views of the Mediterranean Sea. Each is spacious and handsomely decorated with Italian designer fabrics and oak furnishings, featuring satellite television, Pay TV, telephone (ISDN), dataport, minibar, in-room safe and marble bathrooms. Additional features in the Executive Rooms and Suites include complimentary tea/coffee making facility, mini stereo and in-room fax. Within 19km of the Athens International Airport and 25min of the city center.
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Barber/Hair Stylist
Beachfront Hotels
Bedrooms: 1 Bedroom
Beds: Rooms with King Beds
Beds: Sofa Bed in Room
Business Center
Car Rental
Childrens Playground
Complimentary Breakfast
Concierge Services
Currency Exchange
Desk
Elevators
Fitness Center
Golf Course on Property
Hairdryer
Internet: Available
Internet: Broadband Access in Guest Rooms
Meeting Facilities
Mini Bar
News Stand
Pets Allowed
Pool - Extra Cool Kid Pool
Pool - Outdoor
Private Beach Cabanas
Restaurant On Property
Room Service (24 Hours)
Safe Deposit Box
Safe: In-Room Safe
Telephone in Room
Relaxing on one of the gorgeous terraces, it is easy to appreciate why the likes of Edward and Mrs. Simpson, King Hussein of Jordan, Rita Hayworth and Ernest Hemingway spent many holidays at this gracious hotel. The Excelsior Palace commands a delightful hillside position, nestled amongst luxuriant vegetation and graced with enchanting sea views from every aspect. This is the coastline that inspired writers of great literature and the hotel itself is steeped in history - the seat of the first great Italian casino, it has been lovingly restored to its turn of the century glory. Elegant grandeur, world class facilities, and the unique charm of the Portofino coast combine to make this a truly memorable Location Overlooking the stunning bay of Rapallo to the east, and the pretty Portofino coast to the west, the hotel is ideally situated for those seeking relaxation in exquisite surroundings. Rapallo, with its fine shops and restaurants is a mere 300 metres away. The international airport of Cristoforo Colombo is only 40 minutes away by taxi (32 kms).
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Balcony
Bath: Bathtub
Bath: Jacuzzi/Hot Tub in the Room
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Bath Tub (Private to the room)
Beach Bar
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Restaurant
Bedding: Pillow Menu
Bedrooms: 1 Bedroom
Bedrooms: 3 Bedrooms
Beds: 2 Twin Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Business Center
Cable/Satellite TV
Childrens Playground
Concierge Services
Connecting Rooms
Cribs Available
Electronic Key
Elevators
Fitness Center
Fitness Equipment
Hairdryer
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
Internet: Available
Internet: WiFi At the Beach
Internet: WiFi By the Pool
Internet: WiFi in Meeting Rooms
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
Jogging Track
Kid Friendly
Kids Menu
Laundry/ Dry Cleaning Service
Marina
Meeting Facilities
Mini Bar
Non-Smoking Room
Ocean View Dining
Pet Friendly - Any Size
Pets Allowed
Photocopy Service
Pool - Indoor
Pool - Outdoor
Poolside Food & Drink Service
Restaurant On Property
Rollaway Beds Available
Room Service (24 Hours)
Room Service (Limited)
Room Type: Beachfront Rooms
Room Type: Family Rooms
Room Type: Ocean View Rooms
Safe Deposit Box
Safe: In-Room Safe
Sauna on Property
Secretarial Services
Self Parking - Uncovered
Slippers
Smoke Alarm in Rooms
Spa/Massage on Property
Surveillance Cameras On Site
Taxi Cab Service
Telephone in Room
Turndown Service
Valet Parking - Covered
Valet Parking - Uncovered
View: Rooms with City Views
View: Rooms with Ocean View
View: Rooms wtih Water Views
Wake-up Service
Windows: Windows Open in the Room
Activities
Boating/Sailing
Fishing
Galleries and Museums
Golf
Guided Nature Walk
Horseback Riding
Kayaking
Mountain Biking
An expansive and elegant private Balinese villa awaits you with separate sleeping, bathing and living pavilions and ocean views from your plunge pool. An Indonesian spa. Dramatic hilltop and oceanside dining. All immersed in the mystique of this spiritual land. Experience the diversity of Bali by pairing your visit with a stay at Four Seasons Resort Bali at Sayan, an intimate upcountry retreat.
Juicy Tidbits Travel + Leisure says..."Expectedly luxurious and dramatic, this Four Seasons sits atop a cliff at the southern end of Jimbaran Bay. The 147 thatched-roof pavilions are furnished in carved teak and upholstered in tropical batik fabrics; some have kitchenettes, and all have gardens, and terraces with private plunge pools that staffers sprinkle daily with frangipani blossoms. Views from them spill out over the sea and the soaring peak of Mount Agung, and many have private access to the resort's private, white-sand beach, with its arsenal of water sports (catamarans, windsurfers, and canoes). Faultless service and a super snazzy spa (where treatment rooms all have their own bougainvillea-filled courtyards) leave you wanting for nothing. Casual, beachside PJ's is the better of the resort's two restaurants; it serves fresh seafood brought daily from the local market (less than a mile away), and is a super spot for chilling out over sundowners." -From Travel + LeisureConde Nast Traveler says..."With villas arranged around seven squares, emulating a Balinese village, "the resort feels like an exclusive city where golf carts take you everywhere!" "Magical accommodations with local art and wooden bedside tabletops are terraced into the hillside. At a sunset dinner on the beach, "they dug out sand to create space for a low table and chairs for my kids." -From Conde Nast Traveler
Juicy Details
Amenties
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
Art Collection
Balcony
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Shower (Private for the Room)
Bath: Private Bathroom
Bath: Separate Bathtub and Shower
Bath: Soaking Tub
Bath: Tub with a View
Bath: Two Person Spa Tub
Bathrooms: 2 Bathrooms
BBQ Area
Beach Good for Kids
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Pool
Beachfront Restaurant
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Bedrooms: 3 Bedrooms
Bedrooms: 4 Bedrooms
Beds with Views
Beds: 2 King Beds
Beds: 2 Twin Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Bikes to Use
Bose Sound System
Butler Service
Chauffeured Car
Childrens Playground
Complimentary Newspaper
Concierge Services
Connecting Rooms
Cool Lounging Spot
Cool Pool Views
Dining Area in the Room
Drive up to the Room
Extra Romantic
Gardens on the Property
Gift Shop
Hairdryer
Internet: Available
Internet: High Speed Outlet in Room
iPod Docking Station
Kid Friendly
Kids Menu
Kids Programs/Club
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Kitchenette
Kitchen: Refrigerator
Limousine Service
Non-smoking Property
Ocean View Dining
Outdoor Massage
Personal Concierge Available
Pillow Top Mattreses
Pool - Extra Cool Kid Pool
Poolside Food & Drink Service
Privacy
Private Beach Dining
Private Chef Availalbe
Private Garden with Room
Private Pool (Private Pool with the Room)
Romantic Bed
Room Type: Beachfront Rooms
Room Type: Bungalows
Room Type: Cottages
Room Type: Family Rooms
Room Type: Good for 3 Couples
Room Type: Indoor Outdoor Rooms
Room Type: Ocean View Rooms
Room Type: Villa
Safe: In-Room Safe
Strollers Available to Use
Stunning Settings