« Previous Plant | Next Plant »
Female selection offers multi-season interest with pure white flowers, dark green foliage and abundantly large, bright red fruit that that the birds will strip before winter. Fall and early winter provides stems ideal for floral or seasonal displays. Rounded habit creates a wonderful foundation plant, specimen or hedge.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 135 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 = 2207 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 | FE | ILEX VERTICILLATA `WILDFIRE` | 1006413 | 0 | 806 | 1019 | 0 | 0 | 29.36 | SHRUBS: ILEX - holly/ winterberry | 1 | 24-30" | #3 | 0 | 29.36 | (5-9) | 27.89 | (10+) | 25.25 | 2207 | 14215 | |||||
| • | Dark Green |
| • | Attracts Songbirds |
| • | White |
| • | First Editions |
| • | Full Sun |
| string |