SELECT
								wp_72_posts.*
							FROM
								wp_72_posts
							INNER JOIN
								wp_72_postmeta ON (wp_72_posts.ID = wp_72_postmeta.post_id)
							WHERE
									wp_72_posts.post_type = 'attachment'
								AND
									((wp_72_posts.post_status = 'inherit'))
								AND
									((wp_72_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_72_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
							GROUP BY
								wp_72_posts.ID
							Array
(
    [0] => stdClass Object
        (
            [ID] => 84
            [post_author] => 1
            [post_date] => 2018-04-27 14:17:55
            [post_date_gmt] => 2018-04-27 12:17:55
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg
            [post_title] => DSCF7703.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => dscf7703-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:17:55
            [post_modified_gmt] => 2018-04-27 12:17:55
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [1] => stdClass Object
        (
            [ID] => 85
            [post_author] => 1
            [post_date] => 2018-04-27 14:22:41
            [post_date_gmt] => 2018-04-27 12:22:41
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg
            [post_title] => 02_2221.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 02_2221-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:22:41
            [post_modified_gmt] => 2018-04-27 12:22:41
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [2] => stdClass Object
        (
            [ID] => 86
            [post_author] => 1
            [post_date] => 2018-04-27 14:22:50
            [post_date_gmt] => 2018-04-27 12:22:50
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg
            [post_title] => 03_2018-04-18-PHOTO-00000003.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 03_2018-04-18-photo-00000003-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:22:50
            [post_modified_gmt] => 2018-04-27 12:22:50
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [3] => stdClass Object
        (
            [ID] => 87
            [post_author] => 1
            [post_date] => 2018-04-27 14:23:01
            [post_date_gmt] => 2018-04-27 12:23:01
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg
            [post_title] => 04_sli05.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 04_sli05-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:23:01
            [post_modified_gmt] => 2018-04-27 12:23:01
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [4] => stdClass Object
        (
            [ID] => 88
            [post_author] => 1
            [post_date] => 2018-04-27 14:23:11
            [post_date_gmt] => 2018-04-27 12:23:11
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg
            [post_title] => 05_2018-04-18_004.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 05_2018-04-18_004-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:23:11
            [post_modified_gmt] => 2018-04-27 12:23:11
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [5] => stdClass Object
        (
            [ID] => 89
            [post_author] => 1
            [post_date] => 2018-04-27 14:23:23
            [post_date_gmt] => 2018-04-27 12:23:23
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg
            [post_title] => 06_DSCF7708.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 06_dscf7708-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:23:23
            [post_modified_gmt] => 2018-04-27 12:23:23
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [6] => stdClass Object
        (
            [ID] => 90
            [post_author] => 1
            [post_date] => 2018-04-27 14:23:36
            [post_date_gmt] => 2018-04-27 12:23:36
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg
            [post_title] => 07_2018-04-18-0005.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 07_2018-04-18-0005-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:23:36
            [post_modified_gmt] => 2018-04-27 12:23:36
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [7] => stdClass Object
        (
            [ID] => 91
            [post_author] => 1
            [post_date] => 2018-04-27 14:23:48
            [post_date_gmt] => 2018-04-27 12:23:48
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg
            [post_title] => 08_DSCF7706.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 08_dscf7706-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:23:48
            [post_modified_gmt] => 2018-04-27 12:23:48
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [8] => stdClass Object
        (
            [ID] => 92
            [post_author] => 1
            [post_date] => 2018-04-27 14:23:59
            [post_date_gmt] => 2018-04-27 12:23:59
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg
            [post_title] => 09_2018-04-18-07.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 09_2018-04-18-07-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:23:59
            [post_modified_gmt] => 2018-04-27 12:23:59
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [9] => stdClass Object
        (
            [ID] => 93
            [post_author] => 1
            [post_date] => 2018-04-27 14:24:13
            [post_date_gmt] => 2018-04-27 12:24:13
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg
            [post_title] => 10_sli09.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 10_sli09-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:24:13
            [post_modified_gmt] => 2018-04-27 12:24:13
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [10] => stdClass Object
        (
            [ID] => 94
            [post_author] => 1
            [post_date] => 2018-04-27 14:24:22
            [post_date_gmt] => 2018-04-27 12:24:22
            [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg
            [post_title] => 11_2018-04-18-009.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_2018-04-18-009-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-27 14:24:22
            [post_modified_gmt] => 2018-04-27 12:24:22
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

)
Array
(
    [84] => Array
        (
            [attachment_id] => 84
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg
            [alt_text] => 
        )

    [85] => Array
        (
            [attachment_id] => 85
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg
            [alt_text] => 
        )

    [86] => Array
        (
            [attachment_id] => 86
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg
            [alt_text] => 
        )

    [87] => Array
        (
            [attachment_id] => 87
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg
            [alt_text] => 
        )

    [88] => Array
        (
            [attachment_id] => 88
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg
            [alt_text] => 
        )

    [89] => Array
        (
            [attachment_id] => 89
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg
            [alt_text] => 
        )

    [90] => Array
        (
            [attachment_id] => 90
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg
            [alt_text] => 
        )

    [91] => Array
        (
            [attachment_id] => 91
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg
            [alt_text] => 
        )

    [92] => Array
        (
            [attachment_id] => 92
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg
            [alt_text] => 
        )

    [93] => Array
        (
            [attachment_id] => 93
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg
            [alt_text] => 
        )

    [94] => Array
        (
            [attachment_id] => 94
            [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg
            [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg
            [alt_text] => 
        )

)
#######

Haus Heidgen – Genuß in gemütlicher Atmosphäre!

Herzlich willkommen in unserem familiengeführten Gasthaus in Leverkusen-Schlehbusch.

Ein Kölsch unter Freunden oder ein genussvolles Essen – hier kocht der Chef noch selbst und verwöhnt Sie mit internationalen Spezialitäten und leckeren Gerichten vom Grill.Freuen Sie sich auf eine unkomplizierte Atmosphäre und den freundlichen Service. Wählen Sie aus verschiedenen Vorspeisen, Salaten und frischen Fleisch & Fischgerichten, die wir sorgfältig für Sie zubereiten.

Dazu passend bieten wir Ihnen eine Auswahl an Weinen, sowie zahlreiche weitere Erfrischungs- oder Heißgetränke an.

Für private oder geschäftliche Veranstaltungen bieten wir Ihnen Platz für bis zu 50 Personen. Lassen Sie sich durch unsere Menüvorschläge inspirieren und unverbindlich beraten, mit welchen leckeren Gerichten Sie Ihre Gäste bei uns verwöhnen können. Gerne verleihen wir Ihrer Feier einen festlichen Rahmen und kümmern uns auf Wunsch um die Dekoration. Wir freuen uns auf Ihre Anfrage – sprechen Sie uns einfach an.

Während der Sommermonate genießen Sie die warmen Tage auf unserer Aussenterrasse unter freiem Himmel.

Parkplätze finden Sie vor dem Haus.

Wir freuen uns auf Ihren Besuch!

Ihr Team von Haus Heidgen

Lust auf Kegeln? Wir bieten noch freie Plätze an! Fragen Sie uns.

HAUS HEIDGEN · Heinrich-Lübke-Str. 128 · 51375 Leverkusen · Tel 0214 - 56557 · Mail: info[at]haus-heidgen.de

Öffnungszeiten

• Dienstag – Sonntag
• 10:00 - 14:00 Uhr
• 17:00 - 24:00 Uhr
• Montag Ruhetag