The City of Galle, a southern gem in Sri Lanka, is renowned for its impressive Portuguese fortress built during their 153-year rule
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 ('172') )
) 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
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
Discover Sri Lanka's best beaches, ancient ruins, and scenic landscapes in this 11-day tour. From Kalpitiya's beaches to Sigiriya's rock fortress, enjoy culture, adventure, and relaxation
The City of Galle, a southern gem in Sri Lanka, is renowned for its impressive Portuguese fortress built during their 153-year rule. This UNESCO World Heritage Site occupies a scenic peninsula and features stunning colonial architecture from both the Portuguese and Dutch eras. Stroll through the fort to admire the Dutch church with its classic facade, the old hospital, and the governor’s residence. Don’t miss the British-era Anglican Church and the historic Meera Mosque, reflecting the diverse history and charm of this unique fort
