You will be logged off in  seconds due to inactivity. Click here to continue your ordering session.

« Previous Plant  |  Next Plant »

Sambucus canadensis 'York'

York Elderberry

  • »  Heavy crops of extra large fruit clusters
  • »  Matures 1-2 weeks after 'Adam'
  • »  Fruit is high in Vitamin C
  • »  Vigorous 8-10' shrub
  • »  Fruit is the largest of any variety

  • Hardiness Zone:4-8
  • Height:8-10 ft
  • Spread:8-10 ft
  • Category:Shrub
  • Bloom Color: Green Shades
Produces heavy crops of extra large fruit clusters, maturing 1 to 2 weeks after 'Adams'. Fruit is high in Vitamin C and individual fruits are the largest of any variety. Vigorous shrub 8-10'.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 117 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 = 1476
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1SAMBUCUS CANADENSIS `YORK`1001942048800025.27SHRUBS: SAMBUCUS - elderberry115-18"#3025.27(5-9)24.01(10+)21.73147614300

Find a local garden center

Within...
...of zip code:
.
string