Schizachyrium scoparium Little Bluestem from Prides Corner Farms

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

Schizachyrium scoparium

Little Bluestem

» Low maintenance
» Deer resistant
» Prefect for your rain-garden
» Cold Tolerant

Hardiness Zone:3-9
Height:2-4 ft
Spread:1-2 ft
Category:Perennial
Bloom Color: White Shades
Foliage Color: Blue Shades, Green Shades, Purple Shades, Bronze

This native grass is a kaleidoscope of colors throughout its long season- beginning in August and lasting through February. Pin straight, upright, slender blue-green leaves containing purplish-bronze racemes. Iconic, outstanding bronze-orange color emerges come fall, followed by puffy white seed heads in the winter. Truly an eye-catcher for multiple seasons!

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 28.9 ms
Record Count: 1
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 = 4655
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price