SELECT JrbRO_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM JrbRO_postmeta price_meta2 WHERE price_meta2.post_id=JrbRO_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-09-05:2028-09-05' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM JrbRO_postmeta price_meta3 WHERE price_meta3.post_id=JrbRO_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM JrbRO_posts INNER JOIN JrbRO_postmeta ON ( JrbRO_posts.ID = JrbRO_postmeta.post_id )
WHERE 1=1 AND (
( JrbRO_postmeta.meta_key = 'accommodation_location_post_id' AND JrbRO_postmeta.meta_value IN ('650') )
) AND JrbRO_posts.post_type = 'accommodation' AND ((JrbRO_posts.post_status = 'publish'))
GROUP BY JrbRO_posts.ID HAVING 1=1
ORDER BY JrbRO_posts.post_title ASC
Unfortunately no accommodations were found.
From Thessaloniki: Day Trip to Dion and Mount Olympus Park
Thessaloniki --Olympos
From
€
49
Unveil Mt. Olympus' secrets as you trek through a scenic national park on an excursion from Thessaloniki. Explore ancient Dion.
From Thessaloniki: Half-Day Canyoning Trip to Mount Olympus
Thessaloniki Mount Olympus
From
€
85
Jump, slide and abseil down waterfalls accompanied by the ICOpro-certified team of instructors for a a fun-filled learning experience on Mount Olympus.
From Thessaloniki: Pozar Thermal Baths and Edessa Day Trip
Thessaloniki: Pozar Thermal
From
€
49
Refresh your mind and body at the Pozar Thermal Baths and relax in the naturally heated water from the hot springs. Continue to the ancient city of Edessa on a day trip from Thessaloniki.
Full-Day Trip to Meteora from Thessaloniki
Thessaloniki
From
€
55
Reaching Meteora from Thessaloniki without a car can involve complicated transportation and leave little time to understand its remarkable monasteries.
Thessaloniki: Kavala, Philippi, and Beach Full Day Trip
Thessaloniki: Kavala, Philippi
From
€
39
Embark on a day trip to northern Greece combining history, culture, and relaxation. Visit Philippi, a UNESCO World Heritage Site, and explore the charming Old Town of Panagia.
Thessaloniki: Vergina and Pella Day Trip
Thessaloniki: Vergina
From
€
49
Take a full day trip by bus from Thessaloniki and travel back in time, into the Macedonian Kingdom of Alexander the Great and Philip II.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.