I just did this but I tore down the original house and rebuilt a new house in it's place located high on a hill at the beach (no flood zone, no HOA, low crime, low noise, and only a few blocks from family). I used most my retirement savings which was a major risk but worked out well for me as I rented it out last summer and the income was plenty to take care of the property, myself, and 2 dogs. The renters were all respectful, no issues.
You have to be in a desirable area for tourists in order to get enough rent.
Plus I added an apartment downstairs with kitchen, living room, and bedroom with shower for me during the rental season. It also has a fenced backyard for the 2 dogs and a covered porch with view of garden and trees...and a peek-a-boo view of the ocean.
After the first rental season I feel confident I'm going to be fine and will be able to save to rebuild my nest egg as well.
BUT...I had LOTS of help. My daughters moved me out of one house doing most of the work but I was still totally stressed. Still not fully recovered. My painters and movers both stole from me big time so be careful! Take pics. and read reviews of companies.
My son-in-law built my house while I moved 7 times between daughter's over a span of 2 years (bad timing with pandemic, supply shortages, labor shortages, and inflation). All good now but was a struggle....don't try to do it alone.