I'm specifically interested in "main street" properties with a downstairs retail space, upstairs apartment(s).If you know of anyone with this sort of experience, I'd REALLY appreciate the connection.

Here are a few suggestions on how you can maximize the wealth of information available: Check out the blogs and podcasts, or take advantage of the search feature (magnifying glass).

@Dave Harlan They have an amazing product but your better off using a mortgage broker with a great reputation for customer service because they offer wholesale pricing advantages to their brokers and the only complaints I've ever heard about them have come from service issues on the retail side.

I need a suggestion here to handle maintenance and cleaningTURNO for automated cleaner payment and scheduling along with inventory trackingQuickbooks / Bookkeeper to keep my PM business in alignmentChase bank & trust accountI'd like a better method for managing linens (bulk order) and distribution.I'd love to compare property management / cohosting agreements with someone to share best practices. 

If you have little to no money, then I would not suggest doing a program like this.

If you can hold on till first part of January the showings and everything else should pickup.This would be my action items: 1. hire a new agent that can sell the place, and get you numbers are rent and selling and sell the place. 2. be honest on the numbers you can get on an ARV so that you can sell it 3. start to get the conversation started with a couple lenders on what these numbers on refi would look like for you and this property 4. my suggestion would be to refi/rent before selling at a loss because if numbers work you can hold for a couple years then sell, but this is dependent on your cash position and liquidity of your situation. 

: I understand that there is commercial and residential, but there has got to be subgroups While I don't think you need to niche down immediately, some specializations in residential RE are:- Co-op- Condo (incl. luxury)- SFR (median pricepoint)- SFR Luxury- MFR- RentalsThere are a ton of commercial RE specializations including retail (various types), restaurant, other food/bev., warehouse, storage, and dozens more.What should I expect when first coming into the profession ?

I took your suggestion and spent the night checking through the cities Master Plan.

I'd suggest checking in with some social service organizations within a few miles of the property to see if they work with people/populations in the area looking for this type of house.

I suggest you turn your moment into the best learning / earning moment.