| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.2 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 = 10383 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 | ||
Mountain Maple is a small, multi-stemmed, deciduous understory tree or large shrub reaching 10–20'. Upright clusters of pale yellow-green flowers bloom in late spring. Soft, green, toothed leaves turn brilliant shades of yellow, orange, or red in fall. Bark is smooth and gray on young stems.
| • | Cold Tolerant |
| • | Attracts Songbirds |
| • | American Beauties Native PlantsĀ® |
| • | Moist, Well-Drained |
Prefers part shade to full shade in cool, moist, well-drained soils. Tolerates rocky, acidic conditions. Prune after leaf drop to shape or thin.
| string |