Juicy Hotels Favorite Spas

Juicy Hotels Favorite Spas

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=417 ORDER BY star_rating desc ,name asc LIMIT 0,5
Well rats. Sorry about this but we aren’t finding anything that matches your search. Nada. Bupkis. Care to try again with revised criteria?

 





Home | Hotels by Destination | Hotels by Type of Hotel | Hotels by Hotel Amenities | Hotels by Activities
Travel Magazine Hotel List | Plan a Road Trip | Last Minute Sunny Travel Weather Hotels
About Us | Press Room | Hoteliers | Advertising | Contact Us
Low Rate Guarantee | FAQ | Terms & Conditions | Privacy Policy | Support | Cancellations/Changes
Facebook | Twitter
For reservation assistance call our booking team (800) 419-1545 with our JUICY promo code 23752 for the best Juicy Hotels rates!
Monday - Friday 6:30 AM - 8 PM PST.  Saturday 8 AM to 2 PM. Sunday 10 AM to 2 PM

To reach the Juicy Hotels & Juicy Travels editorial offices please call 877-GO-JUICY07 (877-584-2907) for assistance.

California Seller of Travel #2099969 | Copyright 2012 Juicy Travels, Inc.