For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Shoe Size Size - Junior UK 11 (EU 29) Remove This Item
  2. Material Primary Synthetic Remove This Item
Clear All

Category

  1. Skates13item
  2. Shoes3item
  3. Bundles5item
  4. SkateHut Sale2item
  5. Footwear13item
  6. Black Friday Deals2item

Sales Name

  1. Price Match2item
  2. Red Tier 11 item

Shoe Size Adjustable

  1. Junior UK 11 - UK 12item
  2. UK 1 - UK 42item
  3. UK 4 - UK 71 item

Shoe Size Multi

  1. Size - Junior UK 11 (EU 29)2item
  2. Size - Junior UK 11.5 (EU 29.5)2item
  3. Size - Junior UK 12 (EU 30)2item
  4. Size - Junior UK 12.5 (EU 31)2item
  5. Size - Junior UK 13 (EU 31.5)2item
  6. Size - Junior UK 13.5 (EU 32)2item
  7. Size - UK 1 (EU 33)2item
  8. Size - UK 1.5 (EU 33.5)2item
  9. Size - UK 2 (EU 34)2item
  10. Size - UK 2.5 (EU 34.5)2item
  11. Size - UK 3 (EU 35)2item
  12. Size - UK 3.5 (EU 36)2item
  13. Size - UK 4 (EU 37)2item
  14. Size - UK 4.5 (EU 37.5)1 item
  15. Size - UK 5 (EU 38)1 item
  16. Size - UK 5.5 (EU 38.5)1 item
  17. Size - UK 6 (EU 39)1 item
  18. Size - UK 6.5 (EU 39.5)1 item
  19. Size - UK 7 (EU 41)1 item

Variant Size

  1. Size - Junior UK 11 (EU 29)2item
  2. Size - UK 1 (EU 33)2item

Channel Filters

  1. Allowed16item

Stock At Supplier

  1. Yes1 item
  2. No15item

Cross Sell Type

  1. Colour11item

Reporting Status

  1. Live16item

In Magento

  1. Yes16item
  2. No15item

Use In Google Feed

  1. Yes16item
  2. No16item

B-Stock

  1. No16item

B-Stock Condition

  1. [Box Damage]1 item

Own Brand?

  1. No16item

Channels Ready

  1. Yes16item

Purchaser

  1. Ricky3item
  2. Tony9item

Google Feed Margin Cat

  1. z16item
  2. z25item
  3. z34item
  4. other11item

Order In Active

  1. No16item

Order In Product

  1. No16item

Export

  1. No16item

Has Identifier for GMC

  1. Yes5item
  2. No11item

Export Common

  1. No16item

Supplier Name

  1. Shiner3item
  2. Stateside13item

Is for Gifting?

  1. No16item

Is Configurable Product

  1. Yes5item

Product Type Basic

  1. Heelys14item
  2. Inline Skates - Adjustable2item

Heelys Collection

  1. Snazzy3item

Is Simple Product

  1. Yes2item
  2. No16item

Department

  1. Footwear14item
  2. Inline Skates2item

Price

  1. £25.00 - £49.9912item
  2. £50.00 and above4item

Brand Name

  1. Heelys3item
  2. SFR2item
  3. Breezy Rollers11item

Number Of Wheels

  1. 111item
  2. 23item

Product Type

  1. Footwear > Heelys14item
  2. Inline Skates > Adjustable Roller Blades2item

Main Colour

  1. Black2item
  2. Blue1 item
  3. Green1 item
  4. Multi1 item
  5. Pink4item
  6. Silver1 item
  7. White5item

Gender

  1. Female5item
  2. Unisex11item

Vegan

  1. No16item

Skate Type Boot

  1. Soft Boot2item

Skate Suitability

  1. Indoor2item
  2. Outdoor2item

Age Group

  1. Kids16item

Skate Closure System

  1. Lacing2item
  2. Velcro2item
  3. Buckle2item

Abec Rating

  1. ABEC 52item

Size Adjustable?

  1. Yes2item

Durometer Rating

  1. 82a2item

Adjustable Stopper?

  1. No2item

Light-up Wheels?

  1. No2item

Skate Wheel Size

  1. 64mm2item
  2. 70mm2item
  3. 72mm1 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, 405880, 406078, 406114, 406222, 406258, 406321, 406357, 406393, 408991, 154088, 154087, 150787, 155145, 155146)) ORDER BY FIELD(e.entity_id,406150,406186,405880,406078,406114,406222,406258,406321,406357,406393,408991,154088,154087,150787,155145,155146)

16 Items