« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 167 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 = 10257 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 | ||
Snowcone® Japanese Snowbell is a compact ornamental tree admired for its elegant, rounded crown and abundant display of fragrant, bell-shaped white flowers in late spring. It offers a tidy, symmetrical habit and attractive dark green foliage that turns yellow in fall. Its delicate blooms and refined form make it an excellent choice for patios, entryways, or as a specimen tree in the landscape.
Snowcone® Japanese Snowbell thrives in full sun to partial shade and prefers rich, acidic, well-drained soil that is kept consistently moist. It appreciates a sheltered site with some protection from hot afternoon sun in warmer climates. Minimal pruning is needed to maintain its graceful form, though light shaping can be done after flowering. Mulching helps retain moisture and keep roots cool.
| string |