I would love to meet others in the area who are experienced and can shed some light on the process, tips, advice etc.

 @Dave FeltsYour post has shed so much light on my search for the best areas.

You have but one path in front of you and it is light up like Times Square tomorrow night.  

Hey Thanks , its a little scary and a serious endeavor, not to be taken lightly

Domestic hot water, and; Electricity adequate for lighting and any mechanical equipment within the home.

Kitchen has white laminate in okay condition, kitchen and bathrooms have wallpaper in bad condition, one bathroom has slightly rusted light fixtures, the grey wall paint is either gloomy or chic (you choose), backyard has patches from the dog, master bedroom has a weird wood inset, garage has a big dent in the dry wall where someone's car hit it, Where would you invest to make it feel more clean and modern?

I have some more information in a private message to shed more light on my situation if that would help.  

Granite color I believe was 'oriental light.'  

Domestic hot water, and; Electricity adequate for lighting and any mechanical equipment within the home.

The upstairs unit needs some light rehab (kitchen and bathroom) and the exterior of the house needs paint and a roof sooner than later.