ala National Park is one of Sri Lanka's most famous wildlife reserves, located in the southeastern part of the island. Covering over 1,000 square kilometers, it is known for its diverse ecosystems, including forests, grasslands, and wetlands
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 ('2105') )
) 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.
Yala National Park is one of Sri Lanka’s most famous wildlife reserves, located in the southeastern part of the island. Covering over 1,000 square kilometers, it is known for its diverse ecosystems, including forests, grasslands, and wetlands. Yala is home to a wide variety of wildlife, including leopards, elephants, crocodiles, and numerous bird species. It is particularly renowned for its high leopard population, making it one of the best places in the world to spot these elusive big cats. The park offers safari tours, allowing visitors to explore its rich biodiversity and stunning landscapes