I've never hired a CPA as I've always only needed to file 1040EZ's until now and when I did file using software/websites, it was free because I was active duty.

I have much more than that from 2 decades of experience.I currently have 3 firms.1) An IT Software firm that develops Software for Enterprise Wide Corporations2) A Property Management firm that takes care of all my existing properties3) A new Brokerage FirmI have a NY Broker friend of mine who can walk me through all the Process, but I want to first do my own research since he is a bit busy.So going the route of working for another Brokerage Firm won't be an option I would be considering.At worse, I will hire an Associate Broker or an Office Managing Broker to Manage and set up the appropriate Business Processes.Then I'll have my Software company come in and develop all the necessary IT (Websites, MLS Access, etc.) projects that a full blown Brokerage need these days.

I've been messing around with VBA functions in excel in order to build my own custom CRM software.

I'd suggest that it wouldn't hurt to get some experience there under your belt - these folks with sales backgrounds (cars, software, it matters not) are the small minority that tend to hand me purchase contracts with a specified price far below the appraised value, which isn't otherwise common in the Bay Area.

Looking for as comprehensive a software as possible. 

My question is, do you have or use specific construction management and accounting software that helps keep things moving towards the end goal in an organized fashion?

You didn't define your business - the software for rentals would look much different than the software for flipping.

Does anyone have recommendations for a good software solution for managing the maintenance activities for properties? 

I would be buying lots from those that don't want to rebuild up in fountain grove or Silverado wait a year or two then build some spec homes.. probably easily 2X to 3X your cash.. in 36 months or less.you could join me in my development in Rohnert Park right next to the Graton Casino... 45 minute drive to view your investment LOL... we are not suppose to advertise on BP but since the guys above me talked about their deals I thought I would throw a few out.. also Performing first trust deeds are solid for the passive investor... 8 to 12% is possible you can do that with some crowd funders and local hardmoney lenders.. we have a 9% 5 year product that gives you consistent return with out having to get paid off and find that new deal all the time.

Do you recommend using any real estate investing software for direct mail campaigns, mls access?