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 Wheels') OR custom_subcat='Off-Road 2.8 Wheels')
Tires & Wheels
JConcepts Rulux 2.8" Stampede...

$16.99
JConcepts Rulux 2.8" Stampede...

$16.99
JConcepts Rulux 2.8" Stampede, Rustler 2wd Rear Black Wheel

$16.99
JConcepts Rulux 2.8" Stampede, Rustler 2wd Rear White Wheel

$16.99
Pro-Line Raid 2.8" Black 6x30 Removable Hex Wheels for Stampede/Ru...

$29.99
Traxxas 12mm Hex Wheels, All-Star 2.8'

$13.99
Traxxas Wheels, All-Star 2.8'

$13.99
Traxxas Wheels, All-Star 2.8'

$13.99
Traxxas Wheels, All-Star 2.8'

$11.99
Traxxas Wheels, All-Star 2.8'

$11.99
Traxxas Wheels, All-Star 2.8'

$11.99
Traxxas Wheels, Rustler 4X4 2.8'

$10.99
Traxxas Wheels, Twin-Spoke 2.8'

$11.99
Traxxas Wheels, Twin-Spoke 2.8'

$11.99
Traxxas Wheels, Twin-Spoke 2.8'

$11.99