Add Search Details

SELECT h.* ,(case country when 'US' then country else countryname end ) country FROM hotels h , categorytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.CategoryID=208 ORDER BY star_rating desc ,name asc LIMIT 0,5

Opposite side of the Prat Gran Trade Centre and 150 metres from Caldea. The hotel has panoramic terrace with views to the Escaldes Church, bar solarium, covert and conditioned swimming pool, restaurant and car park. Swimming pool: supplement 6 euro per person. Free access for customers accommodated in a superior room. News 2008-2009: For Saturdays nights (only in winter time) Thematic menu in its restaurant Kronos, without any extra charge. New Business Club, free exclusive access only for Corporate client (Corporate price). We put at your disposal PC, Internet access, TV, coffee break and daily newspaper, as well. Notice: the reservations received with the incomplete information of the credit card (without the security code) won't be confirmed.

Juicy Details Amenties 24 Hour Security Air Conditioned/Climate Control Beds: Rooms with King Beds Car Rental Complimentary Breakfast Elevators Hairdryer In Room Movies Internet: Available Internet: Broadband Access in Guest Rooms Iron/Ironing Board Mini Bar Pool - Indoor Private BBQ Area Restaurant On Property Room Service (Limited) Safe Deposit Box Safe: In-Room Safe Sauna on Property Telephone in Room   Activities Art Class Bicycling Cooking Classes   Hotel Types/Categories Adult Only Resorts Artsy Hotels Best Family Resorts & Hotels Budget Eco Resorts