SELECT CompanyID,CompanyName, ContactPerson, Add1, Add2, Add3, a.CityID, a.CountryID, Pincode, TelStdCode, TelNo, FaxStdCode, FaxNo, email, website, FreeEntry, Activities, MobileNo, isElite, eliteuserfilepath, EliteEnteredDate, EliteValidTillDate, eliteConfirmed, datarefId, entryadddate, AllUAEElite, GCCElite, internationalElite, b.CityID, CityName, b.CountryID, citycode, c.CountryID, CountryName, gulfcountry, countrycode, hostcountry, maincompanyid, branchname,hasBranches,lattitude,longitude,mapzoom, skypeid,facebookpageurl,twitterpageurl,Google_store_applink,Apple_store_applink,rating,whatsappnoforchat,noofreviews,worstrating,bestrating FROM mstcompany a LEFT JOIN mstcity b ON a.CityID = b.CityID LEFT JOIN mstcountry c ON a.CountryID = c.CountryID WHERE a.companyid = 976596 LIMIT 0,1 Enquire Now to Centre Commercial du Mobilier -S/2CM (Siege Social) - Oman Yellow Pages Online
Oman Yellow Pages Online
Centre Commercial du Mobilier -S/2CM (Siege Social)

Centre Commercial du Mobilier -S/2CM (Siege Social) - | E-Showroom

Home Â» Enquiry
Business Enquiry Form
Send Business Enquiry to : Centre Commercial du Mobilier -S/2CM (Siege Social)
   

Enter Your Requirements Subject :

Enter Your Detailed Requirements here such as :

  • Products
  • Specifications
  • Delivery etc

Need Just Quote Need to Purchase
Immediate Within 15-30 days
From Oman From Anywhere

Your Name:*
Your Email:*
Company:
Location:*