| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 43.6 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 = 10073 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 hybrid climber features heavenly pink, highly fragrant blooms that beautifully contrast with lush green foliage. With old-fashioned flowers gracing its vining canes, it offers an exceptionally disease-resistant display, embodying the ultimate blend of classic charm and modern resilience for the future.
| • | Fragrant |
| • | Green |
| • | Disease Resistant |
| • | Supports Bees |
| • | Pink |
| • | Summer Bloomer |
| • | Full Sun |
| • | Climbing |
| • | Average Water |
Plant Colette™ in a sunny spot with well-draining soil. Water regularly but avoid waterlogging. Prune in early spring to encourage new growth and remove any dead or damaged branches. Use a trellis or support to guide its climbing. Fertilize once a month during the growing season for best results.
| string |