For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 456 results

Filter By

Current Filters

  1. In Magento No Remove This Item
Clear All

Category

  1. Skateboards146item
  2. Scooters158item
  3. Skates90item
  4. Bikes27item
  5. Longboards18item
  6. Protection22item
  7. Shoes1 item
  8. Clothes3item
  9. Bags1 item
  10. Sports1 item
  11. Brands439item
  12. Bundles321item
  13. Clearance4item
  14. New Arrivals40item
  15. SkateHut Sale81item
  16. Footwear2item
  17. Black Friday Deals8item

Bike Frame Size

  1. 19.25"2item
  2. 20.5"3item

Bike Type

  1. BMX26item

Bike Wheel Size

  1. 20"26item

Foldable?

  1. No7item

Height Adjustable?

  1. No7item

Material Secondary

  1. Aluminium1 item
  2. Suede2item

Sales Name

  1. Reduction3item
  2. Clearance1 item
  3. Price Match16item
  4. Red Tier 12item
  5. Red Tier 22item
  6. B-Stock3item

Shoe Size Adjustable

  1. Junior UK 8 - Junior UK 114item
  2. Junior UK 12 - UK 24item
  3. UK 3 - UK 63item
  4. UK 6 - UK 82item
  5. Junior 12.5 - UK 21 item
  6. UK 2.5 - UK 52item

Shoe Size Multi

  1. Size - Toddler UK 8 (EU 25.5)4item
  2. Size - Toddler UK 8.5 (EU 26)4item
  3. Size - Toddler UK 9 (EU 26.5)4item
  4. Size - Toddler UK 9.5 (EU 27)4item
  5. Size - Junior UK 10 (EU 27.5)4item
  6. Size - Junior UK 10.5 (EU 28)4item
  7. Size - Junior UK 11 (EU 29)4item
  8. Size - Junior UK 12 (EU 30)4item
  9. Size - Junior UK 12.5 (EU 31)5item
  10. Size - Junior UK 13 (EU 31.5)5item
  11. Size - Junior UK 13.5 (EU 32)5item
  12. Size - UK 1 (EU 33)5item
  13. Size - UK 1.5 (EU 33.5)5item
  14. Size - UK 2 (EU 34)5item
  15. Size - UK 2.5 (EU 34.5)2item
  16. Size - UK 3 (EU 35)5item
  17. Size - UK 3.5 (EU 36)5item
  18. Size - UK 4 (EU 37)5item
  19. Size - UK 4.5 (EU 37.5)5item
  20. Size - UK 5 (EU 38)5item
  21. Size - UK 5.5 (EU 38.5)3item
  22. Size - UK 6 (EU 39)5item
  23. Size - UK 6.5 (EU 39.5)2item
  24. Size - UK 7 (EU 41)2item
  25. Size - UK 7.5 (EU 41.5)2item
  26. Size - UK 8 (EU 42)2item

Variant Size

  1. Large3item
  2. Medium2item
  3. Extra Large1 item
  4. Size - Toddler UK 8 (EU 25.5)2item
  5. Size - Junior UK 12 (EU 30)3item
  6. Size - Junior UK 13 (EU 31.5)3item
  7. Size - UK 1 (EU 33)4item
  8. Size - UK 2 (EU 34)6item
  9. Size - UK 3 (EU 35)16item
  10. Size - UK 4 (EU 37)19item
  11. Size - UK 4.5 (EU 37.5)1 item
  12. Size - UK 5 (EU 38)20item
  13. Size - UK 6 (EU 39)19item
  14. Size - UK 7 (EU 41)26item
  15. Size - UK 8 (EU 42)28item
  16. Size - UK 9 (EU 43)10item
  17. Size - UK 10 (EU 44)5item
  18. Size - UK 11 (EU 46)7item
  19. Size - UK 12 (EU 47)4item
  20. Size - UK 13 (EU 48)1 item
  21. Size 81 item
  22. S/M3item
  23. 22.25" x 6.5"1 item
  24. 23.25" x 6.5"1 item
  25. 5.8"1 item
  26. 5.2"1 item

Skateboard Type

  1. Cruiser3item
  2. Longboard5item
  3. Stunt13item

Variant Width

  1. 130mm1 item
  2. 4.3"2item
  3. 4.5"11item
  4. 4.72"6item
  5. 4.8"2item
  6. 5"4item
  7. 5.1"1 item
  8. 5.25"1 item
  9. 5.5"3item
  10. 5.8"1 item
  11. 6"6item
  12. 6.25"1 item
  13. 6.5"3item
  14. 8"6item
  15. 8.06"1 item
  16. 8.13"3item
  17. 8.25"4item
  18. 8.375"1 item
  19. 8.38"1 item
  20. 8.4"1 item
  21. 8.5"5item
  22. 8.75"1 item

Channel Filters

  1. Allowed315item
  2. Excluded130item
  3. Ebay Only3item

Stock At Supplier

  1. Yes50item
  2. No401item

Cross Sell Type

  1. Colour150item
  2. Size11item
  3. Width2item

Reporting Status

  1. Live443item
  2. Discontinued2item
  3. Pending2item

Use In Google Feed

  1. Yes440item
  2. No111item

B-Stock

  1. Yes4item
  2. No452item

B-Stock Condition

  1. [Box Damage]2item
  2. [Pre-Owned]2item

Own Brand?

  1. Yes6item
  2. No450item

Channels Ready

  1. Yes411item
  2. No46item

Longboard Wheel Variants

  1. Not Needed1 item

Purchaser

  1. Billy29item
  2. Phil6item
  3. Ricky4item
  4. Tony20item
  5. SWAG2item
  6. Brucey2item
  7. Own Brand3item
  8. Rob18item

Country Of Origin

  1. China57item

Google Feed Margin Cat

  1. z125item
  2. z227item
  3. z340item
  4. other14item

Skateboard Wheel Base

  1. 13.875"2item
  2. 14"7item
  3. 14.25"2item
  4. 14.38"2item

Skateboard Deck Shape

  1. Classic Popsicle13item

Skateboard Griptape

  1. Applied22item
  2. Not Included95item

Skateboard Length

  1. 31"3item
  2. 31.5"2item
  3. 31.7"2item
  4. 31.8"1 item
  5. 31.82"1 item
  6. 31.9"2item
  7. 32"6item
  8. 32.2"1 item
  9. 32.31"1 item

Skateboard Deck Concave

  1. Medium13item

Skateboard Deck Construction

  1. 7-Ply13item

Order In Active

  1. Yes18item
  2. No325item

Order In Active Shipping Group

  1. Order in - 5 day leadtime31item
  2. Order in - 2-4 day leadtime2item

Order In Product

  1. Yes50item
  2. No391item

Skateboard Riding Use

  1. Street12item
  2. Park2item

Export

  1. No338item

Has Identifier for GMC

  1. Yes80item
  2. No377item

Export Common

  1. No338item

Supplier Name

  1. 6030 Sports1 item
  2. Black Peak Trading1 item
  3. Centrano135item
  4. Core14item
  5. Form40item
  6. Greenover1 item
  7. HLC1 item
  8. Ison2item
  9. J&R52item
  10. Keen4item
  11. LG Sports Distribution6item
  12. New English2item
  13. Nineteen765item
  14. Onecall14item
  15. Parklife Innovations Ltd1 item
  16. Rock Solid14item
  17. Rolling Thunder15item
  18. Shiner / J&R1 item
  19. Shiner22item
  20. Silverfish1 item
  21. Skatehut6item
  22. Stateside60item
  23. TKC3item
  24. Upgrade1 item
  25. USG19item
  26. Wheels1 item
  27. Flaneurz Ltd2item
  28. Traffic-uk6item
  29. Kaltik6item
  30. OG Distribution1 item
  31. Crocs Europe BV1 item
  32. RI Distribution6item

Best Suited to

  1. Park37item
  2. Street26item
  3. Hybrid15item

Scooter Type

  1. Adult/Commuter Scooter4item
  2. Kids Scooter10item
  3. Stunt Scooter56item
  4. Cruiser Scooter4item

Skateboard Deck Randomiser

  1. No99item

Truck Bolt Length

  1. 7/8"2item
  2. 1"2item

Is for Gifting?

  1. No456item

Skateboard Height Range

  1. 4' 2" - 5' 2"3item
  2. 5' 2" and over31item

Skateboard Shoe Size Range

  1. UK 1 - UK 53item
  2. UK 5 - UK 88item
  3. UK 8 - UK 103item
  4. UK 10 - UK 129item
  5. UK 11 - UK 1210item
  6. UK 12 and over1 item

Scooter Bar Height

  1. Adjustable10item
  2. 500mm2item
  3. 550mm2item
  4. 570mm4item
  5. 584mm3item
  6. 585mm4item
  7. 609mm5item
  8. 620mm12item
  9. 635mm2item
  10. 650mm5item
  11. 660mm1 item
  12. 700mm1 item
  13. 490mm2item

Scooter Height

  1. 750mm3item
  2. 760mm2item
  3. 770mm1 item
  4. 780mm2item
  5. 810mm2item
  6. 815mm5item
  7. 830mm4item
  8. 840mm4item
  9. 850mm3item
  10. 865mm6item
  11. 870mm7item
  12. 895mm1 item
  13. 900mm7item
  14. 920mm2item
  15. 940mm1 item
  16. 945mm1 item
  17. 950mm3item
  18. 965mm2item
  19. 1000mm8item
  20. 1015mm1 item

Is Configurable Product

  1. Yes61item
  2. No7item

Product Label Text

  1. Free Grip Tape72item
  2. 10% Off9item
  3. 30% Off2item
  4. 40% Off1 item
  5. 60% Off2item
  6. 15% Off1 item
  7. 8% Off1 item
  8. 54% Off1 item
  9. 11% Off1 item

Longboard Shape

  1. Cruiser3item
  2. Drop Through4item
  3. Pintail4item
  4. Symmetrical1 item

Skill Level

  1. Beginner12item
  2. Intermediate49item
  3. Pro10item

Product Type Basic

  1. Bike Repair Kits1 item
  2. BMX Completes26item
  3. T-Shirts1 item
  4. Skate Shoes & Trainers1 item
  5. Ramps1 item
  6. Ice Hockey - Skates1 item
  7. Ice Skates - Figure6item
  8. Ice Skates - Hockey1 item
  9. Inline Skates - Adjustable4item
  10. Inline Skates - Aggressive3item
  11. Inline Skate Frames3item
  12. Inline Skates - Freerides1 item
  13. Inline Skates - Rollerblades16item
  14. Longboard Completes9item
  15. Cruisers3item
  16. Longboard Truck Bolts1 item
  17. Longboard Trucks1 item
  18. Knee Pads3item
  19. Pad Sets18item
  20. Protective Gloves2item
  21. Roller Derby Skate Boots1 item
  22. Roller Skates - Adjustable3item
  23. Skate Bearings1 item
  24. Roller Skates34item
  25. Roller Skates - Detachable2item
  26. Jam Plugs8item
  27. Skate Plates1 item
  28. Skate Tools1 item
  29. Scooters - Commuter4item
  30. Scooter Compression Kits7item
  31. Scooter Decks69item
  32. Scooters - Folding2item
  33. Scooter Headsets15item
  34. Scooters - Stunt Scooters56item
  35. Scooters - Three Wheel4item
  36. Skateboard Bearings4item
  37. Skateboard - Completes13item
  38. Skateboard Decks95item
  39. Skateboard Grip Tape8item
  40. Skateboard Truck Bolts6item
  41. Skateboard Trucks4item
  42. Undercarriage Kits1 item
  43. Skateboard Wax1 item
  44. Football Goals1 item
  45. Crocs1 item

Is Simple Product

  1. Yes356item
  2. No108item

Department

  1. Bikes27item
  2. Clothes/Accessories1 item
  3. Footwear2item
  4. General Hardware1 item
  5. Ice Skates8item
  6. Inline Skates28item
  7. Longboards14item
  8. Protection23item
  9. Roller Derby3item
  10. Roller Skates47item
  11. Scooters157item
  12. Skateboards132item
  13. Sports and Outdoor1 item

Price

  1. £0.00 - £24.9970item
  2. £25.00 - £49.9956item
  3. £50.00 - £74.99117item
  4. £75.00 - £99.9961item
  5. £100.00 - £124.9917item
  6. £125.00 - £149.9917item
  7. £150.00 - £174.9929item
  8. £175.00 - £199.9928item
  9. £200.00 - £224.997item
  10. £225.00 and above54item

Brand Name

  1. 100 percent1 item
  2. 187 Killer Pads1 item
  3. Addict Scootering6item
  4. Anarchy Skates1 item
  5. Anti Hero4item
  6. Antik Skates1 item
  7. Apex Pro Scooters2item
  8. Bauer1 item
  9. BazookaGoal1 item
  10. Blueprint Skateboards1 item
  11. Blunt Envy10item
  12. Candi Girl3item
  13. CCM1 item
  14. Chaya1 item
  15. Chocolate17item
  16. Chubby Wheels1 item
  17. Core14item
  18. Crocs1 item
  19. District Scooters1 item
  20. DMR1 item
  21. Eastern Bikes19item
  22. Edea2item
  23. Element7item
  24. Enjoi1 item
  25. Ethic7item
  26. Flip13item
  27. Fracture3item
  28. Girl2item
  29. Hydroponic6item
  30. Independent1 item
  31. JD Bug3item
  32. K21 item
  33. Kaltik6item
  34. LMNADE2item
  35. Loaded3item
  36. Lucky Scooters8item
  37. Magenta1 item
  38. Meow2item
  39. MGP (Madd Gear Pro)11item
  40. Mindless5item
  41. Moxi10item
  42. Native10item
  43. North Scooters12item
  44. Ocean Pacific1 item
  45. Paris Trucks Co1 item
  46. Passport2item
  47. Polar1 item
  48. Powell Peralta8item
  49. Powerdyne1 item
  50. Primitive2item
  51. Rad13item
  52. Radio2item
  53. RAM Longboards4item
  54. Rampage6item
  55. REKD6item
  56. Riedell4item
  57. Rio Roller22item
  58. Roces4item
  59. Rollerblade1 item
  60. Rookie2item
  61. Root Industries13item
  62. Sacrifice1 item
  63. SEBA3item
  64. SFR17item
  65. Sk8 Mafia1 item
  66. SkateHut4item
  67. Slamm10item
  68. Sour Skateboards4item
  69. Speed Demons1 item
  70. Striker26item
  71. Sushi1 item
  72. Thank You1 item
  73. The Heart Supply7item
  74. Tilt Scooters12item
  75. Tony Hawk Signature Series1 item
  76. Toy Machine1 item
  77. Vans1 item
  78. Venture2item
  79. Vital4item
  80. WeThePeople4item
  81. Zero21item
  82. Zoo York3item
  83. Slades2item
  84. Unity1 item
  85. Trynyty1 item
  86. FR Skates6item
  87. Luminous Skates3item
  88. Cream3item
  89. Sketti Butta1 item
  90. Longway13item
  91. Opera1 item
  92. Jacuzzi Unlimited1 item
  93. Push1 item
  94. G-Tool1 item

Product Type

  1. Bikes > Accessories > Repair Kits1 item
  2. Bikes > BMX Completes26item
  3. Clothes/Accessories > T-Shirts1 item
  4. Footwear > Skate Shoes and Trainers1 item
  5. General Hardware > Ramps1 item
  6. Ice Hockey > Ice Hockey Skates1 item
  7. Ice Skates > Figure Skates6item
  8. Ice Skates > Hockey Skates1 item
  9. Inline Skates > Adjustable Roller Blades4item
  10. Inline Skates > Aggressive Skates3item
  11. Inline Skates > Frames3item
  12. Inline Skates > Roller Blades16item
  13. Longboards > Completes9item
  14. Longboards > Cruisers3item
  15. Longboards > Truck Bolts1 item
  16. Longboards > Trucks1 item
  17. Protection > Knee Pads3item
  18. Protection > Pad Sets18item
  19. Protection > Protective Gloves2item
  20. Roller Derby > Roller Derby Skates1 item
  21. Roller Derby > Roller Derby Skates - Boot Only1 item
  22. Roller Skates > Adjustable Skates3item
  23. Roller Skates > Bearings1 item
  24. Roller Skates > Completes34item
  25. Roller Skates > Jam Plugs8item
  26. Roller Skates > Plates1 item
  27. Roller Skates > Tools1 item
  28. Scooters > Commuter Completes4item
  29. Scooters > Compression Kits7item
  30. Scooters > Decks69item
  31. Scooters > Folding Completes2item
  32. Scooters > Headsets15item
  33. Scooters > Three Wheeled Completes4item
  34. Skateboards > Bearings4item
  35. Skateboards > Completes13item
  36. Skateboards > Decks95item
  37. Skateboards > Grip Tape8item
  38. Skateboards > Truck Bolts6item
  39. Skateboards > Trucks4item
  40. Skateboards > Undercarriage Kits1 item
  41. Skateboards > Wax1 item
  42. Sports and Outdoor > Football > Goals1 item
  43. Scooters > Stunt Completes56item
  44. Roller Skates > Detachable Skates > Completes2item
  45. Footwear > Crocs1 item
  46. Inline Skates > Freeride Completes1 item

Sport

  1. Cycling1 item
  2. Football1 item

Skateboard Age Range

  1. 8 to 134item
  2. 13 and over33item

Age

  1. 9+ Years26item

Skateboard Deck Width Range

  1. 8.126" - 8.25"2item
  2. 8.26" - 8.50"1 item
  3. 7.25" - 7.49"1 item
  4. 7.50" - 7.99"4item
  5. 8.00 - 8.124"32item
  6. 8.125" - 8.24"7item
  7. 8.25" - 8.49"31item
  8. 8.50" - 8.79"26item
  9. 8.80" - 11"1 item

Main Colour

  1. Black153item
  2. Blue44item
  3. Bronze2item
  4. Brown7item
  5. Burgundy1 item
  6. Camo1 item
  7. Clear1 item
  8. Cream2item
  9. Gold10item
  10. Green20item
  11. Grey7item
  12. Multi13item
  13. Natural9item
  14. Navy3item
  15. Neochrome11item
  16. Orange11item
  17. Pink14item
  18. Purple8item
  19. Raw14item
  20. Red26item
  21. Silver18item
  22. Tan1 item
  23. Teal19item
  24. Turquoise1 item
  25. White31item
  26. Yellow8item

Deck Type

  1. Integrated74item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars7item

Scooter Clamp Type

  1. SCS Compression7item

Scooter Headset Type

  1. Integrated15item

Scooter Wheel Size

  1. 100mm1 item
  2. 120mm1 item
  3. 200mm4item
  4. n/a4item

Skateboard Deck Width

  1. 7.25"1 item
  2. 7.75"4item
  3. 8"32item
  4. 8.06"3item
  5. 8.125"4item
  6. 8.13"4item
  7. 8.25"21item
  8. 8.375"8item
  9. 8.38"2item
  10. 8.4"3item
  11. 8.45"1 item
  12. 8.5"25item
  13. 8.75"2item
  14. 8.88"1 item

Shoe Size

  1. Size - Toddler UK 8 (EU 25.5)2item
  2. Size - Junior UK 12 (EU 30)3item
  3. Size - Junior UK 13 (EU 31.5)4item
  4. Size - UK 1 (EU 33)6item
  5. Size - UK 2 (EU 34)9item
  6. Size - UK 3 (EU 35)25item
  7. Size - UK 3.5 (EU 36)6item
  8. Size - UK 4 (EU 37)34item
  9. Size - UK 4.5 (EU 37.5)3item
  10. Size - UK 5 (EU 38)41item
  11. Size - UK 6 (EU 39)46item
  12. Size - UK 6.5 (EU 39.5)11item
  13. Size - UK 7 (EU 41)55item
  14. Size - UK 7.5 (EU 41.5)3item
  15. Size - UK 8 (EU 42)65item
  16. Size - UK 8.5 (EU 42.5)2item
  17. Size - UK 9 (EU 43)29item
  18. Size - UK 9.5 (EU 43.5)13item
  19. Size - UK 10 (EU 44)17item
  20. Size - UK 10.5 (EU 45)1 item
  21. Size - UK 11 (EU 46)18item
  22. Size - UK 12 (EU 47)15item
  23. Size - UK 13 (EU 48)3item

Pad Size

  1. Extra Extra Small3item
  2. Extra Small7item
  3. Small14item
  4. Medium16item
  5. Large15item
  6. Extra Large3item
  7. Junior (up To 8 Years)1 item

Skateboard Truck Height

  1. Low - Wheels < 53mm2item
  2. Mid - Wheels 53-56mm1 item
  3. High - Wheels > 56mm2item

Size

  1. Medium1 item
  2. Large2item
  3. Kids M (7-8 Years)1 item
  4. Kids L (9-11 Years)1 item

Scooter Deck Type

  1. Integrated 100-110mm24item
  2. Integrated 120mm42item
  3. Integrated 125mm3item

Skateboard Deck Width Suitability

  1. 7.8"1 item
  2. 7.85"1 item
  3. 7.88"1 item
  4. 7.9"2item
  5. 8"2item
  6. 8.1"2item
  7. 8.12"1 item
  8. 8.4"1 item
  9. 8.5"1 item
  10. 8.6"1 item
  11. 9"1 item
  12. 9.12"1 item
  13. 9.5"1 item
  14. 9.62"1 item
  15. 9.75"1 item
  16. 10"1 item
  17. 7.875"1 item
  18. 8.125"1 item

Skateboard Truck Hanger Width

  1. 169mm1 item
  2. 5.0"1 item
  3. 5.2"1 item
  4. 5.25"1 item
  5. 5.8"1 item

Gender

  1. Female28item
  2. Male18item
  3. Unisex49item

Skateboard Griptape Deck Width

  1. 9"5item

Vegan

  1. Yes13item
  2. No443item

Bike Size

  1. Small/Medium20item
  2. Medium5item

Bundle Starting Price

  1. £25.00 - £49.993item
  2. £50.00 - £74.998item
  3. £100.00 and above1 item

Age

  1. 6 to 834item
  2. 8 to 1239item
  3. 10 +39item

Scooter Height

  1. 68cm - 85cm23item
  2. 80cm - 90cm39item
  3. 90cm and over20item
  4. 69cm - 89cm35item

Longboard Length

  1. 28"3item
  2. 32"1 item
  3. 33"1 item
  4. 38"2item
  5. 40"1 item
  6. 42"1 item
  7. 44"2item
  8. 39.5"1 item

Bar Height Range

  1. 700mm and over1 item

Skate Type Boot

  1. Hard Boot17item
  2. Soft Boot47item

Skateboard Size

  1. Mini (under 31")1 item
  2. Full Size12item

Deck Length

  1. 19"5item
  2. 19.5"18item
  3. 20"2item
  4. 20.5"7item
  5. 21"9item
  6. 22"17item
  7. 22.5"1 item
  8. 23"7item
  9. 19.75"12item
  10. 21.25"2item
  11. 20.8"1 item
  12. 17.5"2item
  13. 19.3"5item
  14. 17"2item
  15. 18.5"9item
  16. 18"5item
  17. 22.2"2item

Deck Width

  1. 4"2item
  2. 4.3"2item
  3. 4.5"26item
  4. 4.7"2item
  5. 4.72"6item
  6. 4.75"2item
  7. 4.8"2item
  8. 5.1"5item
  9. 5.25"6item
  10. 5.5"14item
  11. 5.75"3item
  12. 5.8"1 item
  13. 5.9"1 item
  14. 6"17item
  15. 6.25"2item
  16. 6.5"3item

Skate Suitability

  1. Indoor24item
  2. Outdoor44item
  3. Indoor/Outdoor21item

Scooter Bar Shape

  1. T - Shape16item
  2. Y - Shape19item

Age Group

  1. Adult86item
  2. Kids47item

Skate Plate Construction

  1. Plastic30item
  2. Aluminium11item

Scooter Rider Height Range

  1. 125cm - 150cm34item
  2. 150cm - 170cm39item
  3. 170cm and over21item

Skateboard Wheel Size

  1. 52mm10item
  2. 53mm3item
  3. 66mm5item
  4. 70mm1 item

Skate Closure System

  1. Lacing60item
  2. Velcro13item
  3. Buckle27item

Abec Rating

  1. ABEC 532item
  2. ABEC 730item
  3. ABEC 96item
  4. ABEC 111 item
  5. Skate Rated2item
  6. Unrated11item

Size Adjustable?

  1. Yes7item
  2. No61item

Durometer Rating

  1. 100a1 item
  2. 101a1 item
  3. 78a8item
  4. 80a3item
  5. 82a22item
  6. 84a5item
  7. 85a16item
  8. 88a2item
  9. 94a1 item
  10. 95a3item
  11. 96a1 item
  12. 97a1 item
  13. 98a1 item
  14. 99a9item
  15. N/A3item

Adjustable Stopper?

  1. Yes21item
  2. No24item

Light-up Wheels?

  1. No45item

Skate Wheel Size

  1. N/A2item
  2. 54mm10item
  3. 56mm2item
  4. 57mm2item
  5. 58mm15item
  6. 60mm3item
  7. 62mm10item
  8. 64mm4item
  9. 65mm5item
  10. 66mm2item
  11. 70mm4item
  12. 72mm1 item
  13. 80mm13item
  14. 84mm5item
  15. 110mm1 item

Material Primary

  1. Aluminium8item
  2. Canvas5item
  3. Cotton1 item
  4. Faux Leather9item
  5. Faux Suede7item
  6. Hi-Ten Steel1 item
  7. Leather5item
  8. Maple13item
  9. Mesh1 item
  10. Plastic17item
  11. Suede2item
  12. Synthetic4item
  13. Vinyl7item
  14. PU4item
  15. Synthetic Leather3item

Skate Wheel Width

  1. N/A1 item
  2. 30mm3item
  3. 31mm1 item
  4. 32mm19item
  5. 33mm9item
  6. 35mm6item
  7. 36mm5item
  8. 38mm2item
  9. 43mm1 item

Builder Part

  1. Yes184item
  2. No1 item
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (409416, 409495, 406924, 407260, 408208, 408211, 408214, 408217, 408220, 408223, 408889, 408892, 408895, 408898, 408901, 407065, 407068, 408241, 408244, 408247, 408250, 408424, 408427, 407014)) ORDER BY FIELD(e.entity_id,409416,409495,406924,407260,408208,408211,408214,408217,408220,408223,408889,408892,408895,408898,408901,407065,407068,408241,408244,408247,408250,408424,408427,407014)

Showing 384 out of 456

Page