| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 109 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 = 4730 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 native plant offers a shiny evergreen sedge that forms a gracefull, fountain-like mound. It is perfect for shadier spots in the garden, woodland gardens or along a path. It is deer resistant, attracts butterflies, and also has seeds enjoyed by turtles.
| • | Green |
| • | Attracts Butterflies |
| • | Deer Resistant |
| • | American Beauties Native Plants® |
| • | Spring |
| • | Full Shade |
| • | Mounding |
| • | Moist, Well-Drained |
Should be planted in shady area with well drained soil. When the spring bloom is finished it can be cut back to keep tidy.
| string |
