« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 185 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 = 9164 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 multiple award winner, ‘Kelvin Floodlight’ is a longtime favorite of growers, florists, and gardeners. Massive 10-12”, translucent yellow blooms, will add a sunny pop to your garden. Great choice for your first giant dahlia. Excellent for cutting or leave in the garden to be a butterfly magnet!
| • | Award Winning |
| • | Blooms all Season |
| • | Container |
| • | Cut Flower/Foliage |
| • | Focal Point |
| • | Long Blooming |
| • | Reblooming |
| • | Summer Bloomer |
| • | Green |
| • | Attracts Butterflies |
| • | Yellow |
| • | Upright |
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 |