« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 126 ms Record Count: 2 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 = 3763 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 | CHAMAECYPARIS OBTUSA `FILICOIDES COMPACTA` | 1002651 | 0 | 149 | 22 | 0 | 0 | 30.51 | SHRUBS: CHAMAECYPARIS - false cypress cypress ce | 1 | 10-14 Only $20.73 Net!! 15+ Only $20.33 Net!! | 24-30" | #3 | 0 | 30.51 | (5-9) | 28.98 | (10+) | 26.24 | 3763 | 13906 | |||||
| 2 | CHAMAECYPARIS OBTUSA `FILICOIDES COMPACTA` | 1010646 | 0 | 89 | 0 | 0 | 0 | 43.27 | SHRUBS: CHAMAECYPARIS - false cypress cypress ce | 1 | 36-42" | #5 | 0 | 43.27 | (4-6) | 41.11 | (7+) | 37.21 | 3763 | 21154 | ||||||
Grows best in full sun but tolerates light shade. It adapts to a variety of well drained soils. Once established it is very drought tolerant. Prune if desired to keep its compact shape or to remove dead, broken or poorly formed branches.
| string |