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 = 166' at line 10
Hoi An, Vietnam * Hoi An Trails Countryside Resort is an international 4-star hotel and is located on the beautiful countryside of the Hoi An, that is surrounded by the Thu Bon River, rice field, closed to the Cua dai beach and the old town of Hoi An. * The Resort was created to provide a new approach of taking care of the requirements of our guests. Whatever you want or need, we are there to ensure that everything is taken care of right down to the smallest details. We bring you to the local culture, the natural environment and particularly the normal life of Hoi An people, that you can feel in every facet of our service. * Your stay at Hoi An Trails Resort offers you all of Hoi An?s gentle charms. The airness of outdoors ? meeting ? indoors is all around. * From June 01 to Sept 30, 2007 the Resort offer the Special Summer Promotion: Free pick up from the DAD airport or DAD railway station for booking min 2 nights. Pay only 3 nights for 4 nights stay.