« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 51.1 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 = 4214 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 | ||
Kudos™ Yellow has an impeccable compact habit and long lasting, glowing color from June to September. Butterfly loving, yellow colored plumes are full with a delectable honey-mint scent. Perfect in mixed containers or in a border. Deer resistant and drought tolerant!
| • | Border or Bed |
| • | Container |
| • | Cut Flower/Foliage |
| • | Fragrant |
| • | Long Blooming |
| • | Summer Bloomer |
| • | Green |
| • | Deer Resistant |
| • | Yellow |
| • | Full Sun |
| • | Upright |
Grows best in a sunny location with well-drained, fertile soil. Needs excellent drainage to overwinter. Mineral soils are fine.
| string |