Current Criteria (Reset)
14 products found, 112 variants found. Jump To Items
Material=Bronze | |
Shape=Round | |
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='Round' 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 |
---|---|---|---|---|---|
1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1/2" |
3/4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 3/4" |
1" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1" |
1-1/4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1-1/4" |
1-1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 1-1/2" |
2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 2" |
2-1/4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 2-1/4" |
2-1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 2-1/2" |
3" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 3" |
4" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 4" |
4-1/2" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 4-1/2" |
5" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 5" |
6" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 6" |
8" {A} Rd CA 954 Aluminum Bronze | Round | 954 | 8" |