Large Format - Pinot Noir

2006 Domaine Carneros Estate Pinot Noir Magnum

5199

$75.00 / Bottle

By entering Domaine Carneros' Wine Store, you affirm that you are of
legal drinking age in the country where this site is accessed.

Ship to:

close window

Enter your Email Address and your Username and Password will be sent to you.

query

RESULTSET

query
	BRANDID	DATEADDED	DATEMODIFIED	DESCRIPTION	ISACTIVE	ISACTIVEBYSUPPLIER	ISFAVORITE	ISFOREXPORT	ISSHOWNONADDORDER	ISTAXABLE	ISWINESTARTPAGE	MARKETINGURL	MEMBERTEASER	METATAGDESCRIPTION	METATAGKEYWORDS	METATAGTITLE	MODIFIEDBY	NONMEMBERTEASER	OVERRIDECOMPLIANCE	PHOTOPATH	PICTURE	PRICE1	PRICE2	PRICEUNIT1	PRICEUNIT2	PRODUCTID	PRODUCTKEYID	PRODUCTNAME	PRODUCTSKU	PRODUCTTYPEID	SALEPRICE1	SALEPRICE2	TEASER	WINEPRICEPERBOTTLE	WINEPRICEPERCASE	WINERYID	WINESALEPRICEPERBOTTLE	WINESALEPRICEPERCASE
1	[empty string]	2009-01-16 16:37:25.0	2010-07-01 09:22:59.0	A wine of intriguing depth, this vintage unfolds gradually in the glass, revealing aromas of raspberry, bing cherry, Chinese five-spice, a wisp of smoke, and hints of violets and lavender. The vintage is exceptionally full and round on the palate with the classic long, velvety finish that has become the hallmark of the Domaine Carneros Pinot Noir. This wine is a pleasure now, and it has the structure and character to be one of our longest-lived bottlings yet. <br /><br />	1	1	0	0	1	1	0	2006EstatePinotMagnum	[empty string]	[empty string]	[empty string]	2006EstatePinotMagnum	7b4dcc1b-9739-fc16-2052-375c507fe504	[empty string]	0	http://www.domainecarneros.com/assets/images/wines/	2006%20Pinot%20Carneros1%2Ejpg	75.0000	[empty string]	Bottle	[empty string]	e2054edf-1cc4-fbb6-23da-8e51fae55d20	e2054edf-1cc4-fbb6-23da-8e51fae55d20	2006 Domaine Carneros Estate Pinot Noir Magnum	5199	6c4560d0-08ad-4d07-ac80-acf490c85c00	0.0000	[empty string]	[empty string]	75.0000	0.0000	cdc20456-1b78-7bfe-4c23-519d54dda8e1	0.0000	0.0000

CACHED

false

EXECUTIONTIME

SQL

SELECT P.* FROM Products P, ProductsXStates PXS WHERE P.ProductKeyID=PXS.ProductID AND PXS.StateCode='CA' AND PXS.isApproved=1 AND P.WineryID='cdc20456-1b78-7bfe-4c23-519d54dda8e1' AND P.isActive=1 AND P.isActiveBySupplier=1 AND P.ProductID='e2054edf-1cc4-fbb6-23da-8e51fae55d20'