Malus x LOLLIPOP® LOLLIPOP® Flowering Crabapple from Prides Corner Farms

Malus x LOLLIPOP® ('Lollizam')

LOLLIPOP® Flowering Crabapple

» Fragrant tree
» Disease resistant
» Attracts pollinators
» Attracts birds

Hardiness Zone:4-8
Height:8 in
Spread:8 in
Category:Tree
Bloom Color: White Shades
Foliage Color: Green Shades
Breeder:Proven Winners

True to its name, this useful crabapple is a confection of fragrant white flowers in spring perched on top of a sturdy trunk. Tiny, shiny red fruits in fall attract birds and wildlife. Thanks to its truly dwarf genetics, it perpetually maintains the neat form that will make homeowners everywhere fall in love with it.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price