DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 199' at line 10 Travel Information and Hotel Reservations
San Cristobal De Las Casas, Mexico Hotel Ciudad Real Teatro was designed with the traditional touch and colonial style of San Cristobal. It is located only 5 minutes from downtown so guest can get around easily & in good time. It also has an ample parking. the hotel has halls for special events & an international restaurant too deliciously and cordially fulfill the demands of its guests.Its 69 rooms are beautifully decorated in colonial style with excellent garden views, heat, cable TV.