SELECT h.* FROM hotels h, amenitytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.AmenityID=874 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5
Baros Maldives holds an idyllic place on its own private island in the North Male Atoll and is blessed with dream-like views of the Indian Ocean and neighbouring coral islands. Luxurious villas exist in harmony with their surroundings: some set on stilts over the lagoon providing the ultimate in Indian Ocean romance; others are nestled among the coconut palms and hibiscus, just a few paces from the water's edge, boasting chic interiors and lavish indoor and garden bathrooms. Delicious views are complemented by unparalleled dining experiences including two superb restaurants, the unique two-tier over-water fine dining restaurant, The Lighthouse, or intimate dining in or out of your villa. Add to that a wide range of relaxing spa treatments and you're truly spoilt for choice. Things to enjoy - SEN Spa, scuba diving, water sports centre, snorkelling, fitness centre, pool table, table tennis, Wi-Fi, sunset cruise, island hopping, sunrise picnic, sunset fishing, big game fishing, seaplane photo flight. Minimum age for a child should be 8 years older and above. Located on its own private island in the North Male Atoll. A 15-minute speedboat ride from Male International Airport. Baros Maldives is a Small Luxury Hotels of the World property.
Juicy Details
Amenties
24 Hour Front Desk
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Bath Tub (Private to the room)
Bath: Outdoor Shower (Private for the Room)
Bath: Tub with a View
Beachfront Hotels
Beachfront Restaurant
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Beds with Views
Beds: Rooms with King Beds
Beds: Sofa Bed in Room
Boat to Hotel
Butler Service
Cool Lounging Spot
Dining Area in the Room
Extra Romantic
Fitness Center
Gardens on the Property
Green Hotel
Hammocks to Hang Out On
Internet: High Speed Outlet in Room
Internet: WiFi in Public Areas
Live Music on Property
Ocean View Dining
Outdoor Dining
Outdoor Massage
Pillow Top Mattreses
Privacy
Private Beach Dining
Private Boat Available
Private Chef Availalbe
Private Deck/Patio/Terrace
Private Dining Cool Spot
Private Garden with Room
Private Island
Private Pool (Private Pool with the Room)
Restaurant On Property
Romantic Bed
Room Service (24 Hours)
Room Service (Limited)
Room Type: Beachfront Rooms
Room Type: Bungalows
Room Type: Ocean View Rooms
Room Type: Overwater Bungalows
Room Type: Pool Villas
Room Type: Stand Alone Single Unit
Room Type: Thatched Roof Cottages
Room Type: Villa
Stunning Settings
Telephone in Room
Tropical Vibe
Waterfront Hotel Dining
Windows: Windows Open in the Room
Activities
Boating/Sailing
Canoeing
Cooking Classes
Fishing
Ping Pong
Scuba Diving
Small Plane Excursion
Snorkeling
Since 1865, the family-owned and managed Beau-Rivage continues to welcome some of the world's most well known personalities in total discretion. The hotel is situated on the lake front, facing the emblematic and impressive Jet d'eau , fountain of Geneva and is also located just a stone's throw away from the Old town, elegant stores and business districts.The renovation of all the bedrooms, then the restoration of the facades paying scrupulous attention to the crafts involved, and the sumptuous transformation of the corridors : after all this work the new terraces have now come to life, an extension of the historic suites, true contemporary witnesses to the art de vivre Beau-Rivage style, where the future has no barriers.The Hotel provides state-of-the art communication technology, as well as the charm and savoir vivre that makes it one of the most distinguished addresses in SwitzerlandDining: Le Chat BottA gourmet restaurant that serve contemporary and creative French cuisine.Dominique Gauthier's contemporary and creative French cuisine knows no bounds. A Michelin star now crowns his achievements, which also include Chef of the Year 2009 as well as being awarded 18 out of 20 by GaultMillau!
Juicy Tidbits Travel + Leisure says... "19th-century palace with views of Mont Blanc, on the banks of Lake Geneva." Competitive Edge: Geneva's only family-owned hotel, with a central location and outstanding service. Rooms to Book: Lake-view Deluxes, fresh from renovations last fall." -From www.travelandleisure.com
Juicy Details
Amenties
24 Hour Front Desk
A-V Equipment Rental
Air Conditioned/Climate Control
Bath: Bathtub
Bath: Private Bathroom
Bath: Separate Bathtub and Shower
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Bedrooms: 3 Bedrooms
Bedrooms: 4 Bedrooms
Bedrooms: 5 Bedrooms
Beds: 2 Twin Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Business Center
Cable/Satellite TV
Complimentary Breakfast
Computer Use Available
Concierge Services
Connecting Rooms
Cribs Available
Currency Exchange
Deadbolts and Locks in Rooms
Desk
Drive up to the Room
Electronic Key
Elevators
Extra Romantic
Facilities for Hearing Impaired
Fax Machine Available For Guests
Fitness Center
Fitness Equipment
Green Hotel
Hairdryer
Hammocks to Hang Out On
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: Broadband Access in Meeting Rooms
Internet: Free Wireless
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi in Meeting Rooms
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
Iron/Ironing Board
Laundry/ Dry Cleaning Service
Live Music on Property
Meeting Facilities
Mini Bar
Non-Smoking Room
Parking Area Well Lit
Pet Friendly - Size Limit
Pets Allowed
Photocopy Service
Restaurant On Property
Room Service (24 Hours)
Safe Deposit Box
Safe: In-Room Safe
Secretarial Services
Separate Sitting Area
Slippers
Smoke Alarm in Rooms
Stunning Settings
Surveillance Cameras On Site
Telephone in Room
Translation Services
Turndown Service
Valet Parking - Covered
View: Rooms with City Views
View: Rooms with Lake View
View: Rooms wtih Water Views
Voicemail
Wake-up Service
Windows: Sound Proof Windows/Rooms
Windows: Windows Open in the Room
Activities
Badminton
Bungee Jumping
Canoeing
Casino
Climbing Wall
Cooking Classes
Galleries and Museums
Golf
Guided Nature Walk
Helicopter Excursion
Hiking
Hot Air Balloons
Kayaking
Kids Activites/Club
Lively Night Scene
Mountain Biking
Pilates
Ping Pong
Putting Green
Racquetball
River Rafting
Small Plane Excursion
Soccer
Volleyball
Walking
Wine Tasting & Activities
Yoga
Pet Policy
Small pets allowed
Wifi Details
Free WIFI in every guest-rooms, conference and meetings rooms, public areas
Green Details
ISO 14001 and ISO 9001:2000 certifications
How This Juicy Hotel Benefits Its Local Community
Beau-RIvage is has a long time partnership with Switzerland Red Cross and Buakhao White Lotus Foundation (the founder of Buakhao is one of the owner of >Beau-RIvage)
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
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
The China World Hotel is one of Beijings finest hotels - located in the China World Trade Centre complex in the Central Business District - and is attached to the China World Shopping Mall. The hotel is only a 45-minute drive from Beijing Capital International Airport. Located near many foreign embassies - China World Hotel is minutes away from the Forbidden City attraction. The Guomao subway station is a short walk from the hotel. Presenting a contemporary design with strong Chinese influences this award-winning luxury property features legendary Shangri-La services and world-class facilities for business and leisure travelers and meeting attendees. The hotel has a state-of-the-art gymnasium equipped with spacious exercise studios and the latest in cardio-fitness machines. Recreation also includes an indoor swimming pool - squash and tennis courts - steam rooms and Jacuzzis - and an Oxygen Room. The business center facilities offer secretarial assistance - Internet access - meeting rooms - and presentation facilities. China World Hotel has the largest meeting facilities in Beijing - including private function rooms - the 800-person ballroom - and the 2000-seat Conference Hall. There are four restaurants including a cafe - delicatessen - and two full service venues. There are two bar-lounge venues as well as 24-hour room service. China World Hotel offers 716 beautifully appointed Guest Rooms and suites - decorated with contemporary Asian art. All rooms have marble bathrooms - premium Shangri-La toiletries - and soothing earth tone fabrics. Sleep furnishings including large feather duvet covers and a menu of various pillows. Rooms also feature hi-speed Internet - flat screen cable TV - in house movie channels - IDD 2-line phones - voicemail - electronic safe - mini bar - oversized executive desk - and Herman Miller chair. Horizon Club rooms include extra services and amenities - and use of the lounge on levels 19 or 20.
Juicy Tidbits Travel + Leisure says..."Elliptical building with sumptuous dAcor in the central business district, only a 15-minute drive from the Forbidden City.Rooms to Book: The extra-spacious 570-square-foot Premiers.Insider Tip: Go to the Sunday-afternoon High Tea in the opulent Lobby Lounge, accompanied by a 40-piece orchestra."
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Art Collection
Babysitting or Child Care
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Separate Bathtub and Shower
Bedding: Fine Linens
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
Car Rental
Charm up the Wazoo
Chauffeured Car
Complimentary Newspaper
Connecting Rooms
Cool Lounging Spot
Currency Exchange
Desk
Dining Area in the Room
Elevators
Ergonomic Chair
Extra Romantic
Fitness Center
Golf Course on Property
Green Hotel
Hairdryer
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
Iron/Ironing Board
Kids Menu
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Refrigerator
Limousine Service
Live Music on Property
Maid Service
Mini Bar
Non-smoking Property
Pillow Top Mattreses
Pool - Indoor
Privacy
Private Dining Cool Spot
Private Garden with Room
Room Service (Limited)
Room Type: Family Rooms
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Sauna on Property
Separate Sitting Area
Slippers
Sprinkler in Rooms
Telephone in Room
View: Rooms with City Views
Wake-up Service