« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 56.1 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 = 5160 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 | ||
One look at Pinpoint® Blue false cypress is all it takes to fall in love with its lush color and soft, feathery texture. It's a fantastic accent for any place in your landscape, but is particularly striking as a specimen. You'll love the way its unique color looks with your home - especially with tricky-to-match red or orange brick! Pinpoint Blue false cypress naturally grows as a narrow column, so it takes up little space in the landscape. A memorable choice for planting on either side of your front door! Available in garden centers in spring 2020.
| • | Blue |
| • | Deer Resistant |
| • | Proven Winners |
| • | Upright |
| • | Average Water |
This plant needs superb drainage - do not plant in low-lying area or anywhere that standing water occurs, even occasionally. Rarely requires pruning but may be trimmed in spring if desired.
| string |