Rent Properties Hua Hin
See houses for rent
See condos for rent
We rent out all types of properties in Hua Hin and surrounding area. We offer our service from the beginning of you search for accomodation and until end of your stay in Hua Hin. You are in contact with us throughout the process. Our local partners in Hua Hin provide check in and check out. You are in contact with local partner and us during your rental period . Reservation, contract arrival and transport document created in cooperation with us. See below a selection of properties. Prices are stated per. day. Rentperiod is for a minimum period of 7 days. We have more properties . We would like to mail properties to you based on your requests. Please mail to us about your expectations and requests for your holiday.
SELECT SQL_CALC_FOUND_ROWS i123cms_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM i123cms_postmeta price_meta2 WHERE price_meta2.post_id=i123cms_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-09-18:2026-09-18' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM i123cms_postmeta price_meta3 WHERE price_meta3.post_id=i123cms_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM i123cms_posts
WHERE 1=1 AND i123cms_posts.post_type = 'accommodation' AND ((i123cms_posts.post_status = 'publish'))
GROUP BY i123cms_posts.ID HAVING 1=1
ORDER BY i123cms_posts.post_title ASC
LIMIT 0, 12
