SELECT SQL_CALC_FOUND_ROWS 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-07-27:2026-07-27' 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
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.ID DESC
LIMIT 0, 3
Unfortunately no accommodations were found.
Popular destinations
From Rp
Use 30DEAL coupon when checking out to get 30% discount on your purchase.
Valid until 2024-04-26
Sumatera island offering a wide range of attractions and activities. Visitors can explore the natural beauty of places like Lake Toba, the Mentawai Islands, and the Kerinci Seblat National Park, or immerse themselves in the rich cultural heritage of cities like Padang, Bukittinggi, and Medan.
Java island offering a wide range of attractions for visitors to explore. The most famous landmark on the island is Borobudur, the largest Buddhist temple in the world and a UNESCO World Heritage Site, the Hindu temple Prambanan, the historic city of Yogyakarta, Mount Bromo and Ijen volcano.
Medan offers a vibrant and eclectic experience for travelers, with its rich cultural heritage, mouthwatering cuisine, and breathtaking natural landscapes. Whether you're exploring the city's historic landmarks, savoring its culinary delights, or venturing into the wilderness, Medan is sure to leave a lasting impression.
Mount Bromo is an active volcano of 2.329 meters above sea level located in East- Java. It's one of the most visited tourist destinations in East- Java. Take an organized jeep tour with a stop at the viewpoint Penanjakan to enjoy the amazing view at sunrise.