« Previous Plant | Next Plant »
Dense and vigorous with dark evergreen foliage and masses of burgandy-red flower buds that open raspberry-pink in late May. Growth and form make make this plant ideal for woodland group plantings. Beautiful foliage showcases a great display of late May flowers. Shade tolerant.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.2 ms Record Count: 1 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 = 3014 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 | KALMIA LATIFOLIA `RASPBERRY GLOW` | 1000229 | 0 | 1720 | 0 | 0 | 0 | 39.62 | SHRUBS: KALMIA - mountain laurel | 1 | 10-14 Only $26.92 Net!! 15+ Only $26.41 Net!! | 18-21" | #3 | 0 | 39.62 | (5-9) | 37.64 | (10+) | 34.07 | 3014 | 13190 | |||||
| string |