Let's say I live on the street with my laptop.So?

The Charlotte market is still a little small for restricting it to only zip codes as the city and suburbs have been growing so quickly each street is different with some new 300k plus construction sitting alongside some 1950's SFR'S. 

All houses on this street are nice except the direct neighbor - we will try to tactfully market to them to get them to sell to us now or in the future Did you work with any real estate professionals (agents, lenders, etc.) that you'd recommend to others?

I don’t know specifically where this is, but if it’s in Warrensville definitely be careful what street it’s on.

It's on the western side of Near Eastside, on a side street along E 10th Street. 

I live and invest in Memphis and I would not buy on Dawn street. 

If he did, he would be making millions on Wall Street, not selling mortgages. 

He sees this, as with any market shift, in that main street is wanting in on commercial real estate deals, and there is more money chasing deals than good deals to be had.His take aways were in the creative structures:Sponsor offering a No Fee, No Carry, No Pref deal, 100% of cash flow goes to LPs, BUT GP gets a 6% stake in deal as an LP.Sponsor offering a no Pref deal, with a smaller carry, but comes in from day 1.And as @Roni Elias mentioned, there are a lot of options out there. 

They don't keep it clean, the 4 houses around it have a tarp on the roof, there are 8 other houses on the street in better condition at 110K. 

This property is across the street from one of our other duplexes, and while doing the rehab on that one, I continually noticed the house across the street was sitting vacant, under renovation, with tons of potential.