Single room

string(1149) "Database Error; SQL: SELECT
                
                DISTINCT
                `t`.*
                FROM `wp_posts` AS `t`
                
					LEFT JOIN `wp_postmeta` AS `jahreszeit` ON
						`jahreszeit`.`meta_key` = 'jahreszeit'
						AND `jahreszeit`.`post_id` = `t`.`ID`
				
                
						LEFT JOIN `wp_icl_translations` AS `wpml_translations`
							ON `wpml_translations`.`element_id` = `t`.`ID`
								AND `wpml_translations`.`element_type` = 'post_saison'
								AND `wpml_translations`.`language_code` = 'en'
					
                
				LEFT JOIN `wp_icl_languages` AS `wpml_languages`
					ON `wpml_languages`.`code` = `wpml_translations`.`language_code` AND `wpml_languages`.`active` = 1
			
                WHERE ( ( `zimmer`.`ID` = 1179 AND `jahreszeit`.`meta_value` = 'Sommer' ) AND ( `t`.`post_type` = 'saison' ) AND ( `wpml_languages`.`code` IS NOT NULL ) AND ( `t`.`post_status` IN ( 'publish' ) ) )
                
                
                ORDER BY saisonstart ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`
                LIMIT 0, 15; Response: Unknown column 'zimmer.ID' in 'where clause'"
string(1149) "Database Error; SQL: SELECT
                
                DISTINCT
                `t`.*
                FROM `wp_posts` AS `t`
                
					LEFT JOIN `wp_postmeta` AS `jahreszeit` ON
						`jahreszeit`.`meta_key` = 'jahreszeit'
						AND `jahreszeit`.`post_id` = `t`.`ID`
				
                
						LEFT JOIN `wp_icl_translations` AS `wpml_translations`
							ON `wpml_translations`.`element_id` = `t`.`ID`
								AND `wpml_translations`.`element_type` = 'post_saison'
								AND `wpml_translations`.`language_code` = 'en'
					
                
				LEFT JOIN `wp_icl_languages` AS `wpml_languages`
					ON `wpml_languages`.`code` = `wpml_translations`.`language_code` AND `wpml_languages`.`active` = 1
			
                WHERE ( ( `zimmer`.`ID` = 1179 AND `jahreszeit`.`meta_value` = 'Winter' ) AND ( `t`.`post_type` = 'saison' ) AND ( `wpml_languages`.`code` IS NOT NULL ) AND ( `t`.`post_status` IN ( 'publish' ) ) )
                
                
                ORDER BY saisonstart ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`
                LIMIT 0, 15; Response: Unknown column 'zimmer.ID' in 'where clause'"

Single room

For a warm ambiance, our modern single rooms are equipped with elegant wooden floors and high-quality furnishings.

Prices Summer

Period Season Price

Prices Winter

Period Season Price