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 '%5x114.3%' or p.products_model like '%5x114.3%' or m.manufacturers_name like '%5x114.3%') )

[TEP STOP]

Jerry’s EVOX on 18×9.5 e20 Chameleon Grids

Owner: Jerry
Car: Mitsubishi Lancer Evolution 10
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e20/73)
Tires: 255/35/18 Nitto tires
Suspensions: BC coilovers, Rear adjustable toe & camber arms, Front & rear whiteline swap bar end links
Mods: Ets fmic
Ams exhaust w/test pipe
Ams intake
DW65c fuel pump
1000cc injectors
Cobb 3-port ebcs
Tuned by Evans Tuning on 93 octane
362 hp/364 torque

Clint’s 2017 WRX on 18×9.5 Rota Grids in custom Blue finish

Owner: Clint
Car: 2017 Subaru WRX
Wheels: 18×9.5 Rota Grid - (5×114.3/e38/73) in custom Blue finish
Tires: 255/35 federal rsr tires.
Suspensions: Cusco 26 mm front sway bar, Whiteline 22mm rear sway bar, Whiteline heavy duty endlinks
Mods: Levorg front bumper
Torque solutions tgv, egr deletes and pitch stop
Perrin Fmic and sump restrictor
Cobb cold air intake.
Mishimoto oil cooler
Superstik dip stick
Velox front spilter
Hella horns mounted in fog light location
Killer b catless jpipe
Arc grip exhaust with burnt tips
Perrin shift stop, short shift adapter and bushing
Boomba short throw shifter
Anarchy Goliath shift knob
STI interior

protuned by metro performance of so cal
Sponsored by wickedly bossted, superstik, reupdesigns,

instagram is @matatabi_wrx

Peter’s 2015 WRX on 18×8.5 Flat Black Grids

Owner: Peter
Car: 2015 Subaru WRX
Wheels: 18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)
Tires: 245/40 tires
Suspensions: stock

instagram is @PeterW64

In Stock Wheels - February 2018

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

Impreza WRX, BRZ, FR-S Wheels

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

Grid 17×7.5 e48 5×100 56.1 Gold

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

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

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

G-FORCE 17×8 e48 5X100 56.1 Flat BlackHyper BlackGunmetalGold

GRID 17×8 e35 5X100 73 Flat BlackHyper BlackWhiteSports Bronze

GRID 17×8 e44 5X100 73 Flat BlackGunmetalGoldHyper Black

Recce 17×8 e44 5×100 73 Flat BlackGunmetalWhite

Strike 17×8 e40 5×100 73 Flat BlackHyper Black

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

TITAN 17×8 e45 5X100 73 Flat BlackWhite

TORQUE 17×8 e48 5×100 56.1 Flat Black, Gunmetal, Hyper Black, Steel Gray, White

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

DPT 17×9 e42 5X100/114.3 73 Sports BronzeHyper Black

G-FORCE 17×9 e42 5X100 73  Gold

GRID 17×9 e30 5X100 73 Hyper Black

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

GRID 17×9 e42 5X100 73 Gold, Hyper BlackSports Bronze

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

P45R 17×9 e35 5×100 73 Flat Black, Hyper Black

RT5 17×9 e42 5×100 73 GoldSpeed BronzeWhite

SS10 17×9 e42 5X100 73 White

TITAN 17×9 e42 5X100 73 Flat BlackHyper BlackWhite,  Sports Bronze

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

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

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

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

G-FORCE 18×8.5 e48 5X100 56.1 Flat BlackGold

GRAVEL 18×8.5 e44 5X100 56.1 GunmetalGold

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

HG5 18×8.5 e44 5X100 73 GoldHyper Black

MXR 18×8.5 e44 5X100 73 Royal 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

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

SS10 18×8.5 e44 5X100 73 Hyper Black

Strike 18×8.5 e44 5×100 73 Flat Black

SVN 18×8.5 e48 5X100 56.1 Sports Bronze, Speed Bronze

TITAN 18×8.5 e44 5X100 73 Flat BlackHyper Black

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

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

G-FORCE 18×9 e35 5X100 73 Gold

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 ChameleonDeep RedFlat BlackGoldHyper BlackTitanium ChromeSpeed 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 Black, Hyper Black, Royal Hyper BlackRoyal WhiteRoyal Silver

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

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 Hyper BlackHyper SilverWhite

Strike 18×9.5 e38 5×100 73 Flat BlackHyper Black

SS10 18×9.5 e38 5X100 73 Sports BronzeHyper BlackWhite

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 BlackHyper SilverTitanium ChromeWhite

TITAN 18×10 e30 5×100 73 Flat Black, White

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

STi, WRX 2015 up Wheels

DPT 17×9 e42 5X100/114.3 73 Sports BronzeGoldHyper Black

GRID 17×9 e42 5X114.3 73 ChameleonFlat BlackSports BronzeGoldHyper Black, Speed Bronze, White

P45R 17×9 e25 5×114.3 73 Sports Bronze

RT5 17×9 e25 5×114.3 73 Flat Black

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

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

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

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

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

G-FORCE 18×8.5 e48 5X114.3 73 GoldHyper Black, White, Flat Black

GRID 18×8.5 e44 5X114.3 73 ChameleonFlat Black, GoldHyper BlackSpeed Bronze

MXR 18×8.5 e44 5×114.3 73 Royal Silver

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

SS10 18×8.5 e44 5X114.3 73 White

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

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

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

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

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 BlackHyper Black

GRID 18×9.5 e30 5×114.3 73 Hyper Black

GRID 18×9.5 e33 5×114.3 73 Hyper Black

GRID 18×9.5 e38 5X114.3 73 ChameleonFlat BlackGoldHyper BlackSpeed Bronze

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

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

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

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

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

REEV 18×9.5 e38 5×114.3 73 Gold

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

Strike 18×9.5 e38 5×114.3 73 Flat BlackHyper BlackGold

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

TORQUE 18×9.5 e20 5X114.3 73 Hyper 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 Flat Black

P45-r 18×10 e20 5×114.3 73 Royal Gunmetal

RT-5 18×10 e30 5×114.3 73 Hyper Black

STRIKE 18×10 e15 5×114.3 73 Hyper Black

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

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

EVO Wheels Wheels

GRID 18×9.5 e20 5X114.3 73 ChameleonFlat Black, Sports BronzeGoldHyper BlackTitanium Chrome, Speed Bronze

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

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

P45-R 18×10 e20 5×114.3 73 Flat Black. Royal 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 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

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

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

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

GRID 18×8.5 e42 5X108 73 Flat BlackHyper Black, Speed BronzeWhite

GRID 18×9.5 e38 5X108 73 ChameleonFlat Black, Hyper Black, White, Gold, Speed Bronze

KB-F 18×8.5 e42 5×108 73 Hyper Black

KB-R 18×9.5 e38 5×108 Flat BlackHyper 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 White

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×8 e40 4X108 73 Hyper Black

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

Porsche Super Carrera wheels

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

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

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 16×8 e0 6X139.7 hub 110 Flat BlackGunmetal

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

Charlie’s 2003 350z on 19×9.5/10.5 Rota Grids

Owner: Charlie
Car: 2003 Nissan 350z
Wheels: 19×9.5/10.5 Rota Grid - (5×114.3/e15F/e15R/73) in custom Black Chrome powder coating by Transwheel -Indiana
Tires: Nexan
Suspensions: D2 full race coil overs front and rear, Megan racing sway bars, links, rear camber adjusters and front tubular adjustable upper control arms
Mods: NRG Innovations anodized steel lugs
2010 370z 14″ Sport brake kit
Tenabe Medallion exhaust
06 350z HID’s
LED front bumper inserts
Smoked rears
Billet grille insert
Lower lip kit
Carbon Creations rear spoiler
Complete base clear re-spray

Interior:
Superbrightleds interior lighting
Pioneer head unit/Polk interior speakers with one 10″ sub in a custom box.
2 Rockford Fosgate Punch 500’s
Evo Evolution Recaro’s with SRS.
ISR Short shifter

Eng:
AEM cold air intake

Otherwise, stock for now……..

Nothing cut, nothing hacked. Just clean.

All work done by owner

Black Friday Sale 2017

Hi guys!

Listed below are limited in quantity, first payments first served. Hope everyone had a great Thxgiving day and hope you guys enjoy the rest of your weekend. Without any further delay:

$555.00 - D154 1680 4×100 20 RF YAMAHA BLACK
$647.00 - GRID 1795 4X114.3 12 FLT BLK RED LIP
$647.00 - GRID 1795 4X114.3 12 WHITE
$735.00 - G FORCE 1885 5X100 48 GOLD
$735.00 - G FORCE 1885 5X100 48 HYPER BLACK
$735.00 - G FORCE 1890 5X100 35 HYPER BLACK
$735.00 - G FORCE 1890 5X108 35 FLAT BLACK
$735.00 - G FORCE 1890 5X108 35 GUNMETALLIC
$735.00 - G FORCE 1890 5X108 35 WHITE
$615.00 - FLUSH 1580 4X100 20 FLAT BLACK
$615.00 - FLUSH 1580 4X100 20 RL HYPER BLACK
$695.00 - FLUSH 1790 4X114.3 12 WHITE
$695.00 - FLUSH 1790 5X100 42 RF SILVER
$695.00 - FLUSH 1790 5X114.3 25 RF SPORT BRZ
$735.00 - FLUSH 1895 5X100 38 RF SILVER
$735.00 - FLUSH 1895 5X100 38 RL GUNMETALLIC
$735.00 - FLUSH 1895 5X100 38 RL HYPER BLACK
$735.00 - HUCKGEE 1895 5X100 38 GOLD
$735.00 - KENSEI 1895 5X100 35 FLAT BLK
$735.00 - KENSEI 1895 5X100 35 RL SILVER
$900.00 - Staggered REAR: LC DYNA 1910 5X114.3 38 RF SILVER FRONT: LC DYNA 1985 5X114.3 30 RF SILVER
$735.00 - P45F 1880 5X114.3 48 HYPER BLACK
$747.00 - P45R 2 1810 5X114.3 10 MAGNESIUM BLK
$747.00 - P45R 2 1810 5X114.3 20 FLAT BLACK
$859.00 - P45R 3 1812 5X114.3 20 FLAT BLACK
$735.00 - PWR (G12) 1895 5X114.3 38 HYPER BLACK
$735.00 - ROKU 1885 10X100/114 44 GOLD
$735.00 - ROKU 1885 10X100/114 44 HYPER BLACK
$735.00 - ROKU 1895 5X100 38 FLAT BLACK
$735.00 - ROKU 1895 5X100 38 HYPER BLACK
$695.00 - RT5 1790 5X114.3 25 FLAT BLACK
$695.00 - SS10 1790 5X100 42 WHITE
$695.00 - SS10 1790 5X114.3 25 WHITE
$695.00 - SS10 1790 5X114.3 42 FLAT BLACK
$695.00 - SS10 1790 5X114.3 42 RF SPORT BRZ
$695.00 - SS10 1790 5X114.3 42 WHITE
$735.00 - SS10 1885 5X114.3 44 WHITE
$735.00 - SS10 1895 5X100 38 WHITE
$735.00 - SVN 1885 5X100 48 RF SPORT BRZ
$695.00 - STW 1780 5X100 44 RL GOLD
$695.00 - STW 1780 5X100 44 RL HYPER BLACK
$735.00 - TORQUE 1895 5X114.3 28 FLAT BLACK
$735.00 - VECTOR PRO 1895 5X100 38 HYPER BLACK

paypal: sales@wheeldude.com

if you want to pay via VISA/Mastercard or Credit card… email us at sales@wheeldude.com with first last name, email address, billing shipping address, phone number. We take visa or MasterCard and wheels you want to purchase. We will call you Monday to get payment information or you can call and leave the CC number, exp date and 3 digit number in the back to 510 969 9529.

Thx guys! Happy wheeling!

dude
Joseph@wheeldude

(NinjaxBart) Spencer’s 2016 Subaru WRX on PWR-RA 18×9.5 38 5X114.3 73 Hyper Black

Owner: Spencer
Car: 2016 Subaru WRX
Wheels: PWR-RA 18×9.5 38 5X114.3 73 Hyper Black
Tires: Cooper Zeon RS3-S, 255- 35 R18
Suspensions: stock

Spencer has a youtube channel, check him out put on his new kicks. Hyper black def. looks good on that white wrx!

End of Month Sale - September - $750 shipped

Hi Guys we have been blessed w/ some awesome pricing on a few wheels, we are passing the savings over. Here they are:

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

more pix @ https://dudesphotography.smugmug.com/Wheels/18×85-Rota-Roku-Flat-Black/

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


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


SS10 18×8.5 e44 5X114.3 73 White

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

Strike 18×9.5 e38 5×114.3 73 Hyper Black

Wheels listed above are $750 shipped to you ’til the end of the month.

Please contact us at sales@wheeldude.com or via text at (510) 969-9529.

***Sales expires end of the month.

New wheels soon!

- Wheeldude Team!

Peter’s 2015 WRX on 18×8.5 e44 Flat Black Grids

Owner: Peter
Car: 2015 Subaru WRX
Wheels: 18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)
Tires: 245/40 tires
Suspensions: stock

Matts 2016 WRX on 18×9.5 Chameleon Grids

Owner: Matt
Car: 2016 Subaru WRX
Wheels: 18×9.5 Rota Grid - Chameleon (5×114.3/e38/73)
Tires: 245/40/18
Suspensions: D2 Race Coilovers and Cobb front and rear sway bars

for more pix click here