0

Er steken 0 items in uw winkelwagentje

Het winkelwagentje is leeg

Rode wijnen

Finca Sios 2014
Costers del Sió
Prijs per eenheid : € 32,27
stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 42 ) [mf_name] => Costers del Sió [slug] => finca-sios [mf_email] => info@puertadelsol.be [mf_desc] =>

Familiebedrijf in D.O. Costers del Segre in het hart van Cataluña. 71 ha van de totale finca van 700 ha zijn aangeplant met een hele reeks aan druivenvariëteiten …  Het mediterraan klimaat, de heterogeniteit van de ondergrond en de passie van de Riojaanse wijnmaakster zorgen voor een rijke keuze aan kwaliteitswijnen.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.costersio.com/ [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => d29d29def985b7f80b407d6ada6bf1d1 [_tbl:protected] => #__virtuemart_products [_tbl_lang:protected] => #__virtuemart_products_nl_nl [_tbl_key:protected] => virtuemart_product_id [_tbl_keys:protected] => Array ( [0] => virtuemart_product_id ) [_pkey:protected] => virtuemart_product_id [_pkeyForm:protected] => cid [_obkeys:protected] => Array ( [product_name] => 1 [slug] => 1 ) [_unique:protected] => 1 [_unique_name:protected] => Array ( [slug] => 1 ) [_orderingKey:protected] => ordering [_slugAutoName:protected] => product_name [_slugName:protected] => slug [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [serverType] => mysql [connection:protected] => mysqli Object ( [affected_rows] => 1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.36-82.1-log [server_version] => 50636 [stat] => Uptime: 608989 Threads: 1 Questions: 48244356 Slow queries: 473 Opens: 1227184 Flush tables: 1 Open tables: 2048 Queries per second avg: 79.220 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1176663 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 106 [cursor:protected] => [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [timings:protected] => Array ( ) [callStacks:protected] => Array ( ) [offset:protected] => 0 [options:protected] => Array ( [driver] => mysqli [host] => localhost [user] => puertade_site [password] => 0CuU@T%rjOoqZ6p [database] => puertade_site [prefix] => pue_ [select] => 1 [port] => 3306 [socket] => ) [sql:protected] => SELECT nl.category_name FROM pue_virtuemart_categories_nl_nl nl INNER JOIN pue_virtuemart_category_categories par on par.category_child_id = nl.virtuemart_category_id INNER JOIN pue_virtuemart_product_categories cat on cat.virtuemart_category_id = nl.virtuemart_category_id WHERE cat.virtuemart_product_id =215 AND par.category_parent_id=22 LIMIT 1 [tablePrefix:protected] => pue_ [utf:protected] => 1 [utf8mb4:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [transactionDepth:protected] => 0 [disconnectHandlers:protected] => Array ( ) ) [_rules:protected] => [_trackAssets:protected] => [_locked:protected] => [_loggable:protected] => 1 [_xParams] => product_params [_varsToPushParam] => Array ( [min_order_level] => Array ( [0] => [1] => float ) [max_order_level] => Array ( [0] => [1] => float ) [step_order_level] => Array ( [0] => [1] => float ) [product_box] => Array ( [0] => [1] => float ) ) [_translatable] => 1 [_translatableFields:protected] => Array ( [0] => product_name [1] => product_s_desc [2] => product_desc [3] => metadesc [4] => metakey [5] => customtitle [slug] => slug ) [_hashName:protected] => [_omittedHashFields:protected] => Array ( ) [_cryptedFields] => [_langTag:protected] => nl_nl [_ltmp] => [_loadedWithLangFallback] => 0 [_loaded] => 1 [_updateNulls:protected] => 1 [_toConvertDec:protected] => [_tablePreFix] => p. [_autoincrement] => 1 [_observers] => JObserverUpdater Object ( [aliases:protected] => Array ( ) [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [created_on] => 2010-08-05 15:01:47 [created_by] => 0 [modified_on] => 2019-03-21 15:16:57 [modified_by] => 68 [virtuemart_product_id] => 215 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => CSCS33 [product_gtin] => [product_mpn] => [product_name] => Finca Sios 2014 [product_s_desc] => GP 91/100 [product_desc] =>
Waardering Rode wijn geproduceerd in originele stenen tanks uit de 12de eeuw. Een romantisch idee, de herinvoering van een traditionele methode om een authentieke en originele wijn te bekomen.
Druiven 25% Syrah, 75% Garnacha, max 3500kg/ha!
Lagering 12 maanden nieuwe Franse Allier vaten van 500l
Kleur Helder, diepgekleurd robijnrood
Neus Een krachtig aroma, levendig en fris. Een complex aroma van rijp fruit (zwarte bes en pruimen) met florale toetsen (viooltjes en roos) en een kruidige hint van peper en drop, aangevuld met rozemarijn. Dit alles bovenop een minerale basis, wat deze wijn een unieke personaliteit geeft.
Mond Zeer goed gestructureerde, volle wijn. Plezant fris, gebalanceerd en fluwelig met een nadrukkelijke, aangename afdronk
Gastronomie Finca Siós schittert bij stevige vischotels ((calderetas de pescado), 'grote' vleesgerechten en verfijnde wildschotels, gerijpte kazen of bij de open haard ...
Schenktemperatuur 16 - 18 °C
Bewaarpotentieel 7 - 10 jaar
[product_weight] => 0.0000 [product_weight_uom] => LB [product_length] => 0.0000 [product_width] => 0.0000 [product_height] => 0.0000 [product_lwh_uom] => IN [product_url] => [product_in_stock] => -4 [product_ordered] => 0 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2010-08-04 22:00:00 [product_availability] => ico_medaille.gif [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 26 [product_unit] => L [product_packaging] => 0.7500 [product_params] => min_order_level=""|max_order_level=""|step_order_level=""|product_box=""| [intnotes] => [layout] => default [product_canon_category_id] => [min_order_level] => [max_order_level] => [step_order_level] => [product_box] => [allIds] => Array ( [0] => 215 ) [virtuemart_media_id] => Array ( [0] => 367 ) [shoppergroups] => [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 428 [virtuemart_product_id] => 215 [virtuemart_shoppergroup_id] => 0 [product_price] => 26.66942 [override] => 0 [product_override_price] => 0 [product_tax_id] => 3 [product_discount_id] => 0 [product_currency] => 47 [product_price_publish_up] => 0000-00-00 00:00:00 [product_price_publish_down] => 0000-00-00 00:00:00 [price_quantity_start] => 0 [price_quantity_end] => 0 [created_on] => 2010-08-05 15:01:47 [created_by] => 0 [modified_on] => 2019-03-21 15:16:57 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 26.66942 [basePrice] => 26.66942 [basePriceVariant] => 26.66942 [basePriceWithTax] => 32.27 [discountedPriceWithoutTax] => 26.66942 [priceBeforeTax] => 26.66942 [salesPrice] => 32.27 [taxAmount] => 5.60058 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 32.27 [unitPrice] => 43.02666 [discountAmount] => -0 [priceWithoutTax] => 26.66942 [variantModification] => 0 [DBTax] => Array ( ) [Tax] => Array ( [3] => Array ( [0] => Tax 21% (BEL / -) [1] => 21.0000 [2] => +% [3] => 0 [4] => 47 [5] => [6] => 1 [7] => 3 ) ) [VatTax] => Array ( ) [DATax] => Array ( ) [Marge] => Array ( ) [salesPriceTt] => 32.27 [discountedPriceWithoutTaxTt] => 26.66942 [priceWithoutTaxTt] => 26.66942 [discountAmountTt] => -0 [taxAmountTt] => 5.60058 ) ) [selectedPrice] => 0 [categoryItem] => Array ( [0] => Array ( [virtuemart_category_id] => 11 [virtuemart_vendor_id] => 1 [category_name] => Rode wijnen [slug] => rode-wijnen [category_description] =>

Spaanse rode wijnen hebben de laatste jaren menig wijnliefhebber verbaasd met hun uitstekende prijs/kwaliteitsverhouding. Ook vandaag zorgt de passie van de Spaanse wijnmaker voor een continue zoektocht naar kwaliteit en dit op een zo natuurlijk mogelijke manier. In de nabije toekomst zal dit resulteren in meer wijnen met bio-label!

[category_template] => [category_layout] => default [category_product_layout] => default [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => show_store_desc=""|showcategory_desc=""|showcategory=""|categories_per_row=""|showproducts=""|omitLoaded=""|showsearch=""|productsublayout=""|featured=""|featured_rows=""|omitLoaded_featured=""|discontinued=""|discontinued_rows=""|omitLoaded_discontinued=""|latest=""|latest_rows=""|omitLoaded_latest=""|topten=""|topten_rows=""|omitLoaded_topten=""|recent=""|recent_rows=""|omitLoaded_recent=""| [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2007-06-29 11:45:18 [created_by] => 0 [modified_on] => 2018-06-15 12:03:22 [modified_by] => 68 [show_store_desc] => [showcategory_desc] => [showcategory] => [categories_per_row] => [showproducts] => [omitLoaded] => [showsearch] => [productsublayout] => [featured] => [featured_rows] => [omitLoaded_featured] => [discontinued] => [discontinued_rows] => [omitLoaded_discontinued] => [latest] => [latest_rows] => [omitLoaded_latest] => [topten] => [topten_rows] => [omitLoaded_topten] => [recent] => [recent_rows] => [omitLoaded_recent] => [id] => 397 ) [1] => Array ( [virtuemart_category_id] => 30 [virtuemart_vendor_id] => 1 [category_name] => Costers del Segre [slug] => costers-del-segre [category_description] =>

Dankzij een ideale bodem en klimaat langs de oevers van de Segre, een intelligente mix tussen inheemse en Franse druiven, biedt dit gebied een scala aan wijnen met een zeer persoonlijk karakter. Belangrijkste druiven: Garnacha, Ull de Llebre (Tempranillo), Syrah, Macabeo, Chardonnay. Ook hier zorgt kalksteen voor elegantie.

[category_template] => 0 [category_layout] => 0 [category_product_layout] => 0 [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2007-07-02 11:09:58 [created_by] => 0 [modified_on] => 2015-09-02 13:43:07 [modified_by] => 68 [show_store_desc] => [showcategory_desc] => [showcategory] => [categories_per_row] => [showproducts] => [omitLoaded] => [showsearch] => [productsublayout] => [featured] => [featured_rows] => [omitLoaded_featured] => [discontinued] => [discontinued_rows] => [omitLoaded_discontinued] => [latest] => [latest_rows] => [omitLoaded_latest] => [topten] => [topten_rows] => [omitLoaded_topten] => [recent] => [recent_rows] => [omitLoaded_recent] => [id] => 395 ) [2] => Array ( [virtuemart_category_id] => 59 [virtuemart_vendor_id] => 1 [category_name] => 90+ wijnen [slug] => 90plus-wijnen [category_description] =>

Deze lijst bevat al onze wijnen die onder het bekende kwaliteitslabel 90PLUS WINES vallen. Dit wil zeggen wijnen die door wijngoeroes en -magazines zoals Robert Parker, Wine Spectator, José Peñin, ... zijn beoordeeld en 90/100 of meer hebben gescoord.

 

[category_template] => [category_layout] => default [category_product_layout] => default [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => show_store_desc=""|showcategory_desc=""|showcategory=""|categories_per_row=""|showproducts=""|omitLoaded=""|showsearch=""|productsublayout=""|featured=""|featured_rows=""|omitLoaded_featured=""|discontinued=""|discontinued_rows=""|omitLoaded_discontinued=""|latest=""|latest_rows=""|omitLoaded_latest=""|topten=""|topten_rows=""|omitLoaded_topten=""|recent=""|recent_rows=""|omitLoaded_recent=""| [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2011-08-11 13:53:02 [created_by] => 0 [modified_on] => 2018-06-15 12:04:09 [modified_by] => 68 [show_store_desc] => [showcategory_desc] => [showcategory] => [categories_per_row] => [showproducts] => [omitLoaded] => [showsearch] => [productsublayout] => [featured] => [featured_rows] => [omitLoaded_featured] => [discontinued] => [discontinued_rows] => [omitLoaded_discontinued] => [latest] => [latest_rows] => [omitLoaded_latest] => [topten] => [topten_rows] => [omitLoaded_topten] => [recent] => [recent_rows] => [omitLoaded_recent] => [id] => 396 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 30 [2] => 59 ) [virtuemart_category_id] => 11 [ordering] => 0 [id] => 397 [category_name] => Rode wijnen [orderable] => 1 [modificatorSum] => 0 [product_tax_id] => 3 [amount] => 1 [quantity] => 1 [prices] => Array ( [virtuemart_product_price_id] => 428 [virtuemart_product_id] => 215 [virtuemart_shoppergroup_id] => 0 [product_price] => 26.66942 [override] => 0 [product_override_price] => 0 [product_tax_id] => 3 [product_discount_id] => 0 [product_currency] => 47 [product_price_publish_up] => 0000-00-00 00:00:00 [product_price_publish_down] => 0000-00-00 00:00:00 [price_quantity_start] => 0 [price_quantity_end] => 0 [created_on] => 2010-08-05 15:01:47 [created_by] => 0 [modified_on] => 2019-03-21 15:16:57 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 26.66942 [basePrice] => 26.66942 [basePriceVariant] => 26.66942 [basePriceWithTax] => 32.27 [discountedPriceWithoutTax] => 26.66942 [priceBeforeTax] => 26.66942 [salesPrice] => 32.27 [taxAmount] => 5.60058 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 32.27 [unitPrice] => 43.02666 [discountAmount] => -0 [priceWithoutTax] => 26.66942 [variantModification] => 0 [DBTax] => Array ( ) [Tax] => Array ( [3] => Array ( [0] => Tax 21% (BEL / -) [1] => 21.0000 [2] => +% [3] => 0 [4] => 47 [5] => [6] => 1 [7] => 3 ) ) [VatTax] => Array ( ) [DATax] => Array ( ) [Marge] => Array ( ) [salesPriceTt] => 32.27 [discountedPriceWithoutTaxTt] => 26.66942 [priceWithoutTaxTt] => 26.66942 [discountAmountTt] => -0 [taxAmountTt] => 5.60058 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=215&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=215&virtuemart_category_id=11 [addToCartButton] => [availability] => ico_medaille.gif [customfieldsSorted] => Array ( [normal] => Array ( [0] => stdClass Object ( [virtuemart_custom_id] => 5 [custom_parent_id] => 0 [virtuemart_vendor_id] => 1 [custom_jplugin_id] => 0 [custom_element] => [admin_only] => 0 [custom_title] => Middle ribbon [show_title] => 0 [custom_tip] => [custom_value] => 90plus;goud;topwijn [custom_desc] => options for the middle ribbon [field_type] => S [is_list] => 1 [is_hidden] => 1 [is_cart_attribute] => 0 [is_input] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 0 [virtuemart_customfield_id] => 33 [virtuemart_product_id] => 215 [customfield_value] => topwijn [customfield_price] => 0.000000 [customfield_params] => [fpublished] => 0 [override] => 0 [disabler] => 0 [_varsToPushParam] => Array ( [addEmpty] => Array ( [0] => 0 [1] => int ) [selectType] => Array ( [0] => 0 [1] => int ) [multiplyPrice] => Array ( [0] => [1] => string ) [transform] => Array ( [0] => [1] => area ) ) [addEmpty] => 0 [selectType] => 0 [multiplyPrice] => [transform] => [_xParams] => customfield_params [display] => topwijn ) [1] => stdClass Object ( [virtuemart_custom_id] => 7 [custom_parent_id] => 0 [virtuemart_vendor_id] => 1 [custom_jplugin_id] => 0 [custom_element] => [admin_only] => 0 [custom_title] => Regio [show_title] => 0 [custom_tip] => [custom_value] => Andalucía;Aragón;Principado de Asturias;Islas Baleares;Canarias;Cantabria;Castilla-La Mancha;Castilla y León;Cataluña;Comunidad Valenciana;Extremadura;Galicia;La Rioja;Comunidad de Madrid;Comunidad Foral de Navarra;País Vasco;Región de Murcia [custom_desc] => Autonome regio [field_type] => S [is_list] => 1 [is_hidden] => 0 [is_cart_attribute] => 0 [is_input] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 1 [virtuemart_customfield_id] => 49 [virtuemart_product_id] => 215 [customfield_value] => Cataluña [customfield_price] => 0.000000 [customfield_params] => [fpublished] => 0 [override] => 0 [disabler] => 0 [_varsToPushParam] => Array ( [addEmpty] => Array ( [0] => 0 [1] => int ) [selectType] => Array ( [0] => 0 [1] => int ) [multiplyPrice] => Array ( [0] => [1] => string ) [transform] => Array ( [0] => [1] => area ) ) [addEmpty] => 0 [selectType] => 0 [multiplyPrice] => [transform] => [_xParams] => customfield_params [display] => Cataluña ) ) ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-finca-sios8 [file_extension] => jpg [virtuemart_media_id] => 367 [_foldersToTest:VmMediaHandler:private] => Array ( [0] => /home/puertade/public_html/images/stories/virtuemart/product/ [1] => /home/puertade/public_html/images/stories/virtuemart/product/resized/ ) [_actions:VmMediaHandler:private] => Array ( ) [_mLocation:VmMediaHandler:private] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [theme_url] => components/com_virtuemart/ [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-finca-sios8.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-finca-sios8.jpg [file_url_thumb] => [published] => 1 [file_is_downloadable] => 0 [file_is_forSale] => 0 [file_is_product_image] => 0 [shared] => 0 [file_params] => [file_lang] => [created_on] => 2016-10-18 12:35:29 [created_by] => 68 [modified_on] => 2019-03-21 15:16:57 [modified_by] => 68 [file_url_folder] => images/stories/virtuemart/product/ [file_path_folder] => images/stories/virtuemart/product/ [file_url_folder_thumb] => images/stories/virtuemart/product/resized/ [media_role] => file_is_displayable ) ) [file_url_thumb] => [file_url] => images/stories/virtuemart/product/puerta-del-sol-finca-sios8.jpg [product_price] => 26.66942 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 93 [product_name] => Chafandín 2016 [product_price] => 26.066120 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 99 [product_name] => Valduero Reserva 2012 [product_price] => 28.884300 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 42 [mf_name] => Costers del Sió [slug] => bodegas-costers-del-sio [mf_email] => info@puertadelsol.be [mf_desc] =>

Familiebedrijf in D.O. Costers del Segre in het hart van Cataluña. 71 ha van de totale finca van 700 ha zijn aangeplant met een hele reeks aan druivenvariëteiten …  Het mediterraan klimaat, de heterogeniteit van de ondergrond en de passie van de Riojaanse wijnmaakster zorgen voor een rijke keuze aan kwaliteitswijnen.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.costersio.com/ [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 9e74a546fc7a76f5676221eb4b8495c8 [_tbl:protected] => #__virtuemart_manufacturers [_tbl_lang:protected] => #__virtuemart_manufacturers_nl_nl [_tbl_key:protected] => virtuemart_manufacturer_id [_tbl_keys:protected] => Array ( [0] => virtuemart_manufacturer_id ) [_pkey:protected] => virtuemart_manufacturer_id [_pkeyForm:protected] => cid [_obkeys:protected] => Array ( [mf_name] => 1 [slug] => 1 ) [_unique:protected] => 1 [_unique_name:protected] => Array ( [mf_name] => 1 [slug] => 1 ) [_orderingKey:protected] => ordering [_slugAutoName:protected] => mf_name [_slugName:protected] => slug [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [serverType] => mysql [connection:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.36-82.1-log [server_version] => 50636 [stat] => Uptime: 608989 Threads: 1 Questions: 48244357 Slow queries: 473 Opens: 1227184 Flush tables: 1 Open tables: 2048 Queries per second avg: 79.220 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 1176663 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 106 [cursor:protected] => [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [timings:protected] => Array ( ) [callStacks:protected] => Array ( ) [offset:protected] => 0 [options:protected] => Array ( [driver] => mysqli [host] => localhost [user] => puertade_site [password] => 0CuU@T%rjOoqZ6p [database] => puertade_site [prefix] => pue_ [select] => 1 [port] => 3306 [socket] => ) [sql:protected] => SELECT nl.category_name FROM pue_virtuemart_categories_nl_nl nl INNER JOIN pue_virtuemart_category_categories par on par.category_child_id = nl.virtuemart_category_id INNER JOIN pue_virtuemart_product_categories cat on cat.virtuemart_category_id = nl.virtuemart_category_id WHERE cat.virtuemart_product_id =215 AND par.category_parent_id=22 LIMIT 1 [tablePrefix:protected] => pue_ [utf:protected] => 1 [utf8mb4:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [transactionDepth:protected] => 0 [disconnectHandlers:protected] => Array ( ) ) [_rules:protected] => [_trackAssets:protected] => [_locked:protected] => [_loggable:protected] => 1 [_xParams] => 0 [_varsToPushParam] => Array ( ) [_translatable] => 1 [_translatableFields:protected] => Array ( [0] => mf_name [1] => mf_email [2] => mf_desc [3] => mf_url [4] => metadesc [5] => metakey [6] => customtitle [slug] => slug ) [_hashName:protected] => [_omittedHashFields:protected] => Array ( ) [_cryptedFields] => [_langTag:protected] => nl_nl [_ltmp] => [_loadedWithLangFallback] => 0 [_loaded] => [_updateNulls:protected] => [_toConvertDec:protected] => [_tablePreFix] => m. [_autoincrement] => 1 [_observers] => JObserverUpdater Object ( [aliases:protected] => Array ( ) [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [created_on] => 0000-00-00 00:00:00 [created_by] => 0 [modified_on] => 2015-10-16 09:38:40 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 47 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-costers-del-sio7 [file_extension] => jpg [virtuemart_media_id] => 47 [_foldersToTest:VmMediaHandler:private] => Array ( [0] => /home/puertade/public_html/images/stories/virtuemart/manufacturer/ [1] => /home/puertade/public_html/images/stories/virtuemart/manufacturer/resized/ ) [_actions:VmMediaHandler:private] => Array ( ) [_mLocation:VmMediaHandler:private] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [theme_url] => components/com_virtuemart/ [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-costers-del-sio7.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-costers-del-sio7.jpg [file_url_thumb] => [published] => 1 [file_is_downloadable] => 0 [file_is_forSale] => 0 [file_is_product_image] => 0 [shared] => 0 [file_params] => [file_lang] => [created_on] => 2015-09-04 12:22:34 [created_by] => 68 [modified_on] => 2015-10-16 09:38:40 [modified_by] => 68 [file_url_folder] => images/stories/virtuemart/manufacturer/ [file_path_folder] => images/stories/virtuemart/manufacturer/ [file_url_folder_thumb] => images/stories/virtuemart/manufacturer/resized/ [media_role] => file_is_displayable ) ) [file_url_thumb] => [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-costers-del-sio7.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )
 
RegioCataluña
D.O.Costers del Segre
Type Rode wijn
Inhoud 0.75 l
Waardering Rode wijn geproduceerd in originele stenen tanks uit de 12de eeuw. Een romantisch idee, de herinvoering van een traditionele methode om een authentieke en originele wijn te bekomen.
Druiven 25% Syrah, 75% Garnacha, max 3500kg/ha!
Lagering 12 maanden nieuwe Franse Allier vaten van 500l
Kleur Helder, diepgekleurd robijnrood
Neus Een krachtig aroma, levendig en fris. Een complex aroma van rijp fruit (zwarte bes en pruimen) met florale toetsen (viooltjes en roos) en een kruidige hint van peper en drop, aangevuld met rozemarijn. Dit alles bovenop een minerale basis, wat deze wijn een unieke personaliteit geeft.
Mond Zeer goed gestructureerde, volle wijn. Plezant fris, gebalanceerd en fluwelig met een nadrukkelijke, aangename afdronk
Gastronomie Finca Siós schittert bij stevige vischotels ((calderetas de pescado), 'grote' vleesgerechten en verfijnde wildschotels, gerijpte kazen of bij de open haard ...
Schenktemperatuur 16 - 18 °C
Bewaarpotentieel 7 - 10 jaar