« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.6 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 = 9518 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 | ||
Add little bursts of sunshine to your bouquets, arrangements, or gardens withBacardi- a sun-bleached pink, medium sized dahlia. 4-5” blooms on sturdy 3-4’ tall stems. Excellent for cutting or leave in the garden to be a butterfly magnet!
| • | Cut Flower/Foliage |
| • | Pink |
| • | Late Summer |
| • | Full Sun |
Thrives in full sun. Feed regularly with organic fertilizer during the bloom season. Trim off spent blooms to encourage even more bloom. Outstanding as a colorful specimen in-ground and brilliant in a deck container.
| string |