« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 77.3 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 = 9950 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 | ||
Fat growing and broadly pyramidal in shape, this evergreen features stiff, dark green needles arranged in 3's on stiff stems creating a pleasing, full evergreen tree that can be used as a specimen or grouped to create a large windbreak Easy to grow. Large, dense, broadly pyramidal form is attractive and perfect to use as a specimen in large yards or grouped to create a windbreak along borders. Deer resistant.
| • | Dark Green |
| • | Drought Tolerant |
| • | Attracts Songbirds |
| • | Deer Resistant |
| • | Winter |
| • | Full Sun |
| • | Moist, Well-Drained |
Thrives in full sun. Feed yearly with an organic fertilizer. Prune if needed by clipping new growth candles back in spring as they are just extending but not yet flushing needles
| string |