« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 44.4 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 = 10243 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 | ||
'Raywood Weeping' is a unique, weeping variety of Arizona Cypress, known for its striking silvery-blue foliage and gracefully cloaked branching. Each tree is one-of-a-kind, offering an intriguing, sculptural appearance. While it naturally grows upright, staking the young tree helps ensure a more vertical form over time. Left unstaked, it may arch downward or adopt a more irregular shape as it establishes. This tree is also highly tolerant of aesthetic pruning, allowing for creative shaping and artistic results.
| • | Average Water |
This fast-growing evergreen conifer reaches 15-20 feet tall and 5-6 feet wide at maturity, with a unique upright, weeping form. Best used as a specimen or to frame an entryway, it thrives in full to mostly sun and well-drained soils. Once established, it requires minimal water and grows at a rate of 18-24 inches per year. Stake if a tall, upright form is desired.
| string |