Thalavila Church, also known as St. Mary's Church, is located in the village of Thalavila, in the Kegalle District of Sri Lanka
SELECT lJg_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM lJg_postmeta price_meta2 WHERE price_meta2.post_id=lJg_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-04-26:2027-04-26' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM lJg_postmeta price_meta3 WHERE price_meta3.post_id=lJg_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM lJg_posts INNER JOIN lJg_postmeta ON ( lJg_posts.ID = lJg_postmeta.post_id )
WHERE 1=1 AND (
( lJg_postmeta.meta_key = 'accommodation_location_post_id' AND lJg_postmeta.meta_value IN ('2108') )
) AND lJg_posts.post_type = 'accommodation' AND ((lJg_posts.post_status = 'publish'))
GROUP BY lJg_posts.ID HAVING 1=1
ORDER BY lJg_posts.post_title ASC
Unfortunately no accommodations were found.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
Thalavila Church, also known as St. Mary’s Church, is located in the village of Thalavila, in the Kegalle District of Sri Lanka. The church is known for its beautiful architecture and peaceful surroundings, making it a place of both religious significance and natural beauty. It serves as a center of worship for the local Catholic community and is also a popular spot for visitors interested in exploring Sri Lanka’s Christian heritage. The church is set amidst lush greenery, offering a serene atmosphere for prayer and reflection
