Hydrangea quercifolia Snow Queen™ Snow Queen™ Oakleaf Hydrangea from Prides Corner Farms

Hydrangea quercifolia Snow Queen™ ('Flemygea')

Snow Queen™ Oakleaf Hydrangea

» Pure white flowers bloom in July
» Large, dark green leaves
» Rigid stems
» Red-bronze fall color
» Exfoliating bark and orange buds create winter interest

Hardiness Zone:5-8
Height:4-6 ft
Spread:6-8 ft
Category:Shrub
Bloom Color: White Shades
Foliage Color: Green Shades

Performs well in all seasons. Pure white flowers beginning in July create a wonderful contrast to the large, dark green, oak-like leaves. Panicles are held erect on rigid stems. Striking red-bronze fall color. Exfoliating bark and orange buds create winter interest.

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 67.4 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 = 689
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price