Home |  Shop |  Search |  Checkout   Join us on Facebook Follow us on Twitter



Home   >  Sprinklers  


Impulse Sprinkler Metal Head Poly Sled Base

Impulse Sprinkler Metal Head Poly Sled Base

Average rating: 5 Stars. 1 Total Reviews - Scroll down for details
View 1 or more review(s)    Submit a Review


Heavy duty metal head on polymer sled base. Provides partial or full coverage of yard. Water coverage up to 5,800 sq.ft.

Model No: 167SPB - In Stock

Discounts Available!
Buy at Amazon for less!


GILMOUR Impulse Sprinkler Metal Head Poly Sled Base
GILMOUR
GILMOUR Authorized Dealer




Impulse Sprinkler Metal Head Poly Sled Base

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='52680' AND product_attribute_sku.product_id='52680' 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)