« Previous Plant | Next Plant »
Lucious, green leaves with broad, lemon yellow margins create long seasonal interest to this dense and compact Witch Hazel. Lightly scented, yellow flowers will bloom in the fall. Even in the summer heat, Little Prospect’s will not scorch. Flowers blooms just in time for Halloween through Thanksgiving.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 79.9 ms Record Count: 1 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 = 9654 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 | ||
| 1 | HAMAMELIS VIRGINIANA `LITTLE PROSPECT` | 1020359 | 0 | 0 | 30 | 0 | 0 | 52.78 | SHRUBS: HAMAMELIS - witch hazel | 3 | 15-18" | #5 | 0 | 52.78 | (4-6) | 50.14 | (7+) | 45.39 | 9654 | 19286 | ||||||
Grows best in moist, acidic, rich soil in partial shade. Tolerates clay soil and poor drainage. Remove basal sprouts to maintain tree-like shape and to prevent suckers from spreading if you don't want a thicket.
| string |