Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.87 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 != '119' and
g.genus = 'Clematis'
limit 1
id
1120

Clematis 'Stand By Me'

Stand By Me Bush Clematis

A great non-vining clematis with blue bell-shaped flowers, that continuously flower through out the summer. It attracts butterflies and bees and is deer and rabbit resistant.

  • Non-vining, bushy habit
  • Blue bell-shaped flowers
  • Best to stake or cage
  • Attracts hummingbirds

  • Category: Perennial
  • Hardiness Zone: 3-7
  • Height: 34-48 in
  • Spread: 24-28 in
  • Bloom Color: Blue
  • Foliage Color: Green
Login for pricing