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

Grand Hotel Kempinski Geneva is located on the shore of Lake Geneva, facing the water fountain and the Alps with stunning views of the Mont Blanc. The city centre is 5 minutes walking distance. The Airport is conveniently located 15 minutes and the train station is only 5 minutes drive away. Elegantly decorated rooms offer views overlooking lake Geneva, the Alps and the Jura Mountain as well as Hotel patio. All rooms have floor-to-ceiling windows and are equipped with the utmost in comfort, convenience, style and efficiency. High speed Internet access, wireless Internet and plasma TV in all rooms with a direct phone number option. Catch up on work at the desk or re-energise in the marble bathroom. The new duplex Geneva Suite is one of Geneva's largest, boasting views over the city with a private Spa and Gym. Opened in June 2010, le SPA Kempinski Geneva occupies a dedicated 1'400 sqm space. Le SPA offers a perfectly balanced menu of Ayurvedic therapies from India, beautifying treatments from Bali, Thailand, Japan and the Orient. Treatments are sourced by the award winner "CINQ MONDES" in a soothing, contemporary, Asian and Arabian ambiance. The Grill Restaurant, Brasserie, Tse Yang Restaurant, Lounge and Bar with a panoramic terrace overlooking the lake offer a variety of local and international specialities. In-house Java Night Club is the perfect place where you can dance and have fun. The hotels exterior architecture is being designed by tjca Architects with a light and futuristic feel, with the aim to dissolve the boundaries between the Geneva lakeside and access to the hotel lobby and boutique area. With its unique design and facilities the hotel will offer to the business travellers and the leisure visitors as well the highest level of services. The Grand Hotel Kempinski Geneva offers one of the largest in-house conference/congress and exhibition facilities in Switzerland, 10 meeting rooms, modern multi-purpose auditorium with a capacity up to 1300 seats.

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security A-V Equipment Rental Air Conditioned/Climate Control ATM/Bank on Property Babysitting or Child Care Balcony Barber/Hair Stylist Bath: Bathtub Bath: Separate Bathtub and Shower Bedding: Fine Linens Beds: 2 Twin Beds Beds: Rooms with King Beds Beds: Rooms with Two Beds Bus/RV Parking Business Center Cable/Satellite TV Car Rental Complimentary Breakfast Complimentary Newspaper Computer Use Available Concierge Services Currency Exchange Desk Elevators Game Room Golf Course on Property Hairdryer In Room Movies Internet: Available Jogging Track Kids Programs/Club Maid Service Meeting Facilities Mini Bar News Stand Non-Smoking Room Patio Pets Allowed Photocopy Service Pool Pool - Indoor Restaurant On Property Rollaway Beds Available Room Service (24 Hours) Room Service (Limited) Room Type: Lakefront Cabins, Cottages, Hotel Rooms Safe Deposit Box Safe: In-Room Safe Secretarial Services Separate Sitting Area Slippers Smoke Alarm in Rooms Telephone in Room Turndown Service View: Rooms with Lake View View: Rooms wtih Water Views Wake-up Service

Nestled in the Ozarks, overlooking the pristine waters of Table Rock Lake, Chateau on the Lake is Branson's only AAA Four-Diamond resort and convention center. Each beautifully decorated guest room features a wide variety of amenities including dual-line phone with data ports, Web TV access, Sony Play station, iron and ironing board. Dine in at one of Chateaus award winning restaurants or take advantage of the numerous recreational activities on the premise. Chateau on the Lake is minutes from Branson's Downtown Theaters and Missouri's finest golf courses. Nearby Airports * Springfield/Branson - 50 miles.

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security Air Conditioned/Climate Control Babysitting or Child Care Balcony Bedding: Down Comforter Bedding: Fine Linens Beds: Rooms with King Beds Beds: Rooms with Two Beds Beds: Sofa Bed in Room Boat to Hotel Business Center Childrens Playground Complimentary Breakfast Complimentary Coffee Complimentary Newspaper Concierge Services Connecting Rooms Dock Your Boat Electronic Key Fitness Center Golf Course on Property Hairdryer Helicopter Access Hot Tub/Jacuzzi:Outdoor (Shared/On Property) Internet: Available Internet: Broadband Access in Guest Rooms Internet: WiFi in Public Areas Iron/Ironing Board Kid Friendly Kids Menu Kids Programs/Club Kitchen: Coffee Maker Kitchen: Microwave Kitchen: Refrigerator Laundry/ Dry Cleaning Service Maid Service Marina Meeting Facilities News Stand Non-smoking Property Non-Smoking Room Outdoor Dining Pet Friendly - Size Limit Pets Allowed Pillow Top Mattreses Pool Pool - Indoor Pool - Outdoor Poolside Food & Drink Service Restaurant On Property Room Service (Limited) Room Type: Lakefront Cabins, Cottages, Hotel Rooms Safe Deposit Box Safe: In-Room Safe Sauna on Property Self Parking - Uncovered Separate Sitting Area Spa/Massage on Property Telephone in Room Translation Services Uniformed Security on Site View: Rooms with Lake View View: Rooms with Mountain View View: Rooms wtih Water Views Voicemail Wake-up Service Wet Bar   Activities Basketball Canoeing Fall Colors Fly Fishing Hiking Kayaking Kids Activites/Club

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

Displaying 1-5 of 22