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_rota_grid%' or p.products_model like '%17x9_rota_grid%' or m.manufacturers_name like '%17x9_rota_grid%') )

[TEP STOP]

In Stock Wheels - June 2018

Here are the wheels that we have in stock for the month of June 2018. 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

- Truck Wheels

-5×112 pcd wheels

Impreza WRX, BRZ, FR-S Wheels

G-FORCE 17×7.5 e48 5X100 56.1 Flat Black

Grid 17×7.5 e48 5×100 56.1 Sports Bornze

Torque 17×7.5 e48 5×100 56.1 GoldSport BronzeFlat Black

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

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

G-FORCE 17×8 e48 5X100 56.1 Gold

GRID 17×8 e35 5X100 73 Flat BlackHyper BlackWhiteGold, Sports Bronze

GRID 17×8 e44 5X100 73 Flat BlackGunmetalHyper Black

Recce 17×8 e44 5×100 73 Flat BlackGunmetalWhite, Gunmetal Grey

STRIKE 17×8 e40 5×100 73 Flat Black, Hyper Black

STW 17×8 e44 5×100 73 Royal GoldRoyal Hyper Black

TITAN 17×8 e45 5X100 73 Flat BlackWhiteHyper Black

TORQUE 17×8 e48 5×100 56.1 Flat BlackGunmetalHyper BlackSteel GrayWhite

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

DPT 17×9 e42 5X100/114.3 73 Hyper Black

G-FORCE 17×9 e42 5X100 73  GoldHyper Black

GRID 17×9 e30 5X100 73 Hyper Black

GRID 17×9 e35 5X100 73 Flat BlackYamaha BlackHyper BlackSports Bronze, White

GRID 17×9 e42 5X100 73 Flat BlackGoldHyper BlackSports Bronze, White

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

P45R 17×9 e35 5×100 73 Flat Black

SS10 17×9 e42 5X100 73 White

TITAN 17×9 e42 5X100 73 Flat BlackHyper BlackWhite

TORQUE 17×8 e35 5×100 70 Hyper Black

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

GRAVEL 18×8 e48 5X100 56.1 Hyper BlackHyper SilverGold

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

DPT 18×8.5 e44 5×100/114.3 73 Hyper Black

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

G-FORCE 18×8.5 e48 5X100 56.1 Flat BlackGoldHyper BlackGunmetal

GRAVEL 18×8.5 e44 5X100 56.1 GunmetalHyper Black, Gold

GRAVEL 18×8.5 e44 5X100 73 Gunmetal, Hyper Black, Gold

GRID 18×8.5 e44 5X100 73 Flat Black, GoldHyper BlackSpeed Bronze

HG5 18×8.5 e44 5X100 73 GoldHyper Black

KB-F 18×8.5 e44 5×100 73 Yamaha BlackHyper Silver

MXR 18×8.5 e44 5X100 73 Royal Hyper Black

ROKU 18×8.5 e44 5X100 73 Flat BlackHyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Gold

RT-5 18×8.5 e44 5X100 73 Hyper BlackHyper Silver

SS10 18×8.5 e44 5X100 73 Hyper Black

Strike 18×8.5 e44 5×100 73 Flat Black, Hyper Black

SVN 18×8.5 e48 5X100 56.1 Sports BronzeSpeed Bronze

TITAN 18×8.5 e44 5X100 73 Flat BlackHyper Black

TORQUE 18×8.5 e40 5X100 73 Sports BronzeHyper Black

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

G-FORCE 18×9 e35 5X100 73 Flat BlackGunmetalGoldHyper Black

SVN 18×9 e40 5×100 73 Flat Black

SVN 18×9 e40 5×100/114.3 73 Hyper Black

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

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

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

GRID 18×9.5 e38 5X100 73 ChameleonFlat BlackSpeed BronzeWhite, Deep Red

HASHTAG 18×9.5 e38 5×100 73 Gold

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

KB-R 18×9.5 e38 5×100 73 Flat BlackGoldHyper BlackWhite

KENSEI 18×9.5 e35 5X100 73 Royal Silver

MXR 18×9.5 e38 5X100 73 Flat BlackHyper BlackRoyal Hyper BlackRoyal Silver, Royal Gold, Royal White, Gold

P1-R 18×95 e38 5×100 73 Hyper Black

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

ROKU 18×9.5 e38 5X100/114.3 73 Flat BlackGoldHyper Black

RT-5 18×9.5 e44 5X100 73 Hyper BlackHyper SilverWhite

Strike 18×9.5 e38 5×100 73 Flat Black, Hyper Black

SS10 18×9.5 e38 5X100 73 Sports BronzeHyper BlackWhite

TITAN 18×9.5 e38 5×100 73 Flat Black

TORQUE 18×9.5 e35 5X100 73 Sports BronzeHyper Black

TORQUE 18×9.5 e40 5X100 73 Hyper Black

VECTOR Pro 18×9.5 e38 5X100 73 GoldHyper Black

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

SVN-R 18×10 e30 5X100/114.3 73 ChameleonFlat Black Hyper BlackTitanium ChromeWhite

TITAN 18×10 e30 5×100 73 Flat Black

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

KB-R 19×9.5 e40 5×100 73 Flat Black

Linea Corse LC818 19×8.5/10 e38 5×100 73 Hyper BlackHyper Silver

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

STi, WRX 2015 up Wheels

DPT 17×9 e42 5X100/114.3 73 Hyper Black

GRID 17×9 e25 5×114.3 73 Chameleon, Flat BlackHyper Black, Sports Bronze, White

GRID 17×9 e42 5X114.3 73 ChameleonFlat BlackGold, Hyper Black, Speed BronzeWhite

MXR 17×9 e42 5×114.3 73 Hyper BlackRoyal Hyper Black

P45R 17×9 e25 5×114.3 73 Sports Bronze

RT5 17×9 e25 5×114.3 73 Flat Black

SS10 17×9 e25 5×114.3 73 White

SS10 17×9 e42 5X114. 3 73 Flat BlackSports BronzeWhite

TITAN 17×9 e35 5X114.3 73 Flat Black, Hyper Black

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

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

P45-F 18×8 e48 5×114.3 73 Hyper Black

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

DPT 18×8.5 e44 5×100/114.3 73 Hyper Black

G-FORCE 18×8.5 e48 5X114.3 73 GoldHyper BlackWhiteFlat BlackGunmetal, White

GRID 18×8.5 e44 5X114.3 73 ChameleonFlat BlackHyper BlackSpeed Bronze

KB-F 18×8.5 e44 5×114.3 73 Flat BlackHyper BlackHyper Silver

MXR 18×8.5 e44 5×114.3 73 Royal Hyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Gold

SS10 18×8.5 e44 5X114.3 73 White

STRIKE 18×8.5 e44 5×114.3 73 Flat BlackHyper Black

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

G-FORCE 18×9 e25 5×114.3 Gunmetal

G-FORCE 18×9 e30 5X114.3 73 GunmetalGoldHyper Black

SVN 18×9 e40 5×100/114.3 73 Hyper Black

TS-6F e40 5×114.3 73 Gunmetal

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

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

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

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

GRID 18×9.5 e30 5×114.3 73 Hyper Black

GRID 18×9.5 e32 5×114.3 73 Deep RedFlat BlackHyper Black

GRID 18×9.5 e33 5×114.3 73 Hyper Black

GRID 18×9.5 e38 5X114.3 73 ChameleonHyper BlackSpeed Bronze, Flat Black, Gold, Sports Bronze, White

HG5 18×9.5 e35 5X114.3 73 GoldHyper Black

KB-R 18×9.5 e38 5×114.3 Flat BlackHyper Silver , Hyper Black

KENSEI 18×9.5 e25 5X114.3 73 Royal Hyper BlackRoyal Silver

MXR 18×9.5 e38 5X114.3 73 Hyper BlackRoyal GoldRoyal Hyper Black

P1R 18×9.5 e30 5×114.3 73 Hyper Black

P-45R 18×9.5 e30 5X114.3 73 Flat BlackSports Bronze

PWR 18×9.5 e38 5×114.3 73 Hyper Black

REEV 18×9.5 e38 5×114.3 73 Gold

ROKU 18×9.5 e38 5X100/114.3 73 Flat BlackGoldHyper Black

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

Slipstream 18×9.5 e38 5×114.3 73 Flat Black

Strike 18×9.5 e38 5×114.3 73  Hyper BlackGold, Flat Black

SS10 18×9.5 e38 5X114.3 73 Flat BlackWhite

TORQUE 18×9.5 e20 5X114.3 73 Hyper Black

TORQUE 18×9.5 e28 5X114.3 73 Flat Black

TS-6R 18×9.5 e30 5×114.3 73 Gunmetal

TORQUE 18×9.5 e28 5X114.3 73 Flat Black

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

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

GRID 18×10 e30 5×114.3 73 Yamaha Black

P45-r 18×10 e20 5×114.3 73 Royal GunmetalFlat Black

STRIKE 18×10 e15 5×114.3 73 Hyper Black

SVN-R 18×10 e30 5X100/114.3 73 ChameleonFlat Black Hyper BlackTitanium ChromeWhite

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

GARAGISTE 19×8.5 e44 5X114.3 43 Flat BlackHyper Black

GARAGISTE 19×9 e34 5X114.3 43 Flat BlackHyper Black

KB-R 19×9.5 e40 5×114.3 73 Hyper Black

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

EVO Wheels Wheels

G-FORCE 18×9 e30 5X114.3 73 GunmetalGoldHyper Black

GRID 18×9.5 e20 5X114.3 73 ChameleonSports BronzeGoldHyper BlackTitanium ChromeSpeed BronzeWhite

MXR 18×9.5 e20 5X114.3 73 Royal GoldHyper BlackRoyal Hyper Black

P-45R 18×9.5 e20 5X114.3 73 Flat Black

P45-R 18×10 e20 5×114.3 73 Flat BlackRoyal Gunmetal

TORQUE 18×9.5 e20 5X114.3 73 Hyper Black

SVN-R 18×10 e30 5X100/114.3 73 ChameleonFlat Black Hyper BlackHyper SilverTitanium ChromeWhite

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

BMW Wheels

MXR 18×9.5 e8 5×120 73 Sports Bronze

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

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

Linea Corse z2s - 19×8.5/9.5 (5×120/+30/+35) Hyper Silver with polished Lip

Linea Corse z2s - 19×8.5/9.5 (5×120/+15/+20) Hyper Black with polished Lip

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

Lexus Wheels

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

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

GARAGISTE 19×9 e42 5X108 73 Hyper Black

G-FORCE 18×9 e35 5X108 73 WhiteFlat Black

GRID 18×8.5 e42 5X108 73 Flat BlackHyper BlackSpeed BronzeWhite

GRID 18×9.5 e38 5X108 73 ChameleonHyper BlackWhiteGoldSpeed Bronze, Flat Black, White

KB-F 18×8.5 e42 5×108 73 Hyper BlackYamaha Black, Hyper Silver, Flat Black

KB-R 18×9.5 e38 5×108 Flat Black

KB-R 19×9.5 e40 5×109 56.1 Hyper Black

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

RT5 18×8.5  e38 5×108 63.4 Flat Black

Strike 18×8.5 e42 5×108 73 Flat BlackSpeed Bronze, Hyper Black

Strike 18×9.5 e38 5×108 Flat BlackHyper Black

TITAN 17×8 e40 5X108 73 Hyper Black

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

Fiesta Wheels

GRID 17×8 e40 4X108 73 Flat BlackHyper BlackWhite, Hyper Blue

RECCE 17×8 e40 4×108 73 Flat Black

RT-5 18×9.5 e44 4X108 Titanium Chrome

Slipstream 16×7 e40 4×108 63.4 Flat Black

Strike 17×8 e40 4×108 73 Flat BlackHyper Black

TITAN 17×7.5 e45 4X108 63.3 Gold

TITAN 17×8 e40 4X108 73 GoldHyper Black

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

Porsche Super Carrera wheels

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

17×9/11 Linea Corse Fox - (5×130/e16/e16/71.6hb) RSR Finish

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

Truck Wheels

Grid Offroad 16×8 e20 6X139.7 hub 110 BronzeFlat Black, GunmetalHyper Black

Grid Concave 18×9 e42 6X139.7 hub 73 Hyper Black

Recce 18×8.5 e5 6×139.7 hub 110 Flat BlackHyper Black

Recce 18×9 e10 6X139.7 hub 110 Flat Black

Trail-R 17×8.5 e-17 6×139.7 hub 110 Speed Bronze

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

5×112 Wheels

17×9 Rota Grid - Hyper Black(5×112/42/57.1)

18×9.5 Rota DPT - Hyper Black (5×108x112/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×112/e38/73)

18×8.5 Rota KB-F - Hyper Black (5×112/e40/73)

18×9.5 Rota KB-R - Hyper Black (5×112/e40/73)

18×9.5 Rota KB-R - Yamaha Black (5×112/e40/73)

Spencer’s 2013 Scion FR-S on 17×9 +42 in Flat Black Grids

Owner: Spencer
Car: 2013 Scion FR-S
Wheels: 17×9 Rota Grid - Flat Black (5×100/e42/73)
Tires: Michelin Pilot Super Sport tires in 245/40/17
Suspension: Stance Super Sport coilovers (lowered about 2in)
SPC rear lower control arms
Mods: Jackson Racing C30 CARB legal supercharger
Delicious Tuning flex fuel kit
Verus front splitter with race upgrade

Brad’s 2014 BRZ on 17×9 e40 Chameleon Grids

Owner: Brad
Car: 2014 Subaru BRZ limited
Wheels: 17×9 Rota Grid - Chameleon (5×100/e40/73)
Tires: 245/40-17 Firestone Firehawk Indy’s
Suspension: KW v1 coilovers

$15 for a set of wheels!! really!

here is a link to our instagram post:

***HUGE CONTEST** We are doing a contest for all the Wheeldude IG followers! We are raffling off a set of Rota wheels. We will have a 5×100 and a 5×114 and 5×108 rs and st fitment for the winner to pick from. Raffle tickets cost $15 and is limited to two tickets per customer. We have a limited number of tickets set to 75! Payment needs to be sent via PayPal to sales@wheeldude.com please put a not with you first and last name along with email and phone number! We have ticket numbers for both you and us! On Sunday 11/13/17 we will be on IG live to pull the winning ticket! Ticket will be in a box and one ticket will be pulled. After the live drawing a picture of the winning ticket will be posted. To enter please send payment as friends and family so no fee is given. Please give us time to send you an email with you ticket and number! If we don’t get the 75 tickets we will extend the raffle for another 2 days. At that point if we don’t sell the 75 needed tickets we will refund all PayPal payments to customers! We have the following wheels .winner can pick from!
Rota Grid 17×9+42 5×100 Gold

Rota KB-R 18×9.5+38 5×108 hyper black

Rota Roku 18×8.5+44 5×100 hyper black

Rota strike 18×9.5+38 5×100 flat black

Matthew’s 2007 Subaru STi on 17×9 e42 Rota Grid in Flat Black

Owner: Matthew
Car: 2007 Subaru STi
Wheels: 17×9 Rota Grid - Flat Black (5×114.3/e42/73)
Tires: 245/40/17 Hankook Ventus V12 Evo2
Suspensions: Stock STI shocks/struts on RCE Black springs

Setup fits perfect, no rubbing (yet lol). Car looks way meaner, love this look. Really brings out the gold brembos!

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

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