' - 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  | 
Viewing products  4 of 12    « Prev  |   Next »

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.

Sophora Cuvée
  •  
    Reviews
     
  •  
    Tasting Notes
     
  •  
    Wine Details
     
  •  
    Winery Info
     
Sophora Cuvée

Sophora Cuvée

Gisborne & Hawke’s Bay, New Zealand
 
  "Green apple, yellow raisin and lemon zest flavors are crisp and juicy, with toasted nut, apple cider and biscuit hints on the finish. Drink now." 87 Points, Wine Spectator.”
87 points, Wine Enthusiast

$16.00  / Bottle
$192.00  / Case
 

 

 

 
 
This Cuvée of Chardonnay and Pinot Noir has elegant aromas, is rich and full on the palate with a pleasant, lasting mousse. Sophora exhibits an array of ripe fruit flavors and vibrant citrus combined with delicate yeasty characters and a naturally balanced acidity to produce a luscious style of sparkling wine.
Wine Style: Sparkling Wine
Varietal: Cuvee
Appellation: New Zealand
 
len(wineprofile)
Sophora symbolizes the natural beauty and excitement of New Zealand. Pristine growing conditions and abundant sunshine enhances the vibrancy of our sparkling cuvée. We bottle ferment this cuvée of Chardonnay and Pinot Noir to deliver a wonderful array of floral aromas and ripe fruit flavors. Each glass of Sophora is rich, luscious and layered with delicate bubbles.
  • scroll up
  • scroll down
 
 



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: 7.63 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='3F585FD2-0842-319D-9553-BE0E9F4727FA'
  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 3F585FD2-0842-319D-9553-BE0E9F4727FA 8214C74B-045C-F599-7754-5D8670104E8E 6C4560D0-08AD-4D07-AC80-ACF490C85C00 3F585FD2-0842-319D-9553-BE0E9F4727FA //www.hiddenbarrel.com/assets/images/wines/ Sophora_Cuvee_NV.jpg Sophora Cuvée 3946 16 Bottle 0 192 Case 0 16 192 0 0 1 1 0 <div style="text-align: center;">Gisborne &amp; Hawke&rsquo;s Bay, New Zealand</div> <div style="text-align: center;">&nbsp;</div> <div style="text-align: center;">&nbsp; "Green apple, yellow raisin and lemon zest flavors are crisp and juicy, with toasted nut, apple cider and biscuit hints on the finish. Drink now." 87 Points, Wine Spectator.&rdquo;</div> <div style="text-align: center;"><strong>87 points, Wine&nbsp;Enthusiast</strong></div> {ts '2013-01-15 09:53:41'} {ts '2016-11-17 08:33:07'} 0D48A8D9-D444-409F-9D78-7E1D965BECF1 1 1 0 0 0 1 0 0 0 0 0 Sophora Cuvee
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 7.7 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 = '3F585FD2-0842-319D-9553-BE0E9F4727FA'
ORDER BY cwav.displayorder asc, cwav.attributevalue asc
  attribute attributevalueid
Query
Template: /share/production/deployment/vinsuite-production/cfcs/products.cfc
Execution Time: 7.51 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 <> '3F585FD2-0842-319D-9553-BE0E9F4727FA')
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='3F585FD2-0842-319D-9553-BE0E9F4727FA'))
OR (c.coupontypeid = '1F8A985B-2421-458A-99FB-A10BEDC920A2' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = '3F585FD2-0842-319D-9553-BE0E9F4727FA')
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 = '3F585FD2-0842-319D-9553-BE0E9F4727FA'))
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 = '3F585FD2-0842-319D-9553-BE0E9F4727FA'))
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 = '3F585FD2-0842-319D-9553-BE0E9F4727FA'))
)
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