Benefits of a "better" location

[Sean Dawson]

We had been in contact with a real estate agent in Cleveland, Ohio about a 20 unit.  Haven't heard back from him so I am assuming it is in contract at this point.  

Question I have though is the broker and property manager sent me a pm after I asked a few questions.  The agent answered my initial questions with good answers but I had some more including what the PM thought of the numbers stated by the seller and the numbers I had laid out.  

Deal was a 20 units of 1 br/ 1 bath on the borders of Lakewood.  Nice area and nice buildings.  Using the sellers numbers but adjusting them for higher taxes due to higher selling price,  insurance, PM, and lawn/ snow service I calculated that the buildings would not cash flow the $100 per door that we wanted.  

I asked for his opinion and he came back with: " Its hard to show the benefits on a strong neighborhood vs. a weak one on a spreadsheet. To often I see investors choose to buy properties in lessor neighborhoods because they look better on paper. Whatever you choose to do, don't be that guy."

Good advice but doing my research, reading and listening to podcasts here I keep coming back to @Brandon Turners advice " know what you want the deal to flow and stick with it. " (Or something like that!)

The building, neighborhood and rents were nice, but not what we needed.  So after all this, what is the benefit of a better property? Should you lower your per door "take" to make the deal, or perhaps the spreadsheet is not accurate?  

Thanks!