Select CompanyProdID,producttitle,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl from trncompanyprod_forsearch a left JOIN mstproduct b on a.ProductID=b.ProductId left join mstmaingroup c on b.maingroupid=c.maingroupid where a.CompanyID= ? and a.isproductapproved=1 ORDER by ProductOrderNo=0, ProductOrderNo ASC,productimagefilepath desc, a.productlastmodifieddate desc,companyprodid desc Chic Le Frique , Dubai , United Arab Emirates

Saudi Yellow Pages Online

	SAUDI ARABIA YELLOW PAGES ONLINE
	Global site for local search

Chic Le Frique

Chic Le Frique - | E-Showroom

Chic Le Frique
Dubai Dubai
United Arab Emirates

Home

Our Products

Video Gallery

Our Activities

CHIC LE FRIQUE is an online women's boutique established in 2019 and based in Dubai, United Arab Emirates which showcases fresh international high street labels including own label. We offer a selection of beachy relaxed luxurious must-haves.

Product Categories