You will be logged off in  seconds due to inactivity. Click here to continue your ordering session.

« Previous Plant  |  Next Plant »

Ilex x meserveae 'Berryific'

Berryific Holly

  • »  Colorful, pyramidal evergreen
  • »  Loaded with red berries each season

The marvels of modern planting have produced a plant that is guaranteed to be loaded with glorious red berries each season! A 'Blue Prince' and 'Blue Princess' are combined in close proximity creating a colorful, distinctive, pyramidal evergreen that satisfies all season long. Perfect for customers that want all their hollies to have berries or those whose space is limited and can't accommodate separate male and female plants.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 74.1 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 = 709
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1ILEX X MESERVEAE `BERRYIFIC`100788601121160017.99SHRUBS: ILEX - holly/ winterberry112-15"#2017.99(5-9)17.09(10+)15.4770913712

Find a local garden center

Within...
...of zip code:
.
string