It really depends on the lifestyle you want. If you want to live in NYC, for $800,000 you could find a great 1 bedroom apartment. But if you're willing to go to the suburbs of NY or NJ that money can get you a huge house, if you'd rather have that.

For me personally, it would be worth sacrificing the space to be in the city. I grew up in the suburbs and I never want to go back.