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]

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!

Subydude’s STi on 18×8.5 Rota Grid - Flat Gunmetallic

Owner: Subydude
Car: 2006 Subaru Impreza STi
Wheels: Rota Grid 18×8.5 +44 - Flat Gunmetallic

Well, there comes a time where you move onto different things. So this is one of our farewell shots of this crystal grey metallic STi before we sell it. This car has been our shop’s mascot for many years, even during our humble Subydude.com beginnings. These new flat gunmetallic wheels sure look pretty nice on the car though!

Now In Stock - Rota Grid 18×8.5 & 18×9.5 - Flat Gunmetallic

Just in! We’ve got these wheels in stock in two different sizes and a few different offsets. We’ll have these on a car soon, so stay tuned!

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

$949.00

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

$949.00

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

$999.00

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

$999.00

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

$999.00

How low are you? Scion tC on 18×8.5+44 Grids

Owner: Ryan
Car: Scion tC
Wheels: 18×8.5 Rota Grid - Hyper Black (5×100/e44/56.1)
Suspension: Air Suspension

We’re so used to seeing coilovers or shock/springs setup that we often forget about another form of suspension, which is air. Ryan chose to go with air suspension on his Scion tC so he can show-stop every time his car is parked. Thankfully the 18×8.5 Grids were in a size he needed to fully tuck the rear wheel and tire to achieve this look.


Carolyn’s Lancer Ralliart 18×8.5 Rota Grid - Matte Bronze

Owner: Carolyn H.
Car: 2009 Mitsubishi Lancer Ralliart
Wheels: Rota Grid 18×8.5 +44 - Matte Bronze
Tires: Advan 245/40/18

More ladies with Rotas! Carolyn emailed us photos of her rotor glow orange Ralliart with 18×8.5″ Grids! She said there’s no fender rolling required with this setup that’s accompanied by H&R lowering springs.

Cody’s Ralliart Lancer on 18×8.5 Rota Grid - Hyper Black

Owner: Cody (evolutionm.net thread here)
Car: 2009 Mitsubishi Lancer Ralliart
Wheels: Rota Grid 18×8.5 +44 - Hyper Black

Cody’s Ralliart is most go-fast power mods and boy does this one have it. There’s not much on the outside besides the set of Rota Grid wheels, so think twice about trying to get a run against a Rotor Glow Lancer Ralliart on a set of Grids!