Duet Box - Le Reve Blanc de Blancs & Famous Gate Pinot Noir
  •  
    Overview
     
Duet Box - Le Reve Blanc de Blancs & Famous Gate Pinot Noir

Duet Box - Le Reve Blanc de Blancs & Famous Gate Pinot Noir


Representing the best of our sparkling wine and Pinot Noir production, this wooden gift box includes our 2007 Famous Gate Pinot Noir and our 2006 Le Reve Blanc de Blancs.

Remember, if this is a gift be sure to include a gift card at no additional charge.  There is a gift card option at checkout.
$175.00/2 Bottle Pack Wood
  Subtotal:  $0.00
 
 

 

 

 
 
  • scroll up
  • scroll down
 
 

 

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:
If your state is NOT listed above, simply choose one of the following options:

1) Select a state listed above and provide an alternate shipping address in that state during checkout.

2) Close this window, and continue browsing our wines.

Enter your Email Address and your Username and Password will be sent to you.
Email:  
Domaine Carneros | 1240 Duhig Road, Napa California 94559 | 800.716 BRUT(2788) | E-Mail: info@DomaineCarneros.com
2012 Copyright - Domaine Carneros
 
query
RESULTSET
query
  BRANDID COGS CUSTOMWINEATTRIBUTES DATEADDED DATEMODIFIED DESCRIPTION FACEBOOKTEASER ISACTIVE ISACTIVEBYSUPPLIER ISFAVORITE ISFOREXPORT ISSHOWNONADDORDER ISTAXABLE ISWEBSERVICEENABLED ISWINESTARTPAGE MARKETINGURL MEMBERTEASER METATAGDESCRIPTION METATAGKEYWORDS METATAGTITLE MODIFIEDBY NONMEMBERTEASER OVERRIDECOMPLIANCE PHOTOPATH PICTURE PRICE1 PRICE2 PRICEUNIT1 PRICEUNIT2 PRODUCTID PRODUCTKEYID PRODUCTNAME PRODUCTSKU PRODUCTTYPEID PROMOTIONALPRICES ROWID SALEPRICE1 SALEPRICE2 TEASER WINEPRICEPERBOTTLE WINEPRICEPERCASE WINERYID WINESALEPRICEPERBOTTLE WINESALEPRICEPERCASE
1 [empty string] [empty string]
query
RESULTSET
query
  ATTRIBUTE ATTRIBUTEVALUEID
CACHED false
EXECUTIONTIME 0
SQL SELECT cwa.attribute ,cwav.attributevalueid FROM customwineattributes cwa LEFT OUTER JOIN customwineattributevalues cwav ON cwa.attributeID = cwav.attributeID LEFT OUTER JOIN productsxcustomwineattributevalues pxc ON cwav.attributevalueid = pxc.attributevalueid WHERE pxc.productid = ? ORDER BY cwav.displayorder asc, cwav.attributevalue asc
SQLPARAMETERS
array
1 33aa3c01-99fe-13bd-a05f-0669be4a3b6c
2008-07-17 17:55:39.0 2012-01-30 11:52:22.0 Representing the best of our sparkling wine and Pinot Noir production, this wooden gift box includes our 2007 Famous Gate Pinot Noir and our 2006 Le Reve Blanc de Blancs. <br /><br /><em>Remember, if this is a gift be sure to include a gift card at no additional charge.&nbsp; There is a gift card option at checkout.</em> [empty string] 1 1 0 0 1 1 1 0 FamousGateLeReveGiftSet [empty string] [empty string] Domaine Carneros WIne Gifts Estate Two Bottle Box 7b4dcc1b-9739-fc16-2052-375c507fe504 [empty string] 0 http://www.domainecarneros.com/assets/images/wines/ Domaine-Carneros-0237-EditDuetLR&FG.jpg 175.0000 [empty string] Case [empty string] 33aa3c01-99fe-13bd-a05f-0669be4a3b6c 33aa3c01-99fe-13bd-a05f-0669be4a3b6c Duet Box - Le Reve Blanc de Blancs & Famous Gate Pinot Noir 2994 6c4560d0-08ad-4d07-ac80-acf490c85c00
query
RESULTSET
query
  APPLIESTO COUPONACCESSTYPEID COUPONCODE COUPONID COUPONNAME COUPONTYPEID DISCOUNT DISPLAYASNEWPRICE DISPLAYASPRICE DISPLAYPRICEALWAYS DISPLAYPRICEFOREVERYONE DISPLAYTEXT EXPIRYDATE FIXEDDOLLARS ISAPPLICABLE ISDISCOUNTOTHERSHIPPING ISDOLLARSOFF ISFIXEDDOLLARS ISLOWESTCOSTSHIPPING ONDOLLARVOLUMELESS ONDOLLARVOLUMEOVER ONQUANTITIESLESS ONQUANTITIESOVER STARTDATE
CACHED false
EXECUTIONTIME 0
SQL select * from promo_prices where couponid not in ('4cbe8bdb-c13f-8db1-f1b2-ca52e7db0100','70a9e1f6-ab96-ce73-489e-57854fc1278a','31c3bede-fa01-aa57-5f23-b40801fbef07','31c0bb72-eb8e-6294-2839-035c088cd51e','70aea718-09b8-029f-e12f-a489822bc288','4c70efd1-fe2b-9609-6293-b321e4a6f500','31c2a7e0-f44a-ecac-87bb-fa3deeb5e5bc','4cbfde2d-e200-f3e5-b619-e042df21f793')
1096 0.0000 [empty string] <br /><em /> 0.0000 175.0000 cdc20456-1b78-7bfe-4c23-519d54dda8e1 0.0000 0.0000
CACHED false
EXECUTIONTIME 0
SQL SELECT P.* ,'' as customwineattributes ,'' as promotionalprices FROM Products P, ProductsXStates PXS WHERE P.ProductKeyID=PXS.ProductID AND PXS.StateCode=? AND PXS.isApproved=1 AND P.WineryID=? AND P.isActive=1 AND P.isActiveBySupplier=1 AND P.ProductID=?
SQLPARAMETERS
array
1 CA
2 cdc20456-1b78-7bfe-4c23-519d54dda8e1
3 33aa3c01-99fe-13bd-a05f-0669be4a3b6c