« Previous Plant | Next Plant »
Starway To Heaven™ is an elegant and versatile choice for gardeners seeking a tree with year-round interest, fragrant reblooming flowers, and striking seasonal foliage. Its narrow habit and showy blooms make it perfect for enhancing even the smallest landscapes.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 104 ms Record Count: 1 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 = 10042 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 | ||
| 1 | PW | STYRAX JAPONICUS `STARWAY TO HEAVEN` | 1020910 | 0 | 114 | 0 | 0 | 0 | 102.06 | TREES: STYRAX - snowbell | 1 | 5-6' | #7 | 0 | 102.06 | (4-6) | 96.96 | (7+) | 87.77 | 10042 | 20174 | |||||
Minimal pruning is required, mostly to maintain shape and remove any dead or damaged branches. Keep the soil consistently moist for the first year to establish a strong root system. Thrives in full sun to part sun.
| string |