Welcome, | Logout
IMG
Loading..
Select a color
Rothco Police Cut Resistant Lined Gloves
Item: 9RT-3452
Brand: Rothco

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

QTY:
List Price:
Rothco Police Cut Resistant Lined Gloves are made from genuine cowhide leather with a cut resistant lining sewn in to protect hands from knives, razor blades, and other sharp instruments. Shirred elastic hemming at the wrist keep these cold weather gloves secure for ultimate hand protection.
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` = '9RT-3452') 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`