« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 52.5 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 = 685 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 | ||
While we are fixated on blue in the Hydrangea world, Ball Horticulture is working hard to open up our world to new colors with 'Pistachio'. How about this for a mix...red, purple, bronze and green all in varying degrees on each flower? It's a kaleidoscope of varying colors that is made all the more impressive by this selection's ability to rebloom and to bloom on old and new wood. Add up its unique, ever-changing color palette with its incredible desire to bloom and its zone 5 hardiness and you have yet another breakthrough in the Hydrangea world! You'll be wowed by Pistachio™ for all these outstanding traits but the one you might like best is the carefree nature that sees it growing well in any sunny to half-day sun area in your landscape that has moist, well-drained soil with very little input from you other than getting it established. Blessed with a dense, rounded form, it will be as easy to find a home for Pistachio™ in your yard as it will be to show off its remarkable bloom.
Plant in full to partial sun area with moist well-drained soil. Prune dead stems in early spring after the new growth starts - only pruning the portions of the stems that did not break.
| string |