« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 56.4 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 = 9557 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 | ||
Red and yellow bicolor blooms open in early spring and continue throughout the summer into autumn! This variety is well-branched with an outstanding upright habit. An excellent garden performer makes these flowers perfect for attracting butterflies and birds and well as cutting and displaying.
| • | Blooms all Season |
| • | Container |
| • | Cut Flower/Foliage |
| • | Focal Point |
| • | Long Blooming |
| • | Summer Bloomer |
| • | Green |
Dahlias grow best in full sun and 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. Requires average watering and fertilizing.
| string |