A great book set in North Carolina is Three Times Lucky by Sheila Turnage.
Here is the synopsis from Goodreads:
"Rising sixth grader Miss Moses LoBeau lives in the small town of Tupelo Landing, NC, where everyone's business is fair game and no secret is sacred. She washed ashore in a hurricane eleven years ago, and she's been making waves ever since. Although Mo hopes someday to find her "upstream mother," she's found a home with the Colonel--a café owner with a forgotten past of his own--and Miss Lana, the fabulous café hostess. She will protect those she loves with every bit of her strong will and tough attitude. So when a lawman comes to town asking about a murder, Mo and her best friend, Dale Earnhardt Johnson III, set out to uncover the truth in hopes of saving the only family Mo has ever known. Full of wisdom, humor, and grit, this timeless yarn will melt the heart of even the sternest Yankee."
I love Mo and her crazy town. There are a lot of different characters in this book, and they are all pretty hilarious. If you like quirky mysteries, then you will love this book!