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] => 114740 [hotel_id] => [tmp] => [sortierung] => [vn] => 114740 [hotel_name] => Das grüne Hotel zur Post [mi_status] => Freigegeben zum Druck 2014 [inhaber] => Georg Maier [last_import] => 2013-05-22 14:01:52 [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 [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] => Y [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.7985 [l_long] => 13.0199 [video_id] => 197 [amex] => Y [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => Garni [award] => N [niceurl] => das-gruene-hotel-zur-post-in-salzburg [umwelt] => Y [gratis] => N [visa] => N [mastercard] => N [gebucht_2014] => on [bild_1] => ../hbilder/114740_haus_1.jpg [cnt] => 1 ) [1] => Array ( [id] => 756768 [hotel_id] => [tmp] => [sortierung] => [vn] => 756768 [hotel_name] => AllYouNeed Hotel Vienna2 [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Albertina Hotelbetriebsgesellschaft.m.b.H. [last_import] => 2013-05-22 14:01:40 [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 [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.2165 [l_long] => 16.3757 [video_id] => 94 [amex] => Y [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 [visa] => N [mastercard] => N [gebucht_2014] => [bild_1] => ../hbilder/756768_haus_1.jpg [cnt] => 2 ) [2] => Array ( [id] => 756763 [hotel_id] => [tmp] => [sortierung] => [vn] => 756763 [hotel_name] => AllYouNeed Hotel Salzburg [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Albertina Hotelbetriebsgesellschaft.m.b.H. [last_import] => 2013-05-22 14:01:40 [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 [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] => Y [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.8041 [l_long] => 13.0493 [video_id] => 93 [amex] => Y [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 [visa] => N [mastercard] => N [gebucht_2014] => [bild_1] => ../hbilder/756763_haus_1.jpg [cnt] => 3 ) [3] => Array ( [id] => 756767 [hotel_id] => [tmp] => [sortierung] => [vn] => 756767 [hotel_name] => AllYouNeed Hotel Vienna4 [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Albertina Hotelbetriebsgesellschaft.m.b.H. [last_import] => 2013-05-22 14:01:40 [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 [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.1949 [l_long] => 16.3655 [video_id] => 95 [amex] => Y [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 [visa] => N [mastercard] => N [gebucht_2014] => [bild_1] => ../hbilder/756767_haus_1.jpg [cnt] => 4 ) [4] => Array ( [id] => 839700 [hotel_id] => [tmp] => [sortierung] => [vn] => 839700 [hotel_name] => AllYouNeed Hotel Klagenfurt [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Albertina Hotelbetriebsgesellschaft m.b.H. [last_import] => 2013-05-22 14:01:48 [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 [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] => Y [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 46.6174 [l_long] => 14.2678 [video_id] => 103 [amex] => Y [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 [visa] => N [mastercard] => N [gebucht_2014] => [bild_1] => ../hbilder/839700_haus_1.jpg [cnt] => 5 ) [5] => Array ( [id] => 311216 [hotel_id] => [tmp] => [sortierung] => [vn] => 311216 [hotel_name] => Hotel Lungau [mi_status] => Freigegeben 2014 [inhaber] => Marlene Gonschorowski [last_import] => 2013-05-22 14:01:46 [bundesland] => Salzburg [plz] => 5562 [ort] => Obertauern [strasse] => Ringstraße [h_nummer] => 76 [tel_ort] => (0)6456 [tel_nr] => 7335 [fax] => 7335-300 [mobil_vor] => [mobil_nr] => [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. Gesundes Frühstücksbüffet, gemütlicher Wellnessberreich, Kinderspielzimmer, kostenloses W-Lan. Ganz nahe: Pisten, Skischulen, Geschäfte, Restaurants u. In Lokale. Wir freuen uns auf Sie!  [text_e] => 3* bed & breakfast with homely atmosphere: comfortable rooms & holiday apartments in Obertauern’s centre. Healthy breakfast buffet, cozy wellness area, children’s play room, free WiFi. Nearby: skiing slopes, ski schools, shops, restaurants & hot spots. We look forward to welcoming you in our house. [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] => Y [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] => 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 [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] => Y [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_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 [visa] => N [mastercard] => N [gebucht_2014] => on [bild_1] => ../hbilder/311216_haus_1.jpg [cnt] => 6 ) [6] => Array ( [id] => 211269 [hotel_id] => [tmp] => [sortierung] => [vn] => 211269 [hotel_name] => Hotel Donauwalzer [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Mag. Katharina Kluss [last_import] => 2013-05-22 14:01:55 [bundesland] => Wien [plz] => 1170 [ort] => Wien [strasse] => Ottakringer Straße [h_nummer] => 5 [tel_ort] => (0) 1 [tel_nr] => 4057645 [fax] => 4057645-999 [mobil_vor] => [mobil_nr] => [web] => www.donauwalzer.at [mail] => info@donauwalzer.at [kategorie] => Hotel [sterne] => 3 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/211269_haus_1.jpg [haus_2] => ../hbilder/211269_haus_2.jpg [haus_3] => ../hbilder/211269_haus_3.jpg [haus_4] => ../hbilder/211269_haus_4.jpg [logo] => ../hbilder/211269_logo.jpg [text_d] => Das Privathotel mit ausgezeichnetem, freundlichem Service liegt in Gehdistanz zum Zentrum direkt an der U-Bahn. Die charmant eingerichteten Zimmer verfügen über zahlreiche Annehmlichkeiten wie WLAN, Radio, Minibar, Wecker, Fön etc., teilw. Wasserbett oder Whirlpool. Es stehen 2 Lifte, eine Wellnessoase, Pkw-Stellplätze, ein Seminarraum, eine 24 Stunden geöffnete Bar und ein begrünter Innenhof zum Entspannen zur Verfügung. Bekannt ist das Hotel wegen der guten Betreuung, perfekten Lage und des reichhaltigen,  kalten und warmen Frühstücksbuffets, das in dieser Kategorie seinesgleichen sucht.  [text_e] => The private hotel with excellent, friendly service located at walking distance from the centre right by the underground. Charmingly furnished rooms with lots of amenities such as WLAN, radio, mini bar, alarm clock, hairdryer etc. Some with water bed or whirlpool. 2 lifts, a wellness oasis, car parking, a seminar room, 24 hour bar, leafy inner courtyard for pleasant relaxation. The hotel is famous for its good service, perfect location and substantial hot or cold breakfast buffet unrivalled in this category. [picto_p] => Y [picto_c] => N [picto_s] => Y [picto_i] => Y [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] => 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] => Y [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => 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] => Y [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] => Y [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.215 [l_long] => 16.3401 [video_id] => 152 [amex] => Y [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => [award] => N [niceurl] => hotel-donauwalzer-in-wien [umwelt] => N [gratis] => N [visa] => N [mastercard] => N [gebucht_2014] => on [bild_1] => ../hbilder/211269_haus_1.jpg [cnt] => 7 ) [7] => Array ( [id] => 748883 [hotel_id] => [tmp] => [sortierung] => [vn] => 748883 [hotel_name] => Pension Haus Sanz [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Susanne Limmer-Sanz [last_import] => 2013-05-22 14:01:44 [bundesland] => Wien [plz] => 1230 [ort] => Wien [strasse] => Krobothgasse [h_nummer] => 6-12 [tel_ort] => (0) 1 [tel_nr] => 667340515 [fax] => 6673405-13 [mobil_vor] => 0664 [mobil_nr] => 1722374 [web] => www.haussanz.at [mail] => office@haussanz.at [kategorie] => Gasthof oder Pension [sterne] => 3 [sommer] => [winter] => [gasthoefe_sommer] => 1 [gasthoefe_winter] => 1 [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/748883_haus_1.jpg [haus_2] => ../hbilder/748883_haus_2.jpg [haus_3] => ../hbilder/748883_haus_3.jpg [haus_4] => [logo] => ../hbilder/748883_logo.jpg [text_d] => Willkommen in meiner außergewöhnlichen  ***Pension. Wien erleben und im Grünen wohnen! Wir machen es möglich. Die einmaligen Themenzimmer, die Romantikzimmer mit Sternenhimmel und die Gartenappartements in Ruhelage machen Ihren Wien-Besuch zu einem sicher unvergesslichen Erlebnis!  [text_e] => Welcome to my extraordinary **** guesthouse. Enjoy Vienna but stay in leafy surroundings! We will make that possible. These unique themed rooms, romantic rooms with night skies and garden apartments in a quiet location to make your visit to Vienna an unforgettable experience. [picto_p] => N [picto_c] => N [picto_s] => Y [picto_i] => N [picto_n] => N [picto_f] => Y [picto_d] => Y [picto_h] => N [picto_t] => N [picto_g] => N [picto_u] => N [picto_l] => N [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] => Y [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => 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] => N [web_picto_o] => N [web_picto_k] => N [web_picto_j] => N [web_picto_a] => Y [web_picto_c] => N [web_picto_d] => Y [web_picto_n] => Y [web_picto_f] => N [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_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 48.1419 [l_long] => 16.3255 [video_id] => 132 [amex] => N [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => [award] => N [niceurl] => pension-haus-sanz-in-wien [umwelt] => N [gratis] => N [visa] => N [mastercard] => N [gebucht_2014] => [bild_1] => ../hbilder/748883_haus_1.jpg [cnt] => 8 ) [8] => Array ( [id] => 584904 [hotel_id] => [tmp] => [sortierung] => [vn] => 584904 [hotel_name] => Gasthof Hotel Doktorwirt [mi_status] => Freigegeben zum Druck 2014 [inhaber] => Familie Karl Schnöll [last_import] => 2013-05-22 14:01:51 [bundesland] => Salzburg [plz] => 5026 [ort] => Salzburg [strasse] => Glaserstraße [h_nummer] => 9 [tel_ort] => (0) 662 [tel_nr] => 6229730 [fax] => 622973-24 [mobil_vor] => [mobil_nr] => [web] => www.doktorwirt.at [mail] => schnoell@doktorwirt.at [kategorie] => Hotel [sterne] => 4 [sommer] => 1 [winter] => 1 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/584904_haus_1.jpg [haus_2] => [haus_3] => [haus_4] => [logo] => [text_d] => In ländlicher-natürlicher Umgebung und doch nur wenige Autominuten (auch O-Bus Nr. 7) zur herrlichen Innenstadt. Wohnen Sie in einem jahrhundertealten, gepflegten Gasthof mit gemütlicher Atmosphäre.  [text_e] => In unspoiled countryside but only a few minutes by car (o-bus Nr. 7) to the lovely inner city. Stay in a guesthouse that is hundreds of years old and has a cosy atmosphere. [picto_p] => Y [picto_c] => N [picto_s] => Y [picto_i] => N [picto_n] => N [picto_f] => N [picto_d] => N [picto_h] => Y [picto_t] => Y [picto_g] => N [picto_u] => N [picto_l] => N [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] => Y [such_wein] => Y [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => N [such_burgen] => Y [such_single] => Y [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => Y [such_50plus] => N [such_beauty] => N [such_gesundheit] => N [such_alpin] => N [such_individualisten] => N [such_kunst] => 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] => N [web_picto_k] => N [web_picto_j] => N [web_picto_a] => N [web_picto_c] => N [web_picto_d] => N [web_picto_n] => Y [web_picto_f] => N [web_picto_g] => N [web_picto_p] => Y [web_picto_s] => Y [web_picto_i] => N [web_picto_h] => Y [web_picto_t] => Y [web_picto_f_neu] => N [web_picto_u] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 47.7788 [l_long] => 13.0838 [video_id] => 108 [amex] => Y [salesianer] => N [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => [award] => N [niceurl] => gasthof-hotel-doktorwirt-in-salzburg [umwelt] => N [gratis] => N [visa] => N [mastercard] => N [gebucht_2014] => on [bild_1] => ../hbilder/584904_haus_1.jpg [cnt] => 9 ) [9] => Array ( [id] => 583236 [hotel_id] => [tmp] => [sortierung] => [vn] => 583236 [hotel_name] => Parkhotel Pörtschach [mi_status] => Freigegeben zum Druck 2013 [inhaber] => Roland Heitzeneder [last_import] => 2013-05-22 14:01:50 [bundesland] => Kärnten [plz] => 9210 [ort] => Pörtschach am Wörthersee [strasse] => Hans-Pruscha-Weg [h_nummer] => 5 [tel_ort] => (0)4272 [tel_nr] => 2621 [fax] => 2621-731 [mobil_vor] => [mobil_nr] => [web] => www.parkhotel-poertschach.at [mail] => office@parkhotel-poertschach.at [kategorie] => Hotel [sterne] => 4 [sommer] => 3 [winter] => 2 [gasthoefe_sommer] => [gasthoefe_winter] => [winter_appart] => [sommer_appart] => [booking_com_id] => [haus_1] => ../hbilder/583236_haus_1.jpg [haus_2] => ../hbilder/583236_haus_2.jpg [haus_3] => ../hbilder/583236_haus_3.jpg [haus_4] => [logo] => ../hbilder/583236_logo.jpg [text_d] => Parkhotel Pörtschach, das Designer-Hotel der 60er Jahre, dem es gelingt, Tradition und Trends in Einklang zu bringen! 110 Zimmer erstrahlen im neuen Design. Wir haben durchgehend von April bis Jänner geöffnet!  [text_e] => Parkhotel Pörtschach, a 60’s designer hotel, succeeds in combining tradition and new trends. 110 fashionable rooms await you. We are open continuously from April to January and look forward to welcoming you. [picto_p] => Y [picto_c] => N [picto_s] => Y [picto_i] => N [picto_n] => N [picto_f] => Y [picto_d] => N [picto_h] => Y [picto_t] => Y [picto_g] => N [picto_u] => N [picto_l] => N [such_reiten] => N [such_golf] => Y [such_tennis] => Y [such_mountain_bike] => Y [such_fischen] => Y [such_kinderhotels] => Y [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] => Y [such_kulinarik] => Y [such_wellness] => Y [such_wein] => Y [such_erlebnisurlaub] => N [such_trekking] => N [such_museen] => N [such_wassersport] => Y [such_burgen] => N [such_single] => Y [such_sehenswuerdigkeiten] => Y [such_bio] => N [such_romantik] => N [such_50plus] => Y [such_beauty] => Y [such_gesundheit] => Y [such_alpin] => N [such_individualisten] => Y [such_kunst] => Y [vorteilszone] => [hotelvideo] => Hotelvideo JA [web_picto_e] => Y [web_picto_m] => N [web_picto_q] => Y [web_picto_b] => Y [web_picto_r] => Y [web_picto_l] => Y [web_picto_o] => Y [web_picto_k] => Y [web_picto_j] => Y [web_picto_a] => Y [web_picto_c] => Y [web_picto_d] => N [web_picto_n] => Y [web_picto_f] => Y [web_picto_g] => Y [web_picto_p] => Y [web_picto_s] => Y [web_picto_i] => Y [web_picto_h] => Y [web_picto_t] => Y [web_picto_f_neu] => Y [web_picto_u] => N [web_picto_shuttlebus] => N [web_picto_liegewiese] => N [l_lat] => 46.6317 [l_long] => 14.1456 [video_id] => 124 [amex] => Y [salesianer] => Y [bestellung] => on [bemerkungen] => [loadbilder] => N [gebucht_2012] => on [gebucht_2013] => on [garni] => [award] => N [niceurl] => parkhotel-poertschach-in-poertschach-am-woerthersee [umwelt] => N [gratis] => N [visa] => N [mastercard] => N [gebucht_2014] => [bild_1] => ../hbilder/583236_haus_1.jpg [cnt] => 10 ) )