Sheila's place is in a good neighborhood if you like meandering around and finding cool shops, good restaurants, and absorbing some local culture. It is also very convenient to other areas you might want to go, especially Brooklyn Heights which is walking distance, or anywhere in Manhattan which is an easy train ride away.
The apartment works for one or two people, especially if you're planning to go out sightseeing and enjoy Bklyn & the city during the day, and want a safe and quiet place to come back to.