Advice from another first time house hacker (also married) who is in the process of closing on more rentals:
A) Agreed with other poster about not counting on appreciation. Equity happens, but the only appreciation you should be counting on is the forced equity you put in; and even them err conservative.
B) I would definitely make sure that you could actually get $1400. I always look at my worst case scenario, and invest based on that. When we went to house hack I used a $600/month rent even though I thought $650 would be viable and either way I was still profiting, just not as much.
C) At some point, you are not going to want to manage this property. Passive income means you don't deal with tenants, repairs, etc. A property manager would cost you $280/month (10% of $2800/month rent). With your rental calcs, you wouldn't be making money with a manager. I didn't do do this on my house hack and I wish I did, because I do that on all my rental calcs now- even if you plan on managing for a couple of years. I would still cash flow with a manager, but it's not as much as I would like.
That being said, we don't live in a super desirable neighborhood (re: working class) in a much smaller Metro than Atlanta, so we are only about an 8 minute Uber ride from downtown.
D) It might be worth the premium if you absolutely love and want to live in that neighborhood, but if you want to buy a new house after 2 years, and you don't know if you can get that $1400, I'd walk.
E) Another option is to estimate the minimum to make it rentable, and if the numbers work, you can always go for a rehab loan of some kind in a couple of years when you know for sure what rents/prices of houses are. Of course, this adds to your transaction costs. I would talk to your finance professional about this.
Final Philosophical Advice: Sometimes when you're close to a deal its easy to get caught up in trying to make it happen and make the numbers work to justify the purchase, rather than going by the numbers you have as your criteria. (As i almost just did on a deal!) I always look at the worst case scenario and if I'm still meeting my numbers (10% Cash-on-cash) almost, I would go for it. If you go by the worst case scenario and the worst happens, you're still in profit. That's not the case with your deal.
Personal Verdict: I would walk away.