+44 1904 698815
My basket €0.000 item(s)

Eheim

Eheim are world renowned for the quality of their aquarium products. Making everything from thermometers to filters and heaters to complete fish tanks this German company deserve their excellent reputation. Here at Bradshaws we are proud to stock the Eheim range of products and hope that you'll like them.
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`, `cat_index`.`position` AS `cat_index_position` 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.website_id = '2' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2' WHERE (`e`.`entity_id` IN(14126, 12994, 13026, 13030, 14642, 12966, 12969, 12970, 12971, 12972, 12973, 14646))

1 - 12 of 23

  2. 1
▪▪▪
  1. 2
Filter By
Help +44 1904 698815, let us help you!

1 - 12 of 23

  2. 1
▪▪▪
  1. 2
Filter By
Help +44 1904 698815, let us help you!
Latest from our Blog View Blog