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 '%18x9.5_rota_dpt%' or p.products_model like '%18x9.5_rota_dpt%' or m.manufacturers_name like '%18x9.5_rota_dpt%') )

[TEP STOP]

In Stock Wheels - April 2018

Here are the wheels that we have in stock for the month of April 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 Flat BlackHyper BlackGold

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

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 Sports BronzeHyper 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

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

P45R 17×9 e35 5×100 73 Flat Black

RT5 17×9 e42 5×100 73 White

SS10 17×9 e42 5X100 73 White

TITAN 17×9 e42 5X100 73 Flat BlackHyper BlackWhite

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

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

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 BlackHyper BlackSpeed BronzeWhite

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

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

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 Flat BlackWhiteHyper Black, Sports Bronze

GRID 17×9 e42 5X114.3 73 ChameleonFlat BlackGoldSpeed 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

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 BlackGoldHyper BlackSpeed Bronze

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

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

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

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, Hyper Black

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 Black, Hyper Black

GARAGISTE 19×9 e34 5X114.3 43 Flat Black, Hyper 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 Flat BlackGoldHyper 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)

Jose’s 2015 Subaru STi Limited on 18×9.5 Rota DPT

Owner: Jose
Car: 2015 Subaru wrx sti limited
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e30/73) Gold
Tires: 245 40 18 Toyo Proxies
Suspension: Teins Flex’s z

Instagram: @hood_15sti



Jordan’s 2017 WRX on 18×9.5 e35 Rota DPT in Hyper Black

Owner: Jordan
Car: 2017 WRX
Wheels: 18×9.5 Rota DPT - Hyper Black (5×100x114.3/e35/73)
Tires: 245/40 tires
Suspensions: stock
Nameless muffler deletes
Subispeed f1 fog light
Olm foglights
Olm led headlights
C light upgrade
Perrin shift stop
Kartboy short shift kit
Diode dynamics led interior lighting
Shiftsolutions co shift knob
Protune

instagram is @1_slowrx

Mike’s 2017 Ford Focus RS /RS2 on 18×9.5 Rota DPT in Hyper Black

Owner: Mike
Car: 2017 Ford Focus RS /RS2.
Wheels: 18×9.5 Rota DPT - Hyper Black (5×108x114.3/e38/73)
Tires: 255/35/18 Continental ExtremeContact DWS06.
Suspensions: n/a
No Mods.. Yet

They Cleared the Brembo Calipers by about 1/16″ No spacers needed

Instagram: @FOCit.RS

Josh’s 2013 STi on Rota DPT 18×9.5 e44

Owner: Josh
Car: 2013 Subaru STi
Wheels: 18×9.5 Rota DPT - Flat Black (5×100x114.3/e44/73)
Tires: 265/35/18 Sumitomo htr ziii
Suspensions: Stock

Cobb sf intake invidia catted downpipe. Nameless performance catback muffler delete. Pro tuned by Corbin Johnson

@thestig719 2004 Subaru WRX on 18×9.5 e35 Rota DPT

Owner: @thestig719
Car: 2004 Subaru WRX
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e35/73) custom finish
Tires: 235/40/18
Suspension: BC Coilovers

Armando’s 04 STi on 18×9.5 e35 Rota DPT

Owner: Armando
Car: 2004 Subaru Impreza STi
Wheels: 18×9.5 Rota DPT - (5×100x114.3/e35/73) custom Red finish
Tires: 235/40/18

@anthony_trboxr 2014 WRX on 18×9.5 e35 Rota DPT

Owner: Anthony @anthony_trboxr
Car: 2014 Subaru WRX
Wheel: Rota DPT 18×9.5 5×100/114.3 e35 Hyper Black
Tires: 265/35/18

Incoming Wheels - Febuary

These wheels are coming in this Febuary 2015. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

Subaru WRX Wheels

18×8.5 Rota HG5 - Hyper Black (5X100/+44)

18×8.5 Rota HG5 - Gold (5X100/+44)

18×9.5 Rota HG5 - Gold (5X100/+38)

18×9.5 Rota HG5 - Hyper Black (5X100/+38)

18×8.5 Rota DPT - Hyper Black (5×100/114.3/+ 44)

18×8.5 Rota Grid -Flat Black (5×100/+ 44)

18×8.5 Rota Grid - Hyper Black (5×100/+ 44)

18×9.5 Rota Grid - Chameleon (5×100/+ 38)

18×9.5 Rota Grid - Deep Red (5×100/+ 38)

18×9.5 Rota Grid -Flat Black (5×100/+ 38)

18×9.5 Rota Grid - Hyper Black (5×100/+ 38)

18×9.5 Rota Grid - White (5×100/+ 38)

Ford Focus ST Wheels

18×9.5 Rota Grid - Hyper Black (5×108/+ 38)

18×9.5 Rota Grid - Chameleon (5×108/+ 38)

Mitsubishi EVOX, 350Z Wheels

18×9.5 Rota Grid - Deep Red (5×114.3/+ 20)

18×9.5 Rota Grid -Flat Black (5×114.3/+ 20)

18×9.5 Rota Grid - Gold (5×114.3/+ 20)

18×9.5 Rota Grid - Hyper Black (5×114.3/+ 20)

18×9.5 Rota Grid - White (5×114.3/+ 20)

Subaru STi

18×8.5 Rota DPT - Hyper Black (5×100/114.3/+ 44)

18×8.5 Rota Grid - Speed Bronze (5×114.3/+ 44)

18×9 Rota Grid - Flat Black (5×114.3/+42)

18×9 Rota Grid - Hyper Black (5×114.3/+42)

18×9.5 Rota Grid - Deep Red (5×114.3/+ 38)

18×9.5 Rota Grid -Flat Black (5×114.3/+ 38)

18×9.5 Rota Grid - Hyper Black (5×114.3/+ 38)

18×9.5 Rota Grid - White (5×114.3/+ 38)

FR-S, FT-86 and BRZ Wheels

18×8.5/9.5 Rota HG5 - Hyper Black (5X100/+44F/+38R)

18×8.5/9.5 Rota HG5 - Gold (5X100/+44F/+38R)

18×8.5/9.5 Rota Grid -Flat Black (5X100/+44F/+38R)

18×8.5/9.5 Rota Grid - Hyper Black (5X100/+44F/+38R)

Subaru WRX STi 2015, Mitsubishi EVO 8-9 Wheels

18×9.5 Rota HG5 - Hyper Black (5X114.3/+35)

18×9.5 Rota HG5 - Gold (5X114.3/+35)

Audi , Volkswagen Wheels

18×9 Rota Grid - Hyper Black (5×112/+40)

19×8.5 Linea Corse Dyna - Slate Blue (5×112/e40/73hb)

19×8.5 Linea Corse Dyna - Polished (5×112/e35/57.1hb)

Porsche Wheels

17×7.5/9 Linea Corse Fox - RSR Style High Polish(5×130/e35F/e16R/7 1.6)

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip (5×130/e35F/e16R/71.6)

BMW Wheels

19×8.5/10 Linea Corse LC818 - Satin Black (5×120 +30+37/72.6)

Incoming Wheels - March 2014

These wheels are coming in this March 2014. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

ROTA WHEELS

17×9 Rota DPT - Flat Black (5×100/114.3/e42/73)

17×9 Rota DPT - Hyper Black (5×100/114.3/e42/73)

17×9 Rota DPT - Sports Bronze (5×100/114.3/e42/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e22/73)

18×9.5 Rota DPT - Speed Bronze (5×100x114.3/e22/73)

18×9.5 Rota DPT - Flat Black (5×100x114.3/e35/73)

18×9.5 Rota DPT - Gold (5×100x114.3/e35/73)

18×9.5 Rota DPT - Speed Bronze (5×100x114.3/e35/73)

18×8.5 Rota Grid - Flat Black (5×100/e44/73)

18×8.5 Rota Grid - Hyper Black (5×100/e44/73)

18×8.5 Rota Grid - Speed Bronze (5×100/e44/73)

18×8.5 Rota Grid - White (5×100/e44/73)

18×9.5 Rota Grid - Chameleon (5×100/e38/73)

18×9.5 Rota Grid - Gold (5×100/e38/73)

18×9.5 Rota Grid - Hyper Black (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×100/e38/73)

18×9.5 Rota Grid - Flat Black (5×114.3/e20/73)

18×9.5 Rota Grid - Hyper Black (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

18×9.5 Rota Grid - White (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e38/73)

LINEA CORSE WHEELS

18×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip (5×100/e30/73)

RUNDFAHREN WHEELS

19×8.5/10 Rundfahren RM101 - Machined (5×114 +30+38)

19×8.5/10 Rundfahren RM101 - Machined (5×120 +30+37)