Products meeting the search criteria

1054 - Unknown column 'p.products_id' in 'on clause'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%17x9%' or p.products_model like '%17x9%' or m.manufacturers_name like '%17x9%') )

[TEP STOP]

In Stock Wheels - December

Here are the wheels that we have in stock for the month of December 2016. If you guys need anything please contact us in our new line at (510) 969-9529 SMS preferred or email us at sales@wheeldude.com

The following listings are available

- Impreza WRX, BRZ, FR-S Wheels

- STi, WRX 2015 up Wheels

- EVO Wheels Wheels

- BMW Wheels

- Lexus Wheels

- Focus Wheels

- Fiesta Wheels

- Porsche Super Carrera wheels

Impreza WRX, BRZ, FR-S Wheels

DPT 17×8 e48 5X100/114.3 73 Sports Bronze, Hyper Black

G-FORCE 17×8 e48 5X100 56.1 Flat Black, Gold, Hyper Black

GRID 17×8 e35 5X100 73 Flat Black, Sports Bronze, Gold, Hyper Black, White

GRID 17×8 e44 5X100 73 Flat Black, Gunmetal, Gold, Hyper Black

RECCE 17×8 e44 5X100 73 Flat Black, White

TITAN 17×8 e45 5X100 73 Flat Black, Hyper Black, White

TORQUE 17×8 e48 5X100 56.1 Flat Black

——————————————————————————-

DPT 17×9 e42 5X100/114.3 73 Sports Bronze, Gold, Hyper Black

FLUSH 17×9 e42 5X100 73 Machined, Royal Gunmetal, Royal Hyper Black, Royal White

GRID 17×9 e35 5X100 73 Flat Black, Sports Bronze, Yamaha Black, White

GRID 17×9 e40 5X100 Chameleon

GRID 17×9 e42 5X100 73 Sports Bronze, Hyper Black, White

GRID-V 17×9 e42 5X100 73 Sports Bronze, Hyper BlackSpeed Bronze

RT5 17×9 e42 5X100 73 Flat Black, Gold, Hyper Black, Speed Bronze , White

SS10 17×9 e42 5X100 73 Sports Bronze ,White

TITAN 17×9 e35 5X100 73 Flat Black

TITAN 17×9 e42 5X100 73 Flat Black, Hyper Black, White

TORQUE 17×9 e30 5X100 73 Sports Bronze, Hyper Black

——————————————————————————-

GRAVEL 18×8 e48 5X100 56.1 Gold, Hyper Silver

TARMAC3 18×8 e48 5X100 56.1 Hyper Black

——————————————————————————-

G-FORCE 18×8.5 e38 5X100 73 Gold, Hyper Black

G-FORCE 18×8.5 e48 5X100 56.1 Gold, Hyper Black

GRAVEL 18×8.5 e44 5X100 56.1 Gunmetal

GRID 18×8.5 e44 5X100 73 Flat Black, Gold, Hyper Black

HG5 18×8.5 e44 5X100 73 Gold, Hyper Black

MXR 18×8.5 e44 5X100 73 Hyper Black, Royal Hyper Black, Royal Silver

PWR 18×8.5 e44 5X100 56.1 Gunmetal, Hyper Black

ROKU 18×8.5 e44 5X100 73 Flat Black, Hyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

RT-5 18×8.5 e44 5X100 73 Hyper Black

SS10 18×8.5 e44 5X100 73 White

SVN 18×8.5 e48 5X100 56.1 TOMY Gold

TITAN 18×8.5 e44 5X100 73 Flat Black, Hyper Black

TORQUE 18×8.5 e40 5X100 73 Sports Bronze, Hyper Black

——————————————————————————-

G-FORCE 18×9 e35 5X100 Flat Black, Gold, Gunmetal, Hyper Black

GRID 18×9 e42 5X100 Flat Black, Hyper Black

——————————————————————————-

BOOST 2R 18×9.5 e35 5X100 73 Titanium Chrome

D2-EX 18×9.5 e38 5X100 73 BLK W/YMH BLK LIP

DPT 18×9.5 e35 5X100/114.3 73 Flat Black, Gold ,Hyper Black

DPT 18×9.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

FLUSH 18×9.5 e38 5X100 73 Machined, Royal Gunmetal, Royal Hyper Black

GKR 18×9.5 e38 5X100 73 Flat Black, White

GRID 18×9.5 e38 5X100 73 Chameleon, Deep Red, Flat Black, Gold ,Hyper Black, SLATE BLUE, Titanium Chrome, White

HG5 18×9.5 e38 5X100 73 Gold ,Hyper Black

KENSEI 18×9.5 e35 5X100 73 Royal Hyper Black, Royal Silver

MXR 18×9.5 e38 5X100 73 Flat Black, Gold, Hyper Black, Royal Gold,  Royal White

P-1R 18×9.5 e38 5X100 73 Gold, Hyper Black

Rundfahren RM110 18×9.5 e38 5X100 73 Machined

ROKU 18×9.5 e38 5X100 73 Flat Black, Hyper Black

ROKU 18×9.5 e38 5X100/114.3 73 Flat Black, Gold, Hyper Black

RT-5 18×9.5 e44 5X100 73 Gold, Hyper Black, Hyper Silver, White

SS10 18×9.5 e38 5X100 73 Hyper Black, White

T2-R 18×9.5 e38 5X100 73 Gold, Hyper Black

TITAN 18×9.5 e38 5X100 73 Flat Black, Gold, Hyper Black

TORQUE 18×9.5 e35 5X100 73 Sports Bronze, Hyper Black, White

TORQUE 18×9.5 e40 5X100 73 Sports Bronze, Hyper Black

VECTOR Pro 18×9.5 e38 5X100 73 Gold, Hyper Black

——————————————————————————-

SVN-R 18×10 e30 5X100/114.3 73 Chameleon, Flat Black, Hyper Black, Hyper Silver, Titanium Chrome ,White

——————————————————————————-

STi, WRX 2015 up Wheels

DPT 17×9 e42 5X100/114.3 73 Sports Bronze, Gold, Hyper Black

FLUSH 17×9 e42 5X114.3 73 Royal Gunmetal, Royal Hyper Black, RoyalWhite

GRID 17×9 e42 5X114.3 73 Flat Black, Sports Bronze, Gold, Hyper Black

SS10 17×9 e42 5X114. 3 73 Hyper Black, Flat Black, Sports Bronze, SLATE BLUE, White

TITAN 17×9 e42 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

——————————————————————————-

G-FORCE 18×8.5 e48 5X114.3 73 Gunmetal, Gold, Hyper Black, White

GRAVEL 18×8.5 e44 5X114.3 73 Hyper Black

GRID 18×8.5 e44 5X114.3 73 Flat Black, Gold, Hyper Black, Speed Bronze, White

MXR-F 18×8.5 e44 5X114.3 73 Royal SIlver

ROKU 18×8.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

SS10 18×8.5 e44 5X114.3 73 Flat Black, Slate Blue, White

SVN 18×8.5 e48 5X114.3 73 Chameleon, Flat Black

TITAN 18×8.5 e44 5X114.3 73 Flat Black

——————————————————————————-

G-FORCE 18×9 e30 5X114.3 73 Gunmetal, Gold, Hyper Black, White

——————————————————————————-

D2-EX 18×9.5 e38 5X114.3 73 Royal Silver

DPT 18×9.5 e35 5X100/114.3 73 Flat Black,  Gold, Hyper Black, Hyper Silver

DPT 18×9.5 e38 5X114.3/108 73 Hyper Black

DPT 18×9.5 e44 5X100/114.3 73 Flat Black, Gold, Hyper Black

FLUSH 18×9.5 e30 5X114.3 73 Flat Black, Machined, Royal Gunmetal, Royal Hyper Black

GRID 18×9.5 e38 5X114.3 73 Chameleon, Deep Red, Flat Black, Sports Bronze, Gold, Hyper Black, Speed Bronze, Titanium Chrome, White

HASHTAG 18×9.5 e38 5X114.3 73 Flat Black, Hyper Black, Gold

HG5 18×9.5 e35 5X114.3 73 Gold, Hyper Black

KENSEI 18×9.5 e25 5X114.3 73 Flat Black, Royal Hyper Black, Royal Silver

MXR 18×9.5 e38 5X114.3 73 Hyper Black, Royal Hyper Black

P-1R 18×9.5 e30 5X1143 73 Hyper Black

P-45R 18×9.5 e30 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

PWR 18×9.5 e32 5X114.3 73 Gold

PWR 18×9.5 e38 5X114.3 73 Hyper Black

REEV 18×9.5 e38 5X114.3 73 Gold,  Hyper Black

ROKU 18×9.5 e38 5X100/114.3 73 Flat Black, Gold, Hyper Black

ROKU 18×9.5 e38 5X108/114.3 73 GRAY Gunmetal

Linea Corse Lemans 18×9.5 e30 5X114.3 73 Royal Gold

Slipstream 18×9.5 e38 5X114.3 73 Gunmetal, Black, White

SS10 18×9.5 e38 5X114.3 73 Flat Black, Hyper Black, White

T2-R 18×9.5 e38 5X114.3 73 Titanium Chrome

TITAN 18×9.5 e35 5X114.3 73 Flat Black ,Hyper Black

TORQUE 18×9.5 e28 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

VECTOR PRO 18×9.5 e38 5X114.3 73 Gold

——————————————————————————-

SVN-R 18×10 e30 5X100/114.3 73 Chameleon, Flat BlackHyper BlackHyper SilverTitanium Chrome ,White

——————————————————————————-

EVO Wheels Wheels

GRID 18×9.5 e20 5X114.3 73 Chameleon, Deep Red, Flat Black, Sports Bronze, Gold, Hyper Black, Speed Bronze, Titanium Chrome, White

MXR 18×9.5 e20 5X114.3 73 Hyper Black, Royal Gold, Royal Hyper Black

P-45R 18×9.5 e20 5X114.3 73 Flat Black, Sports Bronze, Hyper Black

TORQUE 18×9.5 e20 5X114.3 73 Sports Bronze

SVN-R 18×10 e30 5X100/114.3 73 Chameleon, Flat BlackHyper BlackHyper SilverTitanium Chrome ,White

——————————————————————————-

BMW Wheels

Linea Corse Dyna - 19×8.5/10 (5×120/e30F,e37R) Polished

Linea Corse LC818 - 19×8.5/10 (5×120/e30F,e37R) Hyper SilverSatin Black,

Linea Corse LC910 - 19×8.5/10 (5×120 +35+43) Hyper Silver

Linea Corse Viten - 19×8.5/10 (5×120/e30F,e37R) Silver with Polished Lip

——————————————————————————-

Lexus Wheels

Linea Corse Dyna - 19×8.5/10 (5×114.3/e30F,e38R/73) Polished

Linea Corse Viten - 19×8.5/10 (5×114.3/e30F,e38R) Silver w/ Polished Lip

Linea Corse LC818 - 19×8.5/10 (5×114.3/e30F,e38R/73) Hyper SilverSatin Black

——————————————————————————-

Focus Wheels

G-FORCE 18×9 e35 5X108 73 White, Hyper Black, Gunmetal

GRID 18×8.5 e42 5X108 73 Flat Black, Hyper Black, Speed Bronze, White

GRID 18×9.5 e38 5X108 73 Flat Black, Hyper Black, Speed Bronze

HG5 18×9.5 e38 5X108 73 Flat Black

ROKU 18×9.5 e38 5X108/114.3 73 GRAY GunMetal

TITAN 17×8 e40 5X108 73 Hyper Black

TITAN 17×9 e40 5X108 73 Hyper Black

——————————————————————————-

Fiesta Wheels

GRID 17×8 e40 4X108 Flat Black

GRID 17×9 e42 4X108 Hyper Black

RT-5 18×9.5 e44 4X108 Titanium Chrome

TITAN 17×8 e40 4X108 Hyper Black

——————————————————————————-

Porsche Super Carrera wheels

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip, RSR Finish, Satin Black with Polished Lip

——————————————————————————-

Michael’s FR-S on 17×9 +42 Hyper Black Grids-V

Owner: Michael Allman
Car: Scion FR-S
Wheels:17×9 Rota Grid-V - Hyper Black (5×100/e42/73)
Tires: 245/40/17 Hankook Ventus RS3
Suspension: Fortune auto 500

Dustin’s 2016 Subaru BRZ on 17×9 e42 Sports Bronze Grids

Owner: Dustin Schoultz
Car: 2016 Subaru BRZ
Wheel Info: 17×9 Rota Grid - Sports Bronze (5×100/e42/73)
Tires: Hankook Ventus evo2 tires 245/40R17
Suspension: Tein FlexA coilovers approx. 1.5” drop
SPC lower control arms -2* camber front, -1.5* camber rear.

Wheels sit pretty much flush with fender. Looks awesome!!

Dillon’s 2014 Scion FRS on 17×9 Rota Grid-V in Speed Bronze

Owner: Dillon Shelburn
Car: 2014 Scion FRS
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: Hankook Ventus V12 Evo2 245/40/17
Suspension: ST Coilovers, SPL LCAs, Velox Top Hats.

Sam’s BRZ on Rotra Grid-V 17×9 +42 in Speed Bronze

Owner: Sam Le
Car: Subaru BRZ
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: 245/40/17
Suspension: ISR Coilovers

Awesome staggered wheel setup for your Porsche Super Carrera!

We hope to bring more wheel fun and enjoyment! If you guys need anything please contact us in our new line at (510) 969-9529 SMS preferred or email us at sales@wheeldude.com

17×7.5/9 Linea Corse Fox - (5×130/e35F/e16R/71.6)

Gloss black with polished lip

Owner: Joseph Quimson
Car: 1986 Porsche 911 Carrera,
Wheels: 17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip
Tires: 225/45/17, 245/40/17 Hankook Ventus Evo

RSR Finish

Owner: Cus
Car: 1986 Porsche Carrera
Wheels: 17×7.5/9 Linea Corse Fox - RSR Finish

DSC01915

Satin Black with Polished Lip

Chris’ 2015 WRX on 17×9 e35 Rota Titan in Flat Black

Owner: Chris
Car: Subaru WRX 2015
Wheel: 17×9 Rota Titan - Flat Black (5×114.3/e35/73)
Tire Size: 245/45/17
Suspension: Stock

Dean’s 2006 Subaru WRX on 17×9 Rota Torque e30 Hyperblack

Owner: Dean
2006 Impreza WRX Limited
Wheel Info: Rota Torque/ 17×9 / 5×100 / +30 / Hyperblack
Tires: Bridgestone Potenza 255/40/17
Suspension: SST coilovers
Additional Mods: Rolled and slight pull on rear fenders, slight roll on
front fenders.

Checkout this meaty setup! Took a little work but I say it was worth it! great job Dean! keep at it!

for higher rez pix, click here.

17×9 Rota Grid on 245/40/17 Falken Azenis FK453

Wheels: 17×9 Rota Grid - Gloss Black

Tires: 245/40/18 Falken Azenis FK453

18×9 Rota Grid on Kaden’s 2012 GTi

Car: 2012 Vw GTi

Wheels: 18×9 Rota Grid 5×112 e42 - Hyper Black

Tires: 235/40/18 Bridgestone Potenza re760

Kaden downsized from the 18×9.5 Rota Grid to the 18×9. He will surely enjoy this setups as he mobs back and forth to TX <<>> CA. Safe travels Kaden!

For higher rez pix, click here.