EUR €

  • Choose a currency

  • British Pound Sterling Website:
  • Danish Krone Website:
  • Swedish Krona Website:
  • MOTO Website:

For Sales & Advice Call Us on 071928374650192837565

Search

Menu

Loading...

Your search for "feiyue mid" has 17 results

Filter By

Current Filters

  1. Season Name Carryover Stock Remove This Item
  2. Purchaser Ricky Remove This Item
Clear All

Category

  1. Skateboards16item
  2. Bikes1 item
  3. Bundles16item
  4. Offers7item
  5. Half Price6item
  6. SkateHut Sale7item
  7. Last One8item

Order In Active

  1. No12item

Order In Product

  1. No12item

Export

  1. No15item

Has Identifier for GMC

  1. Yes17item

Export Common

  1. No15item

Supplier Name

  1. Hotline UK1 item
  2. Shiner16item

Skateboard Deck Randomiser

  1. No11item

Is for Gifting?

  1. No17item

Bike Frame Size

  1. 23.5"1 item

Bike Type

  1. BMX1 item

Bike Wheel Size

  1. 29"1 item

Product Label Text

  1. 50% Off3item
  2. 45% Off1 item
  3. Last One7item
  4. 55% Off1 item
  5. 60% Off2item

Stock At Supplier

  1. No15item

Cross Sell Type

  1. Colour6item
  2. Width9item

Reporting Status

  1. Live17item

Sales Name

  1. Clearance1 item
  2. Red Tier 13item
  3. Red Tier 21 item

In Magento

  1. Yes17item

Use In Google Feed

  1. Yes17item

B-Stock

  1. No17item

Product Type Basic

  1. BMX Completes1 item
  2. Skateboard Trucks15item
  3. Undercarriage Kits1 item

Own Brand?

  1. No17item

Channels Ready

  1. Yes17item

Variant Width

  1. 129mm1 item
  2. 139mm2item
  3. 148mm1 item
  4. 149mm1 item
  5. 5"2item
  6. 5.25"1 item
  7. 5.5"1 item
  8. 6"1 item
  9. 7.13"1 item
  10. 7.63"1 item
  11. 8.25"1 item
  12. 9"2item

Channel Filters

  1. Allowed16item
  2. Excluded1 item

Google Feed Margin Cat

  1. z11 item
  2. z21 item
  3. z315item

Department

  1. Bikes1 item
  2. Skateboards16item

Is Simple Product

  1. Yes17item

Price

  1. €0.00 - €24.992item
  2. €25.00 - €49.998item
  3. €50.00 - €74.993item
  4. €75.00 - €99.993item
  5. €600.00 and above1 item

Sport

  1. Cycling1 item

Brand Name

  1. Birdhouse1 item
  2. Grind King4item
  3. Independent4item
  4. Krux3item
  5. Mini Logo2item
  6. SE1 item
  7. Sushi1 item
  8. Thunder1 item

Age

  1. 13+ Years1 item

Product Type

  1. Bikes > BMX Completes1 item
  2. Skateboards > Trucks15item
  3. Skateboards > Undercarriage Kits1 item

Skateboard Truck Height

  1. Mid - Wheels 53-56mm16item

Main Colour

  1. Black3item
  2. Raw7item
  3. Silver7item

Skateboard Deck Width Suitability

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

Skateboard Truck Hanger Width

  1. 129mm1 item
  2. 139mm2item
  3. 148mm1 item
  4. 149mm1 item
  5. 5.0"2item
  6. 5.25"2item
  7. 5.5"1 item
  8. 6.0"1 item
  9. 7.13"1 item
  10. 7.63"1 item
  11. 8.25"1 item
  12. 9.0"2item

Vegan

  1. No17item

Truck Width

  1. 129mm1 item
  2. 139mm2item
  3. 148mm1 item
  4. 149mm1 item
  5. 5"2item
  6. 5.25"1 item
  7. 5.5"1 item
  8. 6"1 item
  9. 8.25"1 item
  10. 9"2item

Age Group

  1. Adult1 item

Builder Part

  1. Yes15item
  2. No1 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 = '5' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 5 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (111808, 111809, 112613, 60328, 111785, 163732, 238012, 238014, 111764, 111765, 111767, 111769, 111774, 111775, 112354, 112518, 176505))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,111808,111809,112613,60328,111785,163732,238012,238014,111764,111765,111767,111769,111774,111775,112354,112518,176505)

17 Items