Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 9.06 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 != '334' and
g.genus = 'Pieris'
limit 1
id

Pieris japonica 'Forest Flame'

Forest Flame Pieris (Japanese Andromeda)

Brilliant red new growth, changes pink, then white, then finally green with profuse pendulous panicles.

  • Spring flowering evergreen shrub
  • New foliage is bright red then changes to pink then green
  • White flowers in early spring

Login for pricing

i

p

y

+

%

8