select i.*, as2.state_abbr
from inventory_item_manage i
left outer join sheffields_2017.address_states as2 on (as2.state_name = i.CollectionLocale or as2.state_abbr = i.CollectionLocale)
where i.inventory_id = '1536'
group by i.id
Buying options
0.36 lb
CO
Details
Germination:
83%
Germination test:
estimate
Purity:
99%
Seeds per lb:
1,063,260
Quantity:
0.36 lb
Collected in:
Colorado
Crop year:
2017
Min. hardiness zone:
3
Item ID:
1824972
Native to: Alabama, Arkansas, Colorado, Connecticut, Delaware, District of Columbia, Georgia, Illinois, Indiana, Iowa, Kansas, Kentucky, Maine, Manitoba, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, New Brunswick, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Nova Scotia, Ohio, Oklahoma, Ontario, Oregon, Pennsylvania, Québec, Rhode I., South Carolina, South Dakota, Tennessee, Utah, Virginia, Washington, West Virginia, Wisconsin, Wyoming
Introduced to: Austria, Belarus, Belgium, Bulgaria, Czechoslovakia, Denmark, France, Germany, Great Britain, Greece, Hungary, Ireland, Italy, Kazakhstan, Krym, Netherlands, North Caucasus, Northwest European R, Norway, Poland, Romania, South European Russi, Sweden, Switzerland, Transcaucasus, Turkmenistan, Ukraine, Uzbekistan, Yugoslavia
Bring the beauty of the New England landscape to your garden with Symphyotrichum novae-angliae, also known as the New England Aster. This large and showy flowering plant is a herbaceous perennial that grows over 6 feet in height. Its hairy, clasping leaves are densely arranged on its stout stems, and bright, rose-purple flowers with orange-yellow centers bloom profusely at the tips of the leafy branches. The flower color varies from lavender and blue to white, and a pink variety of this species is sometimes grown commercially. Native to almost every area in North America east of the Rocky Mountains, the New England Aster is a must-have for any garden looking to add a splash of color and showiness to its landscape. Grow yours today and see why this magnificent plant has become a popular choice among gardeners.