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

Abies concolor

Concolor Fir (White Fir)

Named after the pale colour of the needles, this silvery conifer shimmers.

  • Pyramidal evergreen
  • Long bluish grey needles
  • Loves the sun

  • Category: Tree
  • Height: 30-50 ft
  • Spread: 15-30 ft
  • Foliage Color: Blue-gray
Login for pricing

j

p

x

w

+

2

a

%

/

0