For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "sfr air x pro" has 179 results

Filter By

Current Filters

  1. Main Colour Blue Remove This Item
Clear All

Category

  1. Skateboards46item
  2. Scooters71item
  3. Skates23item
  4. Bikes15item
  5. Longboards10item
  6. Protection14item
  7. Shoes1 item
  8. Clothes1 item
  9. Bags2item
  10. Accessories2item
  11. Sports1 item
  12. Outdoor1 item
  13. Water Sports1 item
  14. More2item
  15. Brands166item
  16. Bundles120item
  17. Clearance3item
  18. New Arrivals6item
  19. SkateHut Sale61item
  20. Footwear1 item
  21. Black Friday Deals14item

Bike Frame Size

  1. 20.5"1 item

Bike Type

  1. BMX5item
  2. BMX1 item
  3. Mini1 item
  4. Mountain2item

Bike Wheel Size

  1. 10"1 item
  2. 20"6item
  3. 27.5"1 item
  4. 29"1 item

Dimension Bag Capacity

  1. 16 - 25 L1 item

Foldable?

  1. Yes1 item
  2. No11item

Height Adjustable?

  1. Yes1 item
  2. No11item

Helmet Certification

  1. EN1078 Certified8item

Kick Stand?

  1. No1 item

Light Brake?

  1. No1 item

Light Front?

  1. No1 item

Light Rear?

  1. No1 item

Regenerative Breaking?

  1. No1 item

Sales Name

  1. Reduction4item
  2. Clearance10item
  3. Price Match22item
  4. Red Tier 13item
  5. Red Tier 26item
  6. B-Stock3item

Scooter Compression Type

  1. IHC6item
  2. HIC1 item
  3. SCS3item

Shoe Size Adjustable

  1. Junior UK 8 - Junior UK 112item
  2. Junior UK 11 - UK 13item
  3. Junior UK 12 - UK 22item
  4. UK 1 - UK 42item
  5. UK 3 - UK 62item

Shoe Size Multi

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

Variant Size

  1. Size - Toddler UK 8 (EU 25.5)1 item
  2. Size - Junior UK 11 (EU 29)3item
  3. Size - Junior UK 12 (EU 30)2item
  4. Size - Junior UK 13 (EU 31.5)2item
  5. Size - UK 1 (EU 33)4item
  6. Size - UK 2 (EU 34)2item
  7. Size - UK 3 (EU 35)4item
  8. Size - UK 4 (EU 37)3item
  9. Size - UK 5 (EU 38)3item
  10. Size - UK 6 (EU 39)4item
  11. Size - UK 7 (EU 41)3item
  12. Size - UK 8 (EU 42)3item
  13. Size - UK 9 (EU 43)1 item

Skateboard Type

  1. Cruiser1 item
  2. Stunt5item
  3. Stunt12item

Variant Width

  1. 129mm1 item
  2. 139mm1 item
  3. 4.5"4item
  4. 5"3item
  5. 5.25"1 item
  6. 5.5"1 item
  7. 6"1 item
  8. 6.25"1 item
  9. 7.75"2item
  10. 8"5item
  11. 8.13"1 item
  12. 8.25"3item
  13. 8.375"1 item
  14. 9"1 item
  15. 9.75"1 item

Channel Filters

  1. Allowed156item
  2. Excluded21item
  3. Ebay Only2item

Helmet Size Range

  1. 48 - 54cm1 item
  2. 49 - 52cm3item
  3. 52 - 56cm1 item
  4. 53 - 56cm5item
  5. 55 - 58cm1 item
  6. 57 - 59cm5item
  7. XXL (58cm - 62cm)1 item

Helmet Impact Type

  1. Single Impact8item

Stock At Supplier

  1. Yes17item
  2. No142item

Cross Sell Type

  1. Colour115item
  2. Width5item

Reporting Status

  1. Live168item
  2. Preview1 item
  3. Discontinued6item
  4. Pending4item

In Magento

  1. Yes133item
  2. No62item

Use In Google Feed

  1. Yes176item
  2. No31item

B-Stock

  1. Yes3item
  2. No176item

B-Stock Condition

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

Own Brand?

  1. Yes16item
  2. No160item

Channels Ready

  1. Yes166item
  2. No13item

Longboard Wheel Variants

  1. Blue - 77a2item
  2. Orange - 80a3item
  3. Purple - 83a3item
  4. Yellow - 86a3item

Purchaser

  1. Billy40item
  2. Phil7item
  3. Ricky4item
  4. Tony24item
  5. SWAG5item
  6. Brucey6item
  7. Own Brand15item
  8. Ross1 item
  9. Rob1 item

Country Of Origin

  1. China12item

Google Feed Margin Cat

  1. z123item
  2. z232item
  3. z377item
  4. other8item

Skateboard Wheel Base

  1. 12.8"1 item
  2. 13"4item
  3. 13.8"3item
  4. 14"7item
  5. 13.98"2item

Skateboard Deck Shape

  1. Classic Popsicle17item

Skateboard Griptape

  1. Applied22item
  2. Not Included16item

Skateboard Length

  1. 29"1 item
  2. 29.5"3item
  3. 31"5item
  4. 31.5"6item
  5. 32"3item

Skateboard Deck Concave

  1. Medium17item

Skateboard Deck Construction

  1. 7-Ply16item
  2. 8-Ply1 item

Order In Active

  1. Yes7item
  2. No126item

Order In Active Shipping Group

  1. Order in - 5 day leadtime8item
  2. Order in - 2-4 day leadtime1 item
  3. Order in 2-4 day and large on normal courier2item

Order In Product

  1. Yes15item
  2. No148item

Skateboard Riding Use

  1. Street17item
  2. Park9item

Export

  1. No139item

Has Identifier for GMC

  1. Yes123item
  2. No56item

Export Common

  1. No139item

Supplier Name

  1. Centrano33item
  2. Core15item
  3. Dwindle3item
  4. Greenover1 item
  5. Guang Wooden2item
  6. HLC1 item
  7. Hotline UK1 item
  8. J&R26item
  9. Keen2item
  10. LG Sports Distribution10item
  11. Madison Distribution3item
  12. MML UK1 item
  13. New Day Fury1 item
  14. Nineteen761 item
  15. Onecall2item
  16. Rock Solid3item
  17. Seventies1 item
  18. Shiner5item
  19. Silverfish1 item
  20. Skatehut5item
  21. Sneaker Sheets1 item
  22. Stateside40item
  23. Stuff Agency1 item
  24. TKC1 item
  25. Upgrade2item
  26. USG6item
  27. Wilton Bradley1 item
  28. Yvolve6item
  29. Traffic-uk1 item
  30. RI Distribution3item

Best Suited to

  1. Park11item
  2. Hybrid6item

Scooter Type

  1. Fliker Scooter2item
  2. Infants & Toddler Scooter1 item
  3. Kids Scooter7item
  4. Light Up Wheel2item
  5. Stunt Scooter12item
  6. Trampoline Scooter1 item
  7. Snow Scooter1 item

Skateboard Deck Randomiser

  1. Yes3item
  2. No9item

Board Length

  1. 37"1 item

Is for Gifting?

  1. Yes11item
  2. No163item

Is Gift Tier

  1. High10item

Skateboard Height Range

  1. 3' 7" - 4' 7"4item
  2. 4' 2" - 5' 2"9item
  3. 5' 2" and over14item

Skateboard Shoe Size Range

  1. J 12 - UK 34item
  2. UK 1 - UK 59item
  3. UK 5 - UK 86item
  4. UK 10 - UK 124item
  5. UK 11 - UK 122item
  6. UK 12 and over2item

Scooter Bar Height

  1. Adjustable8item
  2. 550mm1 item
  3. 560mm1 item
  4. 570mm1 item
  5. 584mm1 item
  6. 600mm1 item
  7. 609mm1 item
  8. 620mm4item
  9. 635mm1 item
  10. 650mm1 item
  11. 711mm1 item
  12. 754mm1 item
  13. 845mm1 item
  14. 890mm1 item
  15. 900mm1 item
  16. 1045mm1 item

Scooter Height

  1. 754mm1 item
  2. 780mm1 item
  3. 805mm1 item
  4. 810mm4item
  5. 830mm2item
  6. 840mm2item
  7. 845mm3item
  8. 850mm2item
  9. 855mm1 item
  10. 865mm1 item
  11. 870mm2item
  12. 890mm1 item
  13. 900mm2item
  14. 915mm1 item
  15. 1045mm1 item

Is Configurable Product

  1. Yes23item

Product Label Text

  1. Free Grip Tape13item
  2. 20% Off1 item
  3. 30% Off2item
  4. 35% Off1 item

Longboard Shape

  1. Cruiser3item

Skill Level

  1. Beginner21item
  2. Intermediate8item
  3. Pro1 item

Product Type Basic

  1. Backpacks1 item
  2. Balance Bikes1 item
  3. BMX Completes6item
  4. Mini BMX Completes1 item
  5. Mountain Bike Completes2item
  6. Mountain BIke Pedal Pins1 item
  7. Mountain BIke Pedals2item
  8. Insoles1 item
  9. Ice Skate Guards3item
  10. Inline Skates - Adjustable5item
  11. Longboard Completes3item
  12. Cruisers3item
  13. Longboard Decks3item
  14. Helmets8item
  15. Mouth Guards1 item
  16. Pad Sets7item
  17. Roller Skates - Adjustable2item
  18. Roller Skates6item
  19. Skate Bags2item
  20. Toe Stops3item
  21. Skate Wheels1 item
  22. Scooter Bar Ends1 item
  23. Scooter Bearings1 item
  24. Scooter Collar Clamps3item
  25. Scooter Compression Kits1 item
  26. Scooter Decks10item
  27. Scooters - Fliker2item
  28. Scooters - Folding8item
  29. Scooter Forks6item
  30. Scooter Grip Tape7item
  31. Scooter Grips9item
  32. Scooter Bars1 item
  33. Scooter Headsets2item
  34. Scooters (Snow)1 item
  35. Scooters - Stunt Scooters12item
  36. Scooters - Three Wheel1 item
  37. Scooters - Toddler1 item
  38. Scooter Wheels6item
  39. Skateboard Bearings1 item
  40. Skateboard Bushings1 item
  41. Skateboard - Completes19item
  42. Skateboard Decks13item
  43. Skateboard Grip Tape2item
  44. Skateboard Trucks5item
  45. Skateboard Wheels1 item
  46. Cricket Sets1 item
  47. Bodyboards1 item
  48. Trampoline Scooters1 item

Is Simple Product

  1. Yes149item
  2. No31item

Department

  1. Bags and Wallets1 item
  2. Bikes13item
  3. Footwear1 item
  4. Ice Skates3item
  5. Inline Skates4item
  6. Longboards9item
  7. Protection16item
  8. Roller Skates15item
  9. Scooters73item
  10. Skateboards40item
  11. Sports and Outdoor1 item
  12. Water1 item

Price

  1. £0.00 - £24.9957item
  2. £25.00 - £49.9945item
  3. £50.00 - £74.9926item
  4. £75.00 - £99.9914item
  5. £100.00 - £124.999item
  6. £125.00 - £149.994item
  7. £150.00 - £174.993item
  8. £175.00 - £199.995item
  9. £200.00 - £224.992item
  10. £225.00 and above14item

Brand Name

  1. Addict Scootering2item
  2. Apex Pro Scooters4item
  3. Blunt Envy1 item
  4. Chubby Wheels4item
  5. Core15item
  6. Darkstar1 item
  7. DMR2item
  8. Dominator Scooters1 item
  9. Eastern Bikes6item
  10. Element1 item
  11. Enjoi2item
  12. Enuff14item
  13. Ethic6item
  14. Flip2item
  15. Gotcha1 item
  16. Grizzly1 item
  17. Gumball1 item
  18. Hype1 item
  19. Indo2item
  20. iXS1 item
  21. Jart1 item
  22. JD Bug5item
  23. Kink1 item
  24. Krooked1 item
  25. Lazer1 item
  26. LMNADE4item
  27. Loaded6item
  28. Lucky Scooters1 item
  29. Meow1 item
  30. MGP (Madd Gear Pro)14item
  31. Mindless2item
  32. ODI2item
  33. Powell Peralta1 item
  34. Powerplay1 item
  35. Race Face1 item
  36. Rad1 item
  37. Rampage9item
  38. REKD3item
  39. Rio Roller4item
  40. River Wheels1 item
  41. Roces1 item
  42. Root Industries6item
  43. SFR15item
  44. SkateHut1 item
  45. Slamm2item
  46. Sneaker Sheets1 item
  47. Speed Demons1 item
  48. Spitfire1 item
  49. SQUBI1 item
  50. Striker1 item
  51. Thank You1 item
  52. Tilt Scooters3item
  53. Tony Hawk Signature Series2item
  54. Toy Machine1 item
  55. United Skates1 item
  56. UrbanArtt Brand1 item
  57. Vital1 item
  58. WeThePeople1 item
  59. Y-Volution6item
  60. Longway3item
  61. Wildcat1 item

Head Size Multi

  1. 48cm1 item
  2. 49cm4item
  3. 50cm4item
  4. 50.8cm4item
  5. 51cm4item
  6. 52cm5item
  7. 53cm7item
  8. 54cm7item
  9. 55cm7item
  10. 56cm7item
  11. 57cm6item
  12. 58cm7item
  13. 59cm6item
  14. 60cm1 item
  15. 61cm1 item
  16. 62cm1 item

Number Of Wheels

  1. 27item
  2. 33item
  3. 41 item

Product Type

  1. Bags and Wallets > Backpacks1 item
  2. Bikes > Balance Bikes1 item
  3. Bikes > BMX Completes6item
  4. Bikes > Mini BMX Completes1 item
  5. Bikes > Mountain Bike Completes2item
  6. Bikes > Mountain Bikes > Pedal Pins1 item
  7. Bikes > Mountain Bikes > Pedals2item
  8. Footwear > Insoles1 item
  9. Ice Skates > Guards3item
  10. Inline Skates > Adjustable Roller Blades5item
  11. Longboards > Completes3item
  12. Longboards > Cruisers3item
  13. Longboards > Decks3item
  14. Protection > Helmets8item
  15. Protection > Mouth Guards1 item
  16. Protection > Pad Sets7item
  17. Roller Skates > Adjustable Skates2item
  18. Roller Skates > Completes6item
  19. Roller Skates > Skate Bags2item
  20. Roller Skates > Toe Stops3item
  21. Roller Skates > Wheels1 item
  22. Scooters > Bearings1 item
  23. Scooters > Collar Clamps3item
  24. Scooters > Compression Kits1 item
  25. Scooters > Decks10item
  26. Scooters > Folding Completes8item
  27. Scooters > Forks6item
  28. Scooters > Grip Tape7item
  29. Scooters > Grips10item
  30. Scooters > Handle Bars1 item
  31. Scooters > Headsets2item
  32. Scooters > Three Wheeled Completes4item
  33. Scooters > Trampoline Scooters1 item
  34. Scooters > Wheels6item
  35. Skateboards > Bearings1 item
  36. Skateboards > Bushings1 item
  37. Skateboards > Completes19item
  38. Skateboards > Decks13item
  39. Skateboards > Grip Tape2item
  40. Skateboards > Trucks5item
  41. Skateboards > Wheels1 item
  42. Sports and Outdoor > Cricket > Sets1 item
  43. Water > Surfing > Bodyboards1 item
  44. Scooters > Stunt Completes12item
  45. Scooters > Snow Scooters1 item

Sport

  1. Cricket1 item
  2. Cycling4item

Skateboard Age Range

  1. 6 and under1 item
  2. 6 to 102item
  3. 8 to 133item
  4. 13 and over14item

Age

  1. 9+ Years7item
  2. 13+ Years2item

Head Size

  1. 45 - 50 cm4item
  2. 50 - 55 cm7item
  3. 55 - 60 cm7item

Age Range

  1. 3 - 6 Years4item
  2. 6 - 12 Years7item
  3. Adults7item

Skateboard Deck Width Range

  1. 7.25" - 7.49"4item
  2. 7.50" - 7.99"10item
  3. 8.00 - 8.124"7item
  4. 8.125" - 8.24"1 item
  5. 8.25" - 8.49"5item
  6. 8.50" - 8.79"3item
  7. 8.80" - 11"2item

Grip Length

  1. 129mm1 item
  2. 135mm2item
  3. 170mm3item
  4. 173mm1 item
  5. 180mm2item

Deck Type

  1. Integrated11item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars2item
  2. Fits Oversized Bars2item
  3. Fits Standard Bars2item

Scooter Bar Type

  1. Aluminium (Standard)4item
  2. No Slit SCS1 item
  3. Standard IHC ICS Threaded1 item

Scooter Clamp Type

  1. Collar Clamp6item
  2. Collar Clamp + Shim1 item
  3. SCS Compression1 item

Scooter Fork Type

  1. Fork For Small Wheels HIC1 item
  2. Fork For Small Wheels IHC3item
  3. Fork For Small Wheels SCS2item
  4. Fork For 120mm Wheels IHC3item
  5. Fork For 120mm Wheels SCS1 item

Scooter Headset Type

  1. Integrated7item

Scooter Wheel Size

  1. 100mm5item
  2. 110mm6item
  3. 120mm11item
  4. 140mm1 item
  5. n/a1 item

Skateboard Deck Width

  1. 7.25"4item
  2. 7.5"1 item
  3. 7.75"10item
  4. 8"7item
  5. 8.13"1 item
  6. 8.25"3item
  7. 8.375"1 item
  8. 8.45"1 item
  9. 8.5"3item
  10. 8.875"1 item
  11. 8.88"1 item
  12. 9"1 item
  13. 9.5"1 item
  14. 9.75"1 item

Truck Width

  1. 129mm1 item
  2. 139mm1 item
  3. 5"1 item
  4. 5.25"1 item
  5. 5.5"1 item
  6. 8"1 item
  7. 8.25"1 item
  8. 8.375"1 item
  9. 8.875"1 item

Shoe Size

  1. Size - Toddler UK 8 (EU 25.5)1 item
  2. Size - Junior UK 11 (EU 29)4item
  3. Size - Junior UK 12 (EU 30)2item
  4. Size - Junior UK 13 (EU 31.5)2item
  5. Size - UK 1 (EU 33)4item
  6. Size - UK 2 (EU 34)3item
  7. Size - UK 3 (EU 35)5item
  8. Size - UK 3.5 (EU 36)1 item
  9. Size - UK 4 (EU 37)4item
  10. Size - UK 5 (EU 38)4item
  11. Size - UK 6 (EU 39)5item
  12. Size - UK 7 (EU 41)4item
  13. Size - UK 8 (EU 42)4item
  14. Size - UK 9 (EU 43)1 item

Pad Size

  1. Extra Extra Small1 item
  2. Extra Small4item
  3. Small6item
  4. Medium6item
  5. Large4item

Skateboard Truck Height

  1. Low - Wheels < 53mm5item

Scooter Deck Type

  1. Integrated 100-110mm7item
  2. Integrated 120mm7item

Head Size Single

  1. 48cm1 item
  2. 49cm2item
  3. 53cm3item
  4. 55cm1 item
  5. 57cm3item
  6. 58cm1 item
  7. S/M1 item
  8. L/XL1 item

Skateboard Deck Width Suitability

  1. 7.4"1 item
  2. 7.5"2item
  3. 7.6"2item
  4. 7.75"3item
  5. 7.8"2item
  6. 7.85"2item
  7. 7.88"2item
  8. 7.9"2item
  9. 8"2item
  10. 8.1"2item
  11. 8.12"2item
  12. 8.2"2item
  13. 8.25"3item
  14. 8.3"1 item
  15. 8.38"1 item
  16. 8.4"1 item
  17. 8.5"1 item
  18. 7.875"2item
  19. 8.375"1 item

Skateboard Truck Hanger Width

  1. 129mm1 item
  2. 139mm1 item
  3. 5.0"1 item
  4. 5.25"1 item
  5. 5.5"1 item

Gender

  1. Female3item
  2. Male6item
  3. Unisex13item

Skateboard Griptape Deck Width

  1. 9"2item
  2. 11"1 item

Vegan

  1. Yes8item
  2. No166item

Bike Size

  1. Small1 item
  2. Small/Medium4item
  3. Medium3item
  4. Large1 item
  5. X-Large1 item

Age

  1. 6 to 816item
  2. 8 to 1220item
  3. 10 +15item

Scooter Height

  1. 68cm - 85cm16item
  2. 80cm - 90cm21item
  3. 90cm and over4item
  4. 69cm - 89cm8item

Scooter Brake Type

  1. Flex Fender4item
  2. Stubby1 item

Longboard Length

  1. 22.5"1 item
  2. 26"1 item
  3. 27.75"2item
  4. 28"1 item
  5. 35"1 item
  6. 39"3item

Bar Height Range

  1. 700mm and over1 item

Bar Width Range

  1. 600mm - 624mm1 item

Helmet Type

  1. Skate Helmet5item
  2. Bike Helmet7item

Skate Type Boot

  1. Hard Boot2item
  2. Soft Boot11item

Skateboard Size

  1. Mini (under 31")5item
  2. Full Size14item

Deck Length

  1. 19"1 item
  2. 19.5"8item
  3. 20"2item
  4. 20.5"1 item
  5. 21"1 item
  6. 22"1 item
  7. 23"1 item
  8. 19.75"1 item
  9. 21.25"1 item
  10. 17.5"1 item
  11. 17"1 item
  12. 18"2item

Bike Suspension

  1. Hardtail2item
  2. Rigid1 item

Scooter Wheel Width

  1. 24mm6item

Deck Width

  1. 120mm2item
  2. 4"1 item
  3. 4.3"1 item
  4. 4.5"7item
  5. 4.72"2item
  6. 5.1"1 item
  7. 5.25"1 item
  8. 5.5"1 item
  9. 6"1 item

Skate Suitability

  1. Indoor9item
  2. Outdoor10item
  3. Indoor/Outdoor4item

Scooter Bar Shape

  1. T - Shape4item
  2. Y - Shape9item

Age Group

  1. Adult15item
  2. Kids28item

Skate Plate Construction

  1. Plastic9item

Scooter Rider Height Range

  1. 125cm - 150cm18item
  2. 150cm - 170cm22item
  3. 170cm and over4item

Skateboard Wheel Size

  1. 50mm2item
  2. 52mm3item
  3. 53mm2item
  4. 54mm12item
  5. 55mm1 item
  6. 56mm1 item
  7. 62mm2item
  8. 66mm1 item
  9. 70mm1 item

Skate Closure System

  1. Lacing9item
  2. Velcro5item
  3. Buckle6item

Abec Rating

  1. ABEC 33item
  2. ABEC 510item
  3. ABEC 710item
  4. ABEC 98item
  5. ABEC 112item
  6. Skate Rated2item

Size Adjustable?

  1. Yes7item
  2. No8item

Durometer Rating

  1. 100a4item
  2. 55d1 item
  3. 82a11item
  4. 85a1 item
  5. 90a5item
  6. 92a1 item
  7. 95a2item
  8. 96a1 item
  9. 99a4item
  10. 99d1 item
  11. N/A1 item

Adjustable Stopper?

  1. Yes1 item
  2. No11item

Light-up Wheels?

  1. No12item

Skate Wheel Size

  1. 52mm1 item
  2. 53mm2item
  3. 54mm4item
  4. 58mm3item
  5. 62mm2item
  6. 64mm2item
  7. 70mm4item
  8. 72mm1 item

Material Primary

  1. Aluminium7item
  2. Canadian Maple1 item
  3. Canvas1 item
  4. Faux Leather2item
  5. Faux Suede2item
  6. Maple16item
  7. Nylon1 item
  8. Plastic3item
  9. Polyester2item
  10. Synthetic2item
  11. Vinyl2item
  12. PU1 item

Skate Wheel Width

  1. 30mm3item
  2. 32mm4item
  3. 33mm2item
  4. 36mm2item

Builder Part

  1. Yes61item
  2. No3item
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 (408847, 84116, 101234, 101203, 101218, 406705, 160602, 111741, 163947, 409018, 374301, 136144, 398754, 394607, 136656, 408118, 409495, 405865, 101169, 102102, 102107, 382961, 101188, 408898)) ORDER BY FIELD(e.entity_id,408847,84116,101234,101203,101218,406705,160602,111741,163947,409018,374301,136144,398754,394607,136656,408118,409495,405865,101169,102102,102107,382961,101188,408898)

Showing 48 out of 179

Page