Unnichai
Unnichai is a place located near the administrative capital of the Batticaloa District. It is mainly known for the Unnichai Tank or rather Dam. Unnichai Dam has an elevation of 30m. You can go on a boating ride, go on a stroll and choose to bathe too. While making your way to this inland, you can witness cultivation in the paddy fields and visit temples on the way. Unnichai truly depicts the natural beauty of Sri Lanka and leave you in awe.
Languages spoken | Tamil |
---|---|
Currency used | LKR |
Area (km2) | 31 |
Country name | Sri Lanka |
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-21:2026-12-21' 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 ('572') )
) 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 car rentals were found.