I am renting a house which is much larger than I need just because I practice piano and don't want to disturb my neighbors. If not for this I would rent a place closer to work.
For soundproofing you need dense materials with lots of mass. Things like mass loaded vinyl, rockwool sheets, or even full-on room in a room. It can get pretty expensive [0]
I agree with the other commentor, a nice digital piano with headphones, or speakers you can adjust the volume out of would be the best option.
[0] http://www.amazon.com/Loaded-Vinyl-Square-Acoustic-Barrier/d...
I guess I am relatively serious for an amateur but the piano is a very difficult instrument to master and so I just feel like since I have such a limited time to practice I rather make that time as effective as possible. That means playing on an acoustic and thus making a lot of noise sadly..
The "make it sound like a wood-and-felt-and-wire piano" issue is solved. The "make the key action feel like a physical piano" is (based on my extensive side-by-side testing) close enough to solved that -if one's concerned about bothering the neighbors with the sound of your playing and one has the money- purchasing a good model is a no-brainer.
http://usa.yamaha.com/products/musical-instruments/keyboards...
The action is the same but the way it reacts and sounds isn't, and at least for classical music, learning the nuances of the sound (and pedal!) is the hardest part..
Also there are just so much more sounds you can produce on a real piano. I know it's weird since it's a percussive instrument but for whatever reason the way you hit the keys makes a difference.
I was in some appartments in Nantes, France, and the windows could let you hear outside (so things like buses going by in the day). In my Tokyo apartment I hear police cars go by (actually, every Sunday I get the black cars from the fascists[0]).
I think there's some better sound isolation in France rather than Tokyo (at least in smaller appartments), but Japan also knows that making too much noise is pretty rude. Usually you're not allowed to play instruments in your place unless you got explicit permission when signing the contract (usually implies that the unit has better isolation). And you try not to hit the walls too often.
I think it's part "don't be a dick", and part "get used to it". It's likely possible to isolate better but it's likely expensive on smaller units (because of the space required).
Though honestly, even when I was in Texas suburbs, there's still noise from traffic and neighbors. It was easier to get peace and quiet though.
I used to live in Santa Monica, and it was only upon leaving that I realized how utterly wonderful their leafblower ban was. Of course, the diesel pickups in the alley behind my apartment were less fun, but I guess you have to choose your battles.
Another thing that perhaps needs to be valued more is sound insulation. I currently live in an apartment in a dense, walk-able city in Europe. However, I'm tempted to buy myself a house and a car, because I'm so sick and tired of all the noise that comes from living in an apartment in a dense area (neighbors, construction nearby, drunk people late at night etc.). Without good sound insulation, I don't think density works, although maybe it's just me who are more sensitive to this than other people.