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

« Previous Plant  |  Next Plant »

Nyssa sylvatica Green Gable™ ('NSUHH')

Green Gable™ Black Gum: Patent PP22,951

  • »  Brilliant fall foliage display
  • »  Very attractive form
  • »  Low maintenance
  • »  Outstanding shade tree

  • Hardiness Zone:4-8
  • Height:45-50 ft
  • Spread:30-35 ft
  • Category:Shrub
  • Foliage Color: Green Shades
Green Gable™ sparkles with its superb, strikingly formal appearance with a pyramidal outline that is oh so easy on the eyes. Shiny, deep green foliage clothes the plant in summer then delivers a tour de force fall foliage show of red and orange that has to be seen to be believed!
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 27.8 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 = 4256
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1NYSSA SYLVATICA `GREEN GABLE`1008637002840092.62TREES: NYSSA - black gum black tupelo26-7'#7092.62(4-6)87.99(7+)79.65425613213

Find a local garden center

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