The bulk of that is purely inflation.2021 and 2022 were bubble years. 

I've heard horror stories and stories of pure success.

Depending purely on appreciation as an investing strategy at this point in the economic cycle likely won't end well for your wife.

I think the pure vacation homes (ie a nice lake house or such) are still doing well.

This leads to a market where prices are higher than they would be from a pure investment standpoint.

Think of it like this... if you are investing in single family homes that cost between $60,000 and $75,000 (let's say your average initial investment with down payment, closing cost, and all the smoke and mirrors is $27,500) and at a 6% interest rate (I always calculate the interest rate high to give myself a decent buffer)  and after ALL cost you average $400 a month in pure cash flow.

Purely speaking the 10k is doing better for you, but the 80K will get you out of the rat race faster.

This article has nothing to do with your hobbies, pure education. https://www.biggerpockets.com/...

I have also checked my local municipal code and there are no restrictions on the quantity of un-related folks living together.The reason I wish to pursue this option is purely from a cash generating standpoint.

Are you wanting purely an investment or do you want a cabin to use yourself and just rent it out and have someone else help pay for it simply because you want a cabin?