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

Ulmus japonica x pumila 'New Horizon'

New Horizon Elm

Upright rapid grower that is tolerant of urban conditions. Dark green summer foliage turns rusty red in the fall. Highly resistant to Dutch elm disease.

  • Highly resistant to Dutch Elm Disease
  • Upright, rapid grower
  • Red fall color
  • Excellent choice for street tree

Login for pricing

e

j

x

2

*

%

8