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]

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

Functional and Clean with 18×8.5 Rota Grid in Matte Gray

Owner: Kings028 on nasioc.com
Car: 2010 Subaru WRX
Wheels: 18×8.5 Rota Grid - Matte Gray (5×100/e44/56.1)
Tires: Hankook Ventus V12 EVOs 235/40/18
Suspension: EPIC lowering springs

Loving the clean and simple look on this ‘10 Subaru WRX. It’s such a nice look to the daily vehicle.

wheeldude.com Gallery
wheeldude.com Gallery

Throwback Session: Dude’s Bugeye WRX on 18×8.5 +44 Grid in Flat Black

Owner: Dude @ Wheeldude.com
Car: 2002 Subaru WRX
Wheels: 18×8.5 Rota Grid - Flat Black (5×100/e44/56.1)
Suspension: JIC Magic Coilovers

The Grids in this particular size is a direct bolt on for most Subaru applications, it’s for those not wanting to run an aggressive setup while still achieving that concave look! It looks good while being very functional! We only have a few sets left in stock ready for shipment so pick up those phones or purchase online before they’re sold out!

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

Subydude’s 2006 STI on 18×8.5″ Grids - Photoshoot with 247media.org

Owner: Subydude
Car: 2006 Subaru Impreza WRX STI
Wheels: 18×8.5 Rota Grid - Flat Gunmetallic (5×114.3/e44/73)
Tires: 255/35/18 Nexen N3000
Suspension: BC Racing Coilovers

Just in case you missed, we did a shoot for Zoeb’s 350Z. We were also able to do a shoot of the Subydude’s STI that morning. The car is running 18×8.5 +44 Grids in Flat Gunmetallic. Check the pictures out!

Click here to see the rest of the set.

Thanks to Ryan Trinidad of 247media.org for the awesome pictures!