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

« Previous Plant  |  Next Plant »

Ilex crenata 'Green Lustre'

Green Luster Japanese Holly

  • »  Compact form
  • »  Dark, lustrous foliage
  • »  Very hardy

Hardiest of our Japanese holly selections, this plant's compact form and dark, lustrous foliage makes it handsome and functional. Wider spreading than tall, excellent for hedging and great alone.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 59.4 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 = 705
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1ILEX CRENATA `GREEN LUSTRE`1000209015000029.33SHRUBS: ILEX - holly/ winterberry121-24"#3029.33(5-9)27.86(10+)25.2270514369
2ILEX CRENATA `GREEN LUSTRE`100140505300058.99SHRUBS: ILEX - holly/ winterberry124-30"#5058.99(4-6)56.04(7+)50.7370520154
3ILEX CRENATA `GREEN LUSTRE`1008156024000117.23SHRUBS: ILEX - holly/ winterberry124-30"#100117.23(4-6)111.37(7+)100.8270519769

Find a local garden center

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