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-10-16:2026-10-16' 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 ('3764') )
) 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
Bali Eco Stay
Tabanan, Bali
From
Rp
information An eco-accommodation surrounded by forests and mountains, a perfect setting to connect with yourself and nature.
Bali Mana Ubud Eco Villas
Ubud, Bali
From
Rp
information An eco-hotel located strategically in Ubud which strives to be ecologically and responsible in every way possible.
Discover the Enchanting Oasis of Samanvaya Luxury Resort & Spa Bali
Karangasem, Bali
From
Rp
Experience enchanting luxury at Samanvaya Resort & Spa Bali. Immerse in nature's embrace, authentic culture, and explore Sidemen Valley's charm.
Discover Tranquility and Luxury at Kelapa Retreat & Spa
Jembrana, Bali
From
Rp
Escape to Tranquility & Luxury at Kelapa Retreat & Spa in West Bali. Offering privacy, breathtaking views, and rejuvenating yoga & spa therapies.
Ngalung Kalla Eco-Retreat, Sumba
Waikabubak, West Sumba Regency
From
Rp
Discover Ngalung Kalla, an eco-friendly retreat on Sumba's stunning southwest coast, offering adventure, relaxation, and a deep connection with nature.
Sukabumi Countryside Retreat: Sukasantai Farmstay
Sukalarang, Sukabumi
From
Rp
Visit Sukasantai! A serene escape founded by a mother-daughter duo, combining enjoyment and relaxation with the perfect countryside vibes.
Agradaya: Nurturing Communities with Sustainable Herbs & Spices
Sleman, Yogyakarta
From
Rp
Discover Agradaya's eco-friendly agroforestry practices & exquisite products of herbs & spices. Join the spices house tour & workshops!
Best Ancient Balinese Healing and Wellness
Desa Baru Village, Tabanan
From
Rp
A cultural blend of healing activities through the ancient practices of traditional Balinese healing therapies, yoga, and meditation.
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!
