SELECT * FROM icedit_siwita_microsite_custominfos_hotelv1 WHERE custominfo_microsite_lang_code='212'
SELECT * FROM icedit_news WHERE news_id='9845' AND news_column_id IN (3150,2546,3176,3151,3152,3153,3154,3155,3159,3160,3185,3186,3187,3188,3156,3177,3178,3179,3180,3181,3183,3184,3189,3190,3191,3192,3182) AND news_active='TRUE'
Offers
Booking / enquiry
Aura Hotel Balatonfüred
Arrival:
Departure:
Discount Code:
Close
Foglalás
Close

Offers

Offers

Weekday Wellness 2=3 nights
Romantic fill up!
To make your stay more memorable