« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 101 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 = 9176 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 | ||
The flowers are very full and rounded at first, later opening up to shallow cups. They are yellow in color, tending almost towards mustard, and have a strong, delicious fragrance, varying between soft floral Tea and pure lemon. It makes a sturdy shrub with broad, spreading growth.
| • | Green |
| • | Yellow |
| • | David Austin Roses |
| • | Upright |
| • | Moist, Well-Drained |
Plant in full 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 |