I'm going to keep it short and simple tonight.
You say: Oh! We couldn't move to the lake! We'd miss our friends!
Ask anybody who has moved away and they'll let you know how your friends are. The good ones will still come see you and the ones that weren't friends will fall by the wayside. We made darned sure we had a 'spare' room and you know, almost nobody slept in it? We're planning on a sofa bed for the next house.
If you've moved to a resort area... there will be a B & B or hotel anyway!
Miss you're friends? Take the $200.00 cure. Hop a plane and go visit!