« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28 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 = 8572 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 | ||
His Royal Highness will add a sense of royalty to your garden with beautiful royal purple blossoms. This new and improved Bearded Iris shows off its ruffled blossoms that rebloom late in the summer. It is deer and rabbit resistant, salt and drought tolerant, and makes excellent cut flowers.
| • | Border or Bed |
| • | Cut Flower/Foliage |
| • | Dried Flower/Foliage |
| • | Focal Point |
| • | Fragrant |
| • | Reblooming |
| • | Specimen |
| • | Green |
| • | Purple |
| • | Average Water |
Thrives in full sun. Well-drained soil is a must. Feed yearly with an organic fertilizer. Remove dead or damaged foliage and spent blooms as needed, and cut back foliage in fall to 6".
| string |