Depending on the makes / models, you can do some pretty clever stuff.
I do exactly what you're talking about using 2 x Netgear DG834G's using the Advanced Wireless features, without a cable running between them.
With that said though, it's only a small house, and both routers have to be in range of each other for this to work.