| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.9 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 = 9266 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 | ||
This easy-to-grow native perennial is at home in the sun or shade. For the best flowering plant in an area with at least 3 hrs of sunlight. Masses of pale blue-rayed, yellow-centered daises inject an electrifying burst of color in the late summer and autumn. Even better, butterflies love to visit its copious blooms!
| • | Native |
| • | Green |
| • | Deer Resistant |
| • | American Beauties Native PlantsĀ® |
| • | Upright |
Grows well in partial sun to partially shaded landscape average to dry soil. Occasional watering is required. At least 3 hours of sunlight is needed for good flowering.
| string |