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

« Previous Plant  |  Next Plant »

Rosa Above All™

Rosa Climber

  • »  Salmon orange blooms
  • »  Fragrant blooms
  • »  3-4" flowers

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 49.7 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 = 10790
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
Eye-catching salmon-orange blooms bring warm, vibrant color to the garden from spring through fall. Lightly fragrant flowers with a pleasant fruity scent climb beautifully over arbors, and fences, creating a stunning vertical display. This vigorous climbing rose offers excellent disease resistance, making it as reliable as it is beautiful for garden borders and landscape accents.

Find a local garden center

Within...
...of zip code:
.
Growing & Maintenance Tips for Rosa Above All™

Thrives in full sun with a moderate amount of water in well-drained soil conditions

string