Current Criteria (Reset)
4 products found, 32 variants found. Jump To Items
Material=Bronze | |
Shape=Square | |
Grade=954 |
Jump To: Length
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 Material='Bronze' and Shape='Square' and Grade='954' And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other, Finish=Other
Length
Custom Lengths | 12" | 18" | 24" | 36" | 48" | 60" | 72" |
Items
Product | Shape | Grade | Thickness | Width | Wall |
---|---|---|---|---|---|
3/4" {A} Sq CA 954 Aluminum Bronze | Square | 954 | 3/4" |
1" {A} Sq CA 954 Aluminum Bronze | Square | 954 | 1" |
1-1/2" {A} Sq CA 954 Aluminum Bronze | Square | 954 | 1-1/2" |
2" {A} Sq CA 954 Aluminum Bronze | Square | 954 | 2" |