The second son is married but has not lived in the home at any point during the last 20 years so this doesn't seem to present any options for savings.I thank everyone in advance for your thoughts. 

House hacking is probably your best option.

So brainstorm the different options then pull the trigger!

Here is a link that provides fantastic information on the turnkey investing option from BP. 

You’re going to deduct your tax prep, your internet, your cellphone, your computer, your tablet, your mileage if you’re involved in the properties, your home office, etc etc.

Here are some general guidelines: Lien Position1st Position LienEquityMinimum Down Payment of 20-25% (a 30% equity to sale price is preferred)Down Payment made in certified funds and not borrowedMaximum Funding of 70% ITV (Investment to Value)SeasoningMinimum of two monthly payments already made12 months or more preferredPayer CreditCredit Score of 650 or higherNo major derogatory trade lines (No 90-180+ days delinquent, foreclosure, repossession, bankruptcy, etc.)No decline in credit since purchase of businessTermsPrefer 60 months or lessMaximum of 72 monthsNo Balloon Payment preferredCash FlowBusiness has positive cash flow1.25 debt service coverage ratio preferred.DocumentationPersonal guarantee from a creditworthy individualStandard documents including Note, Security Agreement, and UCC-1 filing.Tax Returns on the business that substantiate profit and loss statements.OtherPayment history current and verifiablePayer Interview indicating buyer is satisfied with business and comfortable making paymentsMotivation for selling the note is not a result of a deteriorating businessConsideration of high risk businesses or geographic areasIn these situations, sometimes a partial is a better option. 

I’ve been involved in real estate investing for over 30 years, so if you ever have any questions or need guidance, feel free to reach out.

Should I go through with taking ownership of the property and try to salvage it for profit or do I refrain from even involving myself in the situation as it may cost more than it's worth to save it?

They unleashed pandemic handouts and loan programs that greased the economy (this was not well thought out, contributed to the inflationary environment we are still suffering from and PPP and ERP loans were flooded with fraudulent loans and benefits)These programs leveraged existing corporate infrastructure (banks and the government had little or no operational involvement). 

First mortgages involves loss mitigation (occupied 1st) and asset management (vacant 1st).