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

Crataegus laevigata 'Paul's Scarlet'

Paul's Scarlet Hawthorn

Hardy, dense rounded deciduous tree with arching branches. Fragrant, double red flowers in spring. Very attractive specimen tree.

  • Ornamental flowering tree
  • Fragrant, double flowers
  • Produces fruit, but sparingly
  • Upright, rounded form

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