« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 54.8 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 = 10389 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 | ||
Incrediball Storm Proof smooth hydrangea is a compact and resilient shrub with dense growth and strong stems. The kind of reliability we all want in our showstopping shrubs! It features abundant small, white blooms that cover the entire plant, eliminating the need for front fillers. This low-maintenance hydrangea is perfect for gardeners who want a beautiful and weather-resistant shrub.
| • | Green |
| • | White |
| • | Proven Winners |
| • | Summer Bloomer |
| • | Moist, Well-Drained |
Plant in full to partial sun. A good layer of shredded bark mulch helps minimize water loss. Prune the entire plant back in spring just as new growth appears .
| string |