« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 120 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 = 10170 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 | ||
This evergreen, introduced in 1964 and a winner of the prestigious Award of Garden Merit from the Royal Horticultural Society, is prized for its compact, dense, and rounded to conical shape. It features long, lustrous, deep green needles that create a lush, attractive appearance. Slow-growing and highly resistant to diseases and pests, it thrives in sunny locations, making it a reliable and visually striking addition to gardens, even smaller ones.
| • | Green |
| • | Low Maintenance |
| • | Winter |
| • | Full Sun |
| • | Compact |
| • | Moist, Well-Drained |
Tolerates a wide range of soil conditions, including sandy and clay. Performs best in well-drained soils. Thrives in full sun. Pruning is not required.
| string |