SELECT A.l10n_parent AS uid, A.title AS title, A.date_from AS date_from, A.date_to AS date_to, A.offer_min_price AS offer_min_price, A.categories AS categories, A.description AS description, A.image AS image, A.services_title AS services_title, A.services AS services, A.prices AS prices, A.price_disclaimer AS price_disclaimer, A.seo_title AS seo_title, A.seo_description AS seo_description FROM tx_ttconsultingoffers_offers AS A INNER JOIN tx_ttconsultingoffers_offers AS B ON A.l10n_parent = B.uid WHERE A.l10n_parent = 7 AND A.deleted = 0 AND A.hidden = 0 AND B.deleted = 0 AND B.hidden = 0 AND A.sys_language_uid = 2
Villa Eden golf gateway | Villa Eden - The Leading Park Retreat
In the fabulous backdrop of Merano and surroundings, playing golf is a truly extraordinary experience. Vineyards, orchards, Mediterranean vegetation and majestic mountains offer the ideal setting to enjoy this fascinating sport, even on holiday.
Guests of Villa Eden who love golf have an exceptional opportunity to compete on the courses of Lana and Appiano. And we offer you very favorable conditions!