Mylampavali
Mylampavali is situated in the Eastern Province of Sri Lanka near Batticaloa. Mylampavali is known for its Kamakshi Amman Temple. It is known among devotees for an exotic experience in Hinduism, unlike other traditional Hindu temples in Batticaloa. The travel from the main city, Batticaloa it is a beautiful ride that you will surely enjoy. If you are a fan of nature, peace and some quietness, then visiting this small village away from the hustle and bustle will be something to remember. The temperature lies more towards the tropical side. Checking the weather before your travel will help you enjoy your holiday.
Languages spoken | Tamil |
---|---|
Currency used | LKR |
Area (km2) | 28 |
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-22:2026-12-22' 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 ('568') )
) 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.