Check out socketsite.comLuxury condos aren't doing hot in SF and there's some examples on that site that are interesting.I think the key here is that it's specific condos some of which were likely overpaid and now we're seeing true value but it's more of unique situation then city wide trend. 

. #5  Get to know the neighborhood police officers, city officials, and social service organizations in your area.

About 6 months ago I purchased a foreclosure in one of the nicest neighborhoods in the city I live in.

Im planning on looking for a duplex to house hack in the Twin Cities, MN, and I was wondering if I should even bother looking into other loans?

Drive the city looking for dumpsters in yards.

I was born and raised for about 10 years just outside of Charm City. 

*Side note some policies may offer "Repair Cost" settlement which is a nice option that falls in the middle of RCV and ACV and may not require you to insure the dwelling at the full replacement cost estimate.For those outside the major Ohio cities you may have a small stroke hearing someone say to insure it for less than the full RCV.

Since you’re already on BP, when you find a target market I would repost this question rephrased as “can anyone out there investing in city X recommend a great agent for an oos investor.”

LAS COLINAS ASSOCIATION, IRVING CITY, DALLAS COUNTY, TEXAS. 

It is not a city in which undertaking a first project at scale would be advisable.