| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 37.2 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 = 5026 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 | ||
Cup-shaped, lemony-scented creamy white flowers bloom in the spring. The waxy flowers pop against shiny, oblong, green foliage. Cone-line fruits have bright red seeds that mature in fall. Reblooms sporatically throughout the summer. Easy to grow and dependable. Perfect as a specimen tree in full sun. Massive spring bloom is riveting.
| • | Green |
| • | Attracts Songbirds |
| • | White |
| • | American Beauties Native PlantsĀ® |
| • | Wet Soil/Wetlands |
Thrives in full sun. Feed yearly with an organinc fertilizer. Prune immediately after bloom to control shape and size. Avoid heavy, invasive pruning and large branch cuts.
| string |