You will be logged off in  seconds due to inactivity. Click here to continue your ordering session.

« Previous Plant  |  Next Plant »

Amelanchier × grandiflora 'Autumn Brilliance'

Autumn Brilliance Apple Serviceberry (Juneberry)

  • »  Great for formal or natural landscape
  • »  Spreading habit
  • »  Multi-stemmed
  • »  Great winter bark
  • »  Pure white spring bloom
  • »  Bright red fall foliage
  • »  Bird-attracting fruit
  • »  A hybrid between A. arborea x A. laevis

This selection has great attributes that add to the formal or natural landscape. Spreading and multi-stem in habit, it has great winter bark characteristics, pure white spring bloom, bright red fall foliage, and bird attracting fruit. A real winner!
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 60.8 ms
Record Count: 6
Cached: No
Lazy: No
SQL:
select h.program,
s.name,
s.udefSKUNameSuffix,
s.sku,
s.udefBannedStates,
s.udefBBL,
s.udefRR,
s.udefLR,
s.udefTimsTopTwenty,
s.udefJaimesHotList,
s.listPrice as price,
s.udefCategory as category,
s.udefComments as comments,
s.udefGrade as grade,
s.udefSpecial as special,
s.udefPlantSize as plantSize,
s.qtyUnit as size,
s.salePrice,
s.listPrice,
s.udefTier2,
s.udefTier2Price,
s.udefTier3,
s.udefTier3Price,
s.plantID,
s.id
from tb_plant_skus s
inner join tb_lists_hotlist h on (h.sku = s.sku)
where s.isactive = 1 and
s.delete_date is null and
s.isecommerce = 1
and s.plantID = 81
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1AMELANCHIER `AUTUMN BRILLIANCE` - CLUMPCLUMP FORM1007418006490031.12TREES: AMELANCHIER - serviceberry shadblow juneb223-26"#3031.12(5-9)29.56(10+)26.768114048
2AMELANCHIER `AUTUMN BRILLIANCE` - CLUMPCLUMP FORM1003267002630077.08TREES: AMELANCHIER - serviceberry shadblow juneb14-5'#7077.08(4-6)73.23(7+)66.298114652
3AMELANCHIER `AUTUMN BRILLIANCE` - SINGLESINGLE STEM10118620017200140.81TREES: AMELANCHIER - serviceberry shadblow juneb27-8'#150140.81(4-6)133.77(7+)121.18117664
4AMELANCHIER `AUTUMN BRILLIANCE` - CLUMPCLUMP FORM100468706000265Wholesale Yard B&B1-7/8' B+B02658120426
5AMELANCHIER `AUTUMN BRILLIANCE` - CLUMPCLUMP FORM1002075033800325Wholesale Yard B&B1-8/10' B+B03258120427
6AMELANCHIER `AUTUMN BRILLIANCE` - CLUMPCLUMP FORM1004155013000395Wholesale Yard B&B1-10/12' B+B03958121034

Find a local garden center

Within...
...of zip code:
.
Attributes
• Fall Color
Foliage Color
• Red
Attracts Wildlife
• Attracts Songbirds
Flower Color
• White
Season of Interest (Flowering)
• Spring
string