Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 13.6 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 'Mountain Fire'

Mountain Fire Japanese Pieris

  • Fragrant, white flower clusters
  • Great for mass plantings
  • Upright, mounding habit
  • Ideal for the shrub border

Login for pricing

A rounded evergreen shrub that has fiery red new growth and drooping panicles. Prefers acidic soil.

@

e

i

p

x

]

+

a

%

u

8

/