IMG
Loading..
Select a color
Item# J140 Quilted-Flannel-Lined Duck Active Jac
Item: 1BR-J140
Brand: Broberry

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
When Old Man Winter and Mother Nature get all riled up, reach for our Duck Active Jac. It can handle what this fearsome twosome dishes out. Proudly made in the USA, its warm, versatile, and rugged. *12-ounce, heavyweight, firm-hand 100% ring-pun cotton duck *Body and attached hood are lined with quilted flannel for warmth *Quilted-nylon sleeves for warmth and easy in-and-out access *Two inside pockets; two large lower-front pockets *Rib-knit cuffs and waistband seal in warmth.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '1BR-J140') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`