Galle Face Green is a large, open seaside park in the heart of Colombo, Sri Lanka. It stretches along the coast, offering stunning views of the Indian Ocean
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-25:2027-04-25' 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 ('214') )
) 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
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
Galle Face Green is a large, open seaside park in the heart of Colombo, Sri Lanka. It stretches along the coast, offering stunning views of the Indian Ocean. Popular with locals and tourists alike, it’s a great spot for picnics, sunset views, and leisurely walks. The park is also a lively hub, with vendors selling snacks and kite flying being a common sight, especially in the evenings. It’s an ideal place to relax and enjoy the vibrant atmosphere of the city
