You might try the VRBO (vacation rentals by owner) web site. There are several homes advertized on Sunset Beach.
You want to rent in the fall? That should be no problem (summer calendar is pretty full by now).
GL and have fun! We just love Sunset Beach