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 = '1/12 & Smaller Tires') OR custom_subcat='1/12 & Smaller Tires')
Tires & Wheels
Pro-Line Hole Shot Off-Road Mini-T 2.0 Tires

$27.99
RC4WD 1.2" Dirt Grabber A/T Brick Edition Advanced X2S³ All Terrai...

$27.99
RC4WD 1.2" Rock Crusher M/T Brick Edition Advanced X2S³ Scale Tire...

$27.99
Team Associated CR12 Multi-Terrain Tires

$20.99
Team Associated CR12 Tioga Tires

$23.99
Team Associated NanoSport Pin Tires, black

$6.99
Team Associated NanoSport Pin Tires, blue

$6.99
Team Associated NanoSport Pin Tires, red

$6.99
Team Associated NanoSport Radial Tires, black

$6.99
Team Associated NanoSport Radial Tires, red

$6.99
Team Associated Narrow Mini Pin Tires, with inserts

$15.99
Team Associated Wide Mini Pin Tires, with inserts

$16.99
Team Associated Wide Wheels, black, pair

$8.99
Traxxas LaTrax Teton Tire

$13.99
Traxxas LaTrax Tires, slick

$8.99
Traxxas Tires, Bfgoodrich Rally

$17.99
Traxxas Tires, Canyon At 2.2' / Foam Inserts

$17.99
Traxxas Tires, Dual Profile

$21.99
Traxxas Tires, Response Pro 2.2' /Foam Inserts

$21.99
Traxxas Tires, Talon /Foam Inserts

$17.99