I really wanted to buy this house, which was small (for the area anyway) but not tiny:
About 1000 feet. Which I could easily do without changing my lifestyle haha. Any smaller would be more difficult, though, given the whole 2-people-4-dogs-occasional-guests thing.
Didn't work out, though. Still sad about it.