Welcome, | Logout
IMG
Loading..
Select a color
Rothco 8" Cold Weather Hiking Boots
Item: 6RT-5459
Brand: Rothco

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

QTY:
List Price:
Rothco 8" Cold Weather Hiking Boots are perfect for cold, snowy and wet conditions, these winter boots keep feet warm and dry. Rothco's patented Thermoblock technology provides insulation for warmth and the suede leather uppers offer comfortable protection from the elements. These cold weather boots also feature eva midsole, taped seams for waterproofing, and rubber outsoles that provide pliable traction in cold, wet and snowy conditions.
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-5459') 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`