Under contract on an Older Home (early 1900's).. issues

[Marc Shin]

I'm under contract on an older-home.  Like early 1900's in Florida. Home inspection completed yesterday.   The 2 main issues are that there's a leak in one of the bathrooms that is causing water to flow under the sub-floor and into the crawlspace.  Also, the home has some cast-iron piping that is mixed in with newer PVC piping. I think all the cast-iron piping would need to be replaced.  Also, I ordered a sewer scope and they could not get the scope all the way through to the main sewer line because of some blockage so i have no idea if the main sewer line looks ok

.  Also the inspection photos show some of the roof joists look like they're partially cracked.    I'm a first time investor, and all these things are adding up to be a huge headache and source of anxiety for me. SHould I just pass on this old property and look into new construction?   Real newbie here need advice!