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-09-14:2026-09-14' 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 ('3760') )
) 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
Bintan LooLa Eco Adventure Resort
Bintan, Riau
From
Rp
information An amazing array of choices, from camping on survivor island to dorms to chalets above the water to 5-star luxury.
Blue Earth Village – Amed, Bali
Amed, Bali
From
Rp
Eco-friendly resort with authentic experience in Amed, Bali
Camp Tarimbang, Sumba Island
Tarimbang, East Sumba
From
Rp
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.
Experience Eco-Friendly Luxury at Papua Diving Resorts
Raja Ampat, West Papua
From
Rp
Discover the wonders of Raja Ampat's marine life and stunning scenery at Papua Diving Resorts, where luxury and eco-friendliness meet for an unforgettable stay.
Experience Paradise at Raja4Divers Resort: A Diving & Snorkeling Heaven in Raja Ampat
Raja Ampat, West Papua
From
Rp
Escape to Raja4Divers Resort, a small & authentic resort in Raja Ampat. Explore marine biodiversity, lush mangroves, and exotic wildlife only here.
Experience the Perfect Eco-Friendly Getaway at Eco Beach Tent by Billiton
Tanjung Pandan, Belitung
From
Rp
Experience an eco-friendly luxury getaway at Eco Beach Tent by Billiton on Belitung Island. Enjoy sustainability, relaxation, and a private island experience.
Meos Ambower Homestay, Raja Ampat
Raja Ampat, West Papua
From
Rp
Experience a serene and memorable vacation at Meos Ambower Homestay in Raja Ampat. Enjoy comfortable accommodation, delicious meals, and exciting trips to breathtaking spots.
Meru Betiri Conservation Escape: Java Turtle Lodge
Meru Betiri, Banyuwangi
From
Rp
Located in Banguwangi, East Java, amidst the pristine beauty of white coral beaches and lush jungle, lies Java Turtle Lodge. More...
Misool Resort: Your Ultimate Island Getaway in Raja Ampat
Raja Ampat, West Papua
From
Rp
Escape to Misool Resort, a luxurious yet eco-friendly private island getaway in Raja Ampat. Enjoy stunning natural beauty, exceptional diving, and various activities while minimizing your carbon footprint.
Pulau Seribu Desa Laguna Regenerative Village & Resort
Pulau Karang Bongkok, Kepulauan Seribu
From
Rp
information Nourish and recharge yourself in an unspoiled paradise island in Pulau Seribu. Same price, more impactful with Bumi Journey.
Rote Utopia Eco-Lodge
Rote Barat, East Nusa Tenggara
From
Rp
information A sanctuary for authentic gathering and true eco-living.
Tropical Glamping Nusa Penida, Bali
Nusa Penida, Bali
From
Rp
Experience luxury and nature with Tropical Glamping at Nusa Penida, Bali. Enjoy eco-friendly bamboo bungalows, 180-degree ocean views, and more.
Waiwo Resort, Dive Resort in Raja Ampat
Raja Ampat, West Papua
From
Rp
Discover a tranquil retreat at Waiwo Dive Resort in Raja Ampat. Immerse yourself in the world's most beautiful marine parks or simply relax with eco-friendly practices.
1 Day Bali Reef Rehabilitation Diving Trip
Padangbai, Bali
From
Rp
information Experience our diving & reef rehabilitation trip that is not just relaxing but impactful for the environment!
schedule 1 Day
4D3N Togean Islands Expedition Trip Package
Tumbulawa, Central Sulawesi
From
Rp
information Take a break from the hustle and bustle of city life and travel to this mesmerizing Sulawesi's hidden paradise island. Stay is included.
schedule 4 Days 3 Nights
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...
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.