The rent is damn high in downtown / midtown Manhattan and downtown Brooklyn because there is enough business people, movie stars, stock traders, even software developers who are willing to pay as much.

If you step back into southern Brooklyn, Queens, the Bronx, the prices go down to reasonable, while still being within < 1 hour commute by public transport from the downtown area.