Syringa vulgaris x Primrose Primrose Lilac from Prides Corner Farms

Syringa vulgaris x Primrose

Primrose Lilac

» Multi-stemmed, upright grower
» Spring clusters of creamy yellow flowers
» Light fragrance
» Hardy
» Great in the garden or in hedges
» Attracts butterflies and hummingbirds

Hardiness Zone:3-8
Height:12-15 ft
Spread:8-12 ft
Category:Shrub
Bloom Color: White Shades, Yellow Shades
Foliage Color: Green Shades

This multi-stemmed, upright grower is just as enticing for its spring clusters of dreamy, creamy yellow flowers as it is for its light fragrance. Place in your hedges or garden, and you will soon be as enamored of this hardy lilac as the butterflies and hummingbirds are.

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 29.1 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select h.program,
s.name,
s.udefSKUNameSuffix,
s.sku,
s.udefBannedStates,
s.udefBBL,
s.udefRR,
s.udefLR,
s.udefTimsTopTwenty,
s.udefJaimesHotList,
s.listPrice as price,
s.udefCategory as category,
s.udefComments as comments,
s.udefGrade as grade,
s.udefSpecial as special,
s.udefPlantSize as plantSize,
s.qtyUnit as size,
s.salePrice,
s.listPrice,
s.udefTier2,
s.udefTier2Price,
s.udefTier3,
s.udefTier3Price,
s.plantID,
s.id
from tb_plant_skus s
inner join tb_lists_hotlist h on (h.sku = s.sku)
where s.isactive = 1 and
s.delete_date is null and
s.isecommerce = 1
and s.plantID = 2009
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price