Long term play would be to either use it as a short term rental or 1031 exchange it after 2+ years.

Investment Info:

Single-family residence commercial investment investment in West Sacramento.

Purchase price: $500,000

Cash invested: $100,000

AirBNB in West Sacramento

The ability to use leverage to acquire more attractive assets and amplify their potential gains4.

In short its complicated:) each situation is different

I'm considering purchasing a condo or a small SFH in the Oceanside/Carlsbad area as an investment property and renting it out on a short term rental site like AirBNB. 

Steady Growth – Home to Ohio State University (the largest college in the U.S.) and major Fortune 500 companies like Cardinal Health, Nationwide Insurance, and L Brands, Columbus attracts a steady influx of students, professionals, and job seekers every year.Strong Rental Market – With a growing population and a high demand for housing, rental properties are in constant demand, making it a prime market for investors.Affordable Prices – Unlike other hot markets, Columbus still offers below-national-average home prices (around $275,000 median), giving investors a chance to buy in before prices climb even higher.

But I have to ask, is this unit attracting this kind of tenant? 

The area has attracted a lot of new young professionals with their work from home marketing that gives $10,000 to qualified families to help them establish themselves in the area.

It is not walking distance to much but a short drive to a lot and generally a touristy area. 

Short term it is difficult to make the numbers work, the cost of new construction and the time it takes to zone-plan-build are usually the main reasons why private investors stay clear.