Malus 6 - in -1 Cold Climate 6 - in -1 Cold Climate Apple from Prides Corner Farms

Malus 6 - in -1 Cold Climate

6 - in -1 Cold Climate Apple

» 6 varieties of apples grafted onto 1 tree
» Eliminates pollination and space concerns
» Bountiful harvest and outstanding variety

Hardiness Zone:4-8
Height:10-20 ft
Spread:10-20 ft
Category:Edibles

Save room and pollination concerns with the 6-in-1 cold climate apple created from grafting from an assorted selection of cold climate hardy apples. These are the varieties that are used in the grafting: Braeburn, Cortland, Fuji, Gala, Granny Smith, Gravenstein, Jonagold, Jonathon, Melrose, Red Delicious, Red McIntosh, Spartan, Yellow Delicious, Yellow Transparent, and Winesap. Six of these varieties are grafted on the same plant!! Get ready for a bountiful harvest and outstanding variety all for the price of one....that's a bargain in any economy!

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price