I'd like to keep savings and be able to hire out some of the work (something we have not done in the past).My thoughts are to put both into an LLC and look for investors or a business loan, and purchase and move to a new home.

I have smelled it in the halls and in the other tenants air vents.

Two, you hire someone in that area to take pictures for you.

On the other hand, I feel one of the main advantages of passive investments (via syndication/crowdfunding) is that I can hire a manager who has years more experience than I can ever hope to obtain myself.

And to be honest if you could get some strong social media coverage (like hire someone that knows STR to market the property), you could do very well!

They are coming to your property if you allow them or not (you cannot forbid service animals) Consider the facts: https://www.dogster.com/statistics/pet-travel-statistics-tre....Top 12 Pet Travel Statistics78% of American pet owners travel with their pets each year.54% of cat and dog owners plan to travel with their pet.58% of people would prefer to travel with their pet over a friend or family member.52% of travelers base their travel plans on accommodating pets.About 75% of luxury, mid-scale, and economy hotels allow pets.In 2019, a total of 404,556 animals were transported by airline.Nearly 64% of travelers prefer to travel with pets by car.42.9% of people look for a destination with hiking and fresh air for pet travel.Dogs make up 58% of the pets traveling around the world.37% of owners take shorter vacations because of their pets.10% of travelers have hidden their dogs to travel.27% of dog owners go the extra mile for their pets.

Marcus & Millichap’s report also mentions the importance of universities to Pittsburgh’s rental market, “The considerable number of universities in Pittsburgh will provide a diverse hiring pool for the area’s growing tech sector in 2017 and beyond.

Hiring a contractor to assist with repairs and a property management company to manage rental.

My 8 year old turns air bnb with my wife. 

One thing I'll add to an off-market deal is you might find a seller willing to do seller financing.You said, "I don't think the time exchanged to manage SFH would be worth my time and the cash flow most likely wouldn't be reasonable enough to hire a property manager.