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

PondKraft Products

PondKraft is a new range of pond products that are exclusive to Bradshaws. We've listened to what you want from us and searched long and hard to find the right products at the right price. We've found products that are reliable, well designed and easy to use and put them together under the PondKraft brand.

Browse the new exciting PondKraft range online today!

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(12749, 12750, 12754, 14616, 14719, 14720, 12697, 12698, 12699, 12700, 12720, 14716))

1 - 12 of 44

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

1 - 12 of 44

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