The oil is a clear liquid, it only appears yellow because of the bottle's colour
It has a normal viscosity unlike some other cleansing oils I've tried such as DHC which are extra thick in consistency. I like the normal consistency more because it feels easier to spread out and emulsify the makeup on my face.
In terms of effectiveness, I felt that the oil removed my foundation and sunscreen quite easily, without drying out my skin.
The cost is one of the cheaper olive oil based, mineral oil-free cleansing oils I have tried. I purchased this on vacation in Malaysia for approximately RM 42-ish, which translates to about USD 14.
Online is your best bet if you are purchasing from North America. I've shipped with www.adambeauty.com more times than I can remember over the past 6 years, and never have problems. Navigation is usually the issue as the site sorts by parent beauty company which isn't intuitive to those not in those regions. Hada Labo is under the Mentholatum Company brand. You may also find it in some Asian beauty supply stores if they stock the Hada Labo brand.