« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 52.1 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 = 10043 order by udefcategory, name, price | ||||||||||||||||||||||||||
| program | name | udefSKUNameSuffix | sku | udefBannedStates | udefBBL | udefRR | udefLR | udefTimsTopTwenty | udefJaimesHotList | price | category | comments | grade | special | plantSize | size | salePrice | listPrice | udefTier2 | udefTier2Price | udefTier3 | udefTier3Price | plantID | id | ||
From the breeder of Flower Carpet® ground cover roses comes this new addition to the Fragrant Shrub Roses series. It boasts large, beautifully fragrant blooms that exude a charming old-world allure, paired with modern disease resistance. This rose variety captivates with its radiant orange blooms, not only for its stunning appearance but also for its delightful fragrance that permeates the garden. Whether in pots or garden beds, it thrives in sunny locations, offering a vibrant display of color.
| • | Green |
| • | Orange |
| • | Flower Carpet Rose |
| • | Full Sun |
| • | Compact |
For healthy fragrant shrub roses, plant in well-drained, enriched soil and water deeply initially, tapering off as they establish. Apply rose fertilizer in spring, and deadhead blooms regularly. Prune lightly in early spring, monitor pests, and protect in colder climates with mulch.
| string |