select * from ir_oewv.hotels where bestellung = 'on' and (video_id > 0 AND gratis != 'Y') order by gratis,sterne asc limit 10 offset 0Array ( [0] => Array ( [id] => 850707 [uuid] => FDDF0E88-0555-4777-BF0C-6DC3533E1103 [hotel_id] => [tmp] => [sortierung] => [vn] => 850707 [hotel_name] => A&O Graz Hauptbahnhof [mi_status] => Freigegeben zum Druck 2017 [inhaber] => A&O Hotels and Hostels [last_import] => 2017-12-16 14:01:24 [bundesland] => Steiermark [plz] => 8020 [ort] => Graz [strasse] => Eggenberger Straße [h_nummer] => 7 [tel_ort] => (0)316 [tel_nr] => 570 162 - 3700 [fax] => 570 162 - 3790 [mobil_vor] => [mobil_nr] => [web] => www.aohostels.com [mail] => booking@aohostels.com [kategorie] => Hotel [sterne] => 2 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/850707_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => Die Dachterrasse macht das Haus zu einem echten Hingucker – super Aussicht auf die Stadt, leckere Drinks & Snacks an der Bar, kostenloses WLAN; plus All-You-Can-Eat-Frühstück jeden Morgen.  [text_e] => Our roof terrace is a real eye-catcher – brilliant view of the city, delicious drinks & snacks at the bar, free WIFI, plus all-you-can-eat breakfast buffet each morning. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => N [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => Y [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => Y [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => N [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.0704 [l_long] => 15.4158 [video_id] => 202 [amex] => Y [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => [gebucht_2013] => on [garni] => [award] => N [niceurl] => a-o-graz-hauptbahnhof-in-graz [umwelt] => N [gratis] => N [basiseintrag] => N [visa] => N [mastercard] => N [gebucht_2014] => on [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => Y [bild_1] => ../hbilder/850707_haus_1.jpg [cnt] => 1 ) [1] => Array ( [id] => 850708 [uuid] => 84EC240B-D669-473E-9210-E8BEDC527028 [hotel_id] => [tmp] => [sortierung] => [vn] => 850708 [hotel_name] => A&O Wien Hauptbahnhof [mi_status] => Freigegeben zum Druck 2017 [inhaber] => A&O Hotels and Hostels [last_import] => 2017-12-16 14:01:18 [bundesland] => Wien [plz] => 1100 [ort] => Wien [strasse] => Sonnwendgasse [h_nummer] => 11 [tel_ort] => (0)1 [tel_nr] => 602 0617 - 3800 [fax] => 602 0617 - 3890 [mobil_vor] => [mobil_nr] => [web] => www.aohostels.at [mail] => booking@aohostels.com [kategorie] => Hotel [sterne] => 2 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/850708_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => A&O ist mittendrin im neuen modernen Stadtviertel. Gratis WLAN in der Lobby, eine Bar, Billardtisch, Kicker, Skybar & Außenterasse sorgen für Entspannung und geselligen Austausch nach dem Sightseeing.  [text_e] => A&O is situated in the new, modern district. Free WiFi in the lobby, one bar, a pool table, tabletop football, skybar & terrace make it easy to relax & spend a nice time with others after a day of sightseeing. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => Y [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => Y [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.1813 [l_long] => 16.3792 [video_id] => 201 [amex] => Y [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => [gebucht_2013] => on [garni] => [award] => N [niceurl] => a-o-wien-hauptbahnhof-in-wien [umwelt] => N [gratis] => N [basiseintrag] => N [visa] => N [mastercard] => N [gebucht_2014] => on [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => Y [bild_1] => ../hbilder/850708_haus_1.jpg [cnt] => 2 ) [2] => Array ( [id] => 841905 [uuid] => 0FE538CA-17D1-410F-BBD2-450F03CDD3D6 [hotel_id] => [tmp] => [sortierung] => [vn] => 841905 [hotel_name] => A&O Wien Stadthalle [mi_status] => Freigegeben zum Druck 2017 [inhaber] => A&O HOTELS and HOSTELS Holding AG [last_import] => 2017-12-16 14:01:07 [bundesland] => Wien [plz] => 1160 [ort] => Wien [strasse] => Lerchenfelder Gürtel [h_nummer] => 9-11 [tel_ort] => (0) 1 [tel_nr] => 4930480-3900 [fax] => 4930480-5190 [mobil_vor] => [mobil_nr] => [web] => www.aohostels.at [mail] => booking@aohostels.com [kategorie] => Hotel [sterne] => 2 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/841905_haus_1.jpg [haus_2] => ../hbilder/841905_haus_2.jpg [haus_3] => ../hbilder/841905_haus_3.jpg [haus_4] => [logo] => ../hbilder/841905_logo.jpg [text_d] => Seit 2009 überzeugt das Hotel mit moderner Einrichtung und unschlagbarer Atmosphäre - günstige Preise und zentrale Lage inklusive. Durch die Nähe zum Westbahnhof und zur Innenstadt bietet das A & O Haus einen idealen Start für eine erlebnisreiche Städtereise. EZ, DZ und Familienzimmer.  [text_e] => Modern amenities and unbeatable atmosphere since 2009 - favourable prices and central position included. Proximity of Westbahnhof station and inner city makes the A&O the ideal starting point for an adventurous city journey. Single, double and family rooms. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => Y [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => Y [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => N [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.2053 [l_long] => 16.3364 [video_id] => 136 [amex] => Y [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => [garni] => [award] => N [niceurl] => a-o-wien-stadthalle-in-wien [umwelt] => N [gratis] => N [basiseintrag] => N [visa] => N [mastercard] => N [gebucht_2014] => on [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => Y [bild_1] => ../hbilder/841905_haus_1.jpg [cnt] => 3 ) [3] => Array ( [id] => 114740 [uuid] => 87B88F82-75B0-401A-8DF0-DF114E383F60 [hotel_id] => [tmp] => [sortierung] => [vn] => 114740 [hotel_name] => Das Grüne Bio-Hotel zur Post [mi_status] => 2018 zum Druck freigeben [inhaber] => Georg Maier [last_import] => 2017-12-16 14:01:13 [bundesland] => Salzburg [plz] => 5020 [ort] => Salzburg [strasse] => Maxglaner Hauptstraße [h_nummer] => 45 [tel_ort] => (0) 662 [tel_nr] => 832339-0 [fax] => 832339-5 [mobil_vor] => [mobil_nr] => [web] => www.hotelzurpost.info [mail] => info@hotelzurpost.info [kategorie] => Hotel Garni [sterne] => 3 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/114740_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => Das Hotel ist außen und innen „grün“. Übernachten mit minimalen CO²Abdruck in ruhigen Zimmern, einem herrlichen Bio-Frühstück und das Service der familiären Gastlichkeit mitten in Salzburg.  [text_e] => Our hotel is green on the outside & the inside. Spend the night with a minimal carbon footprint in quiet rooms and enjoy a delicious organic breakfast & great service in homely atmosphere in Salzburg’s centre. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => N [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => Y [such_fischen] => N [such_kinderhotels] => Y [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => Y [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => Y [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => Y [such_50plus] => Y [such_beauty] => N [such_gesundheit] => Y [such_alpin] => N [such_individualisten] => Y [such_kunst] => Y [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => N [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => N [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => Y [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => N [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.7985 [l_long] => 13.0199 [video_id] => 232 [amex] => N [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => GARNI [award] => N [niceurl] => das-gruene-bio-hotel-zur-post-in-salzburg [umwelt] => N [gratis] => N [basiseintrag] => N [visa] => N [mastercard] => N [gebucht_2014] => on [gebucht_2015] => [linkbuchung] => http://www.gastrodat-online.com/gd_onlinebooking?cid=302-200309 [ama] => N [sky] => Y [bild_1] => ../hbilder/114740_haus_1.jpg [cnt] => 4 ) [4] => Array ( [id] => 839118 [uuid] => 3DACEF60-0252-4F74-A1B7-D955606E24AA [hotel_id] => [tmp] => [sortierung] => [vn] => 839118 [hotel_name] => AQI Hotel Schladming [mi_status] => Freigegeben zum Druck 2016 [inhaber] => Klaus Walcher [last_import] => 2015-11-17 14:23:24 [bundesland] => Steiermark [plz] => 8970 [ort] => Schladming [strasse] => Coburgstraße [h_nummer] => 54 [tel_ort] => 3687 [tel_nr] => 23536 [fax] => 23536-36 [mobil_vor] => [mobil_nr] => [web] => www.aqi-hotel.com [mail] => info@aqi-schladming.com [kategorie] => Hotel [sterne] => 3 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/839118_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => Aktivität – Qualität – Individualität! Zentral, in bester Lage, direkt am Lift und an der Piste. Adults only (Kinder ab 13), modern, stilvoll, gemütlich, kostenloses WLAN, SkySauna. Hoteleigene Parkgarage!  [text_e] => Activity – quality – individuality! Centrally and perfectly situated, right by the ski lift and slopes. Adults only (children 13 years or older), modern, stylish, cosy, free WIFI and Sky sauna. Private parking. [picto_p] => Y [picto_c] => Y [picto_s] => Y [picto_i] => N [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => N [picto_t] => Y [picto_g] => N [picto_u] => N [picto_l] => N [such_reiten] => N [such_golf] => Y [such_tennis] => N [such_mountain_bike] => Y [such_fischen] => N [such_kinderhotels] => N [such_wandern] => Y [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => Y [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => Y [such_sehenswuerdigkeiten] => N [such_bio] => N [such_romantik] => Y [such_50plus] => Y [such_beauty] => N [such_gesundheit] => N [such_alpin] => Y [such_individualisten] => Y [such_kunst] => N [such_zentral] => Y [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => Y [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => Y [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => N [web_picto_h] => N [web_picto_t] => Y [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_x] => Y [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.3939 [l_long] => 13.6932 [video_id] => 219 [amex] => Y [salesianer] => Y [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => [gebucht_2013] => [garni] => [award] => N [niceurl] => aqi-hotel-schladming-in-schladming [umwelt] => N [gratis] => N [basiseintrag] => N [visa] => N [mastercard] => N [gebucht_2014] => [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => N [bild_1] => ../hbilder/839118_haus_1.jpg [cnt] => 5 ) [5] => Array ( [id] => 756768 [uuid] => B3EFEB54-594F-4E2F-998E-1A184DA1BA98 [hotel_id] => [tmp] => [sortierung] => [vn] => 756768 [hotel_name] => AllYouNeed Hotel Vienna2 [mi_status] => 2018 zum Druck freigeben [inhaber] => Albertina Hotelbetriebsgesellschaft m.b.H. [last_import] => 2017-12-16 14:01:01 [bundesland] => Wien [plz] => 1020 [ort] => Wien [strasse] => Große Schiffgasse [h_nummer] => 12 [tel_ort] => (0) [tel_nr] => 50114-0 [fax] => 50114-0-99 [mobil_vor] => [mobil_nr] => [web] => www.allyouneedhotels.at [mail] => vienna2@allyouneedhotels.at [kategorie] => Hotel Garni [sterne] => 3 [sommer] => 1 [winter] => [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/756768_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => Zwischen der Altstadt und dem Prater gelegen, verwöhnt Sie unser Hotel mit Nichtraucher-Zimmern und warmem Frühstücksbuffet. Entspannen Sie im großzügigen und ruhigen Hotel-Garten mit Terrasse!  [text_e] => Situated between historic city centre and the Wurstelprater amusement park, our hotel offers comfortable non-smoking rooms and a warm breakfast buffet. Relax in our ample and tranquil hotel garden with terrace. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => N [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => N [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => Y [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.2165 [l_long] => 16.3757 [video_id] => 94 [amex] => N [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => GARNI [award] => N [niceurl] => allyouneed-hotel-vienna2-in-wien [umwelt] => N [gratis] => N [basiseintrag] => Y [visa] => N [mastercard] => N [gebucht_2014] => [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => N [bild_1] => ../hbilder/756768_haus_1.jpg [cnt] => 6 ) [6] => Array ( [id] => 756763 [uuid] => 9031F762-9463-489E-B629-966E0DDB6DE4 [hotel_id] => [tmp] => [sortierung] => [vn] => 756763 [hotel_name] => AllYouNeed Hotel Salzburg [mi_status] => 2018 zum Druck freigeben [inhaber] => Albertina Hotelbetriebsgesellschaft m.b.H. [last_import] => 2017-12-16 14:01:01 [bundesland] => Salzburg [plz] => 5020 [ort] => Salzburg [strasse] => Glockengasse [h_nummer] => 4b [tel_ort] => (0) [tel_nr] => 50114-0 [fax] => 50114-0-99 [mobil_vor] => [mobil_nr] => [web] => www.allyouneedhotels.at [mail] => salzburg@allyouneedhotels.at [kategorie] => Hotel Garni [sterne] => 3 [sommer] => 1 [winter] => [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/756763_haus_1.jpg [haus_2] => ../hbilder/756763_haus_2.jpg [haus_3] => ../hbilder/756763_haus_3.jpg [haus_4] => [logo] => ../hbilder/756763_logo.jpg [text_d] => Das Hotel befindet sich in ruhiger Lage am Fuße des Kapuzinerbergs. Die vielen Sehenswürdigkeiten der Mozartstadt erreichen Sie in wenigen Gehminuten. Besonderes Highlight: Starten Sie Ihre Urlaubstage mit unserem warmen Frühstücksbuffet auf der Hotel-Terrasse über den Dächern Salzburgs.   [text_e] => Our hotel is situated tranquilly at the foot of Kapuzinerberg. The Mozart’s city’s various sights are within a few minutes walking distance. Our special highlight for you: Start your days with our warm breakfast buffet on our panoramic roof terrace enjoying the view over Salzburg. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => N [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => N [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => N [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => N [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.8041 [l_long] => 13.0493 [video_id] => 93 [amex] => N [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => GARNI [award] => N [niceurl] => allyouneed-hotel-salzburg-in-salzburg [umwelt] => N [gratis] => N [basiseintrag] => Y [visa] => N [mastercard] => N [gebucht_2014] => [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => N [bild_1] => ../hbilder/756763_haus_1.jpg [cnt] => 7 ) [7] => Array ( [id] => 756767 [uuid] => A373C93C-D505-4D86-BB4C-BEC61984CC9C [hotel_id] => [tmp] => [sortierung] => [vn] => 756767 [hotel_name] => AllYouNeed Hotel Vienna4 [mi_status] => 2018 zum Druck freigeben [inhaber] => Albertina Hotelbetriebsgesellschaft m.b.H. [last_import] => 2017-12-16 14:01:01 [bundesland] => Wien [plz] => 1040 [ort] => Wien [strasse] => Schäffergasse [h_nummer] => 2 [tel_ort] => (0) [tel_nr] => 50114-0 [fax] => 50114-0-99 [mobil_vor] => [mobil_nr] => [web] => www.allyouneedhotels.at [mail] => vienna4@allyouneedhotels.at [kategorie] => Hotel Garni [sterne] => 3 [sommer] => 1 [winter] => [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/756767_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => Verbringen Sie Ihren Wien-Urlaub in bester Lage. Unser Hotel ist nur wenige Gehminuten von Ringstraße, Innenstadt und Naschmarkt entfernt. Am Morgen stärkt Sie unser warmes Frühstücksbuffet.  [text_e] => Only few steps from the famous circular road Ringstrasse, the city centre & Vienna’s most popular market Naschmarkt, our hotel is perfect for your Vienna trip. Start your days with a warm breakfast buffet. [picto_p] => N [picto_c] => N [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => N [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => N [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => N [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => N [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => N [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.1949 [l_long] => 16.3655 [video_id] => 95 [amex] => N [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => GARNI [award] => N [niceurl] => allyouneed-hotel-vienna4-in-wien [umwelt] => N [gratis] => N [basiseintrag] => Y [visa] => N [mastercard] => N [gebucht_2014] => [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => N [bild_1] => ../hbilder/756767_haus_1.jpg [cnt] => 8 ) [8] => Array ( [id] => 839700 [uuid] => 0025C35A-3157-4AD5-A198-4B66C4F3A17A [hotel_id] => [tmp] => [sortierung] => [vn] => 839700 [hotel_name] => AllYouNeed Hotel Klagenfurt [mi_status] => 2018 zum Druck freigeben [inhaber] => Albertina Hotelbetriebsgesellschaft m.b.H. [last_import] => 2017-12-16 14:01:10 [bundesland] => Kärnten [plz] => 9020 [ort] => Klagenfurt [strasse] => Nautilusweg [h_nummer] => 11 [tel_ort] => (0) [tel_nr] => 50114-0 [fax] => 50114-0-99 [mobil_vor] => [mobil_nr] => [web] => www.allyouneedhotels.at [mail] => klagenfurt@allyouneedhotels.at [kategorie] => Hotel Garni [sterne] => 3 [sommer] => 1 [winter] => [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/839700_haus_1.jpg [haus_2] => ../hbilder/839700_haus_2.jpg [haus_3] => ../hbilder/839700_haus_3.jpg [haus_4] => [logo] => ../hbilder/839700_logo.jpg [text_d] => Mitten im touristischen Zentrum von Klagenfurt bietet Ihnen unser Hotel die beste Ausgangslage: Strandbad Wörthersee, Minimundus und Europapark sind nur wenige Schritte entfernt. Unser Highlight: Genießen Sie das warme Frühstücksbuffet auf unserer Panorama-Dachterrasse. Gratis Wlan!  [text_e] => Situated right in Klagenfurt’s touristic centre, our hotel is the ideal base for visiting lido Klagenfurt (lake Wörthersee), Minimundus (miniature park) and Europapark nearby. The highlight for you to start your day: Enjoy a rich breakfast buffet on our panoramic roof terrace. Free WiFi. [picto_p] => N [picto_c] => Y [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => N [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => N [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => N [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => N [web_picto_f] => N [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => N [web_picto_f_neu] => N [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 46.6174 [l_long] => 14.2678 [video_id] => 103 [amex] => N [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => GARNI [award] => N [niceurl] => allyouneed-hotel-klagenfurt-in-klagenfurt [umwelt] => N [gratis] => N [basiseintrag] => Y [visa] => N [mastercard] => N [gebucht_2014] => [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => N [bild_1] => ../hbilder/839700_haus_1.jpg [cnt] => 9 ) [9] => Array ( [id] => 311216 [uuid] => 98B20972-E49F-4C27-BB89-B58C0E0A5522 [hotel_id] => [tmp] => [sortierung] => [vn] => 311216 [hotel_name] => Hotel Lungau [mi_status] => Freigegeben zum Druck 2017 [inhaber] => Marlene Gonschorowski [last_import] => 2017-12-16 14:04:23 [bundesland] => Salzburg [plz] => 5562 [ort] => Obertauern [strasse] => Ringstraße [h_nummer] => 76 [tel_ort] => (0)6456 [tel_nr] => 7335 [fax] => 7335-300 [mobil_vor] => 0664 [mobil_nr] => 2347329 [web] => www.hotel-lungau.at [mail] => info@hotel-lungau.at [kategorie] => Hotel Garni [sterne] => 3 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/311216_haus_1.jpg [haus_2] => ../hbilder/311216_haus_2.jpg [haus_3] => ../hbilder/311216_haus_3.jpg [haus_4] => [logo] => ../hbilder/311216_logo.jpg [text_d] => Familiär geführtes ***Frühstückshotel mit Komfortzimmer u. Ferienwohnungen im Zentrum von Obertauern. Ganz nahe: Pisten, Skischulen, Geschäfte, Restaurants u. In Lokale. Wir freuen uns auf Sie!  [text_e] => Family-run ***Breakfast hotel, comfortable rooms, holiday apartments in the centre of Obertauern. Near: pistes & ski schools, shopping, restaurants & in-club. We´re looking forward to seeing you! [picto_p] => N [picto_c] => N [picto_s] => Y [picto_i] => Y [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => N [picto_t] => N [picto_g] => Y [picto_u] => N [picto_l] => Y [such_reiten] => N [such_golf] => N [such_tennis] => N [such_mountain_bike] => N [such_fischen] => N [such_kinderhotels] => N [such_wandern] => N [such_nordic] => N [such_naturidyll] => N [such_schlank] => N [such_motorrad] => N [such_familienreisen] => N [such_historische] => N [such_casino] => N [such_luxus] => N [such_kulinarik] => N [such_wellness] => N [such_wein] => N [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => N [such_single] => N [such_sehenswuerdigkeiten] => N [such_bio] => N [such_romantik] => N [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => N [such_zentral] => N [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => N [web_picto_b] => Y [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => N [web_picto_d] => N [web_picto_n] => N [web_picto_f] => Y [web_picto_g] => N [web_picto_p] => N [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => N [web_picto_t] => Y [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_x] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.2478 [l_long] => 13.5618 [video_id] => 111 [amex] => N [salesianer] => Y [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => GARNI [award] => N [niceurl] => hotel-lungau-in-obertauern [umwelt] => N [gratis] => N [basiseintrag] => N [visa] => N [mastercard] => N [gebucht_2014] => on [gebucht_2015] => [linkbuchung] => [ama] => N [sky] => N [bild_1] => ../hbilder/311216_haus_1.jpg [cnt] => 10 ) )
Sortierung nach Video:
1 von 6
1
A&O Graz Hauptbahnhof
Steiermark, Graz
ST
2
W
3
A&O Wien Stadthalle
Wien, Wien
W
4
Das Grüne Bio-Hotel zur Post
Salzburg, Salzburg
S
5
AQI Hotel Schladming
Steiermark, Schladming
ST
7
AllYouNeed Hotel Salzburg
Salzburg, Salzburg
S
9
AllYouNeed Hotel Klagenfurt
Kärnten, Klagenfurt
K
10
Hotel Lungau
Salzburg, Obertauern
S
1 von 5
 
 
 
   
test