Hands-Free Faucets

PERFECT FOR PEOPLE WITH A LOT ON THEIR MINDS (AND HANDS).

Finally an idea whose time has come. Danze brings the convenience of an automatic, hands-free faucet to your home. Just place your hand in front of the sensor at the spout base to start the water. Perfect for clean-up when you’re handling food or for washing kids’ messy hands without messing up the faucet. Our ingenious design lets you set the water to come on at a predetermined temperature. And the flow stops when you put your hand in front of the sensor again or when the timer runs out. You can even set the timer to just the right length. Of course, you can also use the handle manually like you would with ordinary faucets. All this functionality comes in the beautiful form of our sleek Parma™ design. All controls are hidden under the sink and can be wired to the same power source as your garbage disposal or use batteries.

SELECT  prod.name as prodname,tblsubgroup.tagname as subrouptag, col.name as ColName, subcol.name as SubColName,  col.description,pd.sku,pd.base_sku, colgroup.name as colgroupname ,grp.tagname as grouptag   ,md.tagname as midgrouptag,colmid.name as midgroupname,  collectcaption.html_code as trade , collectcaption.name as collectName,collectcaption.captionID as collectionID from tblproduct pd

INNER JOIN tblproduct_midgroup gp ON pd.productID = gp.productID

INNER JOIN tblmidgroup md ON md.midgroupID = gp.midgroupID

INNER JOIN tblcaption collectcaption ON collectcaption.captionID = pd.collectionID AND collectcaption.type=2 and collectcaption.languageID= 1

INNER JOIN tblgroup grp ON  grp.groupID = md.groupID

INNER JOIN tblcaption colmid ON colmid.captionID = md.midgroupID AND colmid.type=11  and colmid.groupID= 1 and colmid.languageID=1

LEFT JOIN tblcaption subcol ON pd.subcollectionID = subcol.captionID and subcol.type = 17 and subcol.languageID= 1

INNER JOIN tblsubgroup ON pd.subgroupID = tblsubgroup.subgroupID

INNER JOIN tblcaption prod ON prod.captionID = pd.productID AND prod.type=7 and prod.languageID= 1

INNER JOIN tblcaption col ON col.captionID = tblsubgroup.subgroupID AND col.groupID = 1 AND col.type=12  and col.languageID=1

INNER JOIN tblcaption colgroup ON colgroup.captionID = md.groupID AND colgroup.type=10  and colgroup.languageID= 1

WHERE pd.subgroupID= 16

AND md.groupID= 1

AND gp.midgroupID= 1

AND pd.active=1 and pd.discontinued=0

GROUP BY base_sku order by pd.sku

Product Search

Register/Login

Search Kitchen

Hands-Free Faucets

PERFECT FOR PEOPLE WITH A LOT ON THEIR MINDS (AND HANDS).