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:
Enter your Email Address and your Username and Password will be sent to you.
Email:  
Customer Login   Employment   Email Signup   Directions   Contact Us   Media & Trade   Customer Service & Shipping  
Domaine Carneros | 1240 Duhig Road, Napa California 94559 | 800.716 BRUT(2788) | E-Mail: info@DomaineCarneros.com
2010 Copyright - Domaine Carneros
 
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] 2008-07-03 10:48:31.0 2010-06-22 10:04:24.0 <p>Our popular Brut cuv&eacute;e in a larger 1.5 liter format. Ideal for small dinner parties and events.&nbsp; Bottle Size: 1.5L - Will pour approximately ten 5oz glasses. <br /><br />The newly released 2006 cuv&eacute;e is composed of 58% pinot noir, 41% chardonnary and 1% pinot blanc. </p> <p>&nbsp;</p> 1 1 0 0 1 1 0 MagnumSparklingWine [empty string] [empty string] Magnum Sparkling Wine 2006 Vintage Brut Magnum Sparkling Wine 7b4dcc1b-9739-fc16-2052-375c507fe504 [empty string] 0 http://www.domainecarneros.com/assets/images/wines/ brut_shot3.png 70.0000 [empty string] Bottle [empty string] ea0a2903-d0fa-b2b0-522c-e2257c9809d7 ea0a2903-d0fa-b2b0-522c-e2257c9809d7 2006 Vintage Brut Magnum Sparkling Wine 5467 6c4560d0-08ad-4d07-ac80-acf490c85c00 0.0000 [empty string] [empty string] 70.0000 0.0000 cdc20456-1b78-7bfe-4c23-519d54dda8e1 0.0000 0.0000
CACHED false
EXECUTIONTIME 0
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='ea0a2903-d0fa-b2b0-522c-e2257c9809d7'