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

Malus domestica 'Braeburn'

Braeburn Apple Tree

Has a sweet flavour balanced with moderate tartness that produces a unique blend. The texture is crisp, firm and juicy. Fruit ripens in October.

  • CAN NOT BE SHIPPED TO THE US
  • Sweet flavor balanced with tartness
  • Crisp, firm and juicy
  • Semi-dwarf
  • Fragrant white flowers

Login for pricing
Attracts Wildlife
Attracts Butterflies
Attracts Songbirds
Exposure
Full Sun
Foliage Color
Green
Soil Moisture
Average Water
Attributes
Edible
Focal Point
Habit
Upright
Season of Interest (Flowering)
Spring