IMG
Loading..
Select a color
Flying Cross Lapd Perfect Match Trouser
Item: 3FL-39489
Brand: Flying Cross

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

QTY:
List Price:
Perfect Match is Fechheimer's perfect answer to looking your best all day, every day you are in your uniform. By constructing shirts and trousers of the exact same fabric, they are guaranteed to match.

Feature:
  • 12 oz. 70% polyester/28% rayon/2% Lycra serge provides durability, comfort, mobility and shape retention with stretch
  • Imported
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` = '3FL-39489') 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`