Are items like this significant issues that will limit your potential? 

The out of state owner is looking to offload this apartment complex where they have overspent on capital expense items in the last 3 years due to natural disasters.

I use Contract grade items from places like Pottery Barn (or the family of William Sonoma brands).  

I'm looking through the spreadsheet and I think it's worth mentioning that it's possible to spend a lot less for certain material items as well as labor in many cases depending on how frugal you want to beinterior door with hardware: $5-10 used, $30-50 newwindow: $10-50 used, $100-200 newlight fixtures: $1-10 used, 6 pack flushmount at lowes for $44fan fixture: $24-60 new water heater: $250 newtoilet: $50-90 newsink: $40-200 new faucet: $10-30 newtile: 0.49-2/sqft newappliance: $20-200 each appliance usedmy last rehab was:60 elec permit cost + 300 elec repair (tenant destroyed meter box causing house to be condemned)1600 material + 1500 labor flooring for 1400 sqft500 material + 600 labor spray paint whole house semigloss and patch some large holes$30 for 4 interior doors which I put in$10 mirror for bathroom$100 paint porch, stairs, and stair rail brown$50 fridge, $10 burner plates for stoveI also spent at least a few hundred with help on cleaning and taking out the trash and some other expenses here and there which altogether added up to about 5 thousand.I spent maybe 30 hours over there in total on the weekends.

Keep the property and 3.5% rate lock, and refinance out the capital using a HELOC or other item.

➡️ Can you provide a list of completed capital expenditure (Capex) items and their costs?

Make sure you have a good wastebasket nearby for other items.

Everyone has an opinion on the house, the lease, how much rent they should pay, what items to redline in the lease, etc.

I do not want to list all the items you mentioned but heck IMO there is much more to this story.

You can find videos/articles online on how to get the basement dry, but the basic process is: 1) turn off all electric to the basement (to avoid electrocution from the water), 2) run pumps to get the standing water out of the basement (sounds like you're already doing this)3) remove all furniture and items from the basement,4) once you've pumped out the standing water from the basement, rent a wet/dry carpet cleaner/extractor from home depot, and use it to extract as much water as possible from the carpets (they'll be much lighter and easier to move once you get the water out). 5) After you've used the carpet extractor to get most of the water out of the carpet, remove all carpet and get it out of the house for drying (if you're trying to salvage the carpets), or throw the carpet out.