Badulla
Badulla is the main city of Uva Province situated in the lower central hills of Sri Lanka. It is the capital city of Uva Province and the Badulla District. Wikipedia
| Country name | Sri Lanka |
|---|
SELECT hw9nN_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM hw9nN_postmeta price_meta2 WHERE price_meta2.post_id=hw9nN_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-09-30:2027-09-30' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM hw9nN_postmeta price_meta3 WHERE price_meta3.post_id=hw9nN_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM hw9nN_posts INNER JOIN hw9nN_postmeta ON ( hw9nN_posts.ID = hw9nN_postmeta.post_id )
WHERE 1=1 AND (
( hw9nN_postmeta.meta_key = 'accommodation_location_post_id' AND hw9nN_postmeta.meta_value IN ('28439') )
) AND hw9nN_posts.post_type = 'accommodation' AND ((hw9nN_posts.post_status = 'publish'))
GROUP BY hw9nN_posts.ID HAVING 1=1
ORDER BY hw9nN_posts.post_title ASC
Unfortunately no accommodations were found.
Unfortunately no tours were found.
Unfortunately no car rentals were found.