Valdosta has two seasons: summer, and summer-but-not-as-much.
Moody itself is north of Valdosta. One could easily go into the counties to the immediate north and get cheaper housing options, but I can't speak to current availability. Valdosta itself isn't going to be too bad unless you are trying to buy into a new, trendy subdivision.
Its proximity brings a lot of tourist travel via I-75 and supports a service industry far beyond what the local population could support on its own.
I very much enjoyed my time there, but family considerations just won't allow me to go back. I visit as often as I can and still have cousins down there.