« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 76.3 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 = 3388 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™ Coral has an impeccable habit and long lasting, glowing color from June to August. Butterfly loving, coral colored plumes are full with a delectable honey-mint scent. Perfect in mixed containers or in a border. Deer resistant!
| • | Award Winning |
| • | Border or Bed |
| • | Container |
| • | Cut Flower/Foliage |
| • | Fragrant |
| • | Summer Bloomer |
| • | Green |
| • | Low Maintenance |
| • | Deer Resistant |
| • | Full Sun |
| • | Upright |
Thrives in sunny locations with well-drained soil. Feed yearly with an organic fertilizer. Great drainage is crucial for overwintering. Perfect in groups or containers.
| string |