Database Error
Message:MySQL Query fail: SELECT DISTINCT name from files where property_id = AND is_default = 0 ORDER BY sortby DESC
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 'AND is_default = 0 ORDER BY sortby DESC' at line 1
Date:Saturday, December 14, 2019 at 11:29:32 PM
Script:/no/properties/orchid-paradise-homes-opv201-56
Database Error
Message:MySQL Query fail: select check_in, check_out from bookings where is_cancelled = 0 AND deleted = 0 AND property_id = ORDER BY check_in
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 'ORDER BY check_in' at line 4
Date:Saturday, December 14, 2019 at 11:29:32 PM
Script:/no/properties/orchid-paradise-homes-opv201-56
Thai Vacation Homes
English Dansk Norsk
  1. Home
  2. Properties

Check-in:
Check-out:

Price from

1-6 days: THB
7-39 days: THB
40+ days: THB
Book Now

Availability for the next 3 months

= booked

Next 3 months

Places Nearby

3km to the water/beach (as the crows flies).

  • 1Hua Hin Beach
  • 2Shopping, cinema & bowling
  • 3Hua Hin Walking Street. Dining, massage and nightlife
  • 4Bangkok Hospital
  • 5Central Bus Station

Related properties

Database Error
Message:MySQL Query fail: SELECT property_id, property_name, property_url, price_high_3, price_low_3, (SELECT name FROM files WHERE property_id = properties.property_id AND is_default = 1 LIMIT 1) as PropertyImage from properties WHERE property_id != AND property_label = '' ORDER BY sortby DESC
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 'AND property_label = '' ORDER BY sortby DESC' at line 3
Date:Saturday, December 14, 2019 at 11:29:32 PM
Script:/no/properties/orchid-paradise-homes-opv201-56