Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 3.41 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 != '451' and
g.genus = 'Sorbus'
limit 1
id
1452

Sorbus aucuparia 'Cardinal Royal'

Cardinal Royal Mountain Ash

A small, narrow, upright deciduous tree that produces small white flowers and brilliant red edible berries.

  • Small, narrow, upright habit
  • White flower clusters in spring
  • Showy reddish-orange berry-like clusters

Login for pricing
Attracts Wildlife
Attracts Songbirds
Exposure
Full Sun
Foliage Color
Green
Soil Moisture
Average Water
Attributes
Fall Color
Naturalizing
Specimen
Habit
Upright
Season of Interest (Flowering)
Spring