Home   >  Sprinklers  

Bulk Colorstorm Stake Impulse Sprinkler (Case of 6)

The Colorstorm Stake Impulse Sprinkler showers your lawn with water and keeps it looking green. Covers an area of 70 feet in diameter. The impulse sprinkler has an adjustable diffusion plate that makes it possible to change the angle of the water.

Model No: 10-15060 - In Stock

Discounts Available!

DRAMM

---

Colorstorm Stake Impulse Sprinkler (Case of 6)

Enter the quantity below and click "add to cart":

Database error: Invalid SQL: SELECT product_thumb_image,Bradprice,product_height,product_attribute.attribute_name,product_attribute.attribute_value,product_lwh_uom,product_attribute.product_id,product_attribute_sku.attribute_name,madeinusa,shippingsurcharge,bcispecial,product_weight,product_full_image,product.product_id,product_name,product_in_stock,loneinstock,loneprice,Color,Size,Ingredients,Infos from product,product_price,product_attribute_sku,product_attribute WHERE product_attribute.product_id=product.product_id AND product_attribute.attribute_name=product_attribute_sku.attribute_name AND product_parent_id='26557' AND product_attribute_sku.product_id='26557' AND product.product_id=product_price.product_id ORDER BY FIELD(lcase(substr(attribute_value,1,3)),'min','xxs','xsm','x-s','sma','med','int','lar','lrg','xla','xl ','xxl','xxx'), product_attribute.attribute_value asc
MySQL Error: 1030 (Got error 28 from storage engine)