Chaenomeles speciosa Double Take® Scarlet Double Take® Scarlet Quince from Prides Corner Farms

Chaenomeles speciosa Double Take® Scarlet ('Scarlet Storm')

Double Take® Scarlet Quince: Patent PP20,951

» Big dark red double flowers
» Bright spring color
» Good cut flower
» Thornless
» Deer-resistant
» Heat tolerant
» Drought tolerant
» Great cut flower

Hardiness Zone:5-8
Height:36-48 in
Spread:36-48 in
Category:Shrub
Bloom Color: Red Shades
Breeder:Proven Winners

Ravishingly red double flowers do more than just decorate the early spring landscape; they resist deer and drought, and are magnificent in cut flower arrangements.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price