Schizophragma hyd. Moonlight Moonlight False Climbing Hydrangea from Prides Corner Farms

Schizophragma hyd. Moonlight

Moonlight False Climbing Hydrangea

» Pewter-blue foliage with green and pink veins
» Large, white, Hydrangea-like blooms in June
» Vigorous demeanor year-round

Hardiness Zone:5-8
Height:20-30 ft
Spread:10-15 ft
Category:Vine
Bloom Color: Blue Shades, White Shades

Be the first one in your area to carry this exciting, underused, handsome vine. The first thing you'll notice is 'Moonlight's' remarkable foliage, pewter blue in color, dissected by a network of green and pink venation. In June you'll rave about its big, white, Hydrangea-like blooms while you'll rave about its vigorous demeanor year round. See pages 14-15 for more information about the White Flower Farm program.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price