SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-04-28:2026-04-28' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY accommodation_price DESC
LIMIT 12, 12
Escape to Janur Bungalow in Borobudur for an authentic Indonesian experience surrounded by lush rice fields, stunning mountains, and local life. Enjoy the outdoor pool, spacious rooms, and nearby Borobudur Temple.
Hidden getaway located at Ujung Kulon National Park, boasting its lush forests and healthy ocean. Home to numerous rare species, a paradise to reinvigorate your soul.
Eco-campground on the stunning island of East Sumba. Immerse in the stunning Tarimbang Bay, with turquoise waters, white sandy beaches, and lush coastal forests.