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

« Previous Plant  |  Next Plant »

Salix niobe

Weeping Willow

  • »  Fast growing
  • »  Extremely popular in the Northeast
  • »  Tolerant of wet areas
  • »  Delicate, gracefully pendulous branches
  • »  Great specimen

  • Hardiness Zone:4-8
  • Height:60-70 ft
  • Spread:40-50 ft
  • Category:Tree
  • Bloom Color: Green Shades
Is there another tree growing in the northeast that is as recognizable as the Weeping Willow?? Fast growing and tolerant of wet areas, the delicate, gracefully pendulous branches of this plant seem to touch everyone with their beauty. A great specimen that needs room to deliver the most impact in the landscape.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 113 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 = 1240
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1SALIX NIOBE1000412036360000131.91TREES: SALIX - willow110-12'#150131.91(4-6)125.31(7+)113.44124014647

Find a local garden center

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