I have no ideal what the ideal SFR is or if there is a better alternative to passive income than SFR rentals.

In a standard scenerio, I would suggest calling a few more times, text and email, but also start looking for alternative solutions so you dont lose the deal. 

Make sure that you're not across the street from the local trucking company, trailer park, landfill, water treatment center, etc.

BAnks have them.. as well as others.then there are registered investment advisors that can sell away IE they search out alternative ( usually real estate of some kind) and they get paid by whoever is selling the deal.. and sometimes the fee's to them are quite large.

GP has different treatments, so we need to know that exactly you are doing. 2) distribution or GP can be once a year or more often.

Alternative, raise the house on stilts like they do in flood zones.Either way, not worth it!

There are alternatives and you can message me for some additional information. 

Yes, we’ve been contemplating the pure sell option.The alternative we’ve been discussions is to rent this out short term (1-2 years) while we purchase another 1-2 properties in the area as we potentially move into the original propertyYou’re absolutely right that we should leave emotions out of it, I just fear the future cost of acquisition will go up as neither my wife nor I are big into flipping

However, they did eventually catch up as people were priced out of SFR and started looking for lifestyle alternatives. 

Sit down with your better half and figure out risk tolerances, etc. and career alternatives.