Select CompanyProdID,producttitle,productdesc,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl,a.companyid from trncompanyprod_forsearch a inner JOIN mstproduct b on a.ProductID=b.ProductId inner 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 limit 0, 3000 Al Rehwan United L.l.c , Muscat , Oman
Abu Dhabi Yellow Pages Online
Video Gallery

View More

Our Activities

Al Ruzaiqy Group of companies had a modest beginning in the year 1991. Mr. Mohamed Hamed Salim Al Ruzaiqi, Group Chairman is the guiding light and inspirational force behind the organization’s phenomenal success. Mr. Ruzaiqi hails from one of the reputed and influential Omani family in Sur. 


View More

Product Categories

Catalogue

Our Management Team

View More

Certificates

View More

Location
Muscat

Year Established

Business Type

Turn over
US$ NA

Employees
NA

Main Markets
Oman