My father in law has a condo on 400 west ocean blvd in Long Beach just a view of the street no ocean. 

Clean soils, no grade challenges, no power lines or utilities running through the property, no street improvements (curbs, gutters, sidewalks, new lanes, streetlights),etc.

You could have something make more money in a 3 year horizon but you need your return in 6 or 12 months etc.Do you have an address of the property for a Google street view to see how it is positioned on the road and in the market? 

The Wall Street Journal/Realtor.com Winter 2023 Emerging Housing Markets Index put the market as the #1 emerging market in America, classifying it as a hot market. https://www.ibrc.indiana.edu/ibr/2023/outlook/lafayette.htmlI've worked with a lot of investors who have found success investing in smaller markets throughout the state.

I've seen other houses down the road and across the street (thanks to Google Maps), but again, I'm not sure about utilities.

This is going to be a bit of an adventure for me: I used to ride fast street bikes back in Austria; this will be my first time on an adventure bike and off road.

His existing sewer lateral apparently runs under his neighbor's lot, to a manhole located in the neighbor's backyard, where both his and the neighbor's sewer laterals connect to another line that runs to the sewer main under the street.

I did some research (after the fact) and found out that they are habitat for humanity homes and there are some more sec 8 homes up the street.

3) What undervalued neighborhood(s)/street(s) do you forsee as having the biggest appreciation opportunities?

Now he's living across the street with my father in-law which causes turmoil.