Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 8 ms
Record Count: 7
Cached: No
Lazy: No
SQL:
select p.friendlyURL as myval
from tb_users_plants p
where p.isactive and p.displayOnWebsite = 1 and isnull(p.deleteDate) and userID = 3829
and p.type = 'Genus General Cards'
group by p.friendlyURL
order by p.NameLine2, p.nameLine1
myval
1Angelmist-Series-Angelonia-Summer-Snapdragon
2Aster-Dragon-Aster
3Calibrachoa-Callie-Series
4Multiple-Varieties-Angelonia
5Multiple-Varieties-Pansy
6Plantain-Lillies-multiple-varieties-Hosta
7Viola-x-wittrockiana-Yellow-Cool-Wave-153-Pansy
Aster - Aster 'Dragon' from Landscaper Theme Three

« Previous Plant  |  Next Plant »

Aster 'Dragon'

Aster

  • Wonderful color addition to any garden
  • Flowers appear mid fall
  • Adds color in late summer and fall

Aster Details
Height 12 - 18 in
Spread 15 - 18 in
Zone 3-8
Color Multi-Color
Categories Genus General Cards
Breeder Syngenta