Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 4.12 ms
Record Count: 0
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 != '47' and
g.genus = 'Arctostaphylos'
limit 1
id

Arctostaphylos uva-ursi 'Vancouver Jade'

Vancouver Jade Bearberry

Plants form a dense mat of glossy evergreen leaves. Light pink bell-shaped flowers appear in spring, followed by a showy display of edible, scarlet berries. Foliage turns a beautiful bronze-red in winter.

  • Tolerates them well difficult sites well
  • Lovely draped over the edge of a wall or large rock
  • Small green leaves with silver grey backs

Login for pricing

j

p

8