« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.3 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 = 10244 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 climbing rose, introduced by David Austin in 2000, is a repeat-flowering rambler that reaches up to 15 feet tall. It bears small, soft yellow blooms with 40 petals, held in medium to large clusters, and emits a light to medium musky fragrance. With healthy, strong, slender growth, it features attractive, polished foliage and few thorns. Ideal for a wall, fence, large arch, or pergola, this rose thrives in shady areas.
| • | Green |
| • | Disease Resistant |
| • | Yellow |
| • | David Austin Roses |
| • | Climbing |
This plant thrives in full sunlight but can also tolerate partial sunlight, making it adaptable to various lighting conditions, whether it faces north, east, south, or west. It boasts healthy, strong, and slender growth, with polished, attractive foliage. This rose emits a light to medium musky fragrance, enhancing its appeal. It is relatively low-maintenance, with few thorns, and is well-suited to all soil types.
| string |