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 '%17x9_rota_grid-v%' or p.products_model like '%17x9_rota_grid-v%' or m.manufacturers_name like '%17x9_rota_grid-v%') )

[TEP STOP]

Cameron’s FRS on 17×9 Rota Grid-V in Hyper Black

Owner: Cameron
Car: Scion FR-S
Wheels: 17×9 Rota Grid-V - Hyper Black (5×100/e42/73)
Tires: 245/40/17 Federal 595 rsrr tires
Suspension: BC BR coilovers

Michael’s FR-S on 17×9 +42 Hyper Black Grids-V

Owner: Michael Allman
Car: Scion FR-S
Wheels:17×9 Rota Grid-V - Hyper Black (5×100/e42/73)
Tires: 245/40/17 Hankook Ventus RS3
Suspension: Fortune auto 500

Dillon’s 2014 Scion FRS on 17×9 Rota Grid-V in Speed Bronze

Owner: Dillon Shelburn
Car: 2014 Scion FRS
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: Hankook Ventus V12 Evo2 245/40/17
Suspension: ST Coilovers, SPL LCAs, Velox Top Hats.

Sam’s BRZ on Rotra Grid-V 17×9 +42 in Speed Bronze

Owner: Sam Le
Car: Subaru BRZ
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: 245/40/17
Suspension: ISR Coilovers

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)

Rota Grid-V 17×9 +42 on Dutin’s BRZ

Sometimes a nice meaty set-up is all you need to improve the performance and handling of the already well-equipped BRZ. Dustin has a set of Grid-V 17×9 +42 5×100 Hyper Black on his BRZ and boy does this look good. Clean, simple and track ready.

Owner: Dustin
Car: 2013 Subaru BRZ
Wheels: Grid-V 17×9 +42 Hyper Black
Tire Size: 245/40/18
Suspension: Coilovers




The Wheeldude FR-S on 17×9 Grid-V’s

Owner: Wheeldude
Car: 2013 Scion FR-S
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tires: 245/40/17
Suspension: KW V3 coilovers
Performance Parts: Stivo Exhaust
Accessories: Stivo Chin Spoiler , Stivo Ducktail Spoiler, Stivo Roof Spoiler

We just mounted up the Grid-V’s on our FR-S and took her out for a photoshoot with Ryan of 247media.org. The pictures came out really great and the wheels look just as good on the FR-S as they did on our Bugeye.

This is a great set up for those of you who are looking to get a meaty setup without sacrificing drivability.

The Dude’s Bugeye on 17×9 Grid-V’s

Owner: The Dude
Car: 2002 Subaru Impreza WRX
Wheels: 17×9 Rota Grid-V - Speed Bronze (5×100/e42/73)
Tire Size: 245/40/17 Hankook Ventus S1
Suspension: JIC Magic Coilovers

Check out the latest wheel style mounted up on the Dude’s Bugeye! The 17×9 Grid-V is a lipped wheel, as opposed to the regular 17×9 Grids that have a concave face. More color and bolt pattern options coming real soon!