« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 35.5 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 = 9532 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 | ||
A dwarf variety with soft foliage and deep green color will appear fluffy and dense later in the season. Upright and columnar in form, this evergreen will retain a shamrock-green color all growing season and persist throughout the winter, without the usual bronzing that other Arborvitaes get. Perfect for planting in groups to form a tall hedge, screen or barrier. Easy to grow, with a slower growth rate, very hardy, and low maintenance. Deer resistant.
| • | Evergreen |
| • | Green |
| • | Low Maintenance |
| • | Partial Sun |
| • | Moist, Well-Drained |
Thrives in full to half day sun. Feed yearly with an organic fertilizer. Prune immediately after new growth flush in late spring or early summer to shape and control size.
| string |