« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.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 = 10030 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 | ||
David Austin Roses "Bring Me Sunshine" rose is a charming addition to any garden, known for its exquisite beauty and delightful fragrance. This English shrub rose showcases large, full blooms with a soft apricot-yellow hue, complemented by a subtle hint of pink at the center. The flowers exude a sweet and fruity fragrance, making them ideal for cutting and enjoying indoors. "Bring Me Sunshine" grows into a compact, bushy shrub reaching about 3 to 4 feet in height, making it suitable for borders or containers. Its glossy, dark green foliage provides an elegant backdrop to the profusion of blooms, which appear repeatedly throughout the season. This rose variety is cherished not only for its aesthetic appeal but also for its disease resistance and vigor, ensuring long-lasting beauty in the garden.
| • | Green |
| • | Orange |
| • | David Austin Roses |
| • | Upright |
| • | Moist, Well-Drained |
Plant in full to partial sun with well-drained soil, water deeply during dry spells, fertilize in spring and after the first bloom, prune in late winter, mulch for moisture retention, and provide support if necessary.
| string |