Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.57 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 != '307' and
g.genus = 'Paeonia'
limit 1
id
1305

Paeonia suffruticosa 'Shimadaijin'

Shimadaijin Tree Peony

Fragrant and delicately ruffled, these intense purple blooms are sure to attract attention as a focal point in the garden. These are beautiful as cut flowers.

  • Old-fashioned garden favorite
  • Wonderful long lasting cut flower
  • Glossy green lobed foliage

Login for pricing

@

p

x

+

d

h

8

/