« Previous Plant | Next Plant »
Green Mile™ grows in a tight, upright form making it perfect for narrow garden spaces. In early summer fragrant, showy, white blooms appear among the green foliage attracting butterflies. Excellent as a specimen tree, in a park setting, or in wet soil near ponds/streams.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 54.1 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 = 9395 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 | MAGNOLIA VIRGINIANA `GREEN MILE` | 1020367 | 0 | 23 | 0 | 0 | 0 | 35.81 | TREES: MAGNOLIA | 1 | 24-30" | #3 | 0 | 35.81 | (5-9) | 34.02 | (10+) | 30.8 | 9395 | 19471 | ||||||
| • | Low Maintenance |
| • | Attracts Butterflies |
| • | Yellow |
Grows best in full sun to partial shade in average to wet soil conditions.
| string |