I began my real estate endeavors by buying the house next door to my mothers house in Saint Louis, Mo after she passed.

If I get this deal, I'm going to document the entire deal and transformation of the property here on BiggerPockets.

Best of luck in all your endeavors.

These have been very safe, low maintenance, buy and hold properties for us but I am at the point where I would like to take real estate investing much further with an end goal of being self-employed through our endeavors.

The Rustoleum product is called Cabinet Transformations. 

The short answer would be no.With some restrictions being:- Age 65 or older - or totally and permanently disabled for someone whose 2022 income does not exceed $33,800 annually- Owner occupiedRegardless, I wish you the best in your endeavors! 

Does anyone have any experience with best locations and how to approach m endeavor ?

I have one daughter who has made megabucks investing in RE and a few friends who have done well through their entrepreneurial endeavors and stock market.

It is a +ve multiplier on your future real estate endeavor.

As you also know- a market like Colorado Springs is going to be an excellent long term appreciating market, so over time, this property would transform from a sort of not awesome investment to an amazing source of equity and wealth for you and your family.