Welcome, | Logout
IMG
Loading..
Select a color
Horace Small 100% Cotton 4-pocket Trouser
Item: 3HS-HS2724
Brand: Horace Small

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

QTY:
List Price:
For a great looking outfit, pair our button front shirt with this 4 Pocket Pant. Features include a 2" wide 100% cotton waistband with two silicone beads, soil-release finish for crease retention, bartacks at all stress points, and front crotch lining. Women's pant has elastic waist inserts. Garment uses the exact fabric and construction required to meet the NFPA 1975 standard.
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` = '3HS-HS2724') 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`