Plus the seller would benefit by improving the desirability and affordability of their home for conventional buyers.  

Areas south and south east (Zipcode 27610) of Raleigh have the most left to run but also the least desirable followed by east (Knightdale, Wendell, Zebulon) and north east (Millbrook, and capital area).

So let's build upon that strong desire with positive and productive ways to think about things!

You would think in this rising interest rate environment that may make a purchase even more desirable for a potential buyer if the locked in interest rate is lower than is currently being offered.  

For example, if you are looking to connect with other members near you, want to learn from people in a specific area you’d like to invest in, or have a desire to find people interested in certain topics, you could start your search here: https://www.biggerpockets.com/search/users

The inside looks very nice, and yes close to the beach as the crow flies, but I'm not sure how desirable that area is for short term rentals, especially right across from the airport, albeit a small one. 

Plenty of condo/townhome and even some SFH options for under $500k that will meet your goal of providing cash flow and a desirable place to vacation with your family. 

v=_fCLVapcR2AHigh Point:  https://www.housebeautiful.com/design-inspiration/a26945378/high-point-north-carolina-american-made-furniture/@Scott Mac: In this land of "Nascar and furniture" we have the most diverse forest in the entire continent (western NC), some of the most pristine coastline, several top tier universities, a metro area (Charlotte) of 2.7 million people and rapidly growing, two large military bases and towns, the #1 most visited national park (the Blue Ridge Parkway), some of the most coveted hiking and mountain biking trails and parks, the largest home in the US (The Biltmore Estate), towns like Asheville that consistently make top-10 lists for lifestyle and relocation, coastal towns like Wilmington that are so desirable that they have nearly no land left to build upon, fantastic weather that includes all 4 seasons but only mildly so, etc.

Househacking is my step into the door. multi families seem more scarce here and are in unfavorable areas. i have been adjusting my strategies & know i can also start with a single family. i have a couple questions.what are desirable areas in SA that if buying a single family home would be a great start for househacking.

I am looking to connect with local buy and hold investors in the city of Detroit to learn the desired ROI being sought on a rental property in the current market?