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 = 'Crawler - 1.9 Premounts') OR custom_subcat='Crawler - 1.9 Premounts')
Tires & Wheels
Pro-Line Hyrax 1.9" G8 Rock Terrain Truck Tires Mounted on Impulse ...

$59.99
Pro-Line Interco Bogger 1.9" G8 Tires Mounted on Impulse Black Plas...

$62.99
Pro-Line Interco TSL SX Super Swamper XL 1.9" G8 Tires Mounted on F...

$112.99
Pro-Line Hyrax 1.9" G8 Tires Mounted on Impulse Black Plastic Inter...

$59.99
Pro-Line Interco TSL SX Super Swamper XL 1.9" G8 Rock Terrain Truck...

$59.99
Traxxas Tires and wheels, assembled

$101.99
Traxxas Tires and wheels, assembled...

$115.99
Traxxas Tires and wheels, assembled...

$60.99
Traxxas Tires and wheels, assembled...

$62.99
Traxxas Tires and wheels, assembled...

$115.99
Traxxas Tires and wheels, assembled, glued for 1/16th vehicles

$26.99
Traxxas Tires and wheels, assembled, glued

$56.99
Traxxas Tires and wheels, assembled, glued

$52.99
Traxxas Tires and wheels, assembled, glued

$56.99
Traxxas Tires and wheels, assembled, glued

$52.99
Traxxas Tires and wheels, assembled, glued

$52.99