Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 14.4 ms
Record Count: 0
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 != '465' and
g.genus = 'Symphyotrichum (Aster)'
limit 1
id

Symphyotrichum (Aster) novae 'angliae'

New England Aster

This upright perennial boasts a profusion of showy daisy-like flowers that have rose-purple petals that surround sunny yellow centers.

  • Pretty purple blooms August to September
  • Good for rain gardens, native gardens, stream banks
  • Attracts butterflies

Login for pricing
Attracts Wildlife
Attracts Butterflies
Exposure
Full Sun
Foliage Color
Green
Attributes
Cut Flower/Foliage
Native
Habit
Upright