Browns Beach in Negombo, Sri Lanka, is a popular beach destination known for its relaxing atmosphere and scenic views of the Indian Ocean
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 ('1661') )
) 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
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
Browns Beach in Negombo, Sri Lanka, is a popular beach destination known for its relaxing atmosphere and scenic views of the Indian Ocean. Located just a short distance from the town center, it offers golden sands, calm waters, and a range of water activities such as swimming, fishing, and kayaking. The beach is also home to several beachfront hotels and restaurants, making it a great spot for both relaxation and enjoying local seafood. It’s a perfect place to unwind and enjoy the coastal beauty of Negombo
