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

Acer shirasawanum 'Yasemin'

Yasemin Full Moon Japanese Maple

An upright tree with deeply-lobed shiny purple-red leaves. By summer the foliage changes to bronze-red, then brilliant purple-red in fall.

  • Finely dissected leaves
  • Burgundy foliage all season
  • Ideal specimen for landscape

Login for pricing