Unsere Bärenhöhle (im Park)

object(TableK2Category)#841 (27) { ["id"]=> string(1) "1" ["name"]=> string(16) "Zimmerkategorien" ["alias"]=> string(16) "zimmerkategorien" ["description"]=> string(775) "

In unseren 34 Themenzimmern mit 5 Suiten erwarten Sie liebevolle Details aus der ganzen Welt. Genießen Sie unser besonderes Hotel direkt an der Mosel.

Schlafen Sie wie der römische Weingott „Bacchus“ in einem Doppelbett gearbeitet aus einem originalen Weinfass. Träumen Sie unter dem Sternenhimmel durch den bezaubernden Wintergarten in der Suite „Himmelreich“. Südliches Temperament entfacht das aus Spanien stammende Bett in unserer „Hacienda“. Oder lassen Sie sich bei Ihrer Reise um die Welt nach „Hongkong“ entführen, wo Ihre Kleider in einem original chinesischen Kleiderschrank den Urlaub an der Mosel verbringen.

Finden Sie genau das richtige Ambiente für Ihre persönliche Erholungszeit.

Unsere Zimmerkategorien

" ["parent"]=> string(1) "0" ["extraFieldsGroup"]=> string(1) "2" ["published"]=> string(1) "1" ["image"]=> string(0) "" ["access"]=> string(1) "1" ["ordering"]=> string(1) "1" ["params"]=> string(2866) "{"inheritFrom":"0","catMetaDesc":"","catMetaKey":"","catMetaRobots":"","catMetaAuthor":"","theme":"","num_leading_items":"20","num_leading_columns":"2","leadingImgSize":"Small","num_primary_items":"4","num_primary_columns":"2","primaryImgSize":"Small","num_secondary_items":"4","num_secondary_columns":"2","secondaryImgSize":"Small","num_links":"4","num_links_columns":"2","linksImgSize":"XSmall","catCatalogMode":"0","catFeaturedItems":"1","catOrdering":"date","catPagination":"0","catPaginationResults":"0","catTitle":"0","catTitleItemCounter":"0","catDescription":"1","catImage":"0","catFeedLink":"0","catFeedIcon":"0","subCategories":"1","subCatColumns":"2","subCatOrdering":"","subCatTitle":"1","subCatTitleItemCounter":"1","subCatDescription":"1","subCatImage":"1","itemImageXS":"","itemImageS":"","itemImageM":"","itemImageL":"","itemImageXL":"","catItemTitle":"1","catItemTitleLinked":"1","catItemFeaturedNotice":"0","catItemAuthor":"0","catItemDateCreated":"0","catItemRating":"0","catItemImage":"1","catItemIntroText":"1","catItemIntroTextWordLimit":"15","catItemExtraFields":"1","catItemHits":"0","catItemCategory":"0","catItemTags":"0","catItemAttachments":"0","catItemAttachmentsCounter":"0","catItemVideo":"0","catItemVideoWidth":"","catItemVideoHeight":"","catItemAudioWidth":"","catItemAudioHeight":"","catItemVideoAutoPlay":"0","catItemImageGallery":"0","catItemImageGalleryWidth":"","catItemImageGalleryHeight":"","catItemDateModified":"0","catItemReadMore":"0","catItemCommentsAnchor":"0","catItemK2Plugins":"1","itemDateCreated":"0","itemTitle":"1","itemFeaturedNotice":"0","itemAuthor":"0","itemFontResizer":"0","itemPrintButton":"0","itemEmailButton":"0","itemSocialButton":"0","itemVideoAnchor":"0","itemImageGalleryAnchor":"0","itemCommentsAnchor":"0","itemRating":"0","itemImage":"1","itemImgSize":"Large","itemImageMainCaption":"0","itemImageMainCredits":"0","itemIntroText":"1","itemFullText":"1","itemExtraFields":"1","itemDateModified":"0","itemHits":"0","itemCategory":"0","itemTags":"0","itemAttachments":"1","itemAttachmentsCounter":"0","itemVideo":"1","itemVideoWidth":"","itemVideoHeight":"","itemAudioWidth":"","itemAudioHeight":"","itemVideoAutoPlay":"0","itemVideoCaption":"1","itemVideoCredits":"1","itemImageGallery":"1","itemImageGalleryWidth":"","itemImageGalleryHeight":"","itemNavigation":"1","itemComments":"0","itemTwitterButton":"0","itemFacebookButton":"0","itemGooglePlusOneButton":"0","itemAuthorBlock":"0","itemAuthorImage":"0","itemAuthorDescription":"0","itemAuthorURL":"0","itemAuthorEmail":"0","itemAuthorLatest":"0","itemAuthorLatestLimit":"5","itemRelated":"1","itemRelatedLimit":"5","itemRelatedTitle":"1","itemRelatedCategory":"0","itemRelatedImageSize":"0","itemRelatedIntrotext":"0","itemRelatedFulltext":"0","itemRelatedAuthor":"0","itemRelatedMedia":"0","itemRelatedImageGallery":"0","itemK2Plugins":"1"}" ["trash"]=> string(1) "0" ["plugins"]=> string(0) "" ["language"]=> string(1) "*" ["_tbl":protected]=> string(16) "#__k2_categories" ["_tbl_key":protected]=> string(2) "id" ["_tbl_keys":protected]=> array(1) { [0]=> string(2) "id" } ["_db":protected]=> object(JFalangDatabase)#362 (30) { ["_mlTableList"]=> array(8) { [0]=> string(10) "categories" [1]=> string(15) "contact_details" [2]=> string(7) "content" [3]=> string(13) "k2_categories" [4]=> string(15) "k2_extra_fields" [5]=> string(8) "k2_items" [6]=> string(4) "menu" [7]=> string(7) "modules" } ["_refTables"]=> array(6) { ["fieldTablePairs"]=> array(1) { [0]=> string(8) "k2_items" } ["tableAliases"]=> array(1) { ["k2_items"]=> string(13) "wman_k2_items" } ["reverseTableAliases"]=> array(1) { ["wman_k2_items"]=> string(8) "k2_items" } ["fieldAliases"]=> array(1) { ["alias"]=> string(5) "alias" } ["fieldTableAliasData"]=> array(1) { [0]=> array(4) { ["fieldNameAlias"]=> string(5) "alias" ["fieldName"]=> string(5) "alias" ["tableNameAlias"]=> string(13) "wman_k2_items" ["tableName"]=> string(8) "k2_items" } } ["fieldCount"]=> int(1) } ["_skipSetRefTables"]=> bool(false) ["orig_limit"]=> int(0) ["orig_offset"]=> int(0) ["_table_prefix"]=> string(5) "wman_" ["profileData"]=> array(0) { } ["name"]=> string(6) "mysqli" ["serverType"]=> string(5) "mysql" ["connection":protected]=> object(mysqli)#364 (19) { ["affected_rows"]=> int(1) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(30) "5.5.5-10.1.37-MariaDB-0+deb9u1" ["server_version"]=> int(50505) ["stat"]=> string(152) "Uptime: 10403203 Threads: 15 Questions: 327373377 Slow queries: 0 Opens: 1747629 Flush tables: 1 Open tables: 2000 Queries per second avg: 31.468" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(7274300) ["warning_count"]=> int(0) } ["nameQuote":protected]=> string(1) "`" ["nullDate":protected]=> string(19) "0000-00-00 00:00:00" ["_database":"JDatabaseDriver":private]=> string(13) "4_3-8-wP7BUZA" ["count":protected]=> int(42) ["cursor":protected]=> NULL ["debug":protected]=> bool(false) ["limit":protected]=> int(0) ["log":protected]=> array(0) { } ["timings":protected]=> array(0) { } ["callStacks":protected]=> array(0) { } ["offset":protected]=> int(0) ["options":protected]=> array(9) { ["driver"]=> string(6) "mysqli" ["host"]=> string(9) "localhost" ["user"]=> string(11) "4_schnuffel" ["password"]=> string(12) "Usubatehe445" ["database"]=> string(13) "4_3-8-wP7BUZA" ["prefix"]=> string(5) "wman_" ["select"]=> bool(true) ["port"]=> int(3306) ["socket"]=> NULL } ["sql":protected]=> object(JDatabaseQueryMysqli)#937 (25) { ["offset":protected]=> int(0) ["limit":protected]=> int(0) ["db":protected]=> *RECURSION* ["sql":protected]=> NULL ["type":protected]=> string(6) "select" ["element":protected]=> NULL ["select":protected]=> object(JDatabaseQueryElement)#893 (3) { ["name":protected]=> string(6) "SELECT" ["elements":protected]=> array(1) { [0]=> string(5) "alias" } ["glue":protected]=> string(1) "," } ["delete":protected]=> NULL ["update":protected]=> NULL ["insert":protected]=> NULL ["from":protected]=> object(JDatabaseQueryElement)#941 (3) { ["name":protected]=> string(4) "FROM" ["elements":protected]=> array(1) { [0]=> string(11) "#__k2_items" } ["glue":protected]=> string(1) "," } ["join":protected]=> NULL ["set":protected]=> NULL ["where":protected]=> object(JDatabaseQueryElement)#943 (3) { ["name":protected]=> string(5) "WHERE" ["elements":protected]=> array(1) { [0]=> string(6) "id = 3" } ["glue":protected]=> string(5) " AND " } ["group":protected]=> NULL ["having":protected]=> NULL ["columns":protected]=> NULL ["values":protected]=> NULL ["order":protected]=> NULL ["autoIncrementField":protected]=> NULL ["call":protected]=> NULL ["exec":protected]=> NULL ["union":protected]=> NULL ["unionAll":protected]=> NULL ["selectRowNumber":protected]=> NULL } ["tablePrefix":protected]=> string(5) "wman_" ["utf":protected]=> bool(true) ["utf8mb4":protected]=> bool(true) ["errorNum":protected]=> int(0) ["errorMsg":protected]=> string(0) "" ["transactionDepth":protected]=> int(0) ["disconnectHandlers":protected]=> array(0) { } } ["_trackAssets":protected]=> bool(false) ["_rules":protected]=> NULL ["_locked":protected]=> bool(false) ["_autoincrement":protected]=> bool(true) ["_observers":protected]=> object(JObserverUpdater)#842 (2) { ["observers":protected]=> array(0) { } ["doCallObservers":protected]=> bool(true) } ["_columnAlias":protected]=> array(0) { } ["_jsonEncode":protected]=> array(0) { } ["_errors":protected]=> array(0) { } ["link"]=> string(45) "/de/hotel-mosel/hotelzimmer-suiten-mosel.html" }