' Special Offers - Hidden Barrel
YOUR CART
   CHECK OUT
  Hidden Barrel Wines
Member Login
Username:
Password:
  Always Remember Me
      On This Computer
 

Forgot your username or password?
Click Here.

 

 
|
|
|
|
|
Home  | 
 

Featured Offers

Due to current state regulations, we are unable to ship some of our products to Kansas.
We CANNOT ship wines from the following brands; Anthropology, Block 50, Inkberry or The Counselor.
We apologize for any inconvenience.

Stonier Wines

New Releases: Stonier Wines

Explore the amazing cool-climate Chardonnays and Pinot Noirs from this renowned producer from the Mornington Peninsula, Australia. And now enjoy shipping included with any 6 or more bottles purchased!

...Loading

Mornington Peninsula, Australia

Stonier Chardonnay plantings first took root in 1978. The cool maritime climate of the Mornington Peninsula produces exotically flavoured Chardonnay with an overriding citrus fruit spectrum and a mineral acid backbone.
09557.15
 
$25.00  / Bottle
$300.00  / Case

Mornington Peninsula, Australia

As vineyards mature across the Mornington Peninsula, the deep connection the region has with Pinot Noir has become more pronounced. The cool maritime climate of the region provides a point of consistency to an otherwise temperamental variety.
09558.15
 
$30.00  / Bottle
$360.00  / Case

Mornington Peninsula, Australia

Stonier Chardonnay plantings first took root in 1978. The cool maritime climate of the Mornington Peninsula produces exotically flavoured Chardonnay with an overriding citrus fruit spectrum and a mineral acid backbone.
06814.15
 
$35.00  / Bottle
$420.00  / Case

Mornington Peninsula, Australia

As vineyards mature across the Mornington Peninsula, the deep connection the region has with Pinot Noir has become more pronounced. The cool maritime climate of the region provides a point of consistency to an otherwise temperamental variety.
06815.15
 
$50.00  / Bottle
$600.00  / Case

 
 
 



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

 
  Ship to:

OR

  Pick up at the winery
Enter your Email Address and your Username and Password will be sent to you.
Email:  
Contact Us   Join Email List   Privacy Policy   Shipping & Payment Terms  
© 2016 Hidden Barrel
 
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 1.43 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT
P.ProductID,P.WineryID,P.ProductTypeID,P.ProductKeyID,P.PhotoPath,P.Picture,P.ProductName,P.ProductSKU,P.Price1,P.PriceUnit1,P.SalePrice1,
P.Price2,P.PriceUnit2,P.SalePrice2,P.WinePricePerBottle,P.WinePricePerCase,P.WineSalePricePerBottle,P.WineSalePricePerCase,P.isActive,
P.isActiveBySupplier,P.isWineStartPage,P.Teaser,P.MemberTeaser,P.NonMemberTeaser,P.MetaTagTitle,P.MetaTagKeywords,P.MetaTagDescription,
P.Description,P.DateAdded,P.DateModified,P.ModifiedBy,P.isTaxable,P.isShownOnAddOrder,P.MarketingURL,P.OverrideCompliance,P.isFavorite,
P.BrandID,P.isForExport,P.facebookTeaser,P.isWebserviceEnabled,P.cogs1,P.cogs2,P.CostPerBottle,P.CostPerCase,P.MarketplaceSKU,P.MarketingFee,P.ShortName,P.PlainName
,p.kitBottleSizeID
,'' as customwineattributes
,'' as promotionalprices
FROM Products P, ProductsXStates PXS
WHERE
P.ProductKeyID=PXS.ProductID
AND PXS.StateCode='KS'
AND PXS.isApproved=1
AND P.WineryID='8214C74B-045C-F599-7754-5D8670104E8E'
AND P.isActive=1
AND P.isActiveBySupplier=1
AND P.ProductID='2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB'
  ProductID WineryID ProductTypeID ProductKeyID PhotoPath Picture ProductName ProductSKU Price1 PriceUnit1 SalePrice1 Price2 PriceUnit2 SalePrice2 WinePricePerBottle WinePricePerCase WineSalePricePerBottle WineSalePricePerCase isActive isActiveBySupplier isWineStartPage Teaser MemberTeaser NonMemberTeaser MetaTagTitle MetaTagKeywords MetaTagDescription Description DateAdded DateModified ModifiedBy isTaxable isShownOnAddOrder MarketingURL OverrideCompliance isFavorite BrandID isForExport facebookTeaser isWebserviceEnabled cogs1 cogs2 CostPerBottle CostPerCase MarketplaceSKU MarketingFee ShortName PlainName kitBottleSizeID customwineattributes promotionalprices
1 2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB 8214C74B-045C-F599-7754-5D8670104E8E 6C4560D0-08AD-4D07-AC80-ACF490C85C00 2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB //www.hiddenbarrel.com/assets/images/wines/ StonierReservePinotWeb.png 2015 Stonier Reserve Pinot Noir 06815.15 50 Bottle 0 600 Case 0 50 600 0 0 1 1 0 <div style="text-align: center;">Mornington Peninsula, Australia <br /> <br /> As vineyards mature across the Mornington Peninsula, the deep connection the region has with Pinot Noir has become more pronounced. The cool maritime climate of the region provides a point of consistency to an otherwise temperamental variety.</div> <br /> <br /> {ts '2016-07-19 10:58:39'} {ts '2016-07-19 10:59:54'} C44146A6-C502-6DCF-F5B4-24CF66FA616D 1 1 0 0 0 1 0 0 0 0 0 2015 Stonier Rs Pinot
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 1 ms
Record Count: 0
Cached: No
Lazy: No
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 = '2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB'
ORDER BY cwav.displayorder asc, cwav.attributevalue asc
  attribute attributevalueid
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 1.25 ms
Record Count: 0
Cached: No
Lazy: No
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'
,Cast(c.displayjoinlink as nvarchar(Max)) as 'displayjoinlink'
,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 = '8214C74B-045C-F599-7754-5D8670104E8E'
AND c.issingleuse=0
AND c.isused=0
AND c.isforordergroup=0
AND c.appliesto='products'
AND c.displayasprice = 1
AND c.expirydate > getdate()
AND (ce.productid is NULL OR ce.productid <> '2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB')
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='2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB'))
OR (c.coupontypeid = '1F8A985B-2421-458A-99FB-A10BEDC920A2' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = '2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB')
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 = '2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB'))
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 = '2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB'))
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 = '2DB3DC7F-A0C3-4412-9A98-E3290E4B87EB'))
)
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
)
  couponid CouponName CouponAccessTypeID CouponCode CouponTypeID StartDate ExpiryDate Discount FixedDollars isFixedDollars isDollarsOff AppliesTo onQuantitiesOver onQuantitiesLess isLowestCostShipping isDiscountOtherShipping onDollarVolumeOver onDollarVolumeLess displayasprice displayasnewprice displaypricealways displaypriceforeveryone displaytext displayjoinlink isapplicable