It has been sitting vacant for many years, so this will definitely be a large undertaking.24,000 sqft totalCreate 12,000 sqft of loft apartments in the upper 2 floors.Create 12,000 sqft of retail/restaurant space on the ground floor and and basement.I have never done a project of this size and have never done a commercial develop project at all.

This is a huge undertaking, but with hard work and dedication, it is certainly achievable.In addition to expanding their portfolio, I want to post 3 videos on YouTube and 2 blogs on Biggerpockets about real estate investing per week.

@John RinggoldI retain 50% of the deposit for redecorating expenses for the last 11 years.

Many of the properties in the area come fully furnished but you're likely still going to need to do some redecorating.

I'm also confused about this part concerning tenant appeal:During an appeal to district court, it shall be sufficient to stay execution of a judgment for ejectment if the defendant appellant pays to the clerk of superior court any rent in arrears as determined by the magistrate and signs an undertaking that he or she will pay into the office of the clerk of superior court the amount of the tenant's share of the contract rent as it becomes due periodically after the judgment was entered and, where applicable, comply with subdivisionDoes this just mean tenant must also sign and agree to pay future rent, when it becomes due, during their appeal (for instance, if they appeal on 11/15, but the next court date isn't until 12/15, they agree to pay the court rent for December when it becomes due on December 1st...)?

With that being said it is a major undertaking.

A new, expensive apartment in a hip area may be one you want to re-decorate  interiors frequently to keep it fresh, while an older property in workforce housing is more focused on clean and functional over style.

I am in the construction field and can easily undertake a mostly cosmetic project (kitchens/bathrooms/finishes).   

I’m wanting to get started, but am concerned this would be too big of an undertaking for a first deal. 

I wouldn’t.I don’t mean to be negative - I’ve been in real estate for 45 years - and own and operate over 1100 apartment units worth $150M - and I don’t think I have the knowledge  to undertake the project you envision.