For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Gender Male Remove This Item
  2. Age Group Adult Remove This Item
Clear All

Category

  1. Skates27item
  2. Bikes2item
  3. Shoes1 item
  4. Clothes4item
  5. Brands32item
  6. Bundles25item
  7. Clearance1 item
  8. New Arrivals1 item
  9. SkateHut Sale16item
  10. Footwear1 item

Sales Name

  1. Reduction1 item
  2. Clearance3item
  3. Price Match10item
  4. Red Tier 11 item
  5. Red Tier 21 item

Shoe Size Adjustable

  1. Junior UK 11 - UK 11 item
  2. UK 1 - UK 41 item

Shoe Size Multi

  1. Size - Junior UK 11 (EU 29)1 item
  2. Size - Junior UK 11.5 (EU 29.5)1 item
  3. Size - Junior UK 12 (EU 30)1 item
  4. Size - Junior UK 12.5 (EU 31)1 item
  5. Size - Junior UK 13 (EU 31.5)1 item
  6. Size - Junior UK 13.5 (EU 32)1 item
  7. Size - UK 1 (EU 33)2item
  8. Size - UK 1.5 (EU 33.5)1 item
  9. Size - UK 2 (EU 34)1 item
  10. Size - UK 2.5 (EU 34.5)1 item
  11. Size - UK 3 (EU 35)1 item
  12. Size - UK 3.5 (EU 36)1 item
  13. Size - UK 4 (EU 37)1 item

Variant Size

  1. Size - Junior UK 11 (EU 29)1 item
  2. Size - Junior UK 12 (EU 30)1 item
  3. Size - Junior UK 13 (EU 31.5)5item
  4. Size - UK 1 (EU 33)7item
  5. Size - UK 2 (EU 34)8item
  6. Size - UK 3 (EU 35)14item
  7. Size - UK 3.5 (EU 36)1 item
  8. Size - UK 4 (EU 37)14item
  9. Size - UK 4.5 (EU 37.5)1 item
  10. Size - UK 5 (EU 38)13item
  11. Size - UK 6 (EU 39)13item
  12. Size - UK 7 (EU 41)14item
  13. Size - UK 7.5 (EU 41.5)1 item
  14. Size - UK 8 (EU 42)12item
  15. Size - UK 9 (EU 43)5item
  16. Size - UK 10 (EU 44)2item
  17. Size - UK 11 (EU 46)3item
  18. Size - UK 12 (EU 47)2item
  19. Size - UK 13 (EU 48)1 item

Channel Filters

  1. Allowed29item
  2. Excluded5item

Stock At Supplier

  1. Yes5item
  2. No30item

Cross Sell Type

  1. Colour24item

Reporting Status

  1. Live30item
  2. Discontinued2item
  3. Pending3item

In Magento

  1. Yes31item
  2. No17item

Use In Google Feed

  1. Yes32item
  2. No22item

B-Stock

  1. Yes1 item
  2. No32item

B-Stock Condition

  1. [Box Damage]1 item

Own Brand?

  1. No30item

Channels Ready

  1. Yes32item
  2. No2item

Purchaser

  1. Billy22item
  2. Phil1 item
  3. Ricky1 item
  4. Tony5item
  5. Brucey2item
  6. Ross1 item

Google Feed Margin Cat

  1. z19item
  2. z219item
  3. z317item
  4. other1 item

Order In Active

  1. Yes5item
  2. No21item

Order In Active Shipping Group

  1. Order in - 5 day leadtime5item

Order In Product

  1. Yes6item
  2. No29item

Export

  1. No25item

Has Identifier for GMC

  1. Yes32item
  2. No2item

Export Common

  1. No25item

Supplier Name

  1. 6030 Sports1 item
  2. Form1 item
  3. Hotline UK1 item
  4. J&R1 item
  5. New English2item
  6. Silverfish2item
  7. Skatemate1 item
  8. Sneaker Sheets1 item
  9. Stateside22item
  10. Kaltik1 item

Is for Gifting?

  1. No32item

Is Configurable Product

  1. Yes23item

Product Label Text

  1. 30% Off1 item
  2. 8% Off1 item
  3. 11% Off1 item

Product Type Basic

  1. Bike Jerseys2item
  2. Jackets1 item
  3. Shorts1 item
  4. Insoles1 item
  5. Ice Skates - Figure6item
  6. Ice Skate Guards8item
  7. Inline Skates - Adjustable2item
  8. Inline Skates - Rollerblades1 item
  9. Roller Derby Skate Boots1 item
  10. Roller Skates10item

Is Simple Product

  1. Yes12item
  2. No23item

Department

  1. Bikes2item
  2. Clothes/Accessories2item
  3. Footwear1 item
  4. Ice Skates14item
  5. Inline Skates3item
  6. Roller Derby2item
  7. Roller Skates9item

Price

  1. £0.00 - £24.999item
  2. £25.00 - £49.996item
  3. £50.00 - £74.9911item
  4. £75.00 - £99.992item
  5. £125.00 - £149.991 item
  6. £225.00 - £249.991 item
  7. £250.00 and above3item

Brand Name

  1. 100 percent2item
  2. Edea2item
  3. iXS1 item
  4. Kaltik1 item
  5. Luigino1 item
  6. Riedell1 item
  7. Rio Roller7item
  8. Royal Racing1 item
  9. SFR15item
  10. SkateMate1 item
  11. Sneaker Sheets1 item

Product Type

  1. Bikes > Clothing Jerseys2item
  2. Clothes/Accessories > Jackets1 item
  3. Clothes/Accessories > Shorts1 item
  4. Footwear > Insoles1 item
  5. Ice Skates > Figure Skates6item
  6. Ice Skates > Guards8item
  7. Inline Skates > Adjustable Roller Blades2item
  8. Inline Skates > Roller Blades1 item
  9. Roller Derby > Roller Derby Skates1 item
  10. Roller Derby > Roller Derby Skates - Boot Only1 item
  11. Roller Skates > Completes10item

Sport

  1. Cycling2item

Main Colour

  1. Black13item
  2. Blue5item
  3. Green2item
  4. Grey2item
  5. Navy1 item
  6. Pink1 item
  7. Red1 item
  8. Silver1 item
  9. White4item
  10. Yellow2item

Shoe Size

  1. Size - Junior UK 11 (EU 29)1 item
  2. Size - Junior UK 12 (EU 30)1 item
  3. Size - Junior UK 13 (EU 31.5)6item
  4. Size - UK 1 (EU 33)8item
  5. Size - UK 2 (EU 34)8item
  6. Size - UK 3 (EU 35)14item
  7. Size - UK 3.5 (EU 36)1 item
  8. Size - UK 4 (EU 37)14item
  9. Size - UK 4.5 (EU 37.5)2item
  10. Size - UK 5 (EU 38)13item
  11. Size - UK 6 (EU 39)13item
  12. Size - UK 7 (EU 41)14item
  13. Size - UK 7.5 (EU 41.5)1 item
  14. Size - UK 8 (EU 42)12item
  15. Size - UK 9 (EU 43)6item
  16. Size - UK 10 (EU 44)3item
  17. Size - UK 11 (EU 46)3item
  18. Size - UK 12 (EU 47)3item
  19. Size - UK 13 (EU 48)1 item

Size

  1. Small1 item
  2. Medium1 item
  3. Extra Large2item

Vegan

  1. Yes9item
  2. No21item

Skate Type Boot

  1. Hard Boot1 item
  2. Soft Boot12item

Skate Suitability

  1. Indoor12item
  2. Outdoor11item
  3. Indoor/Outdoor2item

Skate Plate Construction

  1. Plastic10item
  2. Aluminium1 item

Skate Closure System

  1. Lacing11item
  2. Velcro1 item
  3. Buckle3item

Abec Rating

  1. ABEC 55item
  2. ABEC 77item
  3. ABEC 91 item

Size Adjustable?

  1. Yes2item
  2. No12item

Durometer Rating

  1. 82a11item
  2. 85a1 item
  3. 95a1 item

Adjustable Stopper?

  1. Yes4item
  2. No7item

Light-up Wheels?

  1. No11item

Skate Wheel Size

  1. 54mm3item
  2. 58mm8item
  3. 62mm5item
  4. 64mm1 item
  5. 70mm1 item
  6. 80mm1 item

Material Primary

  1. Faux Leather5item
  2. Faux Suede4item
  3. Plastic3item
  4. Polyester1 item
  5. Polyester Blend2item
  6. Vinyl1 item

Skate Wheel Width

  1. 30mm3item
  2. 32mm2item
  3. 33mm6item
  4. 36mm4item
  5. 43mm1 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 (82844, 82843, 82874, 134408, 134409, 82462, 158457, 158458, 82456, 82461, 82460, 173840, 173841, 82457, 408184, 400951, 139284, 151914, 119289, 82854, 82855, 119326, 119327, 119335)) ORDER BY FIELD(e.entity_id,82844,82843,82874,134408,134409,82462,158457,158458,82456,82461,82460,173840,173841,82457,408184,400951,139284,151914,119289,82854,82855,119326,119327,119335)

Showing 24 out of 33

Page