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] => ) ) #######
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.
Load: 18 queries - 0ms - 4.0MB - 145 cache hits / 177 Query: 21 queries - 0ms - 4.2MB - 177 cache hits / 211 Display: 40 queries - 0ms - 4.9MB - 801 cache hits / 875
Schreibe einen Kommentar
Du musst angemeldet sein, um einen Kommentar abzugeben.