' MacRostie - 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  | 
 

MacRostie

CAN'T ADD AN ITEM TO YOUR CART?

Regretfully, due to State regulations, we CANNOT ship The Counselor, Block 50 or Inkberry to your selected State.

MacRostie Winery

MacRostie: Sonoma Coast, California

Since 1987, MacRostie Winery & Vineyards has earned acclaim as one of the Sonoma Coast’s defining wineries. Guided by winemaking legend Steve MacRostie and talented winemaker Heidi Bridenhagen, MacRostie makes acclaimed Sonoma Coast Chardonnays and Pinot Noirs using grapes from a who’s who of the regions greatest vineyards. Hailed for their cool-climate structure and vibrant fruit, these wines have become benchmarks for great Sonoma Coast winemaking.

...Loading

Sonoma Coast, California

“Earthy in anise and blue fruit, this wine is inexplicably crisp and plush at the same time, showing the allure of the variety in its rose petal aromas...”
91 points, Wine Enthusiast
09313.14
 
$56.00  / Bottle
$672.00  / Case
 
Sonoma Coast, California

“this white sings in complexity and tension, providing tart jolts of lemon verbena, ginger and nutmeg. Complex and elegant, especially in its floral perfume, it drinks voluptuously, full of come-hither ripeness.”
90 points, Wine Enthusiast
09312.14
 
$46.00  / Bottle
$552.00  / Case
 
Sonoma Coast, California

"The winery's larger production offering, this is made from a handful of vineyards, including many used in vineyard-designates. Blending prowess shows in this wine that explodes in plum and clove. Tight, bright acid buoys flavors of strawberry, cranberry and orange, with a twisted funk of earth on the finish."
91 Points, Wine Enthusiast
09311.13
 
$34.00  / Bottle
$408.00  / Case
 
Sonoma Coast, California

"Features a delicious core of vibrant grapefruit and lemon-laced tangerine and white peach notes, with zesty acidity that keeps the flavors fresh and jumping. Drink now."
90 points, Wine Spectator
09320.14
 
$25.00  / Bottle
$300.00  / Case

Russian River Valley, California

From top Pinot Noir properties in the Russian River Valley, including our own Thale’s Vineyard, the pure fruit and clarity of our vineyards shines through in this wine. A delicate style of Pinot Noir with earthy forest floor notes complimented with dried cherry aromas.

09419.15
 
$44.00  / Bottle
$528.00  / Case

Russian River, California

Sourced from the famed Ritchie Vineyard and Mirabelle, in a cooler portion of the Russian River Valley, this 2014 release is a pure, elegant and focused wine with lovely aromas and and flavors of tropical orange blossom, fresh-baked wheat bread and wet stone minerality.

09420.14
 
$34.00  / Bottle
$408.00  / Case

Russian River Valley

This wine is the palest green yellow color with crystal clarity. The nose is full of tropical fruit aromas such as melon and kiwi. The palate is crisp and clean with lime citrus backbone. The small use of oak gives the wine a richness and finish that make the wine balanced and inviting.

Available Inventory: 21

9596.15
 
$30.00  / Bottle
$360.00  / Case
Sonoma Coast, California

"The winery's larger production offering, this is made from a handful of vineyards, including many used in vineyard-designates. Blending prowess shows in this wine that explodes in plum and clove. Tight, bright acid buoys flavors of strawberry, cranberry and orange, with a twisted funk of earth on the finish.”
91 Points, Wine Enthusiast
09282.13
 
$17.00  / Bottle
$204.00  / Case
Sonoma Coast, California

"Features a delicious core of vibrant grapefruit and lemon-laced tangerine and white peach notes, with zesty acidity that keeps the flavors fresh and jumping. Drink now."
90 points, Wine Spectator
09403.14
 
$13.00  / Bottle
$156.00  / Case
 
 
 



By entering Hidden Barrel you affirm you are over 21 years old. 

REMEMBER TO LOG IN TO SEE DISCOUNTED STAFF PRICES

 
  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   Privacy Policy   Shipping & Payment Terms  
© 2017 Hidden Barrel
 
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 1.37 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='6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA'
  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 6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA 8214C74B-045C-F599-7754-5D8670104E8E 6C4560D0-08AD-4D07-AC80-ACF490C85C00 6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA //www.hiddenbarrel.com/assets/images/wines/ MacRostie_SonomaCoast_Chard_20141.jpg 2014 MacRostie Sonoma Coast Chardonnay (375 ml/half-bottle) 09403.14 13 Bottle 0 156 Case 0 13 156 0 0 1 1 0 <div style="text-align: center;">Sonoma Coast, California<br /> <br /> "Features a delicious core of vibrant grapefruit and lemon-laced tangerine and white peach notes, with zesty acidity that keeps the flavors fresh and jumping. Drink now."</div> <div style="text-align: center;"><strong>90 points, Wine Spectator</strong></div> 2014 MacRostie Sonoma Coast Chardonnay 375ml <br /> {ts '2015-07-01 11:04:55'} {ts '2017-01-25 10:18:30'} 0654167C-646A-4030-93A5-544CD3692FED 1 1 2014macrostiescchardsplit 0 0 0 1 0 0 0 0 0 2014 MacRostie SC Chard 375
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 0.941 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 = '6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA'
ORDER BY cwav.displayorder asc, cwav.attributevalue asc
  attribute attributevalueid
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 1.07 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 <> '6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA')
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='6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA'))
OR (c.coupontypeid = '1F8A985B-2421-458A-99FB-A10BEDC920A2' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = '6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA')
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 = '6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA'))
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 = '6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA'))
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 = '6E1D3D46-8A2D-4FED-8FB9-2B9CEAB818EA'))
)
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