Current Criteria (Reset)
2116 products found, 2116 variants found. Show All Items
![]() | Finish=Other |
![]() | Length=48 |
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 Finish='Other ' and Length=48 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other
Material
![]() Aluminum {680} | ![]() Brass {190} | ![]() Bronze {82} | ![]() Copper {81} | ![]() Stainless Steel {721} |
![]() Steel {362} |
Shape
![]() Angle {71} | ![]() Channel {15} | ![]() Flat {694} | ![]() Hexagon {66} | ![]() Rectangular Tube {77} |
![]() Round {528} | ![]() Round Pipe {39} | ![]() Round Tube {428} | ![]() Square {103} | ![]() Square Tube {95} |
Grade
110 {81} | 17-4 (type 630) {43} | 2011 {38} | 2024 {106} |
303 {169} | 303 Bearing Shaft {12} | 304 {302} | 316 {126} |
360 {165} | 416 {34} | 420 {15} | 440 {20} |
6061 {430} | 6063 {47} | 7075 {59} | 932 {23} |
954 {59} | Other {387} |