Contemporary Style

YOU TURN THE WATER OFF. YET IT STILL FLOWS.

If sleek, flowing lines are what you’re into, browse no further. Our contemporary designs take minimalism to the max, often adapting the latest European trends (like side-mounted single handles, for example). Because often, the simplest answer is the best.

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= 2 and captionID = style.styleID) as capstylename, (select description  from tblcaption where type=8  and languageId = 1  and groupid= 2 and captionID = style.styleID) as capstyledesc, (select concat(name,html_code) from tblcaption where type=2 and languageId = 1 and groupid= 2 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= 2 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= 2 and collect.active = 1 and pd.active = 1 and pd.discontinued = 0  GROUP By pd.collectionID order by capcollection

Product Search

Register/Login

Search Bathroom

Contemporary Style

YOU TURN THE WATER OFF. YET IT STILL FLOWS.