This isn’t typical living noise; it’s loud enough to disrupt our sleep and daily lives.

I know when i travel to hotels ( which is almost every month) I check for coffee pods and will choose hotel that has them  then i bring my own pods LOL  unless its a real high end hotel and they have the ultra coffee makers  But if you have a cabin that sleeps 23 people it's much easier to just supply the drip coffee makers.

Biggest thing is to make sure there is egress out of the basement sleeping area. 

Bloody oath I do mate.It's never their fault and always yours (Ours).They rarely take any responsibility and cry victim.It's crazy to think but it's like many intentionally look for drama and deep down inside don't want success but rather problems.Someone to dislike and blame and to feel wronged by.All other personal and "at home" issues can now be blamed on this one unfortunate scenario.This "drama" per se is like food for the hungry and they need such drama in life to "survive".My apologies if my above comments sound weird as they are more so from a philosophical standpoint and just some thoughts that I have considered after 5,000+ investor intro calls and as you have mentioned, others feeling wronged by me or my company on many occasions.What a $#@% way to live IMO but I don't judge and sleep in peace.Again, I have been "wronged" by many but consider it my own fault.I also don't call them out publicly or post bad reviews, etc... 

That means no HOA neighborhoods, which rule out many places.  3bedroom might make it tough to work, unless you're sleeping in the laundry or garage and renting full 3bedrooms. 

Leather is very durable and easy to clean but more expensive.Depends on the property and your budget.Sleeper sofas give you more sleeping capacity.

I have lost a lot of sleep over it, and am actually about to board a plane to head to Maui to stay in the unit for a few days.

It may not make sense for you, but people are still sleeping on it. 

In my opinion (I'm definitely bias now, but invested here long before becoming an agent) people are still sleeping on the area with the proximity to Northern CA. 

Finally- you can eliminate 95% of the troubles and risk by simply having professional and legal screening and management processes, so don't sleep on that piece.