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

« Previous Plant  |  Next Plant »

Ilex crenata 'Steeds'

Steeds Upright Japanese Holly

  • »  Strong, upright form
  • »  Great for foundation accent or hedging
  • »  Small, deep green foliage
  • »  Easy to care for and prune

Strong, upright growing form that's great for foundation accent or hedging. Small, deep green foliage adds to this plant's fine textured appearance, and its ease of care and pruning make it a snap to work with.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 53 ms
Record Count: 2
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 = 720
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1ILEX CRENATA `STEEDS`1000210022500037.60SHRUBS: ILEX - holly/ winterberry124-30"#3037.60(5-9)35.72(10+)32.3472014377
2ILEX CRENATA `STEEDS`10014070185700112.78SHRUBS: ILEX - holly/ winterberry130-36"#70112.78(4-6)107.14(7+)96.9972014185

Find a local garden center

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