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=10000627 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5

Prominently located on the western side of the Inner Alster Lake shore in Germany- The Fairmont Hotel Vier Jahreszeiten lies in the heart of the prime retail and commercial district. Founded in 1897- the Fairmont Hotel Vier Jahreszeiten in Hamburg- Germany is the essence of what is understood to be a Grand Hotel in the European tradition and offers an experience rich in spectacular historic charm and great luxury. All 156 rooms and suites have been renovated in 2009 and present themselves in an incredibly young design with attention to detail. The cuisine is spectacular- and some of Germany*s finest restaurants await their guests. Unique and furnished with great attention to historic detail- and each of 5 Function Rooms presents a magnificent backdrop- and this in turn reflects our own warm and engaging concept of hospitality. In addition to impeccable service and luxurious accommodation- you will find some of the best restaurants in Hamburg such as the Haerlin Restaurant- which serves classical and modern cuisine. The Lounge- at the heart of the hotel in Hamburg- Germany- creates a unique atmosphere of elegance and cosiness. We recommend afternoon tea in front of the fire while listening to live piano music.

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security A-V Equipment Rental Air Conditioned/Climate Control Babysitting or Child Care Balcony Barber/Hair Stylist Bath: Bathtub Bath: Separate Bathtub and Shower Bedding: Fine Linens Bedding: Pillow Menu Beds: Rooms with King Beds Bus/RV Parking Business Center Cable/Satellite TV Complimentary Breakfast Computer Use Available Concierge Services Currency Exchange Desk Elevators Fireplace to Enjoy Fitness Center 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: Is Free Internet: WiFi in the Guest Rooms Iron/Ironing Board Jogging Track Kids Programs/Club Kitchen: Coffee Maker Maid Service Meeting Facilities Mini Bar News Stand Non-Smoking Room Patio Photocopy Service Restaurant On Property Rollaway Beds Available Room Service (24 Hours) Room Service (Limited) Room Type: Lakefront Room Type: Lakefront Cabins, Cottages, Hotel Rooms Room Type: Lakeside Cottages/Cabins Room Type: Waterfront Rooms Safe Deposit Box Safe: In-Room Safe Sauna on Property Secretarial Services Slippers Smoke Alarm in Rooms Sprinkler in Rooms Telephone in Room Turndown Service View: Rooms with City Views View: Rooms with Lake View View: Rooms wtih Water Views Wake-up Service

Nestled in between captivating mountains and enchanting lakes- The Fairmont Jasper Park Lodge welcomes you to the Grand Rocky Mountain Lodge Experience. Situated in the magnificent Canadian Rockies in a UNESCO World Heritage Site- The Fairmont Jasper Park Lodge resort invites you to experience the charming cabins and rustic elegance sure to invoke memories that will last a lifetime. With a plethora of wildlife awaiting you just outside your cabin door- Canada*s #1 Golf Resort Course- as rated by the readers of SCOREGolf Magazine- unrivaled skiing- exceptional regional cuisine and an abundance of outdoor adventure opportunities- The Fairmont Jasper Park Lodge promises all hotel guests an experience they won*t soon forget. on the wild side of the Rockies.

Juicy Tidbits

Travel + Leisure says..."Secluded 1922 lakeside lodge with family-friendly cabins and a mountain-style golf course, spread across 700 acres in Jasper National Park.Rooms to Book: Avoid smaller standards; Lakeside Cabin Deluxes ($50 more) have a more affordable (if partially obstructed) view of Lac Beauvert.Insider Tip: Enjoy a glass of wine while sitting out on the sundeck on Lac Beauvert. The southward view sweeps the Whistler mountain range and Mt. Edith Cavell."And Travel + Leisure says..."Active types will love the Stanley Thompson 18-hole course and on-site horseback riding. But for those ready to relax, a seat in the classic wooden lodge overlooking snowcapped Mount Edith Cavell and sparkling Lac Beauvert is just the ticket.Guest Tip: Chris and Bill Pickering of San Diego, who have returned annually since they honeymooned here in 1990, book the same lakefront junior suite, Room 510, every year. It's not as palatial or expensive as the cottages, says mom Chris. But it has a picture window and an amazing view. When the kids were young, it was especially handy because of its proximity to the lodge's game room.National Geographic Says..."Cedar chalets and log cabins on 700 Canadian Rockies acres (283 hectares). Country-style decor. Views of blue, blue Lake Beauvert. Local storyteller shares Jasper lore. Nearby: Miette Hot Springs for a dip, Marmot Basin for skiing, Icefields Parkway for a scenic drive. 446 rooms, suites, and cabins."

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security A-V Equipment Rental ATM/Bank on Property Babysitting or Child Care Balcony Barber/Hair Stylist Bath: Bathtub Bath: Jacuzzi/Whirlpool in Bathroom Bath: Soaking Tub Bedding: Down Comforter Beds: 2 Twin Beds 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 Complimentary Newspaper Concierge Services Currency Exchange Desk Elevators Fireplace in the Room 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 Iron/Ironing Board Jogging Track Kids Programs/Club Kitchen: Coffee Maker Kitchen: Microwave Kitchen: Refrigerator Kitchen: Stove Maid Service Meeting Facilities News Stand Non-Smoking Room Patio Pets Allowed Photocopy Service Pool Pool - Indoor Pool - Outdoor Restaurant On Property Rollaway Beds Available Room Service (24 Hours) Room Service (Limited) Room Type: Cabins Room Type: Lakefront Room Type: Lakefront Cabins, Cottages, Hotel Rooms Room Type: Lakeside Cottages/Cabins Room Type: Stand Alone Single Unit 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 Lake View View: Rooms wtih Water Views Wake-up Service   Activities Golf Horseback Riding   Hotel Types/Categories Best Family Resorts & Hotels Best Golf Resorts Lake Lodges & Lakeside Hotels Mountain Lodges National Geographic Traveler Stay List - Canada Travel and Leisure Best Golf Resorts for Buddy Trips Travel and Leisure Best Golf Resorts for Families Travel and Leisure Top Hotels for Families

Just an hour north of downtown Houston, nestled along the shores of beautiful 22,000 acre Lake Conroe, La Torretta Lake Resort & Spa is a world apart from the bustle of city life and a unique gem featuring a blend of European luxury and Texas comfort. The meticulously-planned propertywhich recent underwent a $130 million expansion and renovationprovides visitors with an unforgettable vacation and meetings experience. Guests of this AAA Four Diamond Resort can expect to find a family-friendly, European-inspired lakeside retreat that maintains a successful balance between nature, relaxation and world-class sophistication.

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security A-V Equipment Rental Air Conditioned/Climate Control Babysitting or Child Care Balcony Barber/Hair Stylist Bath: Bathtub Bathrooms: 2 Bathrooms Bedding: Fine Linens Bedrooms: 1 Bedroom Bedrooms: 2 Bedrooms Beds: 2 Queen Beds Beds: Rooms with King Beds Beds: Rooms with Two Beds Beds: Sofa Bed in Room Boutique Shops Business Center Cable/Satellite TV Complimentary Breakfast Complimentary Newspaper Concierge Services Cribs Available Desk Elevators Fax Machine Available For Guests Fitness Center Game Room Gift Shop Golf Course on Property Hairdryer Hot Tub/Jacuzzi:Outdoor (Shared/On Property) In Room Movies Internet: Available Iron/Ironing Board Jogging Track Kitchen: Coffee Maker Kitchen: Kitchenette Kitchen: Refrigerator Laundry/ Dry Cleaning Service Maid Service Meeting Facilities Mini Bar Non-Smoking Room Pets Allowed Photocopy Service Pool Pool - Outdoor Restaurant On Property Rollaway Beds Available Room Service (24 Hours) Room Service (Limited) Room Type: Good for 2 Couples Room Type: Lakefront Room Type: Lakefront Cabins, Cottages, Hotel Rooms Room Type: Lakeside Cottages/Cabins Room Type: Villa Room Type: Waterfront Rooms Safe Deposit Box Safe: In-Room Safe Secretarial Services Separate Sitting Area Shopping Mall/ Area Smoke Alarm in Rooms Sprinkler in Rooms Telephone in Room Turndown Service View: Rooms with Lake View View: Rooms wtih Water Views Wake-up Service Wheelchair Friendly Public Areas

The Lake Placid Lodge is a beautifully handcrafted Lodge nestled in the Adirondack Mountains, situated on the shores of Lake Placid. The new Main Lodge, opening in October 2008, is a remarkable Arts and Crafts style lodge. The Lodge will offer among the finest accommodations and dining in a truly comfortable, rustic, yet refined setting. Pamper yourself in the new Main Lodge, the private cabins or the newly remodeled Lakeside suites, offering gorgeous views of Lake Placid and Whiteface Mountain. The guest rooms, suites and cabins feature comfortable featherbeds, wood burning fireplaces, rustic furnishings, and deep soaking baths. The Dining Room offers a prix-fixed menu with dining available on the deck overlooking Lake Placid and Whiteface Mountain. The Pub offers a relaxed setting serving lunch, dinner and an all day menu, and also offers outside dining on the deck.

Juicy Tidbits
Travel + Leisure says..."Adirondack style at its best: a recently renovated 1882 hillside resort overlooking Lake Placid, with fireplaces, featherbeds, and handcrafted "twig furniture.Rooms to Book: The lakeside Whitney and Eagles Eyre cabins.Insider Tip: The hotel offers sunset champagne cruises aboard its own luxury “barge.a After a devastating fire in 2005 damaged the original 1882 main house, the hotel reopened a new five-suite 30,000-square-foot main building in August of 2008. The new lodge's style is updated Adirondack with antique local furniture. But the property's best feature is still down by the private shore: 19 luxe log cabins built in the 1920's and 1930's. The service is impeccable and out of sight. Return from dinner and a fire has miraculously been lit in the stone fireplace, and wood replenished in a neatly stacked pile beside the hearth. Breakfast (a plate of raspberry pancakes, tiny jars of house-made preserves) arrives magically in a wicker basket and is whisked away when you're not looking. Blanket-strewn Adirondack chairs from a circle around the fire pit at dusk, with the makings of s'mores (fresh marshmallows, artisanal chocolate) on a tiday table nearby. The Lodge has brought over Kevin McCarthy from nearby sister property the Point - where he was chef for eight years - to create regionally inspired dishes such as apple cider-braised pork belly with tender local blue potatoes."

Juicy Details Amenties A-V Equipment Rental Air Conditioned/Climate Control Beach Bedrooms: 2 Bedrooms Beds: Rooms with King Beds Beds: Sofa Bed in Room Car Rental Complimentary Newspaper Fax Machine Available For Guests Fireplace in the Room Fireplace to Enjoy Game Room Golf Course on Property Hairdryer Internet: Available Iron/Ironing Board Jogging Track Kitchen: Coffee Maker Laundry Room Available Meeting Facilities News Stand Non-Smoking Room Pets Allowed Restaurant On Property Room Service (Limited) Room Type: Cabins Room Type: Lakefront Room Type: Lakefront Cabins, Cottages, Hotel Rooms Room Type: Lakeside Cottages/Cabins Room Type: Stand Alone Single Unit Room Type: Waterfront Rooms Safe Deposit Box Safe: In-Room Safe Telephone in Room Turndown Service View: Rooms with Mountain View Wake-up Service   Hotel Types/Categories Lake Lodges & Lakeside Hotels

Peppers Clearwater Resort ChristchurchAn oasis for the discerning guest Clearwater is fresh, evolving, contemporary. Just 7 minutes from the airport and 15 minutes to the city it is the perfect place to relax and unwind. Set within 465 acres of manicured landscape Clearwater has something for everyone. Stay in supreme comfort in chic rooms with private jetties, luxury suites designed in the style of a boathouse, with decks built over the water, or spacious terrace apartments all with serene lake views. The Lakes Restaurant & Bar is the epitome of casual elegance where Executive Chef, Michael Maguire, changes the menu regularly to utilise seasonal local produce. Conference in style in fresh venues bathed in natural light. Centrepiece to the resort is the 18 hole golf course, home of the prestigious NZPGA Championship. Golfers can walk straight off the course into the Sprig Bar to relax and take in the view to the 18th green and beyond to the Southern Alps. Guests enjoy a myriad of leisure activities, including tennis, petanque, extensive walking/jogging tracks, all purpose sports field, mountain biking and on-site fly fishing for wild brown and rainbow trout. Archery is also available. Horse riding and jet boating are just minutes away.

Juicy Details Amenties 24 Hour Front Desk Air Conditioned/Climate Control Balcony Bath: Bathtub Bath: Private Bathroom Bathrooms: 2 Bathrooms Bedding: Down Comforter Bedding: Fine Linens Bedding: Pillow Menu Bedrooms: 2 Bedrooms Beds: 2 King Beds Beds: 2 Twin Beds Beds: 3 King Beds Beds: 4 Twin Beds Beds: Rooms with Four Beds Beds: Rooms with King Beds Beds: Rooms with Three Beds Beds: Rooms with Two Beds Blackout Drapes/Curtains Complimentary Newspaper Desk Elevators Fax Machine Available For Guests Golf Course on Property Hairdryer Internet: Available Internet: Internet Access Kiosk Jogging Track Kitchen: Coffee Maker Kitchen: Dishwasher Kitchen: Full Kitchen in the Unit Kitchen: Kitchenette Kitchen: Microwave Kitchen: Refrigerator Kitchen: Stove Laundry - Washer/Dryer in Unit Laundry/ Dry Cleaning Service News Stand Non-Smoking Room Patio Photocopy Service Private Deck/Patio/Terrace Restaurant On Property Room Service (24 Hours) Room Type: Lakefront Room Type: Lakefront Cabins, Cottages, Hotel Rooms Room Type: Lakeside Cottages/Cabins Room Type: Villa Room Type: Waterfront Rooms Safe Deposit Box Safe: In-Room Safe Self Parking - Uncovered Separate Sitting Area Telephone in Room View: Rooms with Lake View View: Rooms wtih Water Views Wake-up Service

Displaying 1-5 of 15