Why live in a small 1BR in a 4th floor walk-up for $1975 in Brooklyn Heights?

I don't understand why people settle for living accommodations? You can get so much more for your money in Queens. I Love Queens. It is family friendly.
http://www.nytimes.com/2012/07/29/realestate/where-we-wont-stub-our-toes.html?hp