« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 122 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 = 9169 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 with ‘Renate Tozio’- a zesty yellow-orange, medium sized dahlia. 5-7” blooms on sturdy 4-5’ tall stems. Excellent for cutting or leave in the garden to be a butterfly magnet!
| • | Blooms all Season |
| • | Border or Bed |
| • | Container |
| • | Cut Flower/Foliage |
| • | Focal Point |
| • | Long Blooming |
| • | Reblooming |
| • | Summer Bloomer |
| • | Green |
| • | Attracts Butterflies |
| • | Deer Resistant |
| • | 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 |