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

Magnolia cylindrica 'Marilyn's Choice'

Marilyn's Choice Magnolia

A strikingly columnar form of Magnolia cylindrica, this variety matures to just 5 to 8 feet across, making it perfect for tighter spaces. It produces hundreds of fragrant white upright blooms with vibrant rose-pink flares at the base, even at a young age.

  • A strikingly columnar form
  • Fragrant white upright blooms

Login for pricing

j

p

x

d

2

h

8

/