IMG
Loading..
Select a color
Water-resistant Parka With Lightweight Half Mesh
Item: 1TM-9300
Brand: Tri-Mountain

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

QTY:
List Price:
100% Toughlan® nylon water-resistant parka with lightweight half mesh, half-Taffeta nylon lining. Features underarm zipper opening for extra ventilation, elastic cuffs with Velcro tabs for custom comfort, two side zipper pockets, upper left chest pocket and hood that is conveniently concealed in the collar.
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` = '1TM-9300') 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`