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

« Previous Plant  |  Next Plant »

Rosa Easy Elegance® Super Hero ('BAlsuhe')

Super Hero Shrub Rose: Patent PP20,486

  • »  Northern hardy
  • »  Low care and very rewarding
  • »  Strong disease resistance
  • »  Great cut flower
  • »  Bright red flowers late May through September
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 96.3 ms
Record Count: 0
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 = 1169
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
(Northern Hardy) If your landscape is looking for a savior, 'Super Hero' is your plant! More than a great rose, 'Super Hero' is a low care, very rewarding flowering shrub that will thrill you with its landscape heroics from late May through September. With its everblooming nature, strong resistance to disease and spectacular, bright red, Hybrid Tea-like flowers, this plant begs to be the center of attention and always delivers in the clutch when planted in any full sun location with moist, well-drained soil. 'Super Hero' won't limit its good deeds to the garden... its bloom is perfect for cutting and bringing in the house to help make your home a better place to live, too!

Find a local garden center

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