« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 83.5 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 = 10400 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 | ||
Vibrant orange blooms rise above lush, tropical green foliage on this upright, architectural plant. Perfect for hot, humid climates, it thrives in the summer heat and delivers a long-lasting floral display that continues until the first frost. Its bold foliage stays fresh and green throughout the growing season, adding a striking, exotic touch to any garden.
This plant thrives in loose, nutrient-rich soil that stays evenly moist, but once established, it adapts well—even tolerating wet or poorly drained conditions. For best performance, grow it in full sun. If you'd like to overwinter it, you can bring it indoors and care for it as a houseplant with a little extra attention.
| string |