Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.51 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 'Fireside'

Fireside Apple Tree

A greenish-yellow skinned apple heavily streaked and blushed with red. Flesh is crisp and juicy on this dessert or baking apple. Long-keeping. Ripens early October.

  • CAN NOT BE SHIPPED TO THE US
  • Good for eating
  • Pink flowers in spring
  • Large, red striped fruit
  • Sweet, pleasant flavor

Login for pricing
Exposure
Full Sun
Foliage Color
Green
Attributes
Disease Resistant
Edible
Low Maintenance
Habit
Upright
Season of Interest (Flowering)
Spring