SELECT 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-12-04:2026-12-04' 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 INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('6808') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Belukar Gili Trawangan: A Serene Haven for Blissful Escapes
Gili Trawangan, Lombok
From
Rp
Discover the serene haven of Belukar Gili Trawangan. Unwind in luxury accommodations, relish breathtaking sunsets, and savor exquisite dining here.
Discover the Enchanting Amanwana: Your Gateway to Wilderness Luxury
Moyo Island, West Nusa Tenggara
From
Rp
Escape to Amanwana: Where Luxury Meets Wilderness on Moyo Island. Dive into nature's beauty and unwind in style.
Enchanting Escapes: Tugu Hotel Lombok – Art, Culinary Delights, and Stunning Views
Lombok, West Nusa Tenggara
From
Rp
Experience enchantment at Tugu Hotel Lombok. Indulge in art, culinary delights with stunning views, beachfront villas, and unforgettable dining experiences.
Togean Island Eco-Friendly Resort: Bahia Tomini
Malenge, Togean Island
From
Rp
Escape to Bahia Tomini Eco Resort in Togean Islands—a blissful haven with sustainability, serenity, and creativity. Check this out!
Ujung Kulon Nikki Peucang Resort
Ujung Kulon, Banten
From
Rp
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.
Bali Padang Bai: Coral Restoration Workshop
Padang Bai, Bali
From
Rp
This workshop offers more than just the beauty of life underwater, but will also make it more impactful for the environment! See more...
Jakarta Mangrove Ecotourism: Mangrove Planting Trip
Mangrove Ecotourism Centre, Jakarta
From
Rp
Discover the hidden wonders of Jakarta's mangroves with our immersive tour and mangrove planting experience! More...
Karawang Tanjung Pakis: Mangrove Planting Trip
Tanjung Pakis, Karawang
From
Rp
Join our nursery tour and planting experience in Karawang City, immersing yourself in the beauty of these vital ecosystems.
Nature Conservation
Mangrove Adventure: Race to Net Zero
Pantai Indah Kapuk, North Jakarta
From
Rp
Immersive journey in mangrove forest with a lot of fun activities from race to mangrove planting experiences.
Pulau Kelapa: Coral Restoration Workshop
Kelapa Dua, Kepulauan Seribu, Jakarta
From
Rp
Embark on a journey of purpose and passion with Pulau Kelapa's Coral Restoration Workshop. Get ready for the wonders of marine conservation.
Riau Dompak Island: Mangrove Planting Trip
Dompak, Riau Island
From
Rp
Get ready for amazing mangroves on Riau! Join our Mangrove Planting Trip for conservation, local culture, and hands-on experience.