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-10-06:2026-10-06' 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 (234)
) 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
Our Sunset Suite Double Rooms are ideal for a couples getaway. Overlooking the river, mountain ranges and “Yoyo’s” surf break, offering great views and daily sunsets.
Nasu Surf Bungalows is the perfect land based surf camp for anyone looking for world class waves. Our bungalows are located at Nasu's own private beach, set right in the heart of west Sumbawa's world-renowned surf breaks.
The Planet Nomadas Dive Resort is designed to provide a active getaway for couples, families or groups up to 12 people. The resort is set in from of the beach looking back to Nusa Lembongan Island and across to the coastline of Bali and Mount Agung.
Jatiluwih Kangin, Penebel Tabanan - Bali - Indonesia
From
SANG GIRI consists of eight luxury tents each with en-suite bathrooms and a large private terrace. Enjoy marvellous views of dense mountain ranges and spectacular morning sunrises, with each terrace having its own unique vantage point.
Whales & Waves in West Sumbawa, is a brand new resort, unlike anything else. Escape among untouched natural landscape boasting long and pristine white sandy bays.
