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

« Previous Plant  |  Next Plant »

Ilex verticillata 'Winter Red'

Winter Red Winterberry

  • »  Deep green foliage
  • »  Bright red berries in fall and winter
  • »  Dense, multi-stem form
  • »  Attracts birds

Deep green foliage and a bumper crop of bright red berries in the fall and winter along with a dense, multi-stem form make this plant an excellent choice for landscape borders. Easy care, excellent bird attracter.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 73.9 ms
Record Count: 3
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 = 702
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1ILEX VERTICILLATA `WINTER RED`100032807683430020.19SHRUBS: ILEX - holly/ winterberry124-30"#2020.19(5-9)19.18(10+)17.3670214170
2ILEX VERTICILLATA `WINTER RED`1001093069525290027.83SHRUBS: ILEX - holly/ winterberry118-21"#3027.83(5-9)26.44(10+)23.9370213739
3ILEX VERTICILLATA `WINTER RED`1002098006230040.81SHRUBS: ILEX - holly/ winterberry242-48"#5040.81(4-6)38.77(7+)35.170213916

Find a local garden center

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