« Previous Plant | Next Plant »
The hardy Emerald Spire® Crabapple is a slow-growing, columnar tree with bright fuchsia buds that open to pink spring flowers. It produces abundant red 1-inch fruit that falls in a concentrated area due to its compact canopy. The dark green to purple leaves are disease-resistant and turn yellow in the fall. Preferring moist, well-drained soil, this crabapple is ideal as an accent tree, screen, or for small spaces.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 193 ms Record Count: 2 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 = 10059 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 | MALUS `EMERALD SPIRE` | 1021610 | 0 | 6 | 0 | 0 | 0 | 77.08 | TREES: MALUS - flowering crabapple | 1 | 4-5' | #7 | 0 | 77.08 | (4-6) | 73.23 | (7+) | 66.29 | 10059 | 20165 | ||||||
| 2 | MALUS `EMERALD SPIRE` | 1022728 | 0 | 26 | 0 | 0 | 0 | 114.53 | TREES: MALUS - flowering crabapple | 1 | 7-8' | #15 | 0 | 114.53 | (4-6) | 108.8 | (7+) | 98.5 | 10059 | 21160 | ||||||
| • | Dark Green |
| • | Cold Tolerant |
| • | Pink |
| • | Spring |
| • | Full Sun |
| • | Average Water |
| string |