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 = 180' at line 10
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.