« Previous Plant | Next Plant »
Long, graceful needles make up this medium sized evergreen conifer's narrow shape. Needles are soft and bluish-green and cones will adorn the tree, too. Provides a multitude of landscape uses. Outstanding nesting area for a laundry list of birds along with a food source from its production of cones and seed.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 94.4 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 = 9882 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 | PINUS STROBUS `FASTIGIATA` | 1022113 | 0 | 9 | 1 | 0 | 0 | 199.23 | SHRUBS: PINUS - pine | 1 | 5-6' | #10 | 0 | 199.23 | (4-6) | 189.27 | (7+) | 171.34 | 9882 | 20524 | ||||||
| 2 | PINUS STROBUS `FASTIGIATA` | 1029245 | 0 | 13 | 0 | 0 | 0 | 199.23 | SHRUBS: PINUS - pine | 1 | 4-5' | #10 GB | 0 | 199.23 | (4-6) | 189.27 | (7+) | 171.34 | 9882 | 21618 | ||||||
| • | Evergreen |
| • | Green |
| • | Winter |
| • | Upright |
| • | Moist, Well-Drained |
Loves moist, well-drained soil. Avoid high salt areas. Little pruning required, but prune if necessary following spring growth.
| string |