Welcome, | Logout
IMG
Loading..
Select a color
Rothco G.I. Style Speedlace Combat Boot
Item: 6RT-5094
Brand: Rothco

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

QTY:
List Price:
Rothco's Speedlace Combat Boot Features Black Leather Boot, Padded Collar, Removable Cushion Insole. The Boot Contains Steel Shank And Vulcanized Rubber Sole. This CA Proposition 65 Warning is to provide notice that this product contains chemicals known to the State of California to cause cancer and birth defects or other reproductive harm.
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` = '6RT-5094') 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`