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=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2024-11-21:2026-11-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_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 ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('17982','20081','15882','11872','2594') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','room_type','accommodation','wpcf7_contact_form','ufaq','mc4wp-form' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','room_type','accommodation','wpcf7_contact_form','ufaq','mc4wp-form' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Daios Cove is a luxurious resort in Crete, nestled in a private bay with stunning Aegean Sea views. It features elegant accommodations, fine dining, a private beach, and a world-class spa, offering a serene and sophisticated Mediterranean escape.
Domes Novos Santorini is a family-friendly hotel located on the picturesque Greek island of Santorini. This secluded and luxurious property offers stunning views of the Aegean Sea, providing a perfect backdrop for a memorable family vacation.
Indulge in award-winning dining, spa treatments, and family fun amidst stunning Ionian vistas. Unforgettable experiences await at this oasis, from water sports to cultural delights!
Discover 5-star perfection with stylish rooms, panoramic Aegean Sea views and world-class amenities. The kids' club follows Montessori principles, offering engaging activities for all ages.
Nestled on the Cretan coastline, this luxurious family retreat offers a secluded village-like setting. Relax in private bungalows, some featuring pools amid lush gardens.
In the heart of a Greek nature reserve, this high-end, all-inclusive resort offers a top-tier family getaway. Kids enjoy various clubs, from a crèche (4 months+) to a football academy.
The luxury resort of MarBella is located on the picturesque coast of Corfu. Premium-all- inclusive covers everything you might need during your stay from accommodation, dining and drinks to daily activities and evening entertainment for all the family.
Embark on a coastal escape at the newly renovated Resort, nestled near pristine beaches, families thrive with a crèche, complimentary kids club and diverse learning experiences.
Discover Sani Beach, an award-winning haven on a 7km beach in Halkidiki. Perfect for dynamic family seaside retreats, it captivates with superb facilities and a genuinely warm staff.
Escape to Sani Club, ranked among the world's top family hotels. Enjoy private bungalows with resort perks with expert „Worldwide Kids“ care, crèche, Mini Club, and teen activities.
This eco-friendly resort with private beach boasts sleek design and organic farming. Little Explorers Kids’ Club engages ages 3-10 with workshops, performances and a playground.
Where boho-chic vibes meet sustainability: Indulge in Greek charm at this 4-star Beachfront Retreat. Award-winning cuisine and a kids club (5 years and up) ensure a unique experience.
Escape to Halkidiki Seaside Resort & Villas, a lush five-star retreat on Athos Peninsula. Enjoy Mediterranean gardens, private beach zones, and a range of sports activities.
Before having kids, I used to travel to Greece frequently and I always loved the country for its warm-hearted people, great food and sparkling turquoise waters. Travelling with my children, I have discovered many amazing family friendly resorts, where families are exceptionally well catered for and there are loads of activities that parents and children can enjoy together. Child-friendly Greece at its best! Spring, early summer or autumn are probably the best times to travel to Greece. In summer, prices are inflated, temperatures are very high and there are many more tourists than the rest of the year.
