Famous Gate Stone Coaster
  •  
    Overview
     
 

Famous Gate Stone Coaster

The rustic beauty of marble becomes the backdrop for our Famous Gate wine label. The rough and porous nature of the tumbled marble gives the label an aged and weathered appearance. An antiqued wash heightens the effect.

Coasters sold individually
Measures 4"x4"

$9.95
 
 
  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:  
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
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 335b00dd-9b61-1403-211b-2a978578e1bb
2008-07-17 16:29:06.0 2008-11-03 16:55:07.0 [empty string] [empty string] 1 1 0 0 1 1 1 0 FamousGateStoneCoaster [empty string] [empty string] [empty string] Famous Gate Stone Coaster 7b4dcc1b-9739-fc16-2052-375c507fe504 [empty string] 0 http://www.domainecarneros.com/assets/images/products/ Famous Gate Stone Coaster.jpg 9.9500 0.0000 [empty string] [empty string] 335b00dd-9b61-1403-211b-2a978578e1bb 335b00dd-9b61-1403-211b-2a978578e1bb Famous Gate Stone Coaster [empty string] d1103805-a836-4621-99bb-e04162c228dd
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 DISTINCT c.couponid ,c.CouponName ,c.CouponAccessTypeID ,c.CouponCode ,c.CouponTypeID ,c.StartDate ,c.ExpiryDate ,c.Discount ,c.FixedDollars ,c.isFixedDollars ,c.isDollarsOff ,c.AppliesTo ,c.onQuantitiesOver ,c.onQuantitiesLess ,c.isLowestCostShipping ,c.isDiscountOtherShipping ,c.onDollarVolumeOver ,c.onDollarVolumeLess ,c.displayasprice ,c.displayasnewprice ,c.displaypricealways ,c.displaypriceforeveryone ,Cast(c.displaytext as nvarchar(Max)) as 'displaytext' ,0 as 'isapplicable' FROM coupons c LEFT OUTER JOIN couponsxcoupontypes cxct on cxct.couponid = c.couponid LEFT OUTER JOIN couponexcludes ce on ce.couponid = c.couponid WHERE c.wineryid = ? AND c.issingleuse=0 AND c.isused=0 AND c.isforordergroup=0 AND c.appliesto='products' AND c.displayasprice = 1 AND (ce.productid is NULL OR ce.productid <> ?) AND ( c.coupontypeid = '17271DA7-969F-496A-86EF-896B09E32991' OR (c.coupontypeid = 'e67b8c62-2e3d-417d-990e-f28af95a6fcd' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid IN (select productcategoryid from productsxproductcategories where productid=?)) OR (c.coupontypeid = '1f8a985b-2421-458a-99fb-a10bedc920a2' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = ?) OR (c.coupontypeid = '802f4cea-8b85-46e6-9704-c5d792470f0d' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = (select producttypeid from products p where p.productid = ?)) OR (c.coupontypeid = '75352a6e-a93c-4f79-8aca-0f185ee3f6f0' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = (select winebrandid from wines w left outer join products p on w.wineid = p.productkeyid where p.productid = ?)) OR (c.coupontypeid = '75352a6e-a93c-4f79-8aca-0f185ee3f6f0' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = (select thirdpartywinebrandid from thirdpartywines tpw left outer join products p on tpw.thirdpartywineid = p.productkeyid where p.productid = ?)) ) AND (c.onquantitiesover = 0 OR c.displaypricealways = 1 ) AND (c.onquantitiesless is null OR c.displaypricealways = 1 ) AND (c.ondollarvolumeover = 0 OR c.displaypricealways = 1 ) AND (c.ondollarvolumeless is null OR c.displaypricealways = 1 ) AND (c.displaypriceforeveryone = 1 )
SQLPARAMETERS
array
1 cdc20456-1b78-7bfe-4c23-519d54dda8e1
2 335b00dd-9b61-1403-211b-2a978578e1bb
3 335b00dd-9b61-1403-211b-2a978578e1bb
4 335b00dd-9b61-1403-211b-2a978578e1bb
5 335b00dd-9b61-1403-211b-2a978578e1bb
6 335b00dd-9b61-1403-211b-2a978578e1bb
7 335b00dd-9b61-1403-211b-2a978578e1bb
7165 0.0000 0.0000 The rustic beauty of marble becomes the backdrop for our Famous Gate wine label. The rough and porous nature of the tumbled marble gives the label an aged and weathered appearance. An antiqued wash heightens the effect.<br /><br />Coasters sold individually<br />Measures 4&quot;x4&quot; [empty string] [empty string] cdc20456-1b78-7bfe-4c23-519d54dda8e1 [empty string] [empty string]
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 335b00dd-9b61-1403-211b-2a978578e1bb