| Query Template: /plantsWL/qry_getSubstitutions.cfm:163 Execution Time: 9.56 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 != '514' and g.genus = 'Wisteria' limit 1 | ||
| id | ||
| 1 | 512 | |
Wisteria macrostachys 'Aunt Dee'
Aunt Dee Wisteria
A twining vine with spectacular light purple flowers that should be supported on a trellis or fence.
- Deciduous, woody, flowering vine
- Showy clusters of light purple flowers in spring
- Will climb on arbor, trellis or fence