FAVOR ACTIVAR EL JAVASCRIPT
 
Reservation System: Río Celeste Hideaway
STEPS TO RESERVE
 1| Select dates
 2| Customer information
 3| Confirmation




Amenities
  • Baby Sitting
  • Dry Cleaning
  • Hairdryer
  • Internet access point
  • Internet access WIFI
  • Ironing service
  • Massage
  • Parking lot
  • Rollaway Bed
  • Safety box at the reception
  • In-room Safety box
  • Horseback riding
  • Swimming Pool
  • Jacuzzi
  • Late Check out
  • Non smoking rooms
  • Currency Exchange
  • Tours desk
  • Restaurant
  • Bar
SELECT DATES
Please enter your arrival and departure dates. Then click below on Next to go to the next step.
Please click only ones to avoid duplicated reservations

  children between  0 - 6 years old.
Rooms: # of Adults - room 1: # of Children - room 1:

PROMOTIONAL CODE:
Please select your arrival and departure dates for your booking in the following calendar. The dates marked with an     are not available.

If there is no space available for your requested date, please CLICK HERE so we can help you find alternative dates

 
 
 

Ishtar
         
 
 
MySQL Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

ERROR EN SQL: select max(date_fecha_final) as maxDate from tbl_tarifa_habitacion where fk_int_habitacion in ()