| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 83.4 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 = 9662 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 | ||
Usually grown in colder climate wetlands, Tamarack is a hardy tree that has a slender trunk with bright green, glossy needles that appear in soft tufts in early spring. The needle color will change to a golden-yellow in the fall. Did you know that the roots of this tree were often used to stitch birch-bark canoes since the wood would become very durable when wet?
| • | Native |
| • | Dark Green |
| • | Cold Tolerant |
| • | Non-blooming |
| • | American Beauties Native PlantsĀ® |
| • | Full Sun |
| • | Moist, Well-Drained |
Grows best in moist, well-drained acidic soil. Plant in full sun, but will tolerate some light shade. Trees do not perform well in hot and humid conditions.
| string |