Made of lightweight ballistic nylon, our Molded Nylon Duty Gear is durable yet comfortable. You can be sure that your gear is protected. Molded foam interiors ensure that your gear fits and is easy to remove in a hurry. Hidden metal snap closures to ensure your gear will not fall or slip out. This pouch fits MK4 sprays.
Related Items..
Please Wait...
verifying & adding to your items to your shopping cart...
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` = '9NY-NP-MP-L') 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`