Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.12 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 != '277' and
g.genus = 'Magnolia'
limit 1
id
1273

Magnolia x brooklynensis 'Yellow Bird'

Yellow Bird Magnolia

  • Fragrant, bright yellow flowers
  • Rounded, pyramidal growth
  • Cucumber-like fruit
  • Vibrant fall color
  • Excellent specimen or accent

Login for pricing

A late bloomer but a favourite with rich dark golden-yellow flowers.

j

x

y

d

f

2

8