SELECT * FROM icedit_bph_hotel_roomprices, icedit_bph_hotel_szobatipus_kapcsolo, icedit_bph_hotel_roomprice_groups, icedit_bph_hotel_roomprice_penznemek, icedit_bph_hotel_roomprice_versions, icedit_bph_hotel_roomprice_types, icedit_bph_hotel_szobatipusok WHERE rpgroup_lang_code='4028' AND price_hotel_lang_code='37' AND price_rpgroup_lang_code=rpgroup_lang_code AND rpgroup_lang='en' AND rpgroup_penznem_lang_code=penznem_lang_code AND penznem_lang='en' AND rpgroup_type_lang_code=type_lang_code AND type_lang='en' AND type_sign='ROOM' AND rpgroup_version_lang_code=version_lang_code AND version_lang='en' AND version_sign='DAILYRATE' AND price_date_start<='2019-08-19' AND price_date_end>='2019-08-19' AND price_hszk_id=hszk_id AND hszk_szobatipus_lang_code=szobatipus_lang_code AND szobatipus_lang='en' AND rpgroup_board='AIL' AND rpgroup_lang_code NOT IN (0,4027) AND rpgroup_available_nights_min<='1' AND (rpgroup_available_nights_max>='1' || rpgroup_available_nights_max=0) AND hszk_id IN (0,1448,1449,1451,1450,1452) AND (rpgroup_setting_publicdate_start='0000-00-00 00:00:00' OR rpgroup_setting_publicdate_start<=NOW()) AND (rpgroup_setting_publicdate_end='0000-00-00 00:00:00' OR rpgroup_setting_publicdate_end>=NOW()) AND (rpgroup_active='TRUE' || rpgroup_setting_showwheninactive='TRUE') ORDER BY hszk_sorrend ASC, rpgroup_sorrend ASC
Non-binding inquiry / Book, Greenfield Hotel Golf & Spa Bükfürdő
Discount Code:

Non-binding inquiry / Book

Selection of rooms, prices
Services and other bookings
Enter personal data
Checking the data, send

Unfortunately there are days in the period when we do not have free rooms or exact prices available. Please change the date or send us your request and we give you our offer!

Reservation data
Arrival: 19 August 2019
Departure: 20 August 2019
Nights: 1 night
Tailor-made offer
In case of group reservations of 6 rooms or more or special requests we would be happy to make a tailor-made offer based on your needs.
Useful information about online booking
Quick Confirmation

You may submit your online reservation and we will send you a confirmation right away.

Desktop version Mobile version
We use cookies to provide the best possible user experience. You consent to our cookies if you continue to use our website. Privacy Policy Accept