« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.8 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 = 4885 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 | ||
Outstanding bract color is the calling card for this small tree flower buds open in early May to reveal big, deep red bracts that surround small flowers and put on a magnificent show. Red fall berries and fall foliage add to the show! Perfect specimen for smaller to medium yards. Outstanding bloom color. New foliage emerges red and turns red in fall. Red berries attract native songbirds.
| • | Green |
| • | Attracts Songbirds |
| • | Red |
| • | Late Spring |
| • | Round |
Thrives in the morning sun, afternoon shade. Feed yearly with an organic fertilizer. Remove dead or broken branches when dormant in winter along with any other pruning for size control.
| string |