SELECT * FROM icedit_siwita_microsite_custominfos_hotelv1 WHERE custominfo_microsite_lang_code='212'
SELECT * FROM icedit_news WHERE news_id='9846' 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'
Rooms
Booking / enquiry
Aura Hotel Balatonfüred
Arrival:
Departure:
Discount Code:
Close
Foglalás
Close

Rooms

Rooms

Rooms

Classic comfort
Luxury milieu with real experiences
Premium quality
Smart decision
With large space