Surabaya
Surabaya is the capital city of the Indonesian province of East Java. Surabaya has been one of the busiest trading city ports in Asia. Principal exports from the port include sugar, tobacco and coffee. Surabaya is also known as The City of Heroes due to the epic battle happened in the city during Indonesia’s independence revolution. The highlights of the city include its submarine museum locally known as Monkasel, the immaculately presented Sampoerna museum, the unique Cheng Hoo Mosque, the majestic Sanggar Agung temple or a visit to the island of Madura via the Suramadu Bridge.
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-12-02:2026-12-02' 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 ('7456') )
) 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 accommodations were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.