Welcome, | Logout
IMG
Loading..
Select a color
Iona Lite Jacket - Us433
Item: 1PW-US433
Brand: PortWest

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

QTY:
List Price:
Durable and waterproof jacket with sealed seams Quilt lined for added insulation Storm flap fastened with snaps Reflective tape for visibility Fleece lined collar and knitted cuff to trap the heat Print access for garment customization Pockets: 2 front 1 cell phone 1 pen pocket 1 inner Drawcord hood and hem for comfort and snug fit Generous fit for wearer comfort 5 Pockets, Certified, Sealed seams, Pack-away hood, Cell phone, Mic tabs, EN342, EN343
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` = '1PW-US433') 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`