SELECT
								wp_149_posts.*
							FROM
								wp_149_posts
							INNER JOIN
								wp_149_postmeta ON (wp_149_posts.ID = wp_149_postmeta.post_id)
							WHERE
									wp_149_posts.post_type = 'attachment'
								AND
									((wp_149_posts.post_status = 'inherit'))
								AND
									((wp_149_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_149_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
							GROUP BY
								wp_149_posts.ID
							Array
(
    [0] => stdClass Object
        (
            [ID] => 58
            [post_author] => 1
            [post_date] => 2018-03-28 11:05:27
            [post_date_gmt] => 2018-03-28 09:05:27
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [post_title] => 01_Hotel-Intro.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 01_hotel-intro-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:05:27
            [post_modified_gmt] => 2018-03-28 09:05:27
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [1] => stdClass Object
        (
            [ID] => 59
            [post_author] => 1
            [post_date] => 2018-03-28 11:05:50
            [post_date_gmt] => 2018-03-28 09:05:50
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [post_title] => 02_SAM_4711.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 02_sam_4711-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:05:50
            [post_modified_gmt] => 2018-03-28 09:05:50
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [2] => stdClass Object
        (
            [ID] => 60
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:01
            [post_date_gmt] => 2018-03-28 09:06:01
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [post_title] => 03_SAM_4718.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 03_sam_4718-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:01
            [post_modified_gmt] => 2018-03-28 09:06:01
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [3] => stdClass Object
        (
            [ID] => 61
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:09
            [post_date_gmt] => 2018-03-28 09:06:09
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [post_title] => 04_SAM_4414.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 04_sam_4414-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:09
            [post_modified_gmt] => 2018-03-28 09:06:09
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [4] => stdClass Object
        (
            [ID] => 62
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:17
            [post_date_gmt] => 2018-03-28 09:06:17
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [post_title] => 05_SAM_4421.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 05_sam_4421-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:17
            [post_modified_gmt] => 2018-03-28 09:06:17
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [5] => stdClass Object
        (
            [ID] => 63
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:28
            [post_date_gmt] => 2018-03-28 09:06:28
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [post_title] => 06_SAM_4443.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 06_sam_4443-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:28
            [post_modified_gmt] => 2018-03-28 09:06:28
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [6] => stdClass Object
        (
            [ID] => 64
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:40
            [post_date_gmt] => 2018-03-28 09:06:40
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [post_title] => 07_SAM_4471.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 07_sam_4471-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:40
            [post_modified_gmt] => 2018-03-28 09:06:40
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [7] => stdClass Object
        (
            [ID] => 65
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:52
            [post_date_gmt] => 2018-03-28 09:06:52
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [post_title] => 08_IMG_20180320_171327.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 08_img_20180320_171327-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:52
            [post_modified_gmt] => 2018-03-28 09:06:52
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [8] => stdClass Object
        (
            [ID] => 66
            [post_author] => 1
            [post_date] => 2018-03-28 11:07:00
            [post_date_gmt] => 2018-03-28 09:07:00
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [post_title] => 09_IMG_20180320_171610.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 09_img_20180320_171610-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:07:00
            [post_modified_gmt] => 2018-03-28 09:07:00
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [9] => stdClass Object
        (
            [ID] => 67
            [post_author] => 1
            [post_date] => 2018-03-28 11:07:09
            [post_date_gmt] => 2018-03-28 09:07:09
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [post_title] => 10_SAM_8220.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 10_sam_8220-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:07:09
            [post_modified_gmt] => 2018-03-28 09:07:09
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [10] => stdClass Object
        (
            [ID] => 68
            [post_author] => 1
            [post_date] => 2018-03-28 11:07:17
            [post_date_gmt] => 2018-03-28 09:07:17
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [post_title] => 11_SAM_8222.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_sam_8222-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:07:17
            [post_modified_gmt] => 2018-03-28 09:07:17
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

)
Array
(
    [58] => Array
        (
            [attachment_id] => 58
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [alt_text] => 
        )

    [59] => Array
        (
            [attachment_id] => 59
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [alt_text] => 
        )

    [60] => Array
        (
            [attachment_id] => 60
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [alt_text] => 
        )

    [61] => Array
        (
            [attachment_id] => 61
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [alt_text] => 
        )

    [62] => Array
        (
            [attachment_id] => 62
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [alt_text] => 
        )

    [63] => Array
        (
            [attachment_id] => 63
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [alt_text] => 
        )

    [64] => Array
        (
            [attachment_id] => 64
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [alt_text] => 
        )

    [65] => Array
        (
            [attachment_id] => 65
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [alt_text] => 
        )

    [66] => Array
        (
            [attachment_id] => 66
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [alt_text] => 
        )

    [67] => Array
        (
            [attachment_id] => 67
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [alt_text] => 
        )

    [68] => Array
        (
            [attachment_id] => 68
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [alt_text] => 
        )

)
#######

Herzlich willkommen im Hotel Schützenhof!

in unserem familiär geführten Hotel in Dortmund-Kirchlinde, 1km von der Autobahn-Abfahrt A45 Dortmund-Marten, bieten wir 10 gemütlich eingerichtete Zimmer für jeden Geschmack.

Jedes Zimmer ist mit modernen King-Size-Betten, TV und Telefon eingerichtet. Alle Zimmer sind mit Dusche / WC und Bad/WC sowie Kühlschrank ausgestattet. Im Hotel ist WLAN verfügbar. Die Parkplätze befinden sich hinter dem Haus.

Wir bieten ein Frühstückssystem an, dass in der Zeit von 6.30 – 11.00 Uhr auf dem Zimmer eingenommen werden kann. Wir stellen die Brötchen sowie die Kühlbox mit Wurst + Käse vor die Tür, damit Sie selber bestimmen können, wann Sie Ihr Frühstück einnehmen möchten.

Nutzen Sie jetzt auch unsere neuen Appartements. Geeignet für Monteure – hier können Sie sich in der komplett ausgestatteten Küche selbst versorgen.

Zahlreiche Gaststätten und Restaurants befinden sich in direkter Nähe. Der Ort Kirchlinde bietet auch Einkaufsmöglichkeiten für Selbstversorger. Mit den öffentlichen Verkehrsmitteln ist die Innenstadt leicht zu erreichen. Die Einkaufsmöglichkeiten und gastronomischen Anziehungspunkte in
der Innenstadt sind immer ein Ereignis. Der Verkehrsverein Dortmund bietet Ausflüge rund um Dortmund an. Informationen hierzu liegen im Hotel aus. Für Fahrradfreunde gibt es den neu erschlossenen Emscher-Radweg. Diese mehrtägige Tour führt quer durch das Ruhrgebiet.

In der näheren Umgebung liegt der Revierpark Wischlingen mit verschiedenen Freizeitmöglichkeiten (Schwimmbad, Sauna, Solarium, Tennis, Bootsverleih, Adventure Minigolfplatz etc.). Einen Biergarten finden Sie bei “Tante Amanda”.

Wir freuen uns auf Ihren Besuch und wünschen Ihnen schon jetzt einen angenehmen Aufenthalt.

Schreibe einen Kommentar Antworten abbrechen

Du musst angemeldet sein, um einen Kommentar abzugeben.

HOTEL SCHÜTZENHOF · Kirchlinder Str. 21 · 44379 Dortmund · Telefon: 0231 - 671368 · E-Mail: info@hotel-schuetzenhof.de