I was looking at an attractive rental but it looks like the land value is 75+% of the value, so I would be paying a ton get very little tax benefit. 

Main problem is that I wouldn't be able to get out there after every visit to clean and check up.

Maybe find a vacation rental that can have personal value for me and my family as well.But more so the attraction to selling would be to pay off higher interest debt (and thereby replace some of that warehouse income).

Quote from @Franklin Marquette: When building ADUs, do they generally create value uplift for the property in the same way that the main house is valued?

My work is mainly with investors and I co- host a women's investing in Allentown group.

Position these as limited-time deals to attract budget-conscious travelers.Be Responsive and Personable: Guests often book based on their interaction with a host.

We hope that you can remedy the situation so that we can move into a habitable home.Suggestions that we have to fix the issues:Hire a company to rip up the carpets, treat the subfloors, and replace the carpets, at least on the main level and on the stairs.Provide an air purifier as a start to remedying the smell.Replace the garbage disposal.Hire a plumber to fix the draining issue in the bathroom sink of the smaller bedroom.Fix the tiles in the upstairs bathroom so they no longer present a safety hazard.Replace or fix the screen doors.Fix the gap between the windows and the walls in the living room.Hire a professional company to treat the entire home for pests.

Investors should keep an eye on its growing infrastructure and amenities.Huntersville: A family-friendly suburb with excellent schools and amenities, Huntersville is a solid choice for long-term appreciation.Davidson: A charming college town, Davidson offers steady appreciation and attracts higher-income tenants.Belmont: This small town near Charlotte offers more appreciation potential than cash flow, driven by its desirability and quaint atmosphere.Neighborhoods Offering Both Cash Flow & AppreciationConcord: A tricky yet rewarding market, Concord can provide both cash flow and appreciation.

Shut off the main to the building and check the meter to see if its running , if so you have an underground leak . 

I am a smaller Main Street Type investor and have created/manufactured SFR notes as part of my fix-n-flip program for many years.