I second Smith Mountain Lake (Moneta VA) too as a lovely lake resort area with many vacation rentals. Unfortunately, the quilt shop in the General Store has close their fabric shopping and, I hear, they will only be teaching....not sure how that will work, though.
But you could check out the sweet little Boone Country Store (no personal website) which has a fabric section, sells sandwiches and some homemade edibles, too. They are located on Rt. 116 about 4-5 miles northwest of Burnt Chimney (which is on 122 between Hardy/Westlake and Rocky Mount). The store is almost not visible from the road, on the left, up an incline (gravel road) at a sign you will need to keep an eye open for. Their fabrics are close-out, not necessarily the most current lines, but good prices; also Mettler thread and some notions.
You can google real estate companies for Smith Mountain Lake to find your rentals.
Jan in VA