Additionally, its affordability with a median home price below the national average makes it especially appealing for investors looking for a solid return.

It's only 25 minutes to Lansing, so it may be a cheaper rental solution for people living in Lansing.Don't really know either market, so recommend you compare average rents to determine how likely it is someone would commute.

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.

My situation is that my STR averages less than 7 days, I have material non-passive participation, so that I qualify for the "loophole". 

I've considered the Flip System guys, many people scoff at the 19k fee to get in, but if you look at the whole thing like buying a franchise it's actually not a bad setup if the deals really do yield what they say they are averaging.  

Let’s say that your 50 units rent for $1500 for each unit on average.

We have also been enjoying the educational value of JWB's twice-weekly Zoom show entitled "Not Your Average Investor."

Are these attractive terms for a housing market that appreciates on average 6%?

Alternatively, you could also just apply a % annual appreciation based on historic data, but those typically won't give you the most accurate market data since they're averaged out across all/most property classes (e.g. a single family home may appreciate differently in your area than a mobile or multifam property, etc.) 

Purchase price: $640,000 Cash invested: $1,200,000 Turned a shuttered and rundown 13-unit waterfront motel into a brand new vacation destination with added lakefront "tiny homes", for a new total of 20-units with yearly gross over 500,000 and cashflow averaging $40k monthly.