Current Criteria (Reset)
3669 products found, 3669 variants found. Show All Items
![]() | Condition=Other |
![]() | Length=48 |
Jump To: Material Shape Grade Finish
All items with these criteria are: Thickness=Select Convert(Int, Thickness) TheField, Count(DISTINCT Product.ProductID) TheCount FROM Product with (NOLOCK) INNER JOIN ProductVariant with (NOLOCK) On Product.ProductID = ProductVariant.ProductID WHERE Condition='Other ' and Length=48 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
![]() Alloy {76} | ![]() Aluminum {680} | ![]() Brass {190} | ![]() Bronze {82} | ![]() Cast Iron {53} |
![]() Copper {81} | ![]() Stainless Steel {721} | ![]() Steel {1433} | ![]() Tool Steel {353} |
Shape
![]() Angle {127} | ![]() Channel {44} | ![]() Flat {1413} | ![]() Hexagon {114} | ![]() Rectangular Tube {77} |
![]() Round {1138} | ![]() Round Pipe {39} | ![]() Round Tube {428} | Square {194} | ![]() Square Tube {95} |
Grade
Finish
Cold Finished {689} | De-Carb Free {353} | Hot Finished {53} | Hot Rolled {409} |
Other {2116} | Turned Grnd & Polished {49} |