Sort by
- Price ascendingdescending
- Stars ascendingdescending
- Rating ascendingdescending
Unfortunately no results match your search criteria. Please try searching for something else.
- Destinations
- Badung & Denpasar
- Denpasar: The Living Heart of Modern Balinese Life
- Jimbaran: Where Ancient Fishing Wisdom Meets Golden Sunsets
- Kuta: Beyond the Chaos, Bali’s Original Cultural Bridge
- Legian: Where Bali’s Creative Spirit Found Its Urban Voice
- Nusa Dua: Where Balinese Excellence Meets World-Class Hospitality
- Sanur: Where Bali’s Gentle Soul Meets Timeless Elegance
- Seminyak: Where Balinese Sophistication Meets Global Style
- Uluwatu: Where Sacred Cliffs Guard Bali’s Spiritual Edge
- Ungasan: Where Bali’s Sacred Cliffs Meet the Infinite Ocean
- Bangli
- Buleleng
- Flores
- Labuan Bajo: Gateway to Ancient Dragons and Timeless Maritime Culture
- Gianyar
- Sukawati: Where Bali’s Creative Heart Still Beats
- Ubud: Where Bali’s Soul Meets Your Heart
- Jembrana
- Klungkung
- Lembongan: Where Ancient Seaweed Wisdom Meets Island Hospitality
- Nusa Penida: Where Ancient Spirits Guard Bali’s Wild Sacred Island
- Komodo National Park
- Kanawa Island: Where Pristine Coral Gardens Meet Traditional Bajo Wisdom
- Taka Makassar: Where Traditional Navigation Meets Pristine Atoll Paradise
- Manta Point: Where Ocean Spirits Dance in Sacred Waters
- Komodo Island: Where Dragons Dream and Ancient Spirits Roam
- Padar Island
- Tabanan
- Organized ToursDiscover tours packages
- Adventure
- Culture and History
- Art & Architecture
- Nature & Outdoors
- Culinary & Gastronomy
- Family-Friendly
- Honeymoon
- Luxury
- Budget-Friendly
- Photography
- Solo Travel
- Senior-Friendly
- Accessible
- ActivitiesWhat to do
- Trekking & Hiking
- Watersports
- Rafting
- Canyoning
- Surfing
- Scuba Diving & Snorkeling
- Land Activities
- ATV & Dirt Bikes
- eBikes & Cycling
- Horseback Riding
- Culture & Craft
- Classes & Workshops
- Cooking Classes
- Craft Workshops
- Massage & Spa Classes
- Tours & Excursions
- Dance Shows
- Family & Play
- Waterparks & Amusement
- Wildlife Encounters
- Easygoing Activities
- Wellness & Calm
- Spas & Massages
- Yoga & Meditation
- Other Activities
- EventsBali Calender
- DestinationsWhere you can go
- Organized ToursDiscover tours packages
- ActivitiesWhat to do
- EventsBali Calender
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (
SELECT SUM(rooms_available) rooms_available FROM (SELECT IFNULL(SUM(room_count), 0) rooms_available, availabilities.accommodation_id FROM wp_byt_accommodation_vacancies availabilities INNER JOIN (
select d.the_date from
(
select adddate('2026-08-26',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4
having the_date between '2026-08-26' and '2028-08-26'
ORDER BY the_date
) d
where DATE(d.the_date) >= DATE(CURDATE())
group by d.the_date
order by d.the_date
) possible_dates ON (possible_dates.the_date >= DATE(availabilities.start_date) AND possible_dates.the_date < DATE(availabilities.end_date)) WHERE 1=1 AND ('2026-08-26' BETWEEN start_date AND end_date OR start_date <= '2028-08-26') AND end_date >= '2026-08-26' GROUP BY possible_dates.the_date, availabilities.accommodation_id ) as ra WHERE accommodation_id = wp_posts.ID ) rooms_available , (
SELECT IFNULL(SUM(rooms_booked), 0) rooms_booked FROM ((SELECT IFNULL(SUM(bookings.room_count), 0) rooms_booked, bookings.accommodation_id, possible_dates.the_date FROM wp_byt_accommodation_bookings bookings INNER JOIN (
select d.the_date from
(
select adddate('2026-08-26',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,
(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4
having the_date between '2026-08-26' and '2028-08-26'
ORDER BY the_date
) d
where DATE(d.the_date) >= DATE(CURDATE())
group by d.the_date
order by d.the_date
) possible_dates ON (possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date < DATE(bookings.date_to)) WHERE 1=1 GROUP BY possible_dates.the_date, accommodation_id ) as rb, (SELECT MIN(start_date) min_start_date, MAX(end_date) max_end_date, accommodation_id FROM wp_byt_accommodation_vacancies GROUP BY accommodation_id) min_max_available_dates ) WHERE rb.accommodation_id = wp_posts.ID AND min_max_available_dates.accommodation_id = wp_posts.ID AND rb.the_date >= min_max_available_dates.min_start_date AND rb.the_date < min_max_available_dates.max_end_date ) 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:2026-08-26:2028-08-26' 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_star_count'
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1 AND rooms_available > rooms_booked AND rooms_available >= 1
ORDER BY wp_postmeta.meta_value+0 DESC
LIMIT 0, 10