IMG
Loading..
Select a color
Nylon 6-Panel Cap w/ Fleece Lining
Item: 2PR-6719

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

QTY:
List Price:
Features:
  • This is a water-repellent, nylon, 6-panel baseball cap. It has a pre-curved sandwiched visor and winter fleece lining. This cap is really unique because it features pull down ear flaps for extra warmth which are connected by an elastic band that goes across the back of your neck. It also has a stretch closed back with an adjustable buckle strap closure
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` = '2PR-6719') 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`