Taxus media Stonehenge® Yew from Prides Corner Farms

Taxus media Stonehenge®

Yew: Patent PP31,795

» Beautiful evergreen winter foliage
» The upright shape adds height to any garden
» Focal point
» Tolerates almost any sun conditions

Hardiness Zone:4-7
Height:9-10 ft
Spread:2-4 ft
Category:Shrub
Bloom Color: Inconspicuous
Foliage Color: Green Shades
Breeder:Proven Winners

Stonehenge yew naturally grows with a narrow, columnar habit, which makes it an eminently versatile landscape shrub. Whether you plant one or a dozen, its small footprint leaves you plenty of room for other purposes. Handsome deep green foliage provides a nice texture, and it's one of the most shade tolerant of all evergreens.

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 85.1 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select h.program,
s.name,
s.udefSKUNameSuffix,
s.sku,
s.udefBannedStates,
s.udefBBL,
s.udefRR,
s.udefLR,
s.udefTimsTopTwenty,
s.udefJaimesHotList,
s.listPrice as price,
s.udefCategory as category,
s.udefComments as comments,
s.udefGrade as grade,
s.udefSpecial as special,
s.udefPlantSize as plantSize,
s.qtyUnit as size,
s.salePrice,
s.listPrice,
s.udefTier2,
s.udefTier2Price,
s.udefTier3,
s.udefTier3Price,
s.plantID,
s.id
from tb_plant_skus s
inner join tb_lists_hotlist h on (h.sku = s.sku)
where s.isactive = 1 and
s.delete_date is null and
s.isecommerce = 1
and s.plantID = 8975
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price