IMG
Loading..
Select a color
Boys Long Sleeve Dress Shirt
Item: 8FT-SE9004
Brand: French Toast

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

QTY:
List Price:
    1. Cotton-blend oxford
    2. Mechanical stretch fabric
    3. Wrinkle No More fabric for easy care
    4. Expandable shirt collar
    5. Pearlized button closure
    6. Chest pocket
    7. Back pleat for easy movement
     8. Machine washable
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` = '8FT-SE9004') 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`