For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Use In Google Feed Yes Remove This Item
  2. Deck Length 20.5" Remove This Item
Clear All

Category

  1. SkateHut Sale9item

Sales Name

  1. Clearance3item
  2. Price Match1 item
  3. Red Tier 11 item

Scooter Compression Type

  1. HIC2item

Variant Width

  1. 4.8"2item
  2. 5.25"6item
  3. 5.5"1 item

Channel Filters

  1. Allowed21item

Stock At Supplier

  1. No20item

Cross Sell Type

  1. Colour8item

Reporting Status

  1. Live21item

In Magento

  1. Yes13item
  2. No8item

B-Stock

  1. No21item

Own Brand?

  1. No21item

Channels Ready

  1. Yes21item

Purchaser

  1. Ricky2item
  2. Tony4item

Country Of Origin

  1. China8item

Google Feed Margin Cat

  1. z23item
  2. z35item
  3. other5item

Order In Active

  1. No21item

Order In Product

  1. No21item

Export

  1. No21item

Has Identifier for GMC

  1. Yes7item
  2. No14item

Export Common

  1. No21item

Supplier Name

  1. Centrano9item
  2. Core6item
  3. Shiner2item
  4. RI Distribution4item

Best Suited to

  1. Park10item
  2. Street2item
  3. Hybrid2item

Scooter Type

  1. Stunt Scooter10item

Is for Gifting?

  1. No21item

Scooter Bar Height

  1. 584mm1 item
  2. 610mm3item
  3. 650mm4item

Scooter Height

  1. 820mm2item
  2. 870mm1 item
  3. 900mm4item
  4. 925mm3item

Skill Level

  1. Beginner2item
  2. Intermediate3item
  3. Pro7item

Product Type Basic

  1. Scooter Decks11item
  2. Scooters - Stunt Scooters10item

Is Simple Product

  1. Yes21item

Department

  1. Scooters21item

Price

  1. £25.00 - £49.992item
  2. £50.00 - £74.992item
  3. £75.00 - £99.993item
  4. £100.00 - £124.991 item
  5. £125.00 - £149.995item
  6. £175.00 - £199.995item
  7. £225.00 and above3item

Brand Name

  1. Blazer Pro2item
  2. Core6item
  3. Ethic1 item
  4. Lucky Scooters3item
  5. Native3item
  6. Root Industries5item
  7. Supremacy1 item

Product Type

  1. Scooters > Decks11item
  2. Scooters > Stunt Completes10item

Main Colour

  1. Black7item
  2. Blue1 item
  3. Gold2item
  4. Neochrome2item
  5. Raw2item
  6. Red3item
  7. Silver4item

Deck Type

  1. Integrated8item

Scooter Deck Type

  1. Integrated 100-110mm3item
  2. Integrated 120mm7item
  3. Integrated 125mm1 item

Vegan

  1. No21item

Age

  1. 6 to 83item
  2. 8 to 127item
  3. 10 +8item

Scooter Height

  1. 68cm - 85cm2item
  2. 80cm - 90cm7item
  3. 90cm and over7item
  4. 69cm - 89cm1 item

Deck Width

  1. 4.8"3item
  2. 5.1"3item
  3. 5.25"14item
  4. 5.5"1 item

Scooter Bar Shape

  1. T - Shape5item
  2. Y - Shape4item

Scooter Rider Height Range

  1. 125cm - 150cm3item
  2. 150cm - 170cm7item
  3. 170cm and over7item

Material Primary

  1. Aluminium1 item

Builder Part

  1. Yes11item
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 (364718, 101871, 101022, 254916, 254917, 136655, 408931, 406894, 406900, 387266, 406906, 407047, 409510, 260505, 406825, 406828, 406831, 409234, 409235, 409236, 409237)) ORDER BY FIELD(e.entity_id,364718,101871,101022,254916,254917,136655,408931,406894,406900,387266,406906,407047,409510,260505,406825,406828,406831,409234,409235,409236,409237)

21 Items