SELECT SQL_CALC_FOUND_ROWS 73Z0wC5E_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM 73Z0wC5E_postmeta price_meta2 WHERE price_meta2.post_id=73Z0wC5E_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-04-18:2026-04-18' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM 73Z0wC5E_postmeta price_meta3 WHERE price_meta3.post_id=73Z0wC5E_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM 73Z0wC5E_posts LEFT JOIN 73Z0wC5E_term_relationships ON (73Z0wC5E_posts.ID = 73Z0wC5E_term_relationships.object_id)
WHERE 1=1 AND (
73Z0wC5E_term_relationships.term_taxonomy_id IN (215)
) AND 73Z0wC5E_posts.post_type = 'accommodation' AND ((73Z0wC5E_posts.post_status = 'publish'))
GROUP BY 73Z0wC5E_posts.ID HAVING 1=1
ORDER BY 73Z0wC5E_posts.post_title ASC
LIMIT 0, 12
At Santai Beach Bungalows you can start your day in the big open communal area while checking out the waves in Yoyo’s. This world famous surf break is on walking distance from the guesthouse.
