Banyuwangi
Banyuwangi is a good base for exploring some of East Java. This is where you can start your adventure to the stunning electric blue flame of Ijen Crater. Mountain climbers can hike up from Banyuwangi to the stunning Ijen Crater and be amazed by its legendary blue flames that spring out among the yellow sulphureous rocks, which are cut and gathered manually by traditional miners. The blue fire is actually light from the combustion of sulfuric gases that emerge from cracks in the volcano. Banyuwangi is also internationally known as the destination that has many perfect spots for surfing.
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:2025-02-14:2027-02-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 ('7828') )
) 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
Unfortunately no cruises were found.
Unfortunately no car rentals were found.