The best part of staying at "Casa de Kim" (as Scott himself calls it) is... Scott! He is very friendly, nice and helpful, but without being intrusive. He's really easygoing and chill, it's really easy to get along well with him. He'll give you ton of (good) advice or even invite you to go out if you want, but also leave you alone if you're not in the mood for any of the above. I stayed for a long period and he even introduced me to some of his friends. You can literally ask him for everything and he'll always be willing to help.
Now, the place: the house is nice and the room is quite large for NY standards. The furniture is basic but cosy, the closet is huge, the tv is very good and well-equipped. The only downside during my stay was the radiator, but probably it's mostly me: my "too-hot" threshold is really low. It also sometimes makes a bit of noise and tends to get dusty (although it was clean when I arrived). This is probably due to the fact that the building is a bit old, but hey, that's the nice thing about staying in Brooklyn! The kitchen is small but also well-equipped. He doesn't cook often so you'll mostly have it for yourself.
The neighborhood is really safe, even at late night or early morning. It's also packed with nice places to eat and/or drink and/or buy groceries. Especially on sunny days or mild evenings, Smith St (to which the house is close enough, but far enough to avoid being annoyed by the noise) gets really busy! The subway stop is 2 mins away and trains will take you to Times Sq in 25-35 mins. It's also really easy to get to JFK airport. So you'll enjoy living in Brooklyn (which is really different from Manhattan) but you'll still be able to reach the City pretty easily (30 mins is nothing for Newyorkers!).