The host can exert too much time to collect or they can choose to not collect and pay the expense.  

Will the Scottsdale SFH market continue to stagnate or boom again (or dip further)?

All of Bend seems to be booming. 

The only way to reverse these is to prove the tax collector screwed up on notification and that is primarily done by counting the days in the newpaper.. they must publish for 21 consecutive days prior to the sale.

New construction (strip centers, grocery stores, roads etc) started booming the last year.

To me this and surrounding areas should have been attractive and booming area - Baltimore Inner Harbor is close by - but it's not. 

I live in Raleigh and the area is booming and I see bright future ahead.

Any other locations, check with the tax assessor collector.

There thinking some clean-up-fairy comes swooping in with a broom, washes the ashes away and then Bob The Builder n all his friends comes hot on the hells, Bing-Bang-Boom all is rebuilt and were singing kumbayas by Christmas.......Reality is it took about 10 years to rebuild post katrina. 

There's certainly been an uptick in available properties over the last few years as some owners have grown tired, new construction is booming in new lots and ones that were lost in fires, & investors who bought in 2020-2022 who may've overpaid and weren't properly set up are struggling.