| Query Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38 Execution Time: 6.23 ms Record Count: 1 Cached: No Lazy: No SQL: select p.friendlyURL as myval from tb_users_plants p where p.isactive and p.displayOnWebsite = 1 and isnull(p.deleteDate) and userID = 3829 and p.type = 'Vine' group by p.friendlyURL order by p.NameLine2, p.nameLine1 | ||
| myval | ||
| 1 | Campsis-radicans-Stromboli-Atomic-Red-Trumpet-Vine- | |
Campsis radicans Stromboli
Atomic Red™ Trumpet Vine
- Dark red buds open to orange-red trumpet like flowers
- It will vigorously grow on stone, woodwork or an arbor
- A terrific vertical accent, adding color to a sunny wall or fence
3 Gallon - $49.99
| Atomic Red™ Trumpet Vine Details | |
|---|---|
| Height | 20 - 30 Feet |
| Zone | 5-9 |
| Color | Red |
| Categories | Vine |
| Breeder | First Editions |
Check back soon for additional information on Atomic Red™ Trumpet Vine .
Check back soon for more in-depth details on Atomic Red™ Trumpet Vine .