« Previous Plant | Next Plant »
Noted for having small needles and petite cones make up the lacy, evergreen foliage which give a graceful form. Bottom branches droop lower towards the ground. The bark is thick and ridged with a red-brown color.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 83.9 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 = 3139 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 | TSUGA CANADENSIS | 1000272 | 0 | 1 | 0 | 0 | 0 | 250 | Wholesale Yard B&B | 1 | - | 6/7' B+B | 0 | 250 | 3139 | 20463 | ||||||||||
| 2 | TSUGA CANADENSIS | 1000273 | MA, PA | 0 | 0 | 2 | 0 | 0 | 325 | Wholesale Yard B&B | 1 | - | 7/8' B+B | 0 | 325 | 3139 | 20464 | |||||||||
| • | Green |
| • | Attracts Songbirds |
| • | Deer Resistant |
| • | Non-blooming |
| • | Upright |
| • | Moist, Well-Drained |
Well-drained soil in part shade to full shade. Prefers cool, moist, humid conditions.
| string |