Wicker Park in particular, has a lot of streets with 100 square foot lots.

They are directly across the street from a major hospital, so I was thinking of turning them into m2m for traveling nurses or families of patients.  

Purchase price: $410,000 Cash invested: $40,000 4 Bed 2 Bath Duplex (Side by Side identical units) househack.

You can filter by the beds and baths and other aspects to make the results as close as possible to the one you're comparing.When I build my semi-automated hotsheet for investors, I take exports from the MLS from both the sales side and the rentals side, pull them into a SQL Server database, do some data cleaning to screen out as much of the garbage as possible, and run what I call my "magic query" that joins sale listing locations to rental listing locations by a conditional match on subdivision and beds/baths, or the average of the entire MLS if the subdivision is given as "METES & BOUNDS", with a flag in the output showing that those M 'n B rental numbers are MLS-wide averages for a given beds/baths and will need a more in-depth evaluation (like rentometer) if the estimated cash on cash return for a classic 20% down scenario, looks promising. 

When I drive up and down the streets of the neighborhood, I see an unbelievable amount of rehab going on, and very few of the properties have the permit sign the city provides that is supposed to be visibly posted on the front of the house. 

It's much harder to achieve that inside of Charlotte without buying in rougher areas.For example, this house (1836 Arkray Street) just traded for $85,000 in Gastonia on the MLS.

I'm getting good applications here and there at 1600 but things seem to keep coming up like the rental company bombing it or the tenant showing up and saying they want the garage if there going to rent it despite the advertisement saying street parking only.

It’s an old (1924) 3500 sqft house, 8 bedroom and 3 bath.

If you can predict the future then you really shouldn't be in real estate, you should be on Wall Street and a millionaire. 

Maybe you could create a spreadsheet that has some plumbing/other construction quotes and some "what if" parameters- such as "if I found a house that has 2 bed/1 bath + kitchen/hot water heater, generally how much would it cost the plumb the whole house with new copper/PEX and a water heater".