« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 110 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 = 9240 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 | ||
A new variety ready to steal the spot for your favorite Dahlia. Featuring both light and dark accents in its kaleidoscopic of colors with butterscotch, pinkish, peach, and burgundy all on a decorative, double, 3-4" bloom.
It's height makes it an excellent choice for the back of the border. Massive flowers make great cut flowers. Suitable for containers or borders. A butterfly magnet!
| • | Green |
| • | Attracts Butterflies |
| • | Orange |
| • | Full Sun |
| • | Moist, Well-Drained |
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. Dahlias are mildly toxic to dogs, cats, and horses.
| string |