Las Terrenas – ein Ort, der Karibikträume Wirklichkeit werden lässt. An der Nordküste der Halbinsel Samaná gelegen, verbindet dieses charmante Küstenstädtchen tropische Natur mit internationalem Flair. Einst ein verschlafenes Fischerdorf, hat sich Las Terrenas zu einem lebendigen Urlaubsort entwickelt, der seine Ursprünglichkeit bewahrt hat. Palmenumsäumte Strände, türkisblaues Wasser, eine weltoffene Gemeinschaft und die entspannte Atmosphäre machen den Ort zu einem besonderen Reiseziel.
Hier begegnen sich Dominikaner, europäische Auswanderer und Reisende aus aller Welt in einem harmonischen Miteinander. Kleine Boutiquen, Cafés, Beachbars und eine kreative Gastronomieszene prägen das Straßenbild ebenso wie bunt bemalte Häuser und freundliche Gesichter. Ob Badeurlaub, Aktivtourismus oder Kultur – Las Terrenas bietet alles, was es braucht, um die Dominikanische Republik von ihrer authentischsten Seite kennenzulernen.
SELECT sk_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM sk_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2025-07-16:2027-07-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM sk_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 sk_posts INNER JOIN sk_postmeta ON ( sk_posts.ID = sk_postmeta.post_id ) JOIN sk_icl_translations wpml_translations
ON sk_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', sk_posts.post_type) LEFT JOIN sk_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 (
( sk_postmeta.meta_key = 'accommodation_location_post_id' AND sk_postmeta.meta_value IN ('27340') )
) AND sk_posts.post_type = 'accommodation' AND ((sk_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' OR (
wpml_translations.language_code = 'en'
AND sk_posts.post_type IN ( 'e-floating-buttons','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM sk_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'de'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM sk_icl_translations t2
JOIN sk_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 sk_posts.post_type IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','wp_block','wp_template','wp_template_part','wp_global_styles','wp_navigation','e-floating-buttons','elementor_library','location','review','extra_item','room_type','accommodation','tour','car_rental','product','product_variation','shop_order_placehold','chbs_booking','chbs_booking_form','chbs_booking_extra','chbs_route','chbs_vehicle','chbs_vehicle_company','chbs_vehicle_attr','chbs_location','chbs_price_rule','chbs_av_rule','chbs_driver','chbs_coupon','chbs_geofence','chbs_tax_rate','chbs_email_account','chbs_currency','wpcf7_contact_form' ) ) OR sk_posts.post_type NOT IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','wp_block','wp_template','wp_template_part','wp_global_styles','wp_navigation','e-floating-buttons','elementor_library','location','review','extra_item','room_type','accommodation','tour','car_rental','product','product_variation','shop_order_placehold','chbs_booking','chbs_booking_form','chbs_booking_extra','chbs_route','chbs_vehicle','chbs_vehicle_company','chbs_vehicle_attr','chbs_location','chbs_price_rule','chbs_av_rule','chbs_driver','chbs_coupon','chbs_geofence','chbs_tax_rate','chbs_email_account','chbs_currency','wpcf7_contact_form' ) )
GROUP BY sk_posts.ID HAVING 1=1
ORDER BY sk_posts.post_title ASC
