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=917 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

Just 30 minutes north of San Diego, Southern California's finest resort experience offers casual elegance in a natural setting accented by wildlife and wildflowers. Discover an extensive spa, the area's finest dining choices and Arnold Palmer-signature golf. FOUR SEASONS WILL BE CONCLUDING OUR MANAGEMENT OF FOUR SEASONS RESORT AVIARA EFFECTIVE JUNE 21, 2010. PLEASE CONTACT THE RESORT DIRECTLY OR VISIT OUR FS WEBSITE FOR FURTHER DETAILS.

Juicy Tidbits
Travel + Leisure says..."Spanish colonial-style property 30 minutes north of San Diego, with the area's only Arnold Palmer-designed golf course and easy access to the beach.Rooms to Book: Deluxes on upper floors, for their balconies facing the Eucalyptus tree-filled hills.Insider Tip: Take a surfing lesson from the surf concierge."

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security Air Conditioned/Climate Control Art Collection ATM/Bank on Property Balcony Barber/Hair Stylist Bath: Bathtub Bath: Jacuzzi/Whirlpool in Bathroom Bath: Separate Bathtub and Shower Beach Service Beach Toys Bedding: Down Comforter Bedding: Fine Linens Bedrooms: 1 Bedroom Bedrooms: 2 Bedrooms Bedrooms: 3 Bedrooms Bedrooms: 4 Bedrooms Beds with Views Beds: Rooms with King Beds Beds: Rooms with Two Beds Business Center Butler Service Childrens Playground Complimentary Newspaper Concierge Services Connecting Rooms Cool Hot Tub Cool Lounging Spot Cool Pool Views Desk Dining Area in the Room Elevators Extra Romantic Fireplace to Enjoy Fitness Center Gardens on the Property Hairdryer Internet: Available Internet: High Speed Outlet in Room Internet: WiFi in Public Areas iPod Docking Station Iron/Ironing Board Kid Friendly Kids Menu Kids Programs/Club Kitchen: Coffee Maker Kitchen: Kitchenette Labyrinth on the Property Laundry Room Available Limousine Service Live Music on Property Maid Service Mini Bar Non-Smoking Room Ocean View Dining Outdoor Dining Outdoor Fireplace/Firepit (On Property) Pet Friendly - Size Limit Pets Allowed Pool - Extra Cool Kid Pool Pool Cabanas Poolside Food & Drink Service Privacy Restaurant On Property Room Service (24 Hours) Room Type: Good for 2 Couples Room Type: Good for 3 Couples Room Type: Ocean View Rooms Safe Deposit Box Safe: In-Room Safe Sauna on Property Stunning Settings Turndown Service Wheelchair Friendly Public Areas Windows: Windows Open in the Room   Activities Art Class Badminton Basketball Bicycling Birdwatching Boating/Sailing Bocce Ball Boogie Boarding Casino Croquet Fishing Galleries and Museums Golf Hiking Horseback Riding Hot Air Balloons Kids Activites/Club Mountain Biking Ping Pong Putting Green Running Skydiving Small Plane Excursion Snorkeling Surfing Surfing Lessons Tennis (Outdoor) Video Arcade Volleyball Walking Wildflowers Wildlife - Birds Wine Tasting & Activities   Hotel Types/Categories Best California Beachfront Hotels Best Golf Resorts Best Spa Hotels Best Surfing Hotels Conde Nast Traveler Top Spas Luxury Beach Resorts

A daily resort charge of 30USD *33. 58 tax inclusive* will be applied and includes- Valet parking/ high-speed internet access/ daily paper/ use of the spa facilities/ service personnel gratuity *excluding Spa and FB*. This charge is in addition to the rate quoted. An extraordinary desert hideaway The Boulders Resort - Golden Door Spa is situated on 1 300 acres in the Sonoran Desert foothills of Scottsdale Arizona. The dramatic and innovative architecture blends with the surrounding desert and the 12-million-year-old granite boulder formations that dot the landscape. It is located 33 miles from Phoenix/Sky Harbor Airport minutes from Scottsdale Regional Airport and five miles from the picturesque town of Carefree. A helicopter landing pad is also located on site. General ambiance-Named for the 12-million-year-old granite boulder formations The Boulders is a small luxury hideaway and a nature lover*s paradise where the terrain and plant life have been left virtually untouched to allow indigenous plant and wildlife to prosper. Accommodations-Private casitas many of which are situated along the golf course are shaped into the natural terrain and grouped in village-like clusters. These spacious and luxurious accommodations offer comfort with a Southwestern decor. Hand-hewn wood-beamed ceilings with fans regional art fireplaces wet bars large dressing and bathroom areas and private patios or decks overlook the sun-streaked desert or emerald-green golf course. Elegant one- two- three-bedroom Haciendas and Villas offer fully equipped and beautifully styled kitchens fireplaces flat screen televisions full laundry room doorstep parking and private entrances with accessibility to all resort amenities. A 5 000 sq. ft. Villa Retreat is also available. In-room and public area HSIA included in the daily resort fee. 9 Dinning Options Latilla-Featuring fresh American cuisine with organic and naturally grown ingredients from the Western Seaboard Palo Verde-Serving a delectab.

Juicy Tidbits

Travel + Leisure says..."Lavish Sonoran Desert golf resort with adobe casitas scattered across a millennia-old rock outcropping, plus a legendary spa.Rooms to Book: For the most expansive views, opt for a second-floor unit in a two-story casita in the north section.Insider Tip: Take a moonlight hike with the on-site professional astronomer.
Travel and Leisure also says...The Boulders has always meant golf, golf, and more golf. Now, with the addition of the extraordinary Golden Door Spa, it is also a first-rate spa hotel. Walking to your casita in the chill of the night, past the boulders and the cacti, across wood bridges over dry arroyos, the air scented with piAon drifting from the fireplaces it's as romantic a desert moment as you can hope for. The Boulders has always had the location, where the wilderness merges with the city, and the layout too, with 160 large casitas scattered across its two famous golf courses and the fringes of the desert. No two rooms have the same view, and it's impossible for the front desk to guess which one will please you, so just keep trying until you find the right fit. You'll emerge to play golf, to sun by the pool at the base of a boulder-strewn hill, and to dine at the restaurant, the Latilla, which is built into the boulders themselves. In the spa enjoy the site-appropriate treatments like the turquoise body wrap, which involves honey, blue cornmeal, and a rain stick."

-From Travel + Leisure

Juicy Details Amenties 24 Hour Security Air Conditioned/Climate Control ATM/Bank on Property Balcony Barber/Hair Stylist Bath: Bathtub Bath: Jacuzzi/Whirlpool in Bathroom Bath: Soaking Tub Bath: Two Person Spa Tub Bedding: Fine Linens Bedrooms: 1 Bedroom Bedrooms: 2 Bedrooms Bedrooms: 3 Bedrooms Beds: Rooms with King Beds Beds: Rooms with Two Beds Beds: Sofa Bed in Room Bus/RV Parking Business Center Cable/Satellite TV Car Rental Ceiling Fan Complimentary Breakfast Computer Use Available Concierge Services Cribs Available Desk Fireplace in the Room Fireplace to Enjoy Fireplace: Wood Burning Fireplace in the Room Fitness Center Game Room Golf Course on Property Hairdryer Hot Tub/Jacuzzi:Outdoor (Shared/On Property) 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 in Public Areas Internet: WiFi in the Guest Rooms iPod Docking Station Iron/Ironing Board Kitchen: Coffee Maker Kitchen: Full Kitchen in the Unit Kitchen: Refrigerator Labyrinth on the Property Laundry - Washer/Dryer in Unit Meeting Facilities Microwave Mini Bar News Stand Non-Smoking Room Organic Garden Patio Pets Allowed Photocopy Service Pool Pool - Outdoor Private BBQ Area Private Deck/Patio/Terrace Rollaway Beds Available Room Service (24 Hours) Room Service (Limited) Room Type: Casitas Room Type: Stand Alone Single Unit Room Type: Villa Safe Deposit Box Safe: In-Room Safe Separate Sitting Area Slippers Smoke Alarm in Rooms Spa/Massage on Property Sprinkler in Rooms View: Rooms with Mountain View Wheelchair Accessible Rooms   Activities Glider Golf Horseback Riding Hot Air Balloons Jeep Excursion Photo Safari Pilates Rock Climbing Small Plane Excursion Stargazing Tennis (Outdoor) Walking Yoga   Hotel Types/Categories Best Golf Resorts Best Hotels for Meetings Best Hotels for Weddings Best Spa Hotels Desert Oasis Resorts Travel and Leisure Best Golf Resorts Travel and Leisure Best Golf Resorts for Buddy Trips Travel and Leisure Top 500 Hotels Travel and Leisure World Top 500 Hotels (USA)

Perched high on top of a cliff, in 27 acres of lush tropical woodlands and over-looking the South China Sea, The Sentosa Resort and Spa is a tranquil retreat. It is Singapore's first tropical garden spa destination with an adjacent golf club, just minutes from the heart of Singapore. This is the perfect getaway, where the lush landscaped gardens allow you to experience oneness with nature. Our plush deluxe rooms, luxury suites and idyllic garden villas are furnished in warm, contemporary styles with modern art works. Feel rejuvenated after a Five Elements Cleanse and Purifying Ritual, one of our award-winning Spa Botanica's signature treatments. Enjoy cocktails at The Pavilion at sunset before dining on exquisite seafood at The Cliff, which offers spectacular sea views. For those who prefer extravagaent buffets and champagne bruches, The Terrace is the place to indulge your tastebuds. The Sentosa Resort and Spa is a member of the Small Luxury Hotels of the World.

Juicy Details Amenties 24 Hour Front Desk Air Conditioned/Climate Control Airport Shuttle Balcony Barber/Hair Stylist Bath: Jacuzzi/Whirlpool in Bathroom Bath: Outdoor Shower (Private for the Room) Bath: Private Bathroom Bath: Rainfall Shower Bedrooms: 1 Bedroom Bedrooms: 2 Bedrooms Beds with Views Beds: Rooms with King Beds Beds: Rooms with Two Beds Bikes to Use Bose Sound System Boutique Shops Business Center Cable/Satellite TV Chauffeured Car Complimentary Newspaper Computer Use Available Concierge Services Connecting Rooms Cool Lounging Spot Cool Pool Views Deadbolts and Locks in Rooms Desk Dining Area in the Room Drive up to the Room Elevators Ergonomic Chair Extra Romantic Fitness Center Fitness Equipment Gardens on the Property Gift Shop Golf Course on Property Green Hotel Hairdryer Hot Tub/Jacuzzi:Outdoor (Shared/On Property) In Room Movies Internet: Available Internet: High Speed Outlet in Room Internet: WiFi in Public Areas iPod Docking Station Kids Menu Kitchen: Coffee Maker Kitchen: Kitchenette Kitchen: Refrigerator Labyrinth on the Property Laundry/ Dry Cleaning Service Local Shuttle Service Meeting Facilities Mini Bar Non-Smoking Room Ocean View Dining Outdoor Dining Outdoor Massage Pillow Top Mattreses Pool Pool - Indoor Pool - Outdoor Poolside Food & Drink Service Poolside Restaurant Privacy 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 Rollaway Beds Available Romantic Bed Room Service (24 Hours) Room Type: Bungalows Room Type: Family Rooms Room Type: Good for 2 Couples Room Type: Stand Alone Single Unit Room Type: Villa Safe Deposit Box Safe: In-Room Safe Self Parking - Uncovered Separate Sitting Area Slippers Smoke Alarm in Rooms Spa/Massage on Property Spiritual Renewal Sprinkler in Rooms Stunning Settings Taxi Cab Service Telephone in Room Tropical Vibe Wheelchair Friendly Public Areas Windows: Windows Open in the Room   Activities Badminton Bicycling Canoeing Galleries and Museums Golf Kayaking Kids Activites/Club Lively Night Scene Pilates Ping Pong Running Soccer Stargazing Tennis (Outdoor) Volleyball Walking Wine Tasting & Activities Yoga

Wifi Details Wireless broadband internet access: Hotel Lobby and The Pavilion (chargeable)High speed internet access in guestrooms (chargeable)

On the bluffs of the Ashley River and secluded among tall pines and live oaks, the Inn at Middleton Place offers relaxing accommodations in an atmosphere of unsurpassed natural beauty. A recipient of the American Institute of Architects highest award, the 53-room Inn features elegantly simple and exquisitely designed Guest Rooms In-room refrigerators, complimentary gift baskets, 150-gallon bathtubs and floor to ceiling windows are just some of the unique amenities we offer. Included in the room rate is admission to Middleton Place Plantation, America? Oldest Landscaped Gardens, a southern style breakfast and an evening reception at our Lodge. Guests interact with trained naturalists, who provide daily tours and lectures, on land and water, which bring to life the plantation's natural environment.

Juicy Tidbits
National Geographic Traveler says......
"Architectural sleekness on bluffs of Ashley River that lets nature do the talking: Cypress paneling and mission-style desks bring out colors of trees, and floor-to-ceiling windows reveal surrounding woodlands. Nature tours. Holistic cooking classes. Labyrinth, swan-dotted reflection pools, secret gardens. Carriage rides through bamboo forest. 52 rooms."

Juicy Details Amenties 24 Hour Front Desk Beds: Sofa Bed in Room Business Center Cable/Satellite TV Concierge Services Fireplace in the Room Gardens on the Property Golf Course on Property Hairdryer Internet: Available Kitchen: Coffee Maker Labyrinth on the Property Meeting Facilities Pool Restaurant On Property Spiritual Renewal   Activities Cooking Classes   Hotel Types/Categories National Geographic Traveler Stay List - US Sanctuary For Wellness

Displaying 1-5 of 8