« Previous Plant | Next Plant »
Fire Light® is the new standard to measure all hardy hydrangeas. Upright panicles are packed with florets which transform from pure white to rich pomegranate-pink. Its thick, sturdy stems hold up the beautiful flowers so they are prominently displayed in the garden throughout the late summer and fall. The fat, colorful blooms are easy to use as a cut flower or to dry for enjoyment year round. It loves full to half day sun and will add a distinct presence to you landscape when planted alone or grouped to form a colorful border planting.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 237 ms Record Count: 2 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 = 2178 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 | HYDRANGEA PAN. `FIRE LIGHT` | 1030503 | 0 | 0 | 34 | 0 | 0 | 23.86 | SHRUBS: HYDRANGEA - panicle hydrangea | 2 | 21-24" | #2 | 0 | 23.86 | (5-9) | 22.67 | (10+) | 20.52 | 2178 | 21845 | |||||
| 2 | PW | HYDRANGEA PAN. `FIRE LIGHT` | 1006552 | 0 | 0 | 84 | 0 | 0 | 29.85 | SHRUBS: HYDRANGEA - panicle hydrangea | 2 | 21-24" | #3 | 0 | 29.85 | (5-9) | 28.36 | (10+) | 25.67 | 2178 | 13872 | |||||
| • | Proven Winners |
| string |