Strong job and population growth, plus VSU and the military base are steady growing.

Emotional Purchases: Base your decisions on facts, not just emotions.

Obviously these are very generalized numbers and I feel your pain with L&I, they gotta be getting paid by the hour based on how slow and painful it is to deal with them sometimes.

If you have a large down payment (or the ability to cover negative cashflow), the East Bay's appreciation and principal pay-down benefits have been historically very strong compared to other markets.  

Commenting to follow - I'm based in California. 

Here’s a detailed analysis to help guide your decision:Initial Costs:Purchase Price: $260,000Down Payment and Closing Costs: $60,000Monthly Cost: $400 for several yearsMarket Value:Current Value: $540,000 to $600,000Immediate Equity: $280,000 to $340,000 (based on the market value minus the purchase price)The substantial equity in the farm can be a powerful tool for your investment journey:Home Equity Line of Credit (HELOC): You could use a HELOC against the farm's equity to fund other investments.

Getting creative about using your primary as a chess piece for your investment journey is just fun and probably the best way to hit the fast forward button on your investment journey (so long as your reserves and marriage are strong enough to handle it).

Vacancy rates:The overall office vacancy rate in Tampa is 9.4%, which is below the national average of about 13%.For residential properties, the homeowner vacancy rate is 1.0% and the rental vacancy rate is 4.2% in the 33619 zip code.Days on market:Specific data on days on market wasn't provided for Tampa overall, but the median days on market for homes is 89 days according to one source.Promising areas:The Westshore and Downtown Tampa submarkets have seen increased occupancy, with an uptick of 175,000 square feet over the past year.The Westshore submarket has seen its vacancy rate drop by 100 basis points year over year to 12.5%, hitting a four-year low.Rental property insights:Tampa has a high percentage of renters, with 53% of the population renting rather than owning homes.The median rent price in Tampa is $2,941.Market trends:Tampa's real estate market has seen strong appreciation, with a total appreciation of 129.39% since Q1 2000, at an average annual rate of 4.41%.The city is experiencing population growth and an influx of young, educated professionals due to increasing employment opportunities.Regarding your interest in a brand new construction SFR with live and work usage, this could be a promising investment given Tampa's growing population and the trend of people seeking to live close to their workplaces.

They are likely in violation of the lease agreement in this moment and you can evict based on one of those issues. 

However, you may be able to offset some gains through depreciation recapture.Prorating the exclusion: The IRS typically allows you to prorate the capital gains exclusion based on the percentage of the property used as your primary residence.