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

Paeonia lactifolia 'Miss Mary'

Miss Mary Peony

Large, single, very fragrant flowers that make a great cut flower. Deer resistant and attractive to butterflies.

  • One of the earliest hybrid peonies to bloom!
  • Very fragrant
  • Crimson, single flowers
  • Sturdy stems and deeply dissected leaves

  • Category: Perennial
  • Hardiness Zone: 3-8
  • Height: 18-24 in
  • Spread: 24-36 in
  • Bloom Color: Red
  • Foliage Color: Dark Green
Login for pricing