« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 61.9 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 = 10075 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 | ||
This compact, upright rose grows into a bushy shrub and blooms vibrantly. It's perfect for containers, walls, or shadier spots, making it ideal for city living. The medium scent is zesty, with notes of lemon, lychee, and fresh apricot.
| • | Green |
| • | Yellow |
| • | David Austin Roses |
| • | Summer Bloomer |
| • | Compact |
| • | Average Water |
Roses need at least four hours of direct sunlight daily to thrive, though they can still do well even against a north wall. To reduce competition for resources, plant roses 3 feet from other plants and 2 feet from other roses. Avoid very windy spots, as strong winds can destabilize the plant; firm the soil or use a stake if necessary. Prune in late winter/early spring, when the first growth is beginning. It is ok to prune earlier, but it can be more difficult to identify the less healthy stems that you will want to prune out.
| string |