« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 62.3 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 = 4591 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 | ||
A compact, low-spreading evergreen shrub that delivers year-round interest with minimal effort. Bright golden-yellow new growth adds a splash of color in spring, gradually maturing to a soft blue-green for a beautiful two-tone effect. Its dense, spreading habit makes it ideal for ground cover, slopes, or mass plantings. Once established, this shrub is exceptionally low maintenance and thrives with little care.
| • | Full Sun |
| • | Ground Cover |
Grows well in typical garden soil with moderate moisture and good drainage, preferably in full sun. Adaptable to various soil types, including clay, but does not perform well in overly wet conditions. Once established, it can handle periods of drought. Occasional pruning can help keep its shape neat and compact.
| string |