Add Search Details

SELECT h.* FROM hotels h, amenitytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.AmenityID=10000618 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5

The Diaz Rivera family, one of Mexicos foremost developers, has reserved its most coveted parcel of land an extraordinary, 24 acre site at the southernmost tip of Mexicos Baja California Peninsula for a resort of unprecedented luxury. Capella Pedregal encompasses 24 spectacular mountainside and oceanfront acres at the very point where the Pacific Ocean meets the Sea of Cortez, near the legendary rock formations known as Lands End. The development is reached via the only privately-owned tunnel in Mexico. Carved through the heart of the mountainside, it is a 300-meter-long engineering feat that separates the town of Cabo from the Pacific Ocean. This incredibly dramatic entrance to Capella deposits visitors at what will be Capella Pedregals entrance courtyard overlooking a long expanse of beach and the ocean. It leaves no question but that they have entered a world apart.

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security A-V Equipment Rental Air Conditioned/Climate Control Airport Shuttle ATM/Bank on Property Babysitting or Child Care Balcony Barber/Hair Stylist Bath: Bathtub Bath: Separate Bathtub and Shower Bathrooms: 2 Bathrooms Beachfront Hotels Bedding: Down Comforter Bedding: Fine Linens Bedrooms: 3 Bedrooms Beds: 2 King Beds Beds: Rooms with King Beds Beds: Rooms with Two Beds Boutique Shops Business Center Cable/Satellite TV Complimentary Local Telephone Calls Complimentary Newspaper Computer Use Available Concierge Services Cribs Available Currency Exchange Dining Area in the Room Elevators Fax Machine Available For Guests Fireplace in the Room Fireplace to Enjoy Fitness Center Game Room Hairdryer Hot Tub/Jacuzzi:Outdoor (Shared/On Property) Internet: Available Internet: Free Wireless Internet: Is Free Internet: WiFi in the Guest Rooms iPod Docking Station Iron/Ironing Board Jogging Track Kitchen: Coffee Maker Kitchen: Dishwasher Kitchen: Full Kitchen in the Unit Kitchen: Microwave Kitchen: Refrigerator Kitchen: Stove Labyrinth on the Property Maid Service Meeting Facilities Mini Bar News Stand Non-Smoking Room Patio Pets Allowed Photocopy Service Pool Pool - Indoor Pool - Outdoor Private Pool (Private Pool with the Room) Restaurant On Property Room Service (24 Hours) Room Service (Limited) Room Type: Beach Bungalows Room Type: Beachfront Cottage Room Type: Beachfront Rooms Room Type: Casitas Room Type: Ocean View Rooms Room Type: Stand Alone Single Unit Room Type: Villa Room Type: Waterfront Rooms Safe Deposit Box Safe: In-Room Safe Sauna on Property Secretarial Services Separate Sitting Area Smoke Alarm in Rooms Telephone in Room Turndown Service View: Rooms with Ocean View View: Rooms wtih Water Views Wake-up Service Wheelchair Accessible Rooms Wheelchair Friendly Public Areas

Grand Resort represents consummate luxury in terms of Location, design, facilities and service. The highest level of pampering, relaxation, leisure and recreation are values offered to the discerning visitor who wants to live this experience. Located on the south side of the Athens area, in a 72 acre peninsula of unique charm, Grand Resort exudes an aura of distinction and elegance. The magical Location, surrounded by the clear blue waters of the Aegean Sea, offers both the natural beauty and the cultural treasures which have given birth to the Olympic spirit and define Greek hospitality. All villas, suites and bungalows are situated along the waterfront of the bay and offer ultimate privacy in a true dream world. A seasonal hotel, closed from end of October to beginning of April. The lush peninsula of Grand Resort is graced with private sandy coves surrounded by dazzling blue waters, where travelers are lulled by an amazing world of leisure, beauty and Mediterranean flair. Seasonal Hotel: Closed October 30, 2008 to April 19, 2009.

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security Air Conditioned/Climate Control Babysitting or Child Care Barber/Hair Stylist Beachfront Hotels Bedrooms: 1 Bedroom Business Center Car Rental Complimentary Breakfast Concierge Services Currency Exchange Elevators Fitness Center Hairdryer Internet: Available Meeting Facilities News Stand Non-Smoking Room Photocopy Service Pool Pool - Outdoor Private Pool (Private Pool with the Room) Restaurant On Property Room Service (24 Hours) Room Type: Beach Bungalows Room Type: Beachfront Cottage Room Type: Beachfront Rooms Room Type: Bungalows Room Type: Stand Alone Single Unit Room Type: Villa Room Type: Waterfront Rooms Safe Deposit Box Safe: In-Room Safe Turndown Service Wake-up Service

InterContinental Bora Bora Le Moana Resort occupies what most people say is the most beautiful site in French Polynesia. Two white sand beaches, a wide array of water sports, intriguing cultural activities and unique bungalows stationed over the water are the ingredients for the ultimate island escape. Alain Gerbault's grave is a must on any tour of the island.

Juicy Details Amenties Babysitting or Child Care Beach Beachfront Hotels Beds: Sofa Bed in Room Bus/RV Parking Business Center Cable/Satellite TV Car Rental Complimentary Breakfast Concierge Services Cribs Available Currency Exchange Desk Fax Machine Available For Guests Hairdryer Iron/Ironing Board Kids Programs/Club Maid Service Mini Bar Pool - Outdoor Room Service (Limited) Room Type: Beach Bungalows Room Type: Beachfront Rooms Room Type: Bungalows Room Type: Overwater Bungalows Room Type: Stand Alone Single Unit Safe Deposit Box Safe: In-Room Safe Turndown Service   Hotel Types/Categories Best Hotels for Weddings

InterContinental Moorea Resort & Spa is nestled between mountains and a lagoon on a stunning French Polynesian island. The resort features Mooreas widest range of activities, including the Moorea Dolphin Center, Bathys Diving Club, tennis, kayaking, canoeing, skiing and Jeep tours. ****NOTE: We will start the construction of a magnificient new pool commencing November 21st 2009 and finishing July 31st 2010. During construction the building facing the pool and the main buildings will be closed. Rooms facing the garden and lagoon will remain open. Fare Hana poolside restaurant will be closed. Breakfast, lunch and dinner will be served at Fare Nui restaurant. Acces to the main beach, activities and boat dock will be accessible and free transfers to the "motu" (small island with a great and peaceful beach) will be offered until the end of March 2010. Also, all our bungalows will be renovated in several steps with the terrace extension and be completed in may 2010. InterContinental Moorea Resort & Spa will start the construction of a magnificient new pool and upgrading all the bungalow: commencing November 21st 2009 and finishing June 30th 20.

Juicy Details Amenties Air Conditioned/Climate Control Babysitting or Child Care Beach Beachfront Hotels Beds: Rooms with King Beds Beds: Sofa Bed in Room Bus/RV Parking Cable/Satellite TV Car Rental Complimentary Breakfast Complimentary Newspaper Concierge Services Cribs Available Currency Exchange Desk Fax Machine Available For Guests Hairdryer Iron/Ironing Board Kitchen: Coffee Maker Maid Service Mini Bar Pool - Outdoor Private Garden with Room Private Pool (Private Pool with the Room) Rollaway Beds Available Room Service (Limited) Room Type: Beach Bungalows Room Type: Beachfront Rooms Room Type: Bungalows Room Type: Ocean View Rooms Room Type: Overwater Bungalows Room Type: Stand Alone Single Unit Room Type: Swim Up Rooms Safe Deposit Box Safe: In-Room Safe Tropical Vibe Turndown Service View: Rooms with Ocean View View: Rooms wtih Water Views   Activities Wildlife - Dolphins

Opening the end of February 2009 and offering breathtaking views from each of its 60 Guest Rooms and five private villa suites, this luxury seafront Hotel Features a private beach where guests find peace and relaxation, renovated villas sheltered by coastal pine trees, and where the roar of the sea can be heard from the rooms, open air restaurant overlooking the beautiful scenery of Isola Bella. Visitors have many local activities to choose from including historical and cultural sights.

Juicy Details Amenties 24 Hour Front Desk Air Conditioned/Climate Control Bath: Bathtub Bath: Jacuzzi/Hot Tub in the Room Bath: Jacuzzi/Whirlpool in Bathroom Bath: Outdoor Bath Tub (Private to the room) Beds: 2 Twin Beds Beds: Rooms with King Beds Beds: Rooms with Two Beds Concierge Services Desk Fitness Center Hairdryer Internet: Available Internet: Free Wireless Internet: Is Free Internet: WiFi in the Guest Rooms Kitchen: Refrigerator Patio Private Outdoor Hot Tub (with room) Restaurant On Property Room Service (Limited) Room Type: Beach Bungalows Room Type: Bungalows Room Type: Ocean View Rooms Room Type: Stand Alone Single Unit Safe Deposit Box Safe: In-Room Safe Slippers Telephone in Room View: Rooms with Ocean View View: Rooms wtih Water Views

Displaying 1-5 of 18