Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 1.19 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 != '145' and
g.genus = 'Crocosmia'
limit 1
id
1144

Crocosmia x crocosmiiflora 'George Davidson'

George Davidson Montbretia

A hummingbird magnet! This brilliant hybrid has starry blooms that is very easy to grow.

  • Sword-shaped, basal foliage
  • Nodding, tubular flowers
  • Excellent cut flower

  • Category: Perennial
  • Hardiness Zone: 5-9
  • Height: 24-36 in
  • Spread: 6-12 in
  • Bloom Color: Yellow
Login for pricing

b

l

i

p

y

+

t

d

%