For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Reporting Status Live Remove This Item
  2. Department Bikes Remove This Item
Clear All

Category

  1. Scooters2item
  2. Electrics1 item
  3. Clothes1 item
  4. Bundles2item
  5. New Arrivals7item
  6. SkateHut Sale11item
  7. Black Friday Deals6item

Bike Frame Size

  1. 19.25"2item
  2. 20"2item
  3. 20.5"3item
  4. 21"1 item
  5. 24"1 item

Bike Type

  1. Balance1 item
  2. BMX28item
  3. BMX1 item
  4. Electric1 item
  5. Mini1 item
  6. Mountain6item
  7. Road1 item

Bike Wheel Size

  1. 10"1 item
  2. 20"30item
  3. 27.5"5item
  4. 29"5item

Sales Name

  1. Clearance2item
  2. Exclusion1 item
  3. Price Match2item

Variant Size

  1. 90mm1 item
  2. 20"1 item
  3. 18"1 item

Channel Filters

  1. Allowed22item
  2. Excluded40item

Max Range

  1. 24 miles1 item

Max Speed

  1. 15.5 mph1 item

Stock At Supplier

  1. Yes24item
  2. No36item

Cross Sell Type

  1. Colour43item
  2. Size2item

In Magento

  1. Yes23item
  2. No43item

Use In Google Feed

  1. Yes62item
  2. No9item

B-Stock

  1. No62item

Own Brand?

  1. No62item

Channels Ready

  1. Yes59item
  2. No3item

Purchaser

  1. Billy1 item
  2. Phil1 item
  3. Tony2item
  4. Brucey15item
  5. Rob1 item

Google Feed Margin Cat

  1. z14item
  2. z25item
  3. z311item
  4. other1 item

Order In Active

  1. No36item

Order In Active Shipping Group

  1. Order in 2-4 days, oversize onto worldoptions1 item

Order In Inactive Shipping Group

  1. Oversize items too big for normal couriers1 item

Order In Product

  1. Yes24item
  2. No34item

Export

  1. No37item

Has Identifier for GMC

  1. Yes22item
  2. No40item

Export Common

  1. No37item

Supplier Name

  1. 4 Down1 item
  2. BSD1 item
  3. Centrano3item
  4. Certified Collective 1 item
  5. Flow1 item
  6. Form1 item
  7. J&R2item
  8. Moore Large2item
  9. Seventies2item
  10. Silverfish9item
  11. Upgrade1 item
  12. USG28item
  13. Yvolve1 item
  14. Quella1 item
  15. Traffic-uk8item

Is for Gifting?

  1. Yes2item
  2. No60item

Is Configurable Product

  1. Yes3item
  2. No1 item

Product Type Basic

  1. Bike Repair Kits1 item
  2. Balance Bikes3item
  3. BMX Completes29item
  4. BMX Grips1 item
  5. BMX Headsets1 item
  6. BMX Inner Tubes3item
  7. BMX Pedals1 item
  8. Bike Jerseys1 item
  9. Bike Shorts1 item
  10. Electric Bike Completes1 item
  11. Fixie Bike Completes1 item
  12. Mini BMX Completes1 item
  13. Mountain Bike Completes7item
  14. Mountain BIke Chain Rings2item
  15. Mountain BIke Grips1 item
  16. Mountain BIke Handlebars2item
  17. Mountain BIke Inner Tubes1 item
  18. Mountain BIke Pedals4item
  19. Mountain BIke Stems1 item

Is Simple Product

  1. Yes52item
  2. No10item

Price

  1. £0.00 - £24.999item
  2. £25.00 - £49.997item
  3. £50.00 - £74.991 item
  4. £75.00 - £99.992item
  5. £100.00 - £124.991 item
  6. £125.00 - £149.993item
  7. £225.00 - £249.996item
  8. £300.00 - £324.991 item
  9. £325.00 - £349.995item
  10. £425.00 and above27item

Brand Name

  1. 100%1 item
  2. Collective Bikes1 item
  3. Cult1 item
  4. DMR1 item
  5. Eastern Bikes26item
  6. Fit1 item
  7. Flow1 item
  8. Kenda1 item
  9. MGP (Madd Gear Pro)2item
  10. Michelin1 item
  11. Odyssey1 item
  12. Race Face7item
  13. Radio2item
  14. Royal Racing1 item
  15. Salt2item
  16. Super B1 item
  17. Tag Metals2item
  18. WeThePeople4item
  19. Y-Volution1 item
  20. Quella1 item
  21. Wildcat1 item
  22. Cinema1 item
  23. Tribal2item

Product Type

  1. Bikes > Accessories > Repair Kits1 item
  2. Bikes > Balance Bikes3item
  3. Bikes > BMX Completes29item
  4. Bikes > BMX Grips1 item
  5. Bikes > BMX Headsets1 item
  6. Bikes > BMX Inner Tubes3item
  7. Bikes > BMX Pedals1 item
  8. Bikes > Clothing Jerseys1 item
  9. Bikes > Clothing Shorts1 item
  10. Bikes > Electric Bike Completes1 item
  11. Bikes > Mini BMX Completes1 item
  12. Bikes > Mountain Bike Completes7item
  13. Bikes > Mountain Bikes > Chain Rings2item
  14. Bikes > Mountain Bikes > Grips1 item
  15. Bikes > Mountain Bikes > Handlebars2item
  16. Bikes > Mountain Bikes > Inner Tubes1 item
  17. Bikes > Mountain Bikes > Pedals4item
  18. Bikes > Mountain Bikes > Stems1 item
  19. Bikes > Fixie Bike Completes1 item

Sport

  1. Cycling18item

Age

  1. 9+ Years30item
  2. 13+ Years7item

Grip Length

  1. 135mm1 item
  2. 150mm1 item

Main Colour

  1. Black21item
  2. Blue9item
  3. Green2item
  4. Grey2item
  5. Orange5item
  6. Purple1 item
  7. Raw1 item
  8. Red6item
  9. Tan1 item
  10. Teal1 item
  11. Turquoise1 item
  12. White5item
  13. Yellow5item

Scooter Headset Type

  1. Integrated1 item

Size

  1. Medium1 item
  2. Waist 28"1 item
  3. Waist 38"1 item

Gender

  1. Male1 item

Vegan

  1. No62item

Bike Size

  1. Small7item
  2. Small/Medium21item
  3. Medium13item
  4. Large4item
  5. X-Large5item

Bike Fork Travel

  1. Rigid1 item

Bike Suspension

  1. Hardtail7item
  2. Rigid3item

Age Group

  1. Adult2item

Material Primary

  1. Aluminium1 item
  2. Hi-Ten Steel3item
  3. Nylon2item
  4. Polyester Blend2item

Builder Part

  1. Yes2item
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 (356744, 272749, 62671, 62528, 231349, 206509, 400540, 400525, 400555, 400570, 309109, 410385, 410386, 153728, 408514, 60192, 171187, 398658, 398661, 407659, 157326, 397262, 397274, 400510)) ORDER BY FIELD(e.entity_id,356744,272749,62671,62528,231349,206509,400540,400525,400555,400570,309109,410385,410386,153728,408514,60192,171187,398658,398661,407659,157326,397262,397274,400510)

Showing 24 out of 62

Page