Detaillierte Suche

What?
Accommodation
Welche Yachtart?
Gulets
Katamarane
Motoryachten
Segelyachten
Wie viele Kabinen?
2 Kabinen
3 Kabinen
4 Kabinen
5 Kabinen
6 Kabinen
7 Kabinen (und mehr)
Wo?
Welcher Charterpreis?
0 - 49.999 €
50.000 - 99.999 €
100.000 - 149.999 €
150.000 - 199.999 €
200.000 € +

Motoryachten

Finden Sie Ihre ideale Charteryacht: hier eine Auswahl der besten Motoryachten

Wählen Sie Ihre ideale Motoryacht aus unserer sorgfältig ausgewählten Kollektion. Wenn Sie das perfekte Schiff nicht finden können, zögern Sie nicht, uns zu kontaktieren. Ihr Charterbroker ist für Sie da, um Sie zu beraten und die ideale Charteryacht nach Ihren Bedürfnissen zu finden.

SELECT SQL_CALC_FOUND_ROWS wp974_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp974_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2025-01-02:2027-01-02' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp974_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 wp974_posts LEFT JOIN wp974_term_relationships ON (wp974_posts.ID = wp974_term_relationships.object_id) JOIN wp974_icl_translations wpml_translations ON wp974_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp974_posts.post_type) LEFT JOIN wp974_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 ( wp974_term_relationships.term_taxonomy_id IN (50,11) ) AND wp974_posts.post_type = 'accommodation' AND ((wp974_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' OR ( wpml_translations.language_code = 'en' AND wp974_posts.post_type IN ( 'accommodation' ) AND ( ( ( SELECT COUNT(element_id) FROM wp974_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'de' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp974_icl_translations t2 JOIN wp974_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'de' AND ( p.post_status = 'publish' OR p.post_status = 'private' OR ( p.post_type='attachment' AND p.post_status = 'inherit' ) ) ) = 0 ) ) ) ) AND wp974_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','accommodation','acf-field-group','wpcf7_contact_form' ) ) OR wp974_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','accommodation','acf-field-group','wpcf7_contact_form' ) ) GROUP BY wp974_posts.ID HAVING 1=1 ORDER BY wp974_posts.post_title ASC LIMIT 0, 12