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

[TEP STOP]

In Stock Wheels - August 2019

Here are the wheels that we have in stock for the month of August 2019. If you guys need anything please contact us in our line at (510) 969-9529 SMS preferred or email 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, Gunmetal, Gold, Hyper Black

GRID 17×7.5 e48 5X100 56.1 Sports Bronze

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

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

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

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

GRID 17×8 e44 5X100 73 Flat BlackGunmetalHyper Black

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

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

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

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

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

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

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

GRID 17×9 e30 5X100 73 Hyper Black

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

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

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

P45R 17×9 e35 5×100 73 Flat Black

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

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

GRAVEL 18×8 e48 5X100 56.1 Hyper Black

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

DPT 18×8.5 e44 5×100/114.3 73 Hyper Black, Flat Black, Sports Bronze

G-FORCE 18×8.5 e38 5X100 73 Gold

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

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

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

GRID 18×8.5 e44 5X100 73 Hyper Black, White, Speed Bronze, Flat Black

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

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

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

SS10 18×8.5 e44 5X100 73 Hyper Black

Strike 18×8.5 e44 5×100 73 Hyper Black

SVN 18×8.5 e48 5X100 56.1 Sports Bronze,

SVN 18×8.5 e48 5X100 73 Speed Bronze

TFA-F 18×8.5 e44 5X100 73 Hyper Black

TITAN 18×8.5 e44 5X100 73 Flat BlackHyper Black

TORQUE 18×8.5 e40 5X100 73 Sports Bronze

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

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

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

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

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

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

HASHTAG 18×9.5 e38 5×100 73 Gold

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

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

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

RT-5 18×9.5 e35 5X100 73 Hyper Black, White

RT-5 18×9.5 e44 5X100 73 Flat Black, Hyper Black

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

TITAN 18×9.5 e38 5×100 73 Flat Black, Hyperr Black

VECTOR Pro 18×9.5 e38 5X100 73 Hyper Black

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

SVN-R 18×10 e30 5X100/114.3 73 ChameleonWhite, Flat Black, Hyper Black

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

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

Linea Corse LC818 19×10 e38 5×100 73 Hyper Black

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

STi, WRX 2015 up Wheels

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

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

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

P45R 17×9 e25 5×114.3 73 Sports Bronze, Hyper Black

RT5 17×9 e42 5×114.3 73 Speed Bornze

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

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

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

DPT 18×8.5 e44 5×100/114.3 73 Hyper Black, Flat Black, Sports Bronze

G-FORCE 18×8.5 e48 5X114.3 73 GoldFlat BlackGunmetal, Hyper Black

Gravel 18×8.5 e48 5×114.3 73 Gunmetal, Hyper Black

GRID 18×8.5 e44 5X114.3 73 Flat Black,  Gold, Chameleon, Hyper Black

KB-F 18×8.5 e44 5×114.3 73 Hyper Silver, Yamaha Black

MXR 18×8.5 e44 5×114.3 73 Matte Bronze w/ Sports Bronze lip

STRIKE 18×8.5 e44 5×114.3 73 Flat Black

SVN 18×8.5 e48 5×114.3 73 Flat Black, Hyper Black

TITAN 18×8.5 e44 5×114.3 73 Flat Black

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

G-FORCE 18×9 e25 5×114.3 Gunmetal

G-FORCE 18×9 e30 5X114.3 73 GunmetalGold, Hyper Black

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

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

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

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

GRID 18×9.5 e30 5×114.3 73 Hyper Black

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

HASHTAG 18×9.5 e38 5X114.3 73 Gold

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

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

P1R 18×9.5 e30 5×114.3 73 Hyper Black

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

PWR 18×9.5 e38 5×114.3 73 Hyper Black

SLIPSTREAM 18×9.5 e38 5×114.3 73 White, Flat Black, Full Royal Gunmetal

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

SS10 18×9.5 e38 5X114.3 73 White

Titan 18×9.5 e35 5×114.3 73 Hyper Black

Titan 18×9.5 e38 5×114.3 73 Hyper Black, Flat Black

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

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

GRID 18×10 e30 5×114.3 73 Flat Black

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

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

FFO1 19×8.5 e40 5X114.3 73 Hyper Black

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

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

LC818 19×8.5 e30 5×114.3 73 Satin Black, Hyper Silver

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

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

EVO Wheels Wheels

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

GRID 18×9.5 e20 5X114.3 73 Chameleon, Sports BronzeGoldSpeed BronzeWhite, Flat Black, Hyper Black, Slate Blue

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

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

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

BMW Wheels

FF01/02 19×8.5/10  (5×120/30F, 37R/72.6) Hyper Black

Linea Corse LC818 - 19×8.5/10 (5×120/e30F,e37R)  Satin 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 LC818 - 19×8.5/10 (5×114.3/e30F,e38R/73)  Satin Black

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

Focus Wheels

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

GARAGISTE 19×9 e42 5X108 73 Flat Black, Hyper Black

G-FORCE 18×9 e35 5X108 73 White

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

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

KB-F 18×8.5 e42 5×108 73 Yamaha Black, Flat Black

KB-R 18×9.5 e38 5×108 73 Hyper Black

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

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

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

Fiesta Wheels

GRID 16×7 e42 4×108 73 Flat Black, Hyper Black

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

RECCE 17×7.5  e40 4×108 63.3 Flat Black, Sports Bronze, Slate Gray

RECCE 17×8 e40 4×108 73 Flat Black, Gold, Slate Gray

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

TITAN 17×7.5 e45 4X108 63.3 Gold

TITAN 17×8 e40 4X108 73 Hyper Black, Flat 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, Hyper 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×108×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)

Nik’s 2104 Focus ST on 18×9 e35 Rota G-Force in Hyper Black

Owner: Nik
Car: 2014 Focus ST
Wheels: 18×9 Rota G-Force - Hyper Black (5×108/e35/73)
Tires: 225/40 indy fire hawks
Suspensions: BC Racing extreme drops coiler with massive camber arms
-2 degrees of camber in the front and -7 in the rear

Wheels on Sale

Here are the wheels that are on Sale. 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

Impreza WRX, BRZ, FR-S Wheels

HG5 18×8.5 e44 5X100 73 GoldHyper Black

ROKU 18×8.5 e44 5X100/114.3 73 Gold

ROKU 18×8.5 e44 5X100 73  Hyper Black

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

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

ROKU 18×9.5 e38 5X100 73 Hyper Black

SS10 18×9.5 e38 5X100 73 White

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

STi, WRX 2015 up Wheels

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

ROKU 18×8.5 e44 5X100/114.3 73 Gold

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

SS10 18×8.5 e44 5X114.3 73 White

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

New Rota Garagiste

19″ Rota Garagiste in Flat Black and Hyper Black.

Now Available!!!

19×8.5 e44 in 5X114.3 in Flat Black, Hyper Black
19×9 e34 in 5X114.3 in Flat Black, Hyper Black
19×9 e42 in 5X108 in Hyper Black

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

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

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

$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

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!

@chelsiecastetter 2014 Focus ST on 18×9.5 e38 Hyper Black Grids

Owner: @chelsiecastetter
Car: 2014 Ford Focus ST
Wheels: 18×9.5 Rota Grid - Hyper Black (5×108/e38/73)
Tires: 235/40/18 Eagle F1
Suspensions: Eibach lowering springs

Stage 1 Cobb tune with Cobb intake. Has a flowmaster catback. Boomba bov.

No fender mods were necessary to fit this wheel and tire setup.