Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 4.69 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 != '253' and
g.genus = 'Lilium'
limit 1
id
1251

Lily Looks

Lilium asiaticum 'Tiny Rocket'

Tiny Rocket Asiatic Lily

Upward facing deep red flowers with strong green foliage. Bright and long lasting. Very showy.

  • Bold up-facing, red flowers
  • Dwarf, compact habit
  • Great for sunny border or rock gardens

  • Category: Perennial
  • Patent: PPAF
  • Hardiness Zone: 3-9
  • Height: 12-14 in
  • Spread: 10-12 in
  • Bloom Color: Red
Login for pricing

b

l

j

p

x

+

t

d

/