Dust Pans

Dust Pans - Any item or chemical used to clean, scrub, or maintain floors

SUBCATEGORIES
	Handheld Dust Pan	(3)
	Lobby Dust Pans	(25)

VENDORS
	Carlisle	(19)
	Royal Industries	(3)
	Thunder Group	(3)
	Winco	(3)

PRICES
	$ 4 - $ 23	(21)
	$ 23 - $ 300	(7)

CONSTRUCTION
	metal	(1)
	plastic	(4)
	plastic w/handle	(6)

Search Results: 28 Products

Sort:

SELECT p_model, p_title as p_titlang, p_title, p_descrip as p_descrip, p_sell, p_sellBy, p_listPrc, p_mapPrc, prc_bustSite, prc_bustCart, sp_price, v_id, v_name , (MATCH (p_title) AGAINST ('+Dust +Pan' IN BOOLEAN MODE) ) * p_relevance as relev FROM products JOIN pricing ON p_prc_id = prc_id JOIN vendor ON prc_v_id = v_id JOIN prod_cat ON pc_p_id = p_id JOIN category ON pc_c_id = c_id LEFT JOIN ship_prod ON sp_p_id = p_id LEFT JOIN media ON p_id = m_p_id AND m_type = 'Image' WHERE p_sell <> 0 and p_relevance >= 0 and c_left >= (SELECT c_left FROM category WHERE c_id = 2608) AND c_right <= (SELECT c_right FROM category WHERE c_id = 2608) order by relev desc, p_model LIMIT 24, 24