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

Garden Ornaments

At Bradshaws Direct we sell a range of garden ornaments and garden features to brighten up your garden.

Choose from our great selection of decorative garden features that will meet any budget including garden statues, outdoor clocks, thermometers and water features and add that unique look to your garden.

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(13756, 14300, 14321, 14741, 13434, 13440, 13446, 13458, 13461, 13464, 11530, 11534))

1 - 12 of 18

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

1 - 12 of 18

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