Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 19 ms
Record Count: 2
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
1Bougainvillea-Barbara-Karst-Bougainvillea
2Campsis-radicans-Stromboli-Atomic-Red-Trumpet-Vine-
Atomic Red™ Trumpet Vine - Campsis radicans Stromboli from GCM Theme Three

« Previous Plant  | 

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

Atomic Red™ Trumpet Vine Details
Height 20 - 30 Feet
Zone 5-9
Color Red
Categories Vine

Check back soon for additional information on Atomic Red™ Trumpet Vine .

Check back soon for more in-depth details on Atomic Red™ Trumpet Vine .