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

[TEP STOP]

The Dude wanted 18×8.5 +44 Grids in Slate Grey on his STi

Name: The Dude’s
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota Grid - Slate Grey (5×114.3/e44/73)
18×8.5 Rota Grid - White (5×114.3/e44/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Coilovers

Time for a new color, this time it’s the Slate Grey making an appearance on the STi!

wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery

Spotlight: Zach Gill’s Mazdaspeed 3 on 18×8.5 G-Forces

For more information on the wheel: 18×8.5 Rota G-Force - Hyper Black (5×114.3/e48/73)

http://www.wheeldude.com/catalog/product_info.php?products_id=6294

Eugene’s ‘11 WRX on 18×8.5 Rota Grid Wheels in Hyper Black

Owner name: Eugene Suhh
Car/Year: 2011 WRX sedan
Wheel: 18×8.5 Rota Grid - Hyper Black (5×100/e44/73)
Tire: 235/40ZR18 Continental ExtremeContact DW
Suspension mods: Stock (for now)

Eugene is happy with the purchase of his new 18×8.5 Rota Grids as he really liked how the wheels fill out the wheel wells much better and give his car a more aggressive look. The larger rim size also shows off his Brembo brake upgrade advantage. From the photos, he has no reason to not enjoy the new wheels he selected for his car!

wheeldude.com Gallery
wheeldude.com Gallery

Something New - Dallas’ 2012 Impreza Sport on 18×8.5 DPT’s

Owner: Dallas
Car: 2012 Subaru Impreza Sport
Wheels: 18×8.5 Rota DPT - Flat Black (5×100x114.3/e44/73)
Tires: 225/40/18
Suspension: Stock

We posted a teaser picture of this car on our Facebook yesterday. The picture got a lot of negative comments which we already expected since that is always the case whenever a new body style comes out. Nonetheless, we think Dallas’ car looks awesome! The black car and flat black wheels really go well with each other.

Dude’s 06 STi on 18×8.5 Rota Grid Wheels in White right now!

Name: TheDude’s
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota Grid - White (5×114.3/e44/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Coilovers

Enough of the Flat Black! The Dude said it’s time for the White Rota Grids in 18×8.5!! Everything fits correctly, no rubbing!

wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery

Dude’s 06 STi on 18×8.5 Rota Grid Wheels in Flat Black

Owner: The Dude’s
Car: 06 Subaru STi
Wheels: 18×8.5 Rota Grid - Flat Black (5×114.3/e44/73)
Tires: Nexen N3000 255/35/18
Suspension: BC Racing

The big boss woke up early one morning and went to the City to snap these photos. The pictures highlight the wheels so well they look extra spectacular! The wheels do not stick out, therefore it’s perfect for daily driving around.

wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery

Incoming Wheels - April

This is the first batch of wheels that will be arriving this April. We will updating this page again so don’t forget to check back! We are now accepting pre-orders for these wheels. Give us a call at the shop at 510.490.3833 M-F 10am-5pm PST for pre-orders.

Subaru Fitment

18×8.5 Linea Corse Lemans - Hyper Silver w/ PLip(5×100/+45/73)

18×8.5 Linea Corse Lemans - Hyper Silver w/ PLip(5×114.3/+45/73)

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

17×8 Rota DPT - Flat Black (5×100/114.3/e48/73)

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

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

18×8.5 Rota Grid - Gold (5×114.3/e44/73)

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

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

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

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

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

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

18×9.5 Rota Grid - Grey Gunmetallic (5×114.3/e38/73)

18×10 Rota Grid - Flat Black (5×114.3/e30/73)

BMW Fitment

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

19×8.5/10 Linea Corse Lemans - Hyper Silver with Polished Lip 5×120 +30+37

In Stock Wheels - December 19 to 25

Check out our in stock wheels this week! Availability changes daily so give us a call for updates. The wheels are listed by wheel name, size, offset, bolt pattern, hub bore and color.

Subaru Fitment

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

17×9 Rota DPT - Gold (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×8.5 Rota Grid - Hyper Black (5×100/e44/56.1)

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

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

18×8.5 Rota Grid - Gold (5×114.3/e44/73)

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

18×8.5 Rota Grid - Matt Bronze (5×114.3/e44/73)

GRID 18×8.5 5X114.3 e44hub 73-White

18×9.5 Rota Grid - Flat Black (5×100/e38/56.1)

18×9.5 Rota Grid - Flat Gunmetallic (5×100/e38/56.1)

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

18×9.5 Rota Grid - Matte Bronze (5×100/e38/56.1)

18×9.5 Rota Grid - Titanium Chrome (5×100/e38/56.1)

18×9.5 Rota Grid - Flat Gunmetallic (5×114.3/e38/73)

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

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

18×9.5 Linea Corse Lemans - Gold w/ Polish Lip (5×114.3/e30/73)

18×8.5 Rota SVN - Tommy Gold(5×100/e48/56.1)

18×9.5 Rota T2R - Flat Black (5×100/e38/56.1)

18×9.5 Rota T2R - Titanium Chrome (5×114.3/e38/73)

Evo Fitment

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

17×9 Rota DPT - Titanium Chrome (5×100/114.3/e35/73)

18×10 Rota DPT - Hyper Silver (5×120x114.3/e25/72.6)

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

17×9.5 Rota Grid - Full Royal Sports Bronze(5×114.3/e30/73)

18×9.5 Linea Corse Lemans - Hyper Silver w/ Polished Lip (5×114.3/e17/73)

18×9.5 Rota Option-R - Flat Black (5×114.3/e20/73hb)

18×10 Rota T2R - Gold (5×114.3/e25/73)

18×9.5 Rota T2R - Hyper Silver (5×114.3/e20/73)

BMW Fitment

19×8.5/10 Linea Corse LC301 - Hyper Silver with Polished Lip (5×120 +30+37)

19×8.5 Linea Corse LC808(square set up) - Hyper Black with Polished Lip 5×120 +40

19×8.5/9.5 Linea Corse LC808 - Hyper Blck with Polished Lip 5×120 +40+40

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

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

19×8.5/10 Linea Corse LC818 - Smoked Chrome (5×120 +30+22/72.6)

19×9.5/11 Linea Corse LC818 - Hyper Silver (5×120 +25+25/72.6)

19×9.5/11 Linea Corse LC818 - Satin Black (5×120 +25+25 72.6)

19×8.5/10 Linea Corse LC855 - Hyper Silver (5×120/e30/e37/72.6)

19×8.5/10 Linea Corse LC855 - Satin Black (5×120/e30/e22/72.6)

19×8.5/9.5 Linea Corse Lemans -Hyper Silver with Polished Lip 5×120 +40 +40

19×8.5/10 Linea Corse Lemans - Satin Black(5×120/e30F,e37R)

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

19×8.5/10 Linea Corse Lemans - Gold(5×120/e30F,e37R)

19×8.5/10 Linea Corse Veneto - Hyper Silver (5×120/+30F+22R)

19×8.5/10 Linea Corse Veneto - Hyper Black (5×120/+30F+22R)

18×8 Rota P45F - Full Royal Sports Bronze(5×120/e38/72.6)

18×8 Rota Quake - Hyper Silver(5X120/e35/72.6)

Lexus/Nissan/Hyundai Luxury

19×8.5/10 Linea Corse Dyna - Polished (5×114.3/e30F,e38R/73)

19×8.5/10 Linea Corse Dyna - Polished (5×114.3/e30F,e43R/73)

19×8.5/10 Linea Corse LC818 - Hyper Silver (5×114 +30+38)

19×8.5/10 Linea Corse Lemans - Hyp Silvr wPol Lip 5×114.3 +38+43

20×9.5 Rota Extreme - Titanium Chrome(5×114.3/e15/73)

18×8.5 Rota P45F - Hyper Silver(5×114.3/e25/67.1)

19×9 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

19×9/10 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

18×8 Rota Quake - Hyper Silver (5X114.3/e35/73

19×8 Rota Quake - Hyper Silver(5X114.3/e48/73)

Audi Fitment

19×8.5/9.5 Linea Corse Lemans -Hyper Silver w/Pol Lip 5×112+35

19×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip 5×112 +35

Cadillac Fitment

19×8.5/10 Linea Corse LC855 - Hyper Black (6×115/e40/e47/70.3)

19×8.5/10 Linea Corse LC855 - Satin Black (6×115/e40/e47/70.3)

Porsche Fitment

17×7.5/9 Linea Corse Fox - RSR Finish(5×130/e35/e16/73hb)

4×100/4×114.3 Wheels

16×7 Rota Circuit 10 - Full Royal Sports Bronze(4×100/e45/67.1)

17×9.5 Rota Grid - Full Royal Sports Bronze(4×114.3/e12/73)

In Stock Wheels - December 12 to December 18

Check out our in stock wheels this week! Availability changes daily so give us a call for updates. The wheels are listed by wheel name, size, offset, bolt pattern, hub bore and color.

Subaru Fitment

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

17×9 Rota DPT - Gold (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×8.5 Rota Grid - Flat Black (5×100/e44/56.1)

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

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

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

18×8.5 Rota Grid - Gold (5×114.3/e44/73)

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

18×8.5 Rota Grid - Matt Bronze (5×114.3/e44/73)

GRID 18×8.5 5X114.3 e44hub 73-White

18×9.5 Rota Grid - Flat Black (5×100/e38/56.1)

18×9.5 Rota Grid - Flat Gunmetallic (5×100/e38/56.1)

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

18×9.5 Rota Grid - Matte Bronze (5×100/e38/56.1)

18×9.5 Rota Grid - Titanium Chrome (5×100/e38/56.1)

18×9.5 Rota Grid - Flat Gunmetallic (5×114.3/e38/73)

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

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

18×9.5 Linea Corse Lemans - Gold w/ Polish Lip (5×114.3/e30/73)

18×8.5 Rota SVN - Tommy Gold(5×100/e48/56.1)

18×9.5 Rota T2R - Flat Black (5×100/e38/56.1)

18×9.5 Rota T2R - Titanium Chrome (5×114.3/e38/73)

Evo Fitment

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

17×9 Rota DPT - Titanium Chrome (5×100/114.3/e35/73)

18×10 Rota DPT - Hyper Silver (5×120x114.3/e25/72.6)

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

17×9.5 Rota Grid - Full Royal Sports Bronze(5×114.3/e30/73)

18×9.5 Linea Corse Lemans - Hyper Silver w/ Polished Lip (5×114.3/e17/73)

18×9.5 Rota Option-R - Flat Black (5×114.3/e20/73hb)

18×10 Rota T2R - Gold (5×114.3/e25/73)

18×9.5 Rota T2R - Hyper Silver (5×114.3/e20/73)

BMW Fitment

19×8.5/10 Linea Corse LC301 - Hyper Silver with Polished Lip (5×120 +30+37)

19×8.5 Linea Corse LC808(square set up) - Hyper Black with Polished Lip 5×120 +40

19×8.5/9.5 Linea Corse LC808 - Hyper Blck with Polished Lip 5×120 +40+40

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

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

19×8.5/10 Linea Corse LC818 - Smoked Chrome (5×120 +30+22/72.6)

19×9.5/11 Linea Corse LC818 - Hyper Silver (5×120 +25+25/72.6)

19×9.5/11 Linea Corse LC818 - Satin Black (5×120 +25+25 72.6)

19×8.5/10 Linea Corse LC855 - Hyper Silver (5×120/e30/e37/72.6)

19×8.5/10 Linea Corse LC855 - Satin Black (5×120/e30/e22/72.6)

19×8.5/9.5 Linea Corse Lemans -Hyper Silver with Polished Lip 5×120 +40 +40

19×8.5/10 Linea Corse Lemans - Satin Black(5×120/e30F,e37R)

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

19×8.5/10 Linea Corse Lemans - Gold(5×120/e30F,e37R)

19×8.5/10 Linea Corse Veneto - Hyper Silver (5×120/+30F+22R)

19×8.5/10 Linea Corse Veneto - Hyper Black (5×120/+30F+22R)

18×8 Rota P45F - Full Royal Sports Bronze(5×120/e38/72.6)

18×8 Rota Quake - Hyper Silver(5X120/e35/72.6)

Lexus/Nissan/Hyundai Luxury

19×8.5/10 Linea Corse Dyna - Polished (5×114.3/e30F,e38R/73)

19×8.5/10 Linea Corse Dyna - Polished (5×114.3/e30F,e43R/73)

19×8.5/10 Linea Corse LC818 - Hyper Silver (5×114 +30+38)

19×8.5/10 Linea Corse Lemans - Hyp Silvr wPol Lip 5×114.3 +38+43

20×9.5 Rota Extreme - Titanium Chrome(5×114.3/e15/73)

18×8.5 Rota P45F - Hyper Silver(5×114.3/e25/67.1)

19×9 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

19×9/10 Rota P45 - Full Royal Sports Bronze (5×114.3/e20/73)

18×8 Rota Quake - Hyper Silver (5X114.3/e35/73

19×8 Rota Quake - Hyper Silver(5X114.3/e48/73)

Audi Fitment

19×8.5/9.5 Linea Corse Lemans -Hyper Silver w/Pol Lip 5×112+35

19×9.5 Linea Corse Lemans - Hyper Silver with Polished Lip 5×112 +35

Cadillac Fitment

19×8.5/10 Linea Corse LC855 - Hyper Black (6×115/e40/e47/70.3)

19×8.5/10 Linea Corse LC855 - Satin Black (6×115/e40/e47/70.3)

Porsche Fitment

17×7.5/9 Linea Corse Fox - RSR Finish(5×130/e35/e16/73hb)

4×100/4×114.3 Wheels

16×7 Rota Circuit 10 - Full Royal Sports Bronze(4×100/e45/67.1)

17×9.5 Rota Grid - Full Royal Sports Bronze(4×114.3/e12/73)

Mike’s 2006 Subaru Impreza Wagon on 18×8.5 +44 Grids

Owner: Mike
Car: 2006 Subaru Impreza Wagon
Wheels: 18×8.5 Rota Grid - White (5×100/e44/56.1)
Suspension: Tein S-Tech Lowering Springs

At a first glance, we thought he was lowered on coilovers, but turns out Mike achieved such a nice look with just lowering on Tein S-Tech’s lowering springs. He’s currently running Nexen N3000 225/40/18 all around paired up with the 18×8.5 +44 Grids(+39 after 5mm spacers all around). He added minor modifications such as WRX brakes, front lip, and some Red lugs.

wheeldude.com Gallery
wheeldude.com Gallery
wheeldude.com Gallery