For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "squbi three wheel scooter" has 54 results

Filter By

Current Filters

  1. Order In Active No Remove This Item
  2. Shoe Size Size - UK 4 (EU 37) Remove This Item
Clear All

Category

  1. Skates49item
  2. Shoes5item
  3. Bundles33item
  4. New Arrivals4item
  5. SkateHut Sale24item
  6. Footwear16item

Material Secondary

  1. Aluminium1 item

Sales Name

  1. Reduction1 item
  2. Clearance1 item
  3. Price Match12item
  4. Red Tier 21 item

Variant Size

  1. Size - Junior UK 11 (EU 29)3item
  2. Size - Junior UK 12 (EU 30)3item
  3. Size - Junior UK 13 (EU 31.5)6item
  4. Size - UK 1 (EU 33)6item
  5. Size - UK 2 (EU 34)10item
  6. Size - UK 3 (EU 35)20item
  7. Size - UK 4 (EU 37)26item
  8. Size - UK 5 (EU 38)20item
  9. Size - UK 6 (EU 39)25item
  10. Size - UK 7 (EU 41)22item
  11. Size - UK 8 (EU 42)18item
  12. Size - UK 9 (EU 43)5item
  13. Size - UK 10 (EU 44)3item
  14. Size - UK 11 (EU 46)4item
  15. Size - UK 12 (EU 47)3item
  16. Size - UK 13 (EU 48)1 item

Channel Filters

  1. Allowed51item
  2. Excluded4item
  3. Ebay Only1 item

Stock At Supplier

  1. Yes8item
  2. No52item

Cross Sell Type

  1. Colour43item
  2. Size1 item

Reporting Status

  1. Live54item
  2. Discontinued1 item

In Magento

  1. Yes47item
  2. No47item

Use In Google Feed

  1. Yes54item
  2. No54item

B-Stock

  1. No54item

Own Brand?

  1. No54item

Channels Ready

  1. Yes54item
  2. No1 item

Purchaser

  1. Billy21item
  2. Ricky3item
  3. Tony15item

Google Feed Margin Cat

  1. z123item
  2. z220item
  3. z317item
  4. other18item

Order In Active Shipping Group

  1. Order in - 5 day leadtime8item
  2. Order in - 2-4 day leadtime1 item

Order In Product

  1. Yes6item
  2. No54item

Export

  1. No54item

Has Identifier for GMC

  1. Yes29item
  2. No26item

Export Common

  1. No54item

Supplier Name

  1. Centrano4item
  2. J&R9item
  3. Shiner6item
  4. Stateside35item

Is for Gifting?

  1. No54item

Is Configurable Product

  1. Yes29item

Product Label Text

  1. 30% Off4item
  2. 60% Off1 item
  3. 6% Off2item
  4. 54% Off1 item
  5. 11% Off1 item

Product Type Basic

  1. Heelys18item
  2. Inline Skates - Rollerblades5item
  3. Roller Skates31item

Heelys Collection

  1. Classic2item
  2. Rezerve2item

Is Simple Product

  1. Yes8item
  2. No54item

Department

  1. Footwear18item
  2. Inline Skates5item
  3. Roller Derby1 item
  4. Roller Skates30item

Price

  1. £25.00 - £49.9920item
  2. £50.00 - £74.9922item
  3. £75.00 - £99.997item
  4. £125.00 - £149.991 item
  5. £150.00 - £174.991 item
  6. £225.00 - £249.991 item
  7. £275.00 and above2item

Brand Name

  1. Candi Girl1 item
  2. Heelys5item
  3. Moxi3item
  4. Riedell1 item
  5. Rio Roller13item
  6. Roces4item
  7. Rookie1 item
  8. SEBA2item
  9. SFR9item
  10. FR Skates2item
  11. Breezy Rollers13item

Number Of Wheels

  1. 116item
  2. 22item

Product Type

  1. Footwear > Heelys18item
  2. Inline Skates > Roller Blades5item
  3. Roller Derby > Roller Derby Skates1 item
  4. Roller Skates > Completes31item

Main Colour

  1. Black18item
  2. Blue4item
  3. Cream1 item
  4. Green3item
  5. Navy1 item
  6. Pink8item
  7. Purple1 item
  8. Red1 item
  9. Silver1 item
  10. Teal3item
  11. White11item
  12. Yellow2item

Gender

  1. Female16item
  2. Male15item
  3. Unisex34item

Vegan

  1. Yes9item
  2. No45item

Skate Type Boot

  1. Hard Boot3item
  2. Soft Boot33item

Skate Suitability

  1. Indoor25item
  2. Outdoor34item
  3. Indoor/Outdoor2item

Age Group

  1. Adult34item
  2. Kids44item

Skate Plate Construction

  1. Plastic27item
  2. Aluminium5item

Skate Closure System

  1. Lacing36item
  2. Velcro12item
  3. Buckle5item

Abec Rating

  1. ABEC 513item
  2. ABEC 716item
  3. Skate Rated4item
  4. Unrated3item

Size Adjustable?

  1. No36item

Durometer Rating

  1. 82a26item
  2. 84a2item
  3. 85a7item
  4. 95a1 item

Adjustable Stopper?

  1. Yes7item
  2. No24item

Light-up Wheels?

  1. No31item

Skate Wheel Size

  1. 53mm4item
  2. 54mm9item
  3. 58mm21item
  4. 62mm8item
  5. 66mm1 item
  6. 80mm5item
  7. 84mm1 item

Material Primary

  1. Canvas5item
  2. Faux Leather13item
  3. Faux Suede4item
  4. Leather1 item
  5. Plastic3item
  6. Suede1 item
  7. Synthetic13item
  8. Vinyl8item
  9. PU4item

Skate Wheel Width

  1. 30mm9item
  2. 32mm12item
  3. 33mm13item
  4. 36mm7item
  5. 38mm1 item
  6. 43mm1 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 = '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 (406150, 406186, 153278, 134407, 153277, 405880, 406078, 406114, 406222, 406258, 406294, 406321, 406357, 406393, 408991, 409197, 403581, 76890, 76891, 119331, 119340, 380375, 119361, 119362)) ORDER BY FIELD(e.entity_id,406150,406186,153278,134407,153277,405880,406078,406114,406222,406258,406294,406321,406357,406393,408991,409197,403581,76890,76891,119331,119340,380375,119361,119362)

Showing 24 out of 54

Page