« Previous Plant | Next Plant »
This upright, narrow, pyramidal evergreen has an irresistible, soft green foliage and a shape that lends itself to tons of landscape functions from hedging to specimen use. Adaptable and easy to grow.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 130 ms Record Count: 9 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 = 1337 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 | THUJA OCCIDENTALIS `SMARAGD` | 1000033 | 0 | 2435 | 0 | 0 | 0 | 26.26 | SHRUBS: THUJA - arborvitae | 1 | 24-30" | #3 | 0 | 26.26 | (5-9) | 24.95 | (10+) | 22.58 | 1337 | 14480 | ||||||
| 2 | THUJA OCCIDENTALIS `SMARAGD` | 1000191 | 0 | 442 | 0 | 0 | 0 | 48.21 | SHRUBS: THUJA - arborvitae | 1 | 42-48" | #5 | 0 | 48.21 | (4-6) | 45.8 | (7+) | 41.46 | 1337 | 14463 | ||||||
| 3 | THUJA OCCIDENTALIS `SMARAGD` | 1000448 | 0 | 507 | 0 | 0 | 0 | 59.01 | SHRUBS: THUJA - arborvitae | 1 | 4-5' | #7 | 0 | 59.01 | (4-6) | 56.06 | (7+) | 50.75 | 1337 | 14858 | ||||||
| 4 | THUJA OCCIDENTALIS `SMARAGD` | 1002557 | 0 | 1869 | 30 | 0 | 0 | 85.64 | SHRUBS: THUJA - arborvitae | 1 | 4-5' | #10 | 0 | 85.64 | (4-6) | 81.36 | (7+) | 73.65 | 1337 | 14449 | ||||||
| 5 | THUJA OCCIDENTALIS `SMARAGD` | 1015487 | 0 | 6 | 0 | 0 | 0 | 109.50 | SHRUBS: THUJA - arborvitae | 1 | 5-6' | #10 GB | 0 | 109.50 | (4-6) | 104.03 | (7+) | 94.17 | 1337 | 18997 | ||||||
| 6 | THUJA OCCIDENTALIS `SMARAGD` | 1000196 | 0 | 26 | 1 | 0 | 0 | 160 | Wholesale Yard B&B | 1 | - | 5/6' B+B | 0 | 160 | 1337 | 17636 | ||||||||||
| 7 | THUJA OCCIDENTALIS `SMARAGD` | 1001300 | 0 | 73 | 0 | 0 | 0 | 175 | Wholesale Yard B&B | 1 | - | 6/7' B+B | 0 | 175 | 1337 | 20456 | ||||||||||
| 8 | THUJA OCCIDENTALIS `SMARAGD` | 1000728 | 0 | 91 | 0 | 0 | 0 | 260 | Wholesale Yard B&B | 1 | - | 7/8' B+B | 0 | 260 | 1337 | 20457 | ||||||||||
| 9 | THUJA OCCIDENTALIS `SMARAGD` | 1001435 | 0 | 75 | 0 | 0 | 0 | 335 | Wholesale Yard B&B | 1 | - | 8/9' B+B | 0 | 335 | 1337 | 20470 | ||||||||||
Prune in late winter or early spring before new growth begins. Grows best in full sun but generally appreciates some light afternoon shade.
| string |