« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 38.2 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 = 4966 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 | ||
Huge flowers are a deep rosy burgundy that blooms from spring through the fall. The bright flowers attract hummingbirds and butterflies. Good in borders. Attracts butterflies; cut flowers are good fresh or dried.
| • | Blooms all Season |
| • | Border or Bed |
| • | Container |
| • | Cut Flower/Foliage |
| • | Fragrant |
| • | Long Blooming |
| • | Green |
| • | Low Maintenance |
| • | Deer Resistant |
| • | Full Sun |
| • | Upright |
Plant in full sun, average well-drained soil. be careful to not over water. It likes to dry out a bit between watering. Especially over the winter months, the plant generally does not survive soggy soils over the winter.
| string |