You can build in sound proofing, but honestly I'd go with 2-3 floors for each so you don't have the tenant downstairs complaining about the one upstairs walking around at night.For costs-it could be more or less than new retail-depends on finishes of each. 

I came back with some detailed floor plans.

I don't have exact floor plans, so I'm not sure if it would qualify for the 51% apartment sq. ft. necessary for a mixed use dscr loan. 

offering now 1.25M for the 1.495M listed property, with 25% down, no bridge loan, got an 8% offer. there are over 7 offers so not sure that this will be competitive but we will see.estimating around 60k total renovation as only 1 unit needs a full reno, other 2 need new kitchen cabinetry, nicer bathroom vanities and flooring. waiving inspectionHere are the updated rent forecasts, a 2bed can rent 2200/m and a 3bed around 2500/m in this area very close to Yale, 1st year negative but after that should be good CFhttps://docs.google.com/spreadsheets/d/1bLcUAKN5j8CpIKhcBKaD...

Next, 10k in damage seems excessive for an emergency leak, since if the leak was in a wall, it would most likely result in most of the water falling into a basement (if there is a basement) or it would pool along the floor.

A tenant “broke” a railing on the second floor deck and fell down and had medical issues they were sueing for along with PTSD and a bunch of over things .

Therefore anyone with bank originated construction debt or bridge debt is likely happy right now with the rate cut and narrative surrounding future cuts since in many cases these are adjustable rate loans with floors we likely won't see anytime soon.It will be interesting to see whether this cut gets banks who have been on the sidelines back into the market or alternatively some lenders who have continued to lend but with tighter underwriting to ease their guidelines.

However, there's a floor for interest rates due to fears of inflation resurgence, particularly in housing prices.

A smoke detector in every bedroom and a smoke detector and carbon monitor in hallway of every floor and in the basement or attic IF you have furnace, hot water heater etc in them.

The floor is not super out of wack, more just some imperfections of chips and some hills, overall is it worth doing for what it's for?