Wine Sets & Gifts

<PRE>Vintage Brut Rosé Gift Box </PRE>
Vintage Brut Rosé Gift Box
7786
 
$44.00  / Gift Pack
non-compliant product
 
<PRE>Vintage Brut Sparkling Wine with Bouchon in Gift Box</PRE>
Vintage Brut Sparkling Wine with Bouchon in Gift Box
7780
 
$42.00  / Gift Pack
non-compliant product
 
<PRE>Sparkling & Pinot Celebrated Trio - 2006 Brut, Brut Rosé & Avant-Garde Pinot Noir</PRE>
Sparkling & Pinot Celebrated Trio - 2006 Brut, Brut Rosé & Avant-Garde Pinot Noir
5010
 
$99.00  / 3 Bottle Pack Wood
non-compliant product
 
 
<PRE>Celebrated Pinot Trio Wooden Box - Avant-Garde, Estate & The Famous Gate Pinot Noir</PRE>
Celebrated Pinot Trio Wooden Box - Avant-Garde, Estate & The Famous Gate Pinot Noir
2049
 
$135.00  / 3 Bottle Pack Wood
non-compliant product
 
<PRE>Celebrated Sparkling Trio- '06 Brut, Brut Rosé & 2004 Le Reve Blanc de Blancs</PRE>
Celebrated Sparkling Trio- '06 Brut, Brut Rosé & 2004 Le Reve Blanc de Blancs
2011
 
$160.00  / 3 Bottle Pack Wood
non-compliant product
 
<PRE>Duet Box - 2006 Famous Gate Pinot Noir & 2004 Le Reve Blanc de Blancs</PRE>
Duet Box - 2006 Famous Gate Pinot Noir & 2004 Le Reve Blanc de Blancs
2994
 
$163.00  / 2 Bottle Pack Wood
non-compliant product
 
 
 
 
 

 

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-17 17:55:39.0 2010-02-16 09:44:35.0 [empty string] 1 1 0 0 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/ Two Bottle Estate Box Medium.jpg 163.0000 [empty string] Case [empty string] 33aa3c01-99fe-13bd-a05f-0669be4a3b6c 33aa3c01-99fe-13bd-a05f-0669be4a3b6c Duet Box - 2006 Famous Gate Pinot Noir & 2004 Le Reve Blanc de Blancs 2994 6c4560d0-08ad-4d07-ac80-acf490c85c00 0.0000 [empty string] Representing the best of our sparkling wine and Pinot Noir production, this wooden gift box includes our 2006 Famous Gate Pinot Noir (Wine Enthusiast, 92 points) and our 2004 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> 0.0000 163.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='33aa3c01-99fe-13bd-a05f-0669be4a3b6c'