Juncus effusus Soft Rush from Prides Corner Farms

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

Juncus effusus

Soft Rush

» Small gold flowers bloom in summer
» Clump forming
» Provides nesting and cover for wetland birds
» Birds eat the seeds that form in the fall
» Thrives in wet areas - up to 6 inches of standing water

Hardiness Zone:2-9
Height:20-24 in
Spread:30-36 in
Category:Perennial
Bloom Color: Green Shades, Yellow Shades
Breeder:American Beauties Native Plants

Juncus effusus is a clump forming, wetland plant. Upright, fanning, deep green stems make a great accent in a container or water garden. Soft Rush can be planted at the edge of a pond or in up to 6" of standing water. Inconspicuous golden flowers appear atop the stems in summer. Native to most of North America, soft rush provides food and shelter for birds and other wildlife.

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 59.1 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 = 3748
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price