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

Abies balsamea var. phanerolepis

Canaan Fir

A native evergreen Fir with short dark-green to blue-green needles. It has a narrow pyramidal form with upswept branches. It is primarily grown as a Christmas tree by the nursery trade but may be used as a specimen conifer in the garden.

  • Excellent needle retention
  • Beautiful Christmas tree
  • Prefers a cool soil temperature
  • Ideal as specimen or for screening

Login for pricing