I want it to be very durable and trendy but not too expensive.

Some trendy, some ethnic, some just make great sandwiches and burgers. 

Yes it swings like crazy, but the overall trend is up.Tulips R US

That may be the case, especially for some tech workers, but I don't see that becoming a major trend. I

Off a little on one of the predictions, but usually cause I under, or over estimated the impact, but not the facts or the trend.  I

It turned out the agent was a partner owner and we worked out a deal.So the trend is to buy on market if it's a good property you will most likely be competing in the Madison area and need a strong offer.

Any current STR investors have any insight on this trend? Is

If you don't live in a market that is imploding, the general trend is that the house you could buy today will be more expensive down the road.That is not taking into consideration some unforeseen market collapse like 2008.

Like  said above. 2) Leverage or refinance and use money towards whatever the new trend is in real estate investing. 3) Look at Midterm rentals or Lease Option as lots of people move in out of the Seattle area. 4) House Hack your place and run the numbers at that time. 5) and more.. 

Columbus has experienced significant appreciation and this trend is expected to continue in the future.