« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 139 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 = 10124 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 English Shrub Rose, introduced by David Austin in 1991, features exceptionally large, beautifully arranged blooms in a soft apricot color, often tinged with pink. The flowers have a strong, fruity fragrance reminiscent of fresh peaches and apricots, with a classic Old Rose quality. Blooming repeatedly from late spring through early winter, the rose produces large blooms with about 100 petals each. Ideal for zones 5-11, this large shrub grows to about 5 feet tall and 3 feet wide, adding a touch of elegance and a delightful scent to any garden.
For optimal care of the English Shrub Rose, plant it in a mixed border with full sunlight, ideally facing east, south, or west. This rose, suitable for zones 5-11, thrives in any soil type and grows to about 5 feet tall and 3 feet wide. Regular annual pruning will help maintain its shape and encourage healthy growth.
| string |