« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 66.3 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 = 10429 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 | ||
Graceful and eye-catching, Delphinium elatum Aurora™ Lavender lights up the garden with tall spires of soft lavender blooms accented by crisp white centers. Its strong stems and reliable growth make it a striking presence in borders or cutting gardens, while its long-lasting flowers draw in admiration from both gardeners and pollinators. A natural choice for adding height, elegance, and a touch of romance to the summer landscape.
| • | Green |
| • | Deer Resistant |
| • | Lavender |
| • | Early Summer |
| • | Upright |
| • | Average Water |
This Delphinium brings tall, elegant spires of soft lavender blooms with white centers, adding a dramatic touch to sunny gardens. Best in full sun with evenly moist, well-drained soil, this hardy perennial benefits from staking to support its tall stems. Deadhead spent flowers to encourage reblooming, and mulch to help retain moisture.
| string |