Fast Delivery
Price Match
Expert Support
Fast Delivery
Price Match
Expert Support
Call Us Call Us Help Help Basket Basket

Cooling & Air Care

View as Grid List

5 Items

Set Descending Direction
    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' 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 (669, 3003, 3010, 4377, 4380)) ORDER BY FIELD(e.entity_id,669,3003,3010,4377,4380)
  1. PRIORITY: | QTY: 1 | RECOMMENDED: | PRICE: 19.99

    Dimensions: H 47 x W 34 x D 22.5 cm

    £19.99
    More Info
  2. PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 49.99

    Dimensions: H 31.8 x W 24.9 x D 24.9 cm

    £49.99
    More Info
  3. PRIORITY: | QTY: 0 | RECOMMENDED: | PRICE: 329

    Dimensions: H 57 x W 33.5 x D 33.5 cm

    £329.00
    More Info
  4. PRIORITY: | QTY: 2 | RECOMMENDED: | PRICE: 149.99

    Dimensions: H 39.7 x W 29.5 x D 30.7 cm

    £149.99
    More Info
  5. PRIORITY: | QTY: 11 | RECOMMENDED: | PRICE: 79.99

    Dimensions: H 32.8 x W 22 x D 22 cm

    £79.99
    More Info
per page
Now Shopping by
  1. Category Desk Fans Remove This Item
Filters Clear all
Price
  1. £0.00 - £99.99 (3)
  2. £100.00 - £199.99 (1)
  3. £300.00 and above (1)
Manufacturer
  1. IGENIX (2)
  2. Morphy Richards (1)
  3. Shark (2)
Warranty
  1. 2 (5)
Check delivery to your postcode
postcode: local: no
session postcode: session local: no
A G A B C D E F G