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

[TEP STOP]

Brian’s STi on 18×9.5 e38 Chameleon Grids

Owner: Brian
Car: Subaru STi
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e38/73) with 5mm spacers front
Suspension: Feal 44

Other mods include:
-Accessport
-Cobb sf
-Cobb dp modded to catless
-ARK Grip catback
-Mishimoto inlet
-IAG AOS
-Id1000
-AEM 320
-Air pump delete
-AC delete
-FP Blue Turbo
-Grimmspeed uppipe
-Turbosmart wastegate
-Turbosmart 50/50 BOV
-Company 23 EBCS
-Radium fuel rails
-Fuelabs fuel pressure regulator
-Cobb flex fuel kit
-Custom AN fuel lines
-One step colder plugs
-Tomioka motor mounts
-Tomioka trans mount
-Cusco front strut tower brace
-Cusco lower control arms
-Cusco rear diff carrier
-Cusco rear diff collars
-Cusco battery Tie-down
-Kartboy Pitchstop mount
-Perrin wing risers
-Rota grids
-ARP 3″ wheel studs
-Muteki open-ended lug nuts
-Mishimoto weighted shift knob
-Sparco steering wheel
-NRG hub and quick disconnect
-Ati triple center gauge pod
-Rebel VLS AFR, Oil Temp, Boost Guage
-Kartboy Short shifter
-Kartboy shifter bushings
-Feal 441 Coilovers
-Painted Headlight housing
-Morimoto Halos Headlights/Fogs
-Morimoto Bluetooth Controller
-Rally Innovations Ultimate Rally Bar
-6″ pod lights
-12″ bar light
-Battle Aero Chassis Mount Wing
-Aeroflow Rear Quad Canards
-Seamless Designs Shift/E-brake boot
-Alpine head unit
-Kicker door speakers
-Alpine type R 10″ Sub
-Kicker 1200.1 amp
-Blue foot well LEDS
-Blue dome and map light LEDs

@sithevo8 2005 Mitsubishi Evolution VIII SSL on 18×9.5 e20 Flat Black Grids

Owner: Instagram @sithevo8
Car: 2005 Mitsubishi EVO 8
Wheels: 18×9.5 Rota Grid - Flat Black (5×114.3/e20/73)
Tires: 245/45/ZR18
Suspension: Megan Racing Track Series Coilovers

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)

Corrina’s 2014 Mitsubishi Evolution X on 18×9.5 e20 Chameleon Grids

Owner: Corrina
Car: 2014 Mitsubishi Lancer Evolution X MR
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)
Tires: 245/40/18 Toyo Proxes
Suspension: H&R Sport Springs
Mods:
ETS bolt ons: Intake, FMIC, UICP, Race Test Pipe, V2 Exhaust System
Grimmspeed Boost Controller
H&R Sport Springs
Rexspeed Dual Pillar
AEM Digital Boost & Wideband UEGO Gauges
Solleci UFO Dual Horns
Smoked LED Bumper Reflectors
ENGLISH RACING Tune

Fallen Angel’s 2010 EVOX on 18×9.5 e20 Rota Grid in Sports Bronze

Owner: Fallen Angel
Car: 2010 Mitsubishi EVOX
Wheels: 18×9.5 Rota Grid - Sports Bronze (5×114.3/e20/73)
Tires: 245/40/18

Joseph’s 2014 Focus ST on 18×9.5 e38 Hyper Black Grids

Owner: Joseph
Car: 2014 Ford Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: 235/40/18
Suspensions: stock
Mods: Cobb intake, Borla exhaust, Turbosmart bov and Rally armor mudd flap

Bryan’s 2017 Subaru STi on 18×9.5 +38 Hyper Black Grids

Owner: Bryan
Car: 2017 Subaru WRX STi
Wheels: 18×9.5 Rota Grid - Hyper Black (5×114.3/e38/73)
Tires: 245/40/18 Dunlop Sports Maxx
Suspensions: Stock (for now)
Mods: Rear fenders rolled, invidia q300 catback, invidia catted downpipe, Cobb acxessport, subispeed smoked sequential tail lights

Instagram: @bryty93

Jack’s 2015 Subaru STi on 18×9.5 e38 Gold Grids

Owner: Jack
Car: 2015 Subaru STi
Wheels: 18×9.5 Rota Grid - Gold (5×114.3/e38/73)
Tires: Falken Azenis FK510 255/35/18
Suspension: ISC Coilovers
Mods: Invidia Catless Downpipe
Tomei Ti Catback
Cobb V3 AccessPort
Cobb SF Intake
E-Tune
Front Lip
Rear Roof Vortex

David’s 2017 WRX on 18×9.5 Flat Black Grids

Owner: David
Car: 2017 Subaru WRX
Wheels: 18×9.5 Rota Grid - Flat Black (5×114.3/e38/73) with Custom 3D Red Carbon Fiber Vinyl Spokes
Tires: Michelin Pilot Super Sports 255/35/18
Suspension: stock
Mods: ETS Catback
Stage 1 91 Tune

Kenny’s 2015 WRX on 18×9.5 e38 Chameleon Grids

Owner: Kenny
Car: 2015 Subaru WRX
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e38/73)
Tires: 255/40
Suspension: Megan coilovers 10k front and rear, Rolled fenders, Not pulled.
Mods:Cobb V3 access port
Tuned by snail performance @30k
309 hp 346tq
Process west top mount vertacooler w/charge pipe
Grimspeed ebc
Mishimoto cold air intake
CNT catless downpipe
ETS catback exhaust no muff no res
Perrin steering lock out
Perrin solid shifter bushing
CS style front lip
OLM side skirts
OLM window spoiler
Oem rear spats
Rok block mud flaps
HT auto rear defuser
JDM front grill
projector fogs with halo iJdmtoy
Stillen trunk spoiler
JDM rain visor
Premium auto style emblem overlays
Chameleon tint on side emblems
Window tint 20%

Instagram: @Urabus2wrx44