Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 5.73 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 != '260' and
g.genus = 'Liriope'
limit 1
id
1259

Liriope spicata

Creeping Lily Turf

Strap-like dark green leaves turn bronze in winter and produce ornamental black berries. Effective planted under shallow-rooted trees and along streams or ponds.

  • Straplike 18-inch dark green leaves
  • Turns bronze-green in winter
  • Violet to white flowers in mid to late summer

Login for pricing

i

j

p

9

+

t

2

a

*

8