Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 9.79 ms
Record Count: 0
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 != '189' and
g.genus = 'Hamamelis'
limit 1
id

Hamamelis virginiana

Common Witch Hazel

A sturdy plant with small fragrant flowers in October-November sometimes lasting into December. The foliage turns to beautiful orange-yellow in the fall. North American native plant.

  • Open spreading habit with irregular branching
  • Bright golden yellow fall color
  • Fragrant creamy yellow flowers

  • Category: Shrub
  • Hardiness Zone: 4-9
  • Height: 15-30 ft
  • Spread: 15-25 ft
  • Bloom Color: Yellow
  • Foliage Color: Green
Login for pricing

j

x

m

d

f

*

8