Attica is a region that never ceases to amaze. From the historical wonders of Athens to the serene beauty of the Athenian Riviera and the nautical charm of Piraeus!
Central Greece is one of the regions within mainland Greece. It's also known as Roumeli in Greek. It's located south of Thessaly and Epirus, and it includes the island of Evia.
Central Macedonia blends mountains, beaches, ancient wonders, and vibrant cities. From Thessaloniki to Mount Olympus and Halkidiki, it offers authentic experiences all year round.
Crete is a beautiful place and an ideal tourist destination for all travelers in the world. It is situated in a Mediterranean landscape and has a lot of endless beaches.
SELECT HMNxkYV_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM HMNxkYV_postmeta price_meta2 WHERE price_meta2.post_id=HMNxkYV_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-08-21:2028-08-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM HMNxkYV_postmeta price_meta3 WHERE price_meta3.post_id=HMNxkYV_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM HMNxkYV_posts INNER JOIN HMNxkYV_postmeta ON ( HMNxkYV_posts.ID = HMNxkYV_postmeta.post_id )
WHERE 1=1 AND (
( HMNxkYV_postmeta.meta_key = 'accommodation_location_post_id' AND HMNxkYV_postmeta.meta_value IN ('2555') )
) AND HMNxkYV_posts.post_type = 'accommodation' AND ((HMNxkYV_posts.post_status = 'publish'))
GROUP BY HMNxkYV_posts.ID HAVING 1=1
ORDER BY HMNxkYV_posts.post_title ASC
SELECT HMNxkYV_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM HMNxkYV_postmeta price_meta2 WHERE price_meta2.post_id=HMNxkYV_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-08-21:2028-08-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM HMNxkYV_postmeta price_meta3 WHERE price_meta3.post_id=HMNxkYV_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM HMNxkYV_posts INNER JOIN HMNxkYV_postmeta ON ( HMNxkYV_posts.ID = HMNxkYV_postmeta.post_id )
WHERE 1=1 AND (
( HMNxkYV_postmeta.meta_key = 'accommodation_location_post_id' AND HMNxkYV_postmeta.meta_value IN ('2571','2576') )
) AND HMNxkYV_posts.post_type = 'accommodation' AND ((HMNxkYV_posts.post_status = 'publish'))
GROUP BY HMNxkYV_posts.ID HAVING 1=1
ORDER BY HMNxkYV_posts.post_title ASC
SELECT HMNxkYV_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM HMNxkYV_postmeta price_meta2 WHERE price_meta2.post_id=HMNxkYV_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-08-21:2028-08-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM HMNxkYV_postmeta price_meta3 WHERE price_meta3.post_id=HMNxkYV_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM HMNxkYV_posts INNER JOIN HMNxkYV_postmeta ON ( HMNxkYV_posts.ID = HMNxkYV_postmeta.post_id )
WHERE 1=1 AND (
( HMNxkYV_postmeta.meta_key = 'accommodation_location_post_id' AND HMNxkYV_postmeta.meta_value IN ('2630','2925') )
) AND HMNxkYV_posts.post_type = 'accommodation' AND ((HMNxkYV_posts.post_status = 'publish'))
GROUP BY HMNxkYV_posts.ID HAVING 1=1
ORDER BY HMNxkYV_posts.post_title ASC
