apartment

ok we are looking at a new property. My Mom is looking at it with us and our thought is to build a horse barn with an apartment as a MIL quarters? Anyone have any experience with this? Is it cost effective?