SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-06-20:2028-06-20' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('1493') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Unfortunately no accommodations were found.
7-day sailing
7-DAY SAILING ADVENTURE ON THE ADRIATIC
Split and Dalmatia
From
€
A week aboard a private sailboat along the Dalmatian coast. Your route, your pace, your adventure. Fully equipped and ready to go.
MOST WANTED
DIVING TRIP – VRUJA & OMIŠ
Split, Omiš, Vruja
From
€
Minivan transfer Split – Pisak – Omiš – Split, Full diving equipment, Experienced PADI guide, Underwater photos, Diving insurance
Most wanted
ONE-DAY EXCURSION WITH A SAILBOAT
Split, Šolta
From
€
Escape to the crystal-clear waters of Šolta and enjoy a perfect day of swimming, sailing, hidden bays, and pure Dalmatian vibes.
ZIPLINE ADVENTURE
Omiš, Cetina
From
€
8 WIRES, 150 M ABOVE GROUND LEVEL, STUNNING VIEWS, SHORT WALK BETWEEN LINES, 5 HOURS, 7+ YEARS
Unfortunately no cruises were found.
Unfortunately no car rentals were found.