Explore our latest accommodations
SELECT SQL_CALC_FOUND_ROWS i123cms_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM i123cms_postmeta price_meta2 WHERE price_meta2.post_id=i123cms_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-02-07:2027-02-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM i123cms_postmeta price_meta3 WHERE price_meta3.post_id=i123cms_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM i123cms_posts
WHERE 1=1 AND i123cms_posts.post_type = 'accommodation' AND ((i123cms_posts.post_status = 'publish'))
GROUP BY i123cms_posts.ID HAVING 1=1
ORDER BY i123cms_posts.post_title ASC
LIMIT 0, 4
Explore our latest tours

Zagreb city tour
Feel the Pulse of the City
From
Baht
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.

Weekend in Visby
Relaxing time for anyone
From
Baht
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
popular

Weekend in Venice
A romantic getaway
From
Baht
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
private

Weekend in Sagres
Private group escape
From
Baht
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
Explore our latest cruises

8 Days Spain – Affiliate
Barcelona - Ibiza - Sicily - Amalfi - Nice - Barcelona
From
Baht
1,470
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.

7 Days European posh
Amalfi - Ibiza - Barcelona - Marseille - Nice - Rome
From
Baht
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.

4 Days Norway cruise
Geiranger - Ålesund - Nordkapp - Flåm - Tromsø - Geiranger
From
Baht
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.