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=416 ORDER BY star_rating desc ,name asc LIMIT 0,5

Luxury boutique hotel in the center of charming Alamos.

Juicy Details Amenties Art Collection Bath: Bathtub Bath: Jacuzzi/Hot Tub in the Room Bath: Private Bathroom Bath: Soaking Tub Bedding: Down Comforter Bedding: Fine Linens   Activities Putting Green   Hotel Types/Categories Authentic Experience for Location Best Honeymoon Resorts Best Hotels for Couples Best Hotels for Weddings Best Romantic Hotels Juicy Hotels Favorite Hotels Luxe Retreat Luxurious Mexico in Style