The Royal Botanic Gardens in Peradeniya, Sri Lanka, are renowned for their stunning beauty and diverse botanical treasures. Located just 5.5 km west of Kandy
SELECT staging_lJg_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM staging_lJg_postmeta price_meta2 WHERE price_meta2.post_id=staging_lJg_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-04-25:2027-04-25' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM staging_lJg_postmeta price_meta3 WHERE price_meta3.post_id=staging_lJg_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM staging_lJg_posts INNER JOIN staging_lJg_postmeta ON ( staging_lJg_posts.ID = staging_lJg_postmeta.post_id )
WHERE 1=1 AND (
( staging_lJg_postmeta.meta_key = 'accommodation_location_post_id' AND staging_lJg_postmeta.meta_value IN ('240') )
) AND staging_lJg_posts.post_type = 'accommodation' AND ((staging_lJg_posts.post_status = 'publish'))
GROUP BY staging_lJg_posts.ID HAVING 1=1
ORDER BY staging_lJg_posts.post_title ASC
A 5-day Sri Lanka tour visiting Sigiriya, Kandy, Nuwara Eliya, Ella, Galle, and Colombo. Highlights include the Pinnawala Elephant Orphanage, Dambulla Cave Temple, cultural shows, tea plantations, a scenic train ride, and historical landmarks like Galle Fort and Colombo's vibrant city life
A 6-day Sri Lanka tour featuring cultural experiences in Kandy, scenic tea plantations in Nuwara Eliya, wildlife safaris in Udawalawe, and local traditions in Bentota, ending with a city tour in Colombo
Explore Sri Lanka's cultural landmarks, ancient sites, scenic landscapes, and coastal beauty, from Colombo to Jaffna, Sigiriya, Kandy, Nuwara Eliya, Ella, and Galle. A perfect blend of heritage and nature
An 11-day Sri Lanka tour with cultural sites like Sigiriya and Kandy, wildlife safaris in Yala, tea plantations in Nuwara Eliya, and relaxing beach time in Bentota. Explore Colombo before departure
The Royal Botanic Gardens in Peradeniya, Sri Lanka, are renowned for their stunning beauty and diverse botanical treasures. Located just 5.5 km west of Kandy in the Central Province, these gardens attract visitors from around the globe with their impressive collection of orchids, scenic pathways, and proximity to the Mahaweli River. Established in the 19th century, they serve as both a peaceful retreat and an educational hub for botanical enthusiasts, showcasing a rich variety of plant species amidst a lush tropical setting
