WHERE (active = 1 AND custom_active = -1 OR custom_active = 1) AND last_square_price != 0 AND name NOT LIKE '%damage%' AND category NOT LIKE '%clearance%' AND subcat NOT LIKE '%clearance%' AND raw_table != 'CSV_hrp' AND ((custom_newcat = '' AND newcat = '' AND category LIKE '%Tires & Wheels%') OR (newcat = 'Tires & Wheels' AND custom_newcat = '') OR custom_newcat = 'Tires & Wheels') AND ((custom_subcat = '' AND subcat = 'Off-Road 2.8 Premounts') OR custom_subcat='Off-Road 2.8 Premounts')
Tires & Wheels
Pro-Line Badlands 2.8" All Terrain Tires Mounted on Raid Black 6x30...

$54.99
Pro-Line Badlands MX28 HP 2.8" All Terrain BELTED Truck Tires Mount...

$83.99
Pro-Line Badlands MX28 2.8" All Terrain Tires Mounted on Raid Black...

$69.99
Pro-Line Interco TSL SX Super Swamper 2.8" All Terrain Tires Mounte...

$74.99
Pro-Line Masher 2.8" All Terrain Tires Mounted on Raid Black 6x30 R...

$61.99
Pro-Line Sand Paw 2.8" Sand Tires Mounted on Raid Black 6x30 Remova...

$61.99
Pro-Line Sand Paw LP 2.8" Sand Tires Mounted on Raid Black 6x30 Rem...

$69.99
Pro-Line Trencher 2.8" All Terrain Tires Mounted on Raid Black 6x30...

$69.99
Pro-Line Trencher HP 2.8" All Terrain BELTED Truck Tires Mounted on...

$83.99
Pro-Line Trencher LP 2.8" All Terrain Tires Mounted on Raid Black 6...

$61.99
Traxxas Sledgehammer Tires & wheels, assembled, glued ...

$60.99
Traxxas Tires & Wheels, Assembled, Glued

$57.99
Traxxas Tires & Wheels, Assembled, Glued

$57.99
Traxxas Tires & Wheels, Assembled, Glued

$57.99
Traxxas Tires & wheels, assembled, glued

$39.99
Traxxas Tires & wheels, assembled, glued

$39.99
Traxxas Tires & wheels, assembled, glued

$37.99
Traxxas Tires & wheels, assembled, glued

$37.99
Traxxas Tires & wheels, assembled, glued

$53.99
Traxxas Tires & wheels, assembled, glued

$39.99