I also have this problem but after 11 years, I have it figured out. The summer lake cabin (well, it's bigger than a cabin.... more like a house) is pretty remote and there aren't a lot of quilt shops around. The ones I have found have a limited selection of fabrics. The winter house is located within a half hour's drive to several really good fabric shops that also have lots of accessories to choose from. So....
I have duplicated my quilting supplies at the cabin but take a large tote filled with whatever fabric I'll need to make the projects I've selected for the summer. My main stash stays at the winter house. The two homes are 10 hours apart so I can't just go get something I've forgotten. Last summer I took 5 projects.... got 4 done. We get more visitors at the lake and I'm getting older. It takes me more time to get ready for company and clean up after they leave. But getting 4 quilts done last year was good. I've already started thinking about which projects I'll take this year.