The Sri Dalada Maligawa, known as the Temple of the Sacred Tooth Relic, is a revered Buddhist temple in Kandy, Sri Lanka. Situated within the royal palace complex, it enshrines the Relic of the tooth of Buddha
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 ('234') )
) 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
Explore Sri Lanka’s highlights in 13 days, from the beaches of Negombo to the ancient Sigiriya Rock, scenic train rides, Kandy’s culture, and Yala’s wildlife. End with a charming stay in Galle and Colombo's sights
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 Sri Dalada Maligawa, known as the Temple of the Sacred Tooth Relic, is a revered Buddhist temple in Kandy, Sri Lanka. Situated within the royal palace complex, it enshrines the Relic of the tooth of Buddha. This relic has historically held significant political influence, as it is believed that possession of the relic symbolizes governance over the country. Kandy, once the capital of the Sinhalese kings, preserves this heritage, contributing to its UNESCO World Heritage site status, primarily due to the cultural and religious importance of the temple and its relic
