The HOA/by laws will be your first insight into how restrictive these resort style communities are to keep up with the feel and look of the community. 

Waterfront homes, particularly those with Gulf access, can command higher prices and potentially higher returns on investment.3) Tourism and Vacation Rentals: Cape Coral's proximity to popular tourist destinations like Fort Myers Beach and Sanibel Island makes it attractive for vacation rentals, especially during peak tourist seasons.4) Affordability: Compared to other coastal areas in Florida, Cape Coral offers relatively affordable real estate options.

For Cousin A, this could involve cash-out refinancing to access the equity they need.

This was one of only three hotel/motels in the city and the only one with lakefront access, including a dock.

I have full access to Costar premium.

So long term, in my opinion, I always take higher quality location SFH over multifamily house hacking but if the latter is the most and easiest access point into REI then definitely roll the dice.

A successful BRRRR without the tailwind of market appreciation during the renovation period is really, really hard unless you have cash to buy a place that does not qualify for conventional financing, ways to source off market deals with some real issues that you don't mind taking on, and/or access to a crew or cheap labor (could be DIY).

Talk to @Scott Pastel, his team has access to several markets across the US and then decide which one is best for you. 

I only use Zillow but want to ask is a more comprehensive listing that I can access (for example, which is the preferred source for foreclosure homes). 

They can usually access the rental history and occupancy rates for any building that you're looking in.