« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 29.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 = 9519 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 | ||
'Crème de Cassis' is the eye-catching statement your garden needs! The 4-6" blossoms display gorgeous petals that are lavender-pink on top and a deep wine-red color in the center and underneath. Excellent for arrangements or leave in the garden to attract butterflies. Low maintenance and suitable for borders or containers.
| • | Dark Green |
| • | Low Maintenance |
| • | Attracts Butterflies |
| • | Purple |
| • | Full Sun |
| • | Upright |
Dahlias grow best in full sun, moist well-drained soils. They can handle a partly shaded landscape but too much shade can reduce the number of blooms and cause weaker stems. Remove spent flower heads to encourage new blooms.
| string |