« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 81.1 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 = 459 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 | ||
Diervilla Cool Splash® is a breakthrough variegated form of the incredibly hardy Diervilla, a tough-as-nails plant that has been used extensively in the northern landscape due to its durability. Found as a chance sport at Cornell University, this bright new beauty has proved to be just as tough and reliable as its green foliaged relatives. Widely banded in snowy white, the lanceolate leaves possess perfect contrast with vivid green centers and will hold fast to this distinct coloration even in a part shade environment. Clusters of small, sunny, trumpet-like blooms smother this graceful, compact plant in May and June, further delighting the eye. Cool Splash® will thrive in partial shade, is drought resistant and will inject just the shot of easy-care foliage color you need in your landscape.
Cool Splash® will thrive in partial shade, is drought resistant and will inject just the shot of easy-care foliage color you need in your landscape.
| string |