Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 7.7 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select g.id
from tb_plant_genusoverview_substitutions s
inner join tb_plant_genusOverview g on (g.id = s.genus_id)
where g.delete_date is null and g.isactive = 1 and
g.id != '214' and
g.genus = 'Ilex'
limit 1
id
1213

Ilex glabra 'Shamrock'

Shamrock Inkberry

A compact rounded cultivar. Suckers less than the species. A female plant that needs a male pollinator to produce attractive black berries

  • Bright green new foliage
  • Covered with black berries in winter
  • Excellent as hedge or border plant
  • Male pollinator required

Login for pricing