For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "feiyue mid" has 33 results

Filter By

Current Filters

  1. Order In Product Yes Remove This Item
  2. Export Common No Remove This Item
Clear All

Category

  1. Skateboards12item
  2. Skates13item
  3. Bikes5item
  4. Bundles19item
  5. New Arrivals4item
  6. SkateHut Sale6item

Bike Type

  1. BMX3item

Bike Wheel Size

  1. 20"3item
  2. 24"2item

Sales Name

  1. Clearance1 item
  2. Price Match1 item
  3. Red Tier 14item
  4. Red Tier 22item

Variant Size

  1. Size - UK 2 (EU 34)2item
  2. Size - UK 3 (EU 35)2item
  3. Size - UK 4 (EU 37)2item
  4. Size - UK 5 (EU 38)2item
  5. Size - UK 6 (EU 39)2item
  6. Size - UK 7 (EU 41)2item
  7. Size - UK 8 (EU 42)2item
  8. Size - UK 9 (EU 43)2item
  9. Size - UK 10 (EU 44)1 item
  10. Size - UK 11 (EU 46)1 item
  11. Size - UK 12 (EU 47)1 item

Variant Width

  1. 129mm1 item
  2. 149mm1 item
  3. 169mm1 item
  4. 5"1 item
  5. 5.25"1 item
  6. 5.5"2item
  7. 7.6"2item
  8. 8"3item
  9. 8.25"3item

Channel Filters

  1. Allowed18item
  2. Excluded13item
  3. Ebay Only2item

Stock At Supplier

  1. Yes33item
  2. No11item

Cross Sell Type

  1. Colour15item
  2. Width15item

Reporting Status

  1. Live31item
  2. Discontinued1 item
  3. Pending1 item

In Magento

  1. Yes29item
  2. No16item

Use In Google Feed

  1. Yes33item
  2. No13item

B-Stock

  1. No33item

Own Brand?

  1. No33item

Channels Ready

  1. Yes33item

Purchaser

  1. Ricky12item
  2. Tony5item

Google Feed Margin Cat

  1. z27item
  2. z317item
  3. other10item

Order In Active

  1. Yes3item
  2. No22item

Order In Active Shipping Group

  1. Order in - 5 day leadtime14item

Export

  1. No33item

Has Identifier for GMC

  1. Yes19item
  2. No14item

Supplier Name

  1. 4 Down1 item
  2. J&R14item
  3. New English2item
  4. Shiner12item
  5. Upgrade2item
  6. USG2item

Skateboard Deck Randomiser

  1. No7item

Is for Gifting?

  1. Yes1 item
  2. No32item

Is Configurable Product

  1. Yes2item

Product Label Text

  1. 30% Off7item

Product Type Basic

  1. BMX Completes3item
  2. BMX Tyres2item
  3. Ice Skates - Figure2item
  4. Inline Skates - Freerides1 item
  5. Inline Skates - Rollerblades10item
  6. Skateboard Trucks15item

Is Simple Product

  1. Yes20item
  2. No13item

Department

  1. Bikes5item
  2. Ice Skates2item
  3. Inline Skates11item
  4. Skateboards15item

Price

  1. £0.00 - £24.994item
  2. £25.00 - £49.9910item
  3. £50.00 - £74.993item
  4. £100.00 - £124.991 item
  5. £125.00 - £149.992item
  6. £150.00 - £174.992item
  7. £225.00 - £249.992item
  8. £250.00 - £274.992item
  9. £275.00 - £299.994item
  10. £525.00 and above3item

Brand Name

  1. DMR2item
  2. Eastern Bikes2item
  3. Edea2item
  4. Fit1 item
  5. Krux8item
  6. Paris Trucks Co3item
  7. SEBA3item
  8. Sushi4item
  9. FR Skates5item
  10. Luminous Skates3item

Product Type

  1. Bikes > BMX Completes3item
  2. Bikes > BMX Tyres2item
  3. Ice Skates > Figure Skates2item
  4. Inline Skates > Roller Blades10item
  5. Skateboards > Trucks15item
  6. Inline Skates > Freeride Completes1 item

Sport

  1. Cycling2item

Age

  1. 9+ Years3item

Main Colour

  1. Black14item
  2. Blue1 item
  3. Clear1 item
  4. Green1 item
  5. Multi3item
  6. Raw3item
  7. Red2item
  8. Silver4item
  9. Tan1 item
  10. White2item
  11. Yellow1 item

Truck Width

  1. 129mm1 item
  2. 169mm1 item
  3. 5"1 item
  4. 5.25"1 item
  5. 5.5"3item
  6. 7.6"2item
  7. 8"1 item
  8. 8.25"3item

Shoe Size

  1. Size - UK 2 (EU 34)2item
  2. Size - UK 3 (EU 35)2item
  3. Size - UK 4 (EU 37)4item
  4. Size - UK 5 (EU 38)6item
  5. Size - UK 6 (EU 39)10item
  6. Size - UK 6.5 (EU 39.5)9item
  7. Size - UK 7 (EU 41)10item
  8. Size - UK 8 (EU 42)13item
  9. Size - UK 9 (EU 43)10item
  10. Size - UK 9.5 (EU 43.5)7item
  11. Size - UK 10 (EU 44)6item
  12. Size - UK 11 (EU 46)5item
  13. Size - UK 12 (EU 47)5item
  14. Size - UK 13 (EU 48)1 item

Skateboard Truck Height

  1. Mid - Wheels 53-56mm15item

Skateboard Deck Width Suitability

  1. 7"1 item
  2. 7.12"1 item
  3. 7.15"1 item
  4. 7.25"3item
  5. 7.3"3item
  6. 7.35"3item
  7. 7.4"3item
  8. 7.5"4item
  9. 7.6"4item
  10. 7.75"7item
  11. 7.8"8item
  12. 7.85"7item
  13. 7.88"7item
  14. 7.9"7item
  15. 8"11item
  16. 8.1"8item
  17. 8.12"8item
  18. 8.2"9item
  19. 8.25"9item
  20. 8.3"3item
  21. 8.38"3item
  22. 8.4"3item
  23. 8.5"3item
  24. 8.6"1 item
  25. 8.62"1 item
  26. 8.68"1 item
  27. 8.7"1 item
  28. 8.75"1 item
  29. 8.82"1 item
  30. 8.85"1 item
  31. 8.9"1 item
  32. 9"2item
  33. 9.12"1 item
  34. 9.5"1 item
  35. 9.62"1 item
  36. 9.75"1 item
  37. 10"1 item
  38. 7.875"7item
  39. 8.125"10item
  40. 8.375"3item
  41. 8.675"1 item

Skateboard Truck Hanger Width

  1. 129mm1 item
  2. 149mm1 item
  3. 169mm1 item
  4. 5.0"1 item
  5. 5.25"1 item
  6. 5.5"2item
  7. 7.6"2item
  8. 8.0"3item
  9. 8.25"3item

Gender

  1. Female2item
  2. Male2item
  3. Unisex13item

Vegan

  1. No33item

Bike Size

  1. Small1 item
  2. Small/Medium2item

Skate Type Boot

  1. Hard Boot9item
  2. Soft Boot2item

Skate Suitability

  1. Outdoor11item

Age Group

  1. Adult13item
  2. Kids2item

Skate Closure System

  1. Lacing11item
  2. Velcro4item
  3. Buckle11item

Abec Rating

  1. ABEC 73item
  2. ABEC 92item
  3. Unrated6item

Size Adjustable?

  1. No11item

Durometer Rating

  1. 82a1 item
  2. 84a4item
  3. 85a6item

Skate Wheel Size

  1. 80mm9item
  2. 84mm2item
  3. 110mm1 item

Material Primary

  1. Leather2item
  2. Plastic9item

Builder Part

  1. Yes10item
  2. No5item
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 (112610, 112613, 112614, 111817, 379175, 379211, 379649, 285751, 285752, 380228, 380375, 379388, 379418, 379736, 379769, 379802, 379835, 392689, 397049, 397052, 82854, 82855, 112519, 111796)) ORDER BY FIELD(e.entity_id,112610,112613,112614,111817,379175,379211,379649,285751,285752,380228,380375,379388,379418,379736,379769,379802,379835,392689,397049,397052,82854,82855,112519,111796)

Showing 24 out of 33

Page