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

Rhus aromatica

Fragrant Sumac

  • Aromatic foliage
  • Vibrant, orange-red fall color
  • Yellow spring flowers
  • Great for erosion control

  • Category: Shrub
  • Hardiness Zone: 4-9
  • Height: 2-3 ft
  • Spread: 3-8 ft
  • Bloom Color: Yellow
Login for pricing

A native plant used for mass plantings. Small yellow blooms appear in April-May followed by edible, red berries. Foliage turns an outstanding orange in the fall.

b

1

q

j

p

x

y

+

2

h

/