« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 100 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 = 686 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 | ||
No gardener will experience cold feet when they see this 'Wedding Gown'! This great selection is part of the newest generation of reblooming Hydrangeas and one look will make you take the plunge and commit to putting it in a prominent place in your landscape with no regrets. Let's face it, who could regret growing a dense, full spreading plant with deep green foliage that will bloom earlier than almost any other macrophylla type Hydrangea, loading up with pure white, lace-cap type flowers that keep coming in an inexhaustible supply until October. And, Wedding Gown is not just any lacecap flower type. It's bloom features sterile, fully double outer flowers surrounding the pinpoint fertile center flowers in each flower head giving this plant a unique and pleasing bloom that is truly rare. 'Wedding Gown' is a low maintenance garden partner for life that tolerates mildew and wants for nothing other than a shady to semi-shady location.
| string |