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

[TEP STOP]

Zach’s 2015 Subaru BRZ on 18×8.5/9.5 Flat Black Grids

Owner: Zach Grimm
Car: 2015 Subaru BRZ
Wheels: 18×8.5/9.5 Rota Grid - Flat Black (5×100/e44F/e38R/73)
Tires: 225/40/18 and 255/35R18 Ventus v12
Suspension: ISC N1 coilovers
Mods:
Supercharged by vortech with an ecutek tune at 8 psi. borla headers, perrin 3″ catback exhaust and overpipe and a Motiv down pipe with a high flow catalytic converter. Valenti taillights. Smoked headlights. STI gurney flap and OEM rear diffuser. It is making around 260whp.

Incoming Wheels - Febuary

These wheels are coming in this Febuary 2015. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST or you may place the order on our website.

Subaru WRX Wheels

18×8.5 Rota HG5 - Hyper Black (5X100/+44)

18×8.5 Rota HG5 - Gold (5X100/+44)

18×9.5 Rota HG5 - Gold (5X100/+38)

18×9.5 Rota HG5 - Hyper Black (5X100/+38)

18×8.5 Rota DPT - Hyper Black (5×100/114.3/+ 44)

18×8.5 Rota Grid -Flat Black (5×100/+ 44)

18×8.5 Rota Grid - Hyper Black (5×100/+ 44)

18×9.5 Rota Grid - Chameleon (5×100/+ 38)

18×9.5 Rota Grid - Deep Red (5×100/+ 38)

18×9.5 Rota Grid -Flat Black (5×100/+ 38)

18×9.5 Rota Grid - Hyper Black (5×100/+ 38)

18×9.5 Rota Grid - White (5×100/+ 38)

Ford Focus ST Wheels

18×9.5 Rota Grid - Hyper Black (5×108/+ 38)

18×9.5 Rota Grid - Chameleon (5×108/+ 38)

Mitsubishi EVOX, 350Z Wheels

18×9.5 Rota Grid - Deep Red (5×114.3/+ 20)

18×9.5 Rota Grid -Flat Black (5×114.3/+ 20)

18×9.5 Rota Grid - Gold (5×114.3/+ 20)

18×9.5 Rota Grid - Hyper Black (5×114.3/+ 20)

18×9.5 Rota Grid - White (5×114.3/+ 20)

Subaru STi

18×8.5 Rota DPT - Hyper Black (5×100/114.3/+ 44)

18×8.5 Rota Grid - Speed Bronze (5×114.3/+ 44)

18×9 Rota Grid - Flat Black (5×114.3/+42)

18×9 Rota Grid - Hyper Black (5×114.3/+42)

18×9.5 Rota Grid - Deep Red (5×114.3/+ 38)

18×9.5 Rota Grid -Flat Black (5×114.3/+ 38)

18×9.5 Rota Grid - Hyper Black (5×114.3/+ 38)

18×9.5 Rota Grid - White (5×114.3/+ 38)

FR-S, FT-86 and BRZ Wheels

18×8.5/9.5 Rota HG5 - Hyper Black (5X100/+44F/+38R)

18×8.5/9.5 Rota HG5 - Gold (5X100/+44F/+38R)

18×8.5/9.5 Rota Grid -Flat Black (5X100/+44F/+38R)

18×8.5/9.5 Rota Grid - Hyper Black (5X100/+44F/+38R)

Subaru WRX STi 2015, Mitsubishi EVO 8-9 Wheels

18×9.5 Rota HG5 - Hyper Black (5X114.3/+35)

18×9.5 Rota HG5 - Gold (5X114.3/+35)

Audi , Volkswagen Wheels

18×9 Rota Grid - Hyper Black (5×112/+40)

19×8.5 Linea Corse Dyna - Slate Blue (5×112/e40/73hb)

19×8.5 Linea Corse Dyna - Polished (5×112/e35/57.1hb)

Porsche Wheels

17×7.5/9 Linea Corse Fox - RSR Style High Polish(5×130/e35F/e16R/7 1.6)

17×7.5/9 Linea Corse Fox - Gloss Black w/ Pol Lip (5×130/e35F/e16R/71.6)

BMW Wheels

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

Rota Grids

The Rota Grid is one of our best sellers and one of our favorite wheels. It comes with a variations of color and different sizes and fitments. Comparing the wideness of the deep aggressive concavity 10 and 9.5 inch to the slightly curved spoke of the 8.5 inch width Grids. They came in high offset to clear big brake calipers to the low offset for other fitments.

Sizes

Bolt Pattern

  • 6×139.7
  • 5×120
  • 5×114.3
  • 5×112
  • 5×108
  • 5×100
  • 4×114.3

Color

  • Chameleon
  • Deep Red
  • Flat Black
  • Full Royal Silver
  • Gold
  • Gun Metal
  • Hyper Black
  • Hyper Blue
  • Hyper Silver
  • Speed Bronze
  • Sports Bronze
  • Titanium Chrome
  • White

18×10 Rota Grid - Flat Black (5×120/e25/72.6)

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

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

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

18×9.5 Rota Grid - Deep Red (5×100/e38/73)

18×9.5 Rota Grid - Deep Red (5×114.3/e20/73)

18×9.5 Rota Grid - Deep Red (5×114.3/e38/73)

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

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

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

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

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

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

18×9.5 Rota Grid - Full Royal Silver (5×100/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×112/e38/73)

18×9.5 Rota Grid - Full Royal Silver (5×114.3/e20/73)

18×9.5 Rota Grid - Full Royal Silver (5×114.3/e38/73)

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

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

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

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

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

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

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

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

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

18×9.5 Rota Grid - Hyper Blue (5×114.3/e20/73)

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

18×9.5 Rota Grid - Speed Bronze (5×100/e38/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e20/73)

18×9.5 Rota Grid - Speed Bronze (5×114.3/e38/73)

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

18×9.5 Rota Grid - Titanium Chrome (5×114.3/e20/73)

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

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

18×9.5 Rota Grid - White (5×112/e38/73)

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

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

18×8.5/9.5 Rota Grid - Flat Black (5×100/e44F/e38R/73)

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

18×8.5 Rota Grid - Flat Black (5×108/e42/73)

18×8.5 Rota Grid - Flat Black (5×114.3/e44/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 - Hyper Black (5×108/e42/73)

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

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

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

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

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

17×9 Rota Grid - Gold (5×100/e42/73)

17×9 Rota Grid - Gold (5×114.3/e42/73)

17×9 Rota Grid - Hyper Black (5×100/e35/73)

17×9 Rota Grid - Hyper Black (5×100/e42/73)

17×9 Rota Grid - Hyper Black (5×114.3/e42/73)

17×9 Rota Grid - Hyper Black(4×100/e20/51.7)

17×9 Rota Grid - Hyper Black(4×114.3/e12/73)

17×9 Rota Grid - Hyper Black(5×100/e30/73)

17×9 Rota Grid - Hyper Black(5×114.3/e25/73)

17×9 Rota Grid - Sports Bronze(4×114.3/e12/73)

17×9 Rota Grid - Sports Bronze(4×114.3/e25/73)

17×9 Rota Grid - Sports Bronze(5×100/e35/73)

17×9 Rota Grid - Sports Bronze(5×100/e42/73)

17×9 Rota Grid - Sports Bronze(5×114.3/e25/73)

17×9 Rota Grid - Sports Bronze(5×114.3/e42/73)

17×9 Rota Grid - Yamaha Black (5×100/e42/73)

17×9 Rota Grid - Yamaha Black (5×114.3/e25/73)

17×9 Rota Grid - Yamaha Black (5×114.3/e42/73)

17×9 Rota Grid - White (5×114.3/e42/73)

17×9 Rota Grid-V - Hyper Black (5×100/e42/73)

17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)

17×8 Rota Grid - Flat Black (4×108/e40/73)

16×8 Rota Grid Offroad - Flat Black(6×139.7/e0/110)

16×8 Rota Grid Offroad - Gunmetal(6×139.7/e0/110)

Incoming Wheels - July

These wheels are coming in this July 2013. We are now accepting pre-orders for these wheels. You can give us a call at the shop at 510.252.1111 Monday to Friday 10am-5pm PST.

Subaru Fitment

18×9.5 Rota DPT - Gold (5×100x114.3/e44/73)

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

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

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

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

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

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

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

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

18×9.5 Rota RT5 - Hyper Black (5×100/e44/73)

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

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

18×9.5 Linea Corse Lemans - Hyper Silver w/ Pol (5×114.3/e30/73)

18×10 Rota SVN-R - Titanium Chrome (5×100/114.3/e30/73)

18×9.5 Rota Torque - Titanium Chrome (5×100/e35/73)

FRS/BRZ Staggered Set-Up

18×8.5/9.5 Rota RT5 - Hyper Black (5×100/e44F/e44R/73)

Evo Fitment

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

The Wheeldude FR-S on 18×8.5/9.5 White Grids - Staggered Set Up

Owner: Wheeldude
Car: 2013 Scion FR-S
Wheels: 18×8.5/9.5 Rota Grid - White (5×100/e44F/e38R/73)
Tires: 225/40/18 Front; 255/35/18 Rear
Suspension: KW coilovers

It’s a brand new week and it was time to put on another set of wheels on our FR-S. Fortunately for us, Ryan of 247media.org spent a little of his time despite his busy schedule to do a quick sunset photoshoot. We hope you enjoy this white on white delight. :p

Tyler’s FR-S on Hyper Black Grids - Night Shoot

Owner: Tyler
Car: 2013 Scion FR-s
Wheels: 18×8.5/9.5 Rota Grid - Hyper Black (5×100/e44F/e38R/73)
Tires: Hankook Ventus V12 225/40/18 Front; 255/35/18 Rear
Suspension: CG 35mm Lowering Springs
Other mods: Perrin Lightweight Crank Pulley, Perrin Header Back (over pipe, catted front pipe, non resonated catback), CG springs, Rota Grids, Custom Headlights, LED DRL’s, Rally Armor Mudflaps, 6k HIDs

Just a week ago, Tyler sent us over some pictures of his FR-S taken outside his garage. We were supposed to post them up on our website but Tyler told us that he has some sick professional night shots coming soon. The wait was definitely worth it!

Matt’s FR-S on 18×8.5/9.5 Hyper Black Rota Grids

Owner: Matt
Car: 2013 Scion FR-S
Wheels: 18×8.5/9.5 Rota Grid - Hyper Black (5×100/e44F/e38R/73)
Tires: 225/40/18 Front; 255/35/18 Rear
Suspension: BC Racing Coilovers from Rev Works

Matt recently got his BC Racing coilovers installed by Rev Works. The drop definitely finishes off the look of his Scion FR-S!

Just to give you an idea, here’s how Matt’s car looked like before installing the coilovers.

Matt is running a staggered set of Rota Grids in Hyper Black which really looks great on the Asphalt FR-S. :)

Incoming Wheels - January 2013

These wheels are coming in this January 2013. We are now accepting pre-orders for these wheels. Give us a call at the shop at 510.651.2956 M-F 10am-5pm PST for pre-orders.

Subaru

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

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

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

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

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

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

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

18×9.5 Rota Grid - Full Royal Silver (5×114.3/e38/73)

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

Scion FR-S/Subaru BRZ/Toyota 86

18×8.5/9.5 Linea Corse Lemans - H. Silver PLip(5×100/e40/40/73)

Evo

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

Porsche

17×7.5/9 Linea Corse Fox - Satin Black w/Satin Silver Lip (5×130)

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

Josh’s FRS Running 18×8.5/18×9.5 Grids - Now on Coilovers

Owner: Josh
Car: 2012 Scion FRS
Wheels: 18×8.5/9.5 Rota Grid - Hyper Black (5×100/e44F/e38R/73)
Tires: 225/40/18 Front; 245/35/18 Rear
Suspension: BC Racing BR Series Coilovers

We featured Josh and his car on our blog way back in July and he was definitely one of the first FRS owners to run the Rota Grids. (Previous feature here.)

At that time, Josh was still running the stock suspension and we remember a lot of people posting comments that he needed to lower his car. Guess what, Josh is back and his car is on aftermarket suspension now. He even took it a notch higher and went with coilovers instead of lowering springs. Looks great doesn’t it? :)

Our Scion FRS on 18×8.5/9.5 Rota Grid in Gold and Flat Black!

Owner: Wheeldude
Car: 2013 Scion FRS
Wheels: 18×8.5/9.5 Rota Grid - Gold (5×100/e44F/e38R/73)
Tires: 235/40/18, 245/40/18
Suspension: Eibach Sportline Lowering Springs

This was our first setup, the 18×8.5/18×9.5 setup. We ran the 235/40/18 & 245/40/18 tires. We had these laying around at our shop, so we figured.. why not? Do you like how they look?

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