« Previous Plant | Next Plant »
Dense, quick-growing, pyramidal evergreen with intense, silvery-blue foliage color. Great texture. Tough and drought tolerant, this plant's upright pyramidal form is perfect for specimen use or group plantings as a hedge. Outstanding foliage color. Great cover.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 151 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 = 9895 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 | JUNIPERUS SCOPULORUM `MOFFAT BLUE` | 1020356 | 0 | 31 | 0 | 0 | 0 | 198.09 | SHRUBS: JUNIPERUS - upright form | 1 | 5-6' | #15 | 0 | 198.09 | (4-6) | 188.19 | (7+) | 170.36 | 9895 | 22075 | ||||||
| string |