« Previous Plant | Next Plant »
Emerald Squeeze™ grows steadily in a compact form while maintaining dense evergreen foliage. Enjoy as a specimen, plant in narrow garden areas, or use as a privacy screen. This easy to grow, low maintenance evergreen is versatile and adaptable making it the perfect addition to any garden space.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 66.4 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 = 9436 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 `EMERALD SQUEEZE` | 1014350 | 0 | 352 | 0 | 0 | 1 | 23.75 | SHRUBS: THUJA - arborvitae | 1 | 24-30" | #2 | 0 | 23.75 | (5-9) | 22.56 | (10+) | 20.43 | 9436 | 18764 | ||||||
Grows best when planted in average to moist, well-drained soil in full sun.
| string |