Hey Suraj, I moved to Columbus a few years ago (from Portland, Oregon which was super expensive) to become a full time real estate investor, and ever since, I've completed quite a lot of BRRRRs, flips, and own a successful rental portfolio here in Columbus Ohio.

But Generally speaking the parts of the rehab process are:Demo/Clean out/exterior workMechanical/RoofSheetrock/Kitchen?

It could be ideal for a house hack as there are two separate entrances, each with its own kitchen and bathroom.

I love San Diego and also like doing Real Estate in San Diego. i am planning to figure out how to become a real estate professional along with keeping my W2 job as long as the Stadium Company does not fire me. i want to have a backup as my spouse also have a W2 and so if i get laid off i can be then consider full time real estate professional and then focus completely on my RE journey.

I am working toward my RE license and would like to begin as an agent by the end of the summer as a part time job along with my W2 so that I can put any income from that into paying down that HELOC and putting more cash aside for the next possible deal.I'd like to have 2-3 more rentals within the next 5 years so that I can transition from my W2 to full time real estate (is that realistic?

The apartment definitely needs work - mold/mildew smell in bathroom, old kitchen appliances, old water heater, zero closet space, minor flooding in the basement, etc.

And some things that first timers focus on that don't affect ARV at all or very little. 

WL is a place to store and build up your capital until you have enough for the next property down payment.I believe WL is well aligned to be a "foundation" for real estate as the OP mentioned because you need a place for your capital to grow and you need a vehicle to compound your returns over time - real estate isn't a get rich quick scheme.

Najeh,You will want to focus on investing in areas where basic improvements such as curb appeal and internal updates (ie kitchen/bathrooms) would support higher property values that you could refinance or sell to make your money back. 

A Comprehensive Guide to Homebuying, it's essential to be thorough and methodical to ensure you're making an informed decision but draw boundaries, it's okay to open built-in closets and kitchen cabinets to assess the property, However, respect the seller's privacy by not invading their personal space, such as medicine cabinets, storage boxes, or clothing drawers,Interior:Architectural style.Bedroom and bathroom count, size, and location.Closet and storage space.Number of floors.Sightlines and general floorplan.Appliance age and condition.Light switches and socket count.Plumbing and water pressure.Natural light and views.Noise levels.Stairway width and type.Porches and decks.Garage and parking capacity.Proximity to neighboring homes.Remodeling opportunities.Exterior:Roof and siding condition.Landscaping and outdoor maintenance needs.Additional Considerations:Take notes and photos during the tour.Use your five senses to assess the home's condition.Ask your real estate agent questions about the home's features, flaws, and market conditions.Red Flags:Overly scented rooms.Water stains and damage.Lack of maintenance.Foundation issues.Sagging ceiling.Fresh paint that may be covering up issues.Final Tips:Be prepared to make multiple offers before finding the right home at the right price.Stick to your budget when making an offer.Don't overlook potential red flags just because you love a home.