Welcome, | Logout
IMG
Loading..
Select a color
Neese 4703RPT Reversible Trouser
Item: 3NE-4703RPT

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

QTY:
List Price:
The Safe Officer Series is comprised of ANSI 107-2015 certified garments within the public safety category of products. These garments will not only protect the wearer from cold, rain and wet conditions but also offer high visibility attributes for added safety.

Features:
  • Lightweight single ply polyurethane coated nylon
  • ANSI/ISEA 107-2015 Class E Certified
  • Reversible rain pant
  • 2” Silver 3M™ Scotchlite™ reflective film
  • Elastic waist
  • Plain front
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` = '3NE-4703RPT') 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`