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 = 62 AND A.deleted = 0 AND A.hidden = 0 AND B.deleted = 0 AND B.hidden = 0 AND A.sys_language_uid = 2
Villa Eden Break | Villa Eden - The Leading Park Retreat
The perfect program for relaxing and to recharge your energy levels in an atmosphere of warm hospitality. This program is designed for a stay of 2 nights, includes half board and the following services:
1 anti-stress massage (85 min.)
1 revitalizing face and neck treatment according to the method developed by Villa Eden
1 phyto-algae therapy based on Dead Sea salt
Balanced nutritional program of your choice
€ 430 per person Note: The above mentioned program does not include accommodations.