Contemporary Style - Faucets

CUTTING EDGE THAT’S EASY ON THE EYES.

If you belong to the “less is more” school, Danze has, well, more to offer. Choose from an array of stunning minimalist designs with lines that are as clean and crisp as water itself. All made to send a strong statement.

select pd.base_sku,  pd.sku,pd.collectionID as collectionID , style.tagname as styletagname , midgroup.tagname as midgrouptagname ,  grp.tagname as grouptagname , grp.groupID , collect.tagname as collectiontagname , (select name 		from tblcaption where type=7  and languageId = 1  and captionID = pd.productID) as capproduct , (select name 		from tblcaption where type=8  and languageId = 1  and groupid= 1 and captionID = style.styleID) as capstylename, (select description  from tblcaption where type=8  and languageId = 1  and groupid= 1 and captionID = style.styleID) as capstyledesc, (select concat(name,html_code) from tblcaption where type=2 and languageId = 1 and groupid= 1 and captionID = pd.collectionID) as capcollection, (select name 		from tblcaption where type=4  and languageId = 1  and captionID = pd.fitId) as capfit , (select name 		from tblcaption where type=3  and languageId = 1  and captionID = pd.finishId) as capfinish ,  (select name 		from tblcaption where type=17 and languageId = 1  and captionID = pd.subcollectionID) as capSubcollection, (select name 		from tblcaption where type=1  and languageId = 1  and captionID = pd.categoryID ) as capcategory, (select name 		from tblcaption where type=11 and languageId = 1  and groupid= 1 and captionID = midgroup.midgroupID ) as capmidgroup from tblproduct pd    Left  join  tblproduct_style pdstyle  ON pd.productID = pdstyle.productID  	   Left  join  tblstyle style            ON style.styleId = pdstyle.styleID  				   Inner join  tblproduct_midgroup pdmid ON pd.productID = pdmid.productID  	   Inner join  tblmidgroup midgroup      ON pdmid.midgroupID = midgroup.midgroupID    Inner join  tblgroup grp  			  ON grp.groupID  = midgroup.groupID   Inner join  tblcollection collect     ON pd.collectionID = collect.collectionID  where   style.styleID= 2 and grp.groupID= 1 and midgroup.midgroupID= 1 and collect.active = 1 and pd.active = 1 and pd.discontinued = 0  GROUP By pd.collectionID order by capcollection

Product Search

Register/Login

Search Kitchen

Contemporary Style - Faucets

CUTTING EDGE THAT’S EASY ON THE EYES.