Hydrangea quercifolia 'Snowcicle' Snowcicle Oakleaf Hydrangea from Prides Corner Farms

Hydrangea quercifolia 'Snowcicle'

Snowcicle Oakleaf Hydrangea: Patent PP33,072

» Foliage turns red and orange in fall
» Plant multiple to create a small hedge

Hardiness Zone:6-9
Height:4-6 ft
Spread:4-6 ft
Category:Shrub
Bloom Color: Green Shades, Red Shades, White Shades

Bring the winter memories of snow and icicles into your summer garden with the large, thick, white and green panicles that drape over this summer shrub, ‘Snowcicle’. Watch as the luscious green and white color ages into a red-wine and burnt-orange color in the fall giving a multi-seasonal display.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price