Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 3.16 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 != '407' and
g.genus = 'Rosa'
limit 1
id
1406

Rosa palustris

Swamp Rose

Native. Many graceful arching branches on this shrub.  Full of fragrant pink blooms.

  • Best used in wet poorly drained soils
  • Fragrant, single pink blooms
  • Vibrant red fall color
  • Pea-sized red hips

  • Category: Rose
  • Hardiness Zone: 4-9
  • Height: 3-6 ft
  • Spread: 3-6 ft
  • Bloom Color: Pink
  • Foliage Color: Dark Green
Login for pricing

j

z

+

h

/

r