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

« Previous Plant  |  Next Plant »

Diervilla rivularis Ru-Bee Wren™ ('SMDCS')

Ru-Bee Wren™ Mountain Bush Honeysuckle: Patent PP33,289

  • »  Superb crimson new foliage flush
  • »  A perfect, easy to grow plant for small spaces
  • »  An outstanding source of nectar and seed
  • »  Colorful fall display of yellow to orange foliage
  • »  Dry fruit capsules attract birds in fall and winter

You'll love the stunning foliage color on this easy to grow selection as new leaves emerge brilliant crimson in spring filling this dense spreading shrub with color. Leaves age to deep green followed by bright yellow, nectar laden bloom in late June, and native songbird sustaining fruit in fall.

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 109 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 = 8749
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1ABDIERVILLA RIVULARIS `RU-BEE WREN`10130920295880028.82SHRUBS: DIERVILLA - bush honeysuckle118-21"#3028.82(5-9)27.38(10+)24.79874916875

Find a local garden center

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