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

Magnolia stellata 'Royal Star'

Royal Star Magnolia

  • Large, fragrant double white flowers
  • Yellow to bronze foliage in fall
  • Upright, medium-sized shrub
  • Use for mixed shrub borders

  • Category: Shrub
  • Hardiness Zone: 4-9
  • Height: 10-15 ft
  • Spread: 10-12 ft
  • Bloom Color: White
  • Foliage Color: Dark Green
Login for pricing

Produces multi-petaled, star-like blooms that are fragrant and pure white.

j

p

x

d

2

h

8

/