Well, my husband's pick is closer in size to your ideal size: this one is 1191 sq. ft, and it's a really cute house, right across the street from the water, but I'm afraid it's too far north for me.
https://farmandforest.com/listing/46...rgia-vt-05478/
I would hope to be able to fit into something less than 1,000 if I can find something affordable in a vibrant community.