Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 1.37 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 != '111' and
g.genus = 'Chamaecyparis'
limit 1
id
1112

Chamaecyparis nootkatensis 'Glauca Pendula'

Weeping Blue Nootka False Cypress

Soft, pendulous blue-green foliage. Beautiful specimen tree.

  • Unique evergreen tree
  • Upright habit with pendulous branches
  • Flattened sprays of blue green foliage

  • Category: Evergreen
  • Hardiness Zone: 4-7
  • Height: 40-50 ft
  • Spread: 15-20 ft
  • Foliage Color: Blue-Green
Login for pricing

j

x

y

m

a