SELECT h.* FROM hotels h, amenitytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.AmenityID=100345 group by h.id ORDER BY star_rating desc ,name asc LIMIT 0,5
Inspired by the famous Alhambra Palace in Granada and evoking memories of a Moorish and Andalusia era, the elegant and superbly designed Alhambra Thalasso Hotel in Hammamet is an architectural masterpiece in its own right. Intricate moorish motifs and patterns lend character and class to its 184 rooms and suites and blend perfectly with the hotels excellent facilities and sophisticated style of service to offer you a unique and fascinating holiday experience.
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Balcony
Barber/Hair Stylist
Bath: Bathtub
Beach
Beds: Rooms with King Beds
Boutique Shops
Business Center
Cable/Satellite TV
Car Rental
Casino
Complimentary Breakfast
Currency Exchange
Elevators
Fitness Center
Game Room
Hairdryer
Internet: Available
Laundry Room Available
Maid Service
Meeting Facilities
Mini Bar
Pool - Indoor
Restaurant On Property
Room Service (24 Hours)
Safe: In-Room Safe
Sauna on Property
Smoke Alarm in Rooms
Sprinkler in Rooms
Telephone in Room
Turndown Service
Wake-up Service
Located in the heart of the city in the pedestrian area between St Stephen's Cathedral and the world famous Opera House The hotel is an old traditional Vienna style building located in the best area of Vienna. The hotels famous restaurant offers various specialities and the hotel also has a terraced cafe open in the summer.
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Balcony
Barber/Hair Stylist
Beds: 2 Twin Beds
Beds: 3 Twin Beds
Beds: Rooms with Two Beds
Business Center
Cable/Satellite TV
Casino
Complimentary Newspaper
Concierge Services
Currency Exchange
Desk
Elevators
Fax Machine Available For Guests
Fireplace to Enjoy
Hairdryer
Internet: Available
Internet: WiFi in the Guest Rooms
Laundry Room Available
Maid Service
Meeting Facilities
Mini Bar
Non-Smoking Room
Pets Allowed
Restaurant On Property
Room Service (Limited)
Safe Deposit Box
Safe: In-Room Safe
Secretarial Services
Slippers
Smoke Alarm in Rooms
Telephone in Room
Turndown Service
View: Rooms with City Views
Wake-up Service
Welcome to the 5****star TOP Hotel Ambassador Zlata Husa, built in 1920 in the Art Nouveau style on the famous Wenceslas Square directly in the centre of Prague. Our tastefully furnished and comfortable rooms are all air-conditioned and have private marble bathrooms with jacuzzi bath and shower. All rooms are equipped with minibar, SAT TV, direct dial phone allowing conference calls with up to six persons, fax, internet access, safety deposit box and hairdryer. The TOP Hotel Ambassador Zlata Husa is renowned for its great restaurants, cafes and bars. The Lobby bar, the luxurious Halali Restaurant, the traditional Pilsner Restaurant and the newly opened Ambassador Sushi and Thai Bar - all offer excellent fare for discerning gourmet. For our conference guests we offer a wide range of meeting and conference facilities that can accommodate up to 1500 people. Each meeting room is equipped with modern business technology for the ultimate in comfort and convenience. For those who cannot imagine their relaxation without sporting activities, the hotel has a gym with exercise equipment. An experienced masseur and attentive beautician will help you keep in shape. There are also hydrojet, floating, solarium and cosmetic services on offer at the beauty parlour. Within the calmness of the luxury Ambassador Thai and Wellness Club you will find a complete range of exclusive massages and treatments. Amongst them, Thai Massages, carried out by genuine Thai professionals, Indian Ayurvedic massages and a range of other treatments, relaxing baths and beauty wraps. In the comfort of our luxurious treatment rooms each with its own suite bathroom an exceptional experience awaits you. For your entertainment the VIP Club Casino and Goldfingers nightclub are open all night and day. We have just one wish - to invite you to our hotel and spend some unforgettable days together with you directly in the heart of the ancient city of Prague.
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Private Bathroom
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Business Center
Cable/Satellite TV
Casino
Complimentary Breakfast
Concierge Services
Fitness Center
Internet: Available
Local Shuttle Service
Meeting Facilities
Mini Bar
Non-Smoking Room
Pets Allowed
Restaurant On Property
Room Service (24 Hours)
Safe Deposit Box
Safe: In-Room Safe
Secretarial Services
Separate Sitting Area
Telephone in Room
Turndown Service
Wake-up Service
The contemporary architecture of the ARIA tower is complemented by the resort's lavish accommodations. Guestroom corridors streaming with natural light open to areas of enclosed glass, delivering spectacular city or mountain views. Within ARIA's 4,004 Guest Rooms, including 568 suites, panoramic floor-to-ceiling windows offer magnificent views of Las Vegas' striking skyline. ARIA's tower is uniquely designed to deliver corner-window views from every guestroom.
Juicy Details
Amenties
24 Hour Front Desk
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
ATM/Bank on Property
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Separate Bathtub and Shower
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Beds: 2 King Beds
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Blackout Drapes/Curtains
Bus/RV Parking
Business Center
Cable/Satellite TV
Car Rental
Casino
Complimentary Breakfast
Computer Use Available
Concierge Services
Cribs Available
Currency Exchange
Desk
Elevators
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 the Guest Rooms
Iron/Ironing Board
Jogging Track
Maid Service
Meeting Facilities
Mini Bar
News Stand
Non-Smoking Room
Photocopy Service
Pool
Pool - Outdoor
Restaurant On Property
Rollaway Beds Available
Room Service (24 Hours)
Room Service (Limited)
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Sauna on Property
Separate Sitting Area
Slippers
Smoke Alarm in Rooms
Sprinkler in Rooms
Telephone in Room
Turndown Service
Uniformed Security on Site
View: Rooms with City Views
Wake-up Service
Explore Bucharest from the historic Athenee Palace Hilton Bucharest hotel built in 1914 and set in the heart of the city. At the Hilton Athenee Palace Bucharest hotel you can enjoy local attractions including the Romanian Athenaeum and the former Royal Palace. Theatres shops and cafes are all located within walking distance. All Athenee Palace Hilton Bucharest hotel rooms have wireless internet access. Upgrade to a Hilton Room Plus or choose an Executive Room for Executive Lounge access. Enjoy the heated indoor pool Jacuzzi and well-equipped gym. Indulge in professional treatments from La Prairie beauty spa. Spend the evening in our onsite casino or dine in one of 3 restaurants. The English Bar offers a large selection of whiskies. Feast on authentic Italian delights in Roberto*s restaurant. Just 40 minutes* drive from Henri Coanda Airport the Athenee Palace Hilton Bucharest hotel has 13 meeting rooms for up to 400 guests. The Le Diplomate Ballroom is an UNESCO heritage monument and the setting for international events. Take in magnificent views over the Revolution Square and the Athenaeum from the fifth floor balcony in the Executive Lounge.
Juicy Details
Amenties
24 Hour Security
Air Conditioned/Climate Control
ATM/Bank on Property
Barber/Hair Stylist
Bath: Bathtub
Bath: Private Bathroom
Bath: Separate Bathtub and Shower
Bedding: Fine Linens
Bedding: Pillow Menu
Beds: Rooms with King Beds
Beds: Sofa Bed in Room
Blackout Drapes/Curtains
Bus/RV Parking
Business Center
Cable/Satellite TV
Car Rental
Casino
Complimentary Breakfast
Computer Use Available
Concierge Services
Currency Exchange
Desk
Ergonomic Chair
Fitness Center
Hairdryer
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: WiFi in the Guest Rooms
Iron/Ironing Board
Jogging Track
Kids Programs/Club
Kitchen: Coffee Maker
Meeting Facilities
Mini Bar
News Stand
Non-Smoking Room
Pets Allowed
Photocopy Service
Pool
Pool - Indoor
Room Service (24 Hours)
Room Service (Limited)
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Secretarial Services
Separate Sitting Area
Smoke Alarm in Rooms
Sprinkler in Rooms
Turndown Service
View: Rooms with City Views
Windows: Windows Open in the Room