Colombo Port city
Colombo Port City, a new and exciting part of Colombo along the coast. This modern area features sleek buildings, green spaces, and lively shops and restaurants
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 ('211') )
) 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
Hotel Dean
Address 1234, Dubrovnik, Croatia
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
Sri Lanka Culture & Heritage 13 Days
Relaxing time for anyone
From
$
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
Sri Lankan Beach & Heritage in 11 Days
Walking city tour
From
$
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
11 Days Adriatic sea
Venice - Brač - Dubrovnik - Hvar - Korčula - Pula - Split - Venice
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
Unfortunately no car rentals were found.
Colombo Port City, a new and exciting part of Colombo along the coast. This modern area features sleek buildings, green spaces, and lively shops and restaurants. Enjoy a walk along the waterfront, have a meal with ocean views, and explore the latest attractions. Colombo Port City offers a fresh look at the future of the city and is a great spot to relax and enjoy the sea
