NEW
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.
Santorini, Greece
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:2026-06-27:2028-06-27' 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 ('20081') )
) 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
Santorini, Greece
Santorini is a captivating Greek island renowned for its striking beauty and unique charm. Famous for its iconic whitewashed buildings topped with blue domes, the island is set against the backdrop of the deep blue Aegean Sea. Formed by a volcanic eruption, Santorini's dramatic cliffs encircle a stunning caldera, offering some of the most breathtaking views in the world, especially at sunset. The island's picturesque villages, such as Oia and Fira, are perched on these cliffs, boasting narrow cobblestone streets, charming boutiques, and vibrant nightlife.
Santorini is also home to unique black and red sand beaches, a result of its volcanic history, offering a distinctive coastal experience. The island's rich history is evident in its ancient archaeological sites, such as the preserved ruins of Akrotiri, often referred to as the "Pompeii of the Aegean." With its blend of natural beauty, cultural heritage, and romantic ambiance, Santorini remains one of Greece's most sought-after and unforgettable destinations.
| Languages spoken | Greek |
|---|---|
| Currency used | Euro |
| Area (km2) | 73 km2 |
| Country name | Greece |