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-11:2026-09-11' 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 ('3765') )
) 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
Discover the Joy of Slow Living at Kabin Kebun
Bandung, West Java
From
Rp
Experience the joy of slow living at Kabin Kebun. Embrace mindfulness, sustainable practices, and tranquility in a private house with a garden.
Jakarta Green Hotel: Novotel Cikini
Cikini, Jakarta
From
Rp
Get ready to experience luxury and sustainability at Novotel Cikini Jakarta! This 4-star gem is not just a hotel—it's an eco-conscious vibe.
Janur Bungalow, Magelang – Central Java
Magelang, Central Java
From
Rp
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.
Rumah Turi Eco Boutique Hotel, Solo
Mangkubumen, Solo
From
Rp
Discover the sustainable charm of Rumah Turi Eco Boutique Hotel in Solo. Enjoy a unique and eco-friendly stay surrounded by nature and nearby attractions.
Veluvana Bali Bamboo House: A Sustainable Oasis in Sidemen Valley
Karangasem, Bali
From
Rp
Escape to Veluvana Bali Bamboo House in Sidemen Valley. Experience the beauty of nature, sustainable living, and breathtaking views of Mount Agung.
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
Discover The Oasis of Sustainable Living at Omah Lor Projects
Sleman, Yogyakarta
From
Rp
Discover Omah Lor Projects: the Oasis of Sustainable Living. Immerse in permaculture, savor farm-to-table delights and embrace a nature-friendly lifestyle.
Jakarta Interactive Experience at Atsiri Sarinah
Menteng, Jakarta
From
Rp
Discover Atsiri Sarinah Jakarta, an interactive wonderland of aromatherapy, sustainable products, and a place full of delightful experiences!
Lampung Rural Life Trip Package – Way Kambas National Park
Braja Harjosari Village, Way Kambas National Park
From
Rp
information A meaningful trip experience in the magical village of Lampung. Stay is included.
schedule 3 Days 2 Nights
Sekolah Pagesangan: Empowering Rural Communities Through Education & Sustainability
Gunung Kidul, Yogyakarta
From
Rp
Discover Sekolah Pagesangan, a school promoting education, sustainability, and community empowerment through practical life skills and food self-sustenance.