Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 3.8 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 != '472' and
g.genus = 'Syringa'
limit 1
id
1466

Scentara®

Syringa x hyacinthiflora 'Double Blue'

Sentara Double Blue Lilac

  • Flowering deciduous shrub
  • Purple blooms with blue highlights
  • Fragrant blooms
  • Excellent disease resistance

Proven Winners®
  • Category: Shrub
  • Alternate Cultivar: 'SMNSHBBL'
  • Patent: PP29801, Can PBRAF
  • Breeder: Proven Winners®
  • Hardiness Zone: 2-8
  • Height: 72-96 in
  • Spread: 72-96 in
  • Spacing: 72-96 in
  • Bloom Color: Blue, Purple
  • Foliage Color: Dark Green
Login for pricing

b

e

j

x

+

d

h

u

8

/