SELECT h.* FROM hotels h, amenitytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.AmenityID=844 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5
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
Just 42 kilometres (26 miles) from Puerto Vallarta, an unrivalled luxury Mexican vacation experience, edged in pristine white-sand beaches, natural islands and the turquoise Pacific. A unique spa. Sunset dining. Jack Nicklaus golf, with an island green, played beside the waves.
Juicy Tidbits National Geographic Traveler Says..."An elegantly low-profile blue sky/blue water coastal paradise with a green streak. While you laze on the Pacific Ocean beach or submit to a massage employing nopal and pulque (ancient Mexican skin-healing ingredients), the on-premises treatment plant is making used water garden-ready. Get vertical and explore local arts, crafts, and history at the on-site Cultural Center. Regarding the kitchen culture: Chef Fucho is steadfast when it comes to doing business with local fishermen and farmers. 141 rooms and 32 suites."-From National Geographic TravelerTravel + Leisure says..."The Four Seasons Resort Punta Mita caters to the unusualaif you want flower petals sprinkled on your reception from a helicopter, consider it done. Guests can sleep in private casitas with plunge pools, and sign up for massages with sage oil and tequila." -From Travel + Leisure
Juicy Details
Amenties
24 Hour Security
Air Conditioned/Climate Control
Art Collection
Balcony
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Bath Tub (Private to the room)
Bath: Outdoor Shower (Private for the Room)
Bath: Separate Bathtub and Shower
Bathrooms: 2 Bathrooms
Beach Bar
Beach Good for Kids
Beach Service
Beach Toys
Beachfront Hotels
Beachfront Pool
Beachfront Restaurant
Bedding: Down Comforter
Bedding: Fine Linens
Bedding: Pillow Menu
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
Butler Service
Chauffeured Car
Childrens Playground
Clothing Optional
Connecting Rooms
Cool Lounging Spot
Cool Pool Views
Desk
Dining Area in the Room
Drive up to the Room
Ergonomic Chair
Extra Romantic
Fireplace to Enjoy
Fitness Center
Gardens on the Property
Green Hotel
Hammocks to Hang Out On
Hot Springs
Internet: Available
Internet: High Speed Outlet in Room
iPod Docking Station
Kid Friendly
Kids Menu
Laundry Room Available
Limousine Service
Live Music on Property
Meeting Facilities
Non-smoking Property
Non-Smoking Room
Ocean View Dining
Outdoor Dining
Outdoor Fireplace/Firepit (On Property)
Outdoor Massage
Personal Concierge Available
Pet Friendly - Size Limit
Pets Allowed
Pillow Top Mattreses
Private Pool (Private Pool with the Room)
Room Type: Beachfront Rooms
Room Type: Beachfront Villas
Room Type: Casitas
Room Type: Family Rooms
Room Type: Good for 2 Couples
Room Type: Good for 3 Couples
Room Type: Indoor Outdoor Rooms
Room Type: Ocean View Rooms
Room Type: Stand Alone Single Unit
Room Type: Villa
Room Type: Waterfront Rooms
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Sauna on Property
Self Parking - Uncovered
Separate Sitting Area
Spa/Massage on Property
View: Rooms with Ocean View
View: Rooms wtih Water Views
Activities
Archaeology & Ruins
Art Class
Basketball
Birdwatching
Boating/Sailing
Boogie Boarding
Cooking Classes
Fishing
Golf
Guided Nature Walk
Hiking
The Fasano Family, recognized for over a century for their hospitality and fine northern Italian cuisine, administrate Sao Paulo's newest and most charming property. Ten years of planning and construction have been necessary to find the only Location in between the strategic Paulista and Faria Lima Avenue. The private street, surrounded by the greatest names of fashion, was named after the Great Grandfather, Vittorio Fasano. Isay Weinsfeld and Marcio Kogan succeeded architecture of a distinctive elegance updating the style of the 1930's and 40's. They combine classical details, such as English bricks and Italian travertine marble, with a contemporary view. The Hotel offers a unique Location next to the luxury shops, the city's most refined restaurants, and is only a few blocks from the business and financial districts of Avenida Paulista and Avenida Faria Lima. The Rua Vittorio Fasano, formerly the Rua Taiarana, is parallel to the Oscar Freire street and the Avenue Estados Unidos, between the Haddock Lobo and Bela Cintra street.
Juicy Tidbits Conde Nast Traveler says..."This brick building topped by a giant clock face has Armani, Versace, and Louis Vuitton stores as nearby residents, giving it perfect location and design scores. Inside, the "Mussolini modern decor draws the local fashion crowda sometimes the lobby feels like a country club where everybody knows each other." Rooms have Egyptian cotton linens, and some have panoramic city views. Brazilian-inflected Northern Italian dishes at Restaurante Fasano "live up to their reputation," although "prepare for New York prices." "The staff are well polished." " -From Conde Nast Traveler
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Bath: Bathtub
Bath: Tub with a View
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Blackout Drapes/Curtains
Boutique Shops
Business Center
Cable/Satellite TV
Car Rental
Chauffeured Car
Clothing Optional
Complimentary Breakfast
Complimentary Newspaper
Concierge Services
Cool Hot Tub
Currency Exchange
Drive up to the Room
Elevators
Extra Romantic
Fitness Center
Gardens on the Property
Hairdryer
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: High Speed Outlet in Room
Internet: WiFi in Public Areas
iPod Docking Station
Kid Friendly
Limousine Service
Maid Service
Meeting Facilities
Mini Bar
News Stand
Pool
Restaurant On Property
Room Service (Limited)
Room Type: Good for 2 Couples
Room Type: Good for 3 Couples
Safe Deposit Box
Safe: In-Room Safe
Sauna on Property
Self Parking - Uncovered
Separate Sitting Area
Telephone in Room
Valet Parking - Uncovered
View: Rooms with City Views
Wake-up Service
A 5 star stylish design resort touching Nai Yang Beach, Phuket, set amidst lush tropical gardens, 3 pools and postmodern art pieces. Featuring 277 stylised rooms, villas and suites, 8 restaurants and bars, 12 meeting rooms including a 670 person capacity ballroom and an array of activities to enjoy. Accessible only 10 minutes from Phuket International Airport, the resort is adjacent to the Sirinath National Park, Nai Yang Beach which retains a natural ambience and is one of the most peaceful areas on the island. A hidden Andaman Sea sanctuary. 37 km to the city center, Railway Station Surat Thani 450 km, Motorway/ Highway Exit Thepkasatthi Highway 4 km, Beach1 km, Horseback riding 20. 0 km, Hong (sea cave) by starlight 45. 0 km, Deep Sea Fishing 60. 0 km, Day Trips for Diving and Snorkelling 20. 0 km, Canoe Adventure 50. 0 km.
Juicy Tidbits Travel + Leisure says..."Just over two years after the Asian tsunami wreaked havoc on Phuket's coastline, the resort island is back and better than ever. A string of hotels have opened in the past year, the best of which is Indigo Pearl...a 277-room property on secluded Nai Yang Beach that is just putting its finishing touches. Designed by Bangkok-based architect Bill Bensley, Indigo Pearl recalls the site's former life as a tin mine with sleek, industrial-style interiors: polished-concrete floors, steel beams, exposed ceilings, and machinery-inspired sculptures. The austere effect is offset by yards of Thai silk on pillows and chairs, plush beds, and oversize bathtubs. The sprawling property has three swimming pools (don't miss the "snakeskin pool," tiled with glass beads), a yoga-focused spa, tennis courts, a breezy tapas bar, and five other on-site restaurants. Along the beach, a string of cheap and cheerful bars keep a lively beat throughout the day and night."
Juicy Details
Amenties
Air Conditioned/Climate Control
Art Collection
Babysitting or Child Care
Balcony
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Outdoor Bath Tub (Private to the room)
Bath: Outdoor 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 Restaurant
Bedding: Fine Linens
Bedding: Pillow Menu
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Beds with Views
Beds: Rooms with King Beds
Bikes to Use
Ceiling Fan
Chauffeured Car
Childrens Playground
Clothing Optional
Concierge Services
Connecting Rooms
Cool Hot Tub
Cool Lounging Spot
Cool Pool Views
Cool Rooftop Bar
Desk
Dining Area in the Room
Extra Romantic
Fitness Center
Gardens on the Property
Hairdryer
Internet: Available
Internet: Free Wireless
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
Kid Friendly
Kids Menu
Kitchen: Coffee Maker
Kitchen: Refrigerator
Live Music on Property
Meeting Facilities
Outdoor Dining
Outdoor Massage
Patio
Pillow Top Mattreses
Pool
Pool - Outdoor
Poolside Food & Drink Service
Privacy
Private Beach Dining
Private Deck/Patio/Terrace
Private Dining Cool Spot
Private Garden with Room
Private Pool (Private Pool with the Room)
Restaurant On Property
Romantic Bed
Room Service (24 Hours)
Room Service (Limited)
Room Type: Bungalows
Room Type: Family Rooms
Room Type: Pool Villas
Room Type: Villa
Safe Deposit Box
Safe: In-Room Safe
Slippers
Swim Up Bar
Tropical Vibe
Windows: Windows Open in the Room
Activities
Badminton
Bicycling
Boating/Sailing
Canoeing
Cooking Classes
Galleries and Museums
Golf
Built in 1932 - the Raffles Grand Hotel d*Angkor has finally been restored to the majesty of the past - complementing the grandeur of Angkor as never before. In addition to the meticulous restoration of the French-colonial architectural and decorative styles - some of the original features of the hotel were preserved. In 1932 - the hotel was the only building to have a cage elevator. Now the restored original resides in the lobby. The 60. 000 square metres of gardens have also been restored with over 20. 000 flowering plants - shrubs and local trees. When you stay at the Raffles Grand Hotel d*Angkor - you experience the signature Raffles style and service - a blend of modern comforts with the grandeur of yesteryear.
Juicy Tidbits Travel + Leisure says..."Carefully restored French colonial retreat features a lap pool inspired by Angkor's royal baths." -From Travel + LeisureConde Nast Traveler says..."This red-roofed French colonial property with manicured gardens also has Art Deco and Khmer influences. Many rooms come with four-poster beds, claw-foot tubs, and private patios but "aren't really five star." Restaurant Le Grand has a collection of thirteenth-century ceramics and does classic Cambodian dishes. "Expect consistently good service." -From Conde Nast Traveler
Juicy Details
Amenties
24 Hour Front Desk
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
Art Collection
ATM/Bank on Property
Babysitting or Child Care
Balcony
Barber/Hair Stylist
Bath: Bathtub
Bath: Private Bathroom
Bath: Separate Bathtub and Shower
Bath: Tub with a View
BBQ Area
Beach Good for Kids
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Bedrooms: 2 Bedrooms
Beds with Views
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Beds: Sofa Bed in Room
Boutique Shops
Bus/RV Parking
Business Center
Butler Service
Cable/Satellite TV
Car Rental
Ceiling Fan
Childrens Playground
Clothing Optional
Complimentary Breakfast
Complimentary Coffee
Complimentary Newspaper
Computer Use Available
Concierge Services
Connecting Rooms
Cool Bath Tubs
Cool Hot Tub
Cool Lounging Spot
Cool Pool Views
Cribs Available
Currency Exchange
Desk
Dining Area in the Room
Elevators
Extra Romantic
Fax Machine Available For Guests
Fitness Center
Fitness Equipment
Gardens on the Property
Gift Shop
Golf Course on Property
Green Hotel
Hairdryer
Helicopter Access
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: Broadband Access in Meeting Rooms
Internet: High Speed Outlet in Room
Internet: WiFi By the Pool
Internet: WiFi in Meeting Rooms
Internet: WiFi in Public Areas
Internet: WiFi in the Guest Rooms
iPod Docking Station
Iron/Ironing Board
Kid Friendly
Kids Menu
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Kitchenette
Kitchen: Refrigerator
Laundry/ Dry Cleaning Service
Limousine Service
Live Music on Property
Meeting Facilities
Microwave
Mini Bar
No Phones in the Room
Organic Garden
Outdoor Dining
Outdoor Massage
Photocopy Service
Pillow Top Mattreses
Pool
Pool - Children
Pool - Outdoor
Poolside Food & Drink Service
Privacy
Private BBQ Area
Private Outdoor Hot Tub (with room)
Restaurant On Property
Rollaway Beds Available
Romantic Bed
Room Service (24 Hours)
Room Type: Family Rooms
Room Type: Good for 2 Couples
Room Type: Good for 3 Couples
Room Type: Overwater Bungalows
Room Type: Villa
Safe Deposit Box
Safe: In-Room Safe
Sauna on Property
Secretarial Services
Separate Sitting Area
Slippers
Smoke Alarm in Rooms
Spa/Massage on Property
Sprinkler in Rooms
Telephone in Room
Turndown Service
Wake-up Service
Activities
Cooking Classes
Golf
Helicopter Excursion
Hot Air Balloons