« Previous Plant | Next Plant »
Dense, slow-growing, pyramidal evergreen with whorls of thick, dark green, glossy needles that almost appear to be plastic! Reddish-brown buds and branches. Tough, low maintenance, nearly pest-free, and a magnificent specimen plant. Grow alone or in border groupings. Attractive foliage, stems, and buds. Deer resistant.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 46.2 ms Record Count: 1 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 = 3036 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 | SCIADOPITYS VERTICILLATA `WINTERGREEN` | 1003409 | 0 | 15 | 9 | 0 | 0 | 34.70 | TREES: SCIADOPITYS - Japanese umbrella pine | 1 | 21-24" | #2 | 0 | 34.70 | (5-9) | 32.97 | (10+) | 29.84 | 3036 | 14989 | ||||||
| • | Green |
| • | Low Maintenance |
| • | Deer Resistant |
| • | Red |
| • | Moist, Well-Drained |
Likes enriched, well-drained soil. Best appearance when allowed to branch naturally but new growth candle can be trimmed to reduce growth. Prefers protection from the afternoon sun.
| string |