Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 0.913 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select g.id
from tb_plant_genusoverview_substitutions s
inner join tb_plant_genusOverview g on (g.id = s.genus_id)
where g.delete_date is null and g.isactive = 1 and
g.id != '91' and
g.genus = 'Campsis'
limit 1
id
192

Campsis radicans

Trumpet Vine

A self-clinging climber with orange-red trumpet blooms during summer months.

  • Woody vine that attaches to any surface
  • Hummingbirds feed on nectar
  • Orange-red trumpet-shaped flowers July-September

Login for pricing
Attracts Wildlife
Attracts Humming-birds
Exposure
Full Sun
Partial Sun
Soil Moisture
Average Water
Season of Interest (Flowering)
Summer