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 22 results

Filter By

Current Filters

  1. Has Identifier for GMC No Remove This Item
  2. Main Colour Black Remove This Item
Clear All

Category

  1. Skates8item
  2. Bikes6item
  3. Shoes3item
  4. Clothes4item
  5. Brands21item
  6. Clearance1 item
  7. Offers5item
  8. New Arrivals2item
  9. SkateHut Sale5item
  10. Last One1 item
  11. SkateHut Clearance2item

Order In Active

  1. No9item

Order In Active Shipping Group

  1. Order in - 5 day leadtime9item

Order In Product

  1. Yes14item
  2. No6item

Export

  1. No9item

Export Common

  1. No9item

Supplier Name

  1. Greenover6item
  2. J&R9item
  3. Nineteen762item
  4. Rock Solid2item
  5. Shiner3item

Is for Gifting?

  1. No22item

Bike Frame Size

  1. 29"6item

Bike Wheel Size

  1. 29"6item

Product Label Text

  1. 30% Off3item
  2. 45% Off2item

Material Secondary

  1. Aluminium1 item

Stock At Supplier

  1. Yes14item
  2. No9item

Cross Sell Type

  1. Colour6item

Reporting Status

  1. Live16item
  2. Pending6item

Sales Name

  1. B-Stock1 item

In Magento

  1. Yes9item
  2. No13item

Season Name

  1. B-Stock1 item
  2. Carryover Stock4item
  3. Order In Product14item
  4. Order In Warehouse Stock2item
  5. Holiday 232item
  6. Fall 241 item

Use In Google Feed

  1. Yes21item
  2. No18item

B-Stock

  1. Yes1 item
  2. No21item

B-Stock Condition

  1. [Box Damage]1 item

Product Type Basic

  1. Mountain Bike Completes6item
  2. Caps2item
  3. Hats2item
  4. Skate Shoes & Trainers3item
  5. Inline Skates - Freerides1 item
  6. Inline Skates - Rollerblades8item

Own Brand?

  1. No22item

Channels Ready

  1. Yes21item
  2. No1 item

Channel Filters

  1. Allowed11item
  2. Excluded11item

ShipperHQ Shipping Group

  1. Order in - 5 day leadtime14item

Google Feed Margin Cat

  1. z32item
  2. other7item

Department

  1. Bikes6item
  2. Clothes/Accessories4item
  3. Electrical/Tech3item
  4. Footwear3item
  5. Inline Skates9item

Is Simple Product

  1. Yes5item
  2. No17item

Price

  1. €0.00 - €24.992item
  2. €25.00 - €49.994item
  3. €50.00 - €74.991 item
  4. €125.00 - €149.993item
  5. €175.00 - €199.991 item
  6. €200.00 - €224.991 item
  7. €300.00 - €324.992item
  8. €350.00 - €374.992item
  9. €7,250.00 - €7,274.991 item
  10. €8,825.00 and above5item

Sport

  1. Cycling3item

Brand Name

  1. Feiyue3item
  2. Grizzly2item
  3. Primitive2item
  4. Rocky Mountain6item
  5. SEBA5item
  6. FR Skates2item
  7. Luminous Skates2item

Product Type

  1. Bikes > Mountain Bike Completes6item
  2. Clothes/Accessories > Caps2item
  3. Clothes/Accessories > Hats2item
  4. Footwear > Skate Shoes and Trainers3item
  5. Inline Skates > Roller Blades8item
  6. Inline Skates > Freeride Completes1 item

Shoe Size

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

Size

  1. One Size Fits Most2item

Closure Type

  1. Strapback4item

Clothing Style Cap

  1. 5-Panel1 item
  2. Dad Hat1 item
  3. 6-Panel2item

Gender

  1. Unisex16item

Vegan

  1. No22item

Bike Size

  1. Small5item
  2. Medium2item
  3. Large2item
  4. X-Large1 item

Bike Fork Travel

  1. 150mm3item
  2. 170mm3item

Bike Suspension

  1. Full Suspension6item

Skate Type Boot

  1. Hard Boot7item
  2. Soft Boot2item

Skate Suitability

  1. Outdoor9item

Age Group

  1. Adult16item

Skate Closure System

  1. Lacing9item
  2. Velcro6item
  3. Buckle9item

Abec Rating

  1. ABEC 74item
  2. ABEC 91 item
  3. Unrated4item

Size Adjustable?

  1. No9item

Durometer Rating

  1. 82a2item
  2. 84a2item
  3. 85a5item

Adjustable Stopper?

  1. No1 item

Light-up Wheels?

  1. No1 item

Skate Wheel Size

  1. 80mm8item
  2. 84mm1 item
  3. 110mm1 item

Material Primary

  1. Aluminium4item
  2. Canvas3item
  3. Carbon2item
  4. Cotton4item
  5. Leather2item
  6. Plastic7item
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 (382697, 389929, 382445, 389440, 389431, 383600, 379175, 379211, 379649, 389104, 380228, 383603, 379610, 380375, 379418, 379736, 376000, 376045, 376069, 376354, 376366, 376384))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,382697,389929,382445,389440,389431,383600,379175,379211,379649,389104,380228,383603,379610,380375,379418,379736,376000,376045,376069,376354,376366,376384)

22 Items