IMG
Loading..
Select a color
Olympic Zip-off Leg Cycling Pants
Item: 39OU-ZLP596

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

QTY:
List Price:
The Olympic Zip Leg Pants have all of the features of our traditional pants, with the side cargo pockets "short sized". The leg zippers are concealed between two fabric layers to protect your legs from irritation and chafing from the zippers. Short measurement is 6 1/2" standard. Please specify if you'd like 5" or 8". These pants are especially good for harbor Patrols, EMT's and anyone who does not always have time or a convenient place to change from pants into shorts.
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` = '39OU-ZLP596') 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`