Weaverville allows STR and I know they do well, I would just stay out of the actual Weaverville town and stick to the Reems Creek District. 

So ideally a home in a good school district, but in the 150-250k price range.

Could anyone share any insight on 49508 and the kentwood school district?

The way our school districts are funded is set up, inadvertently or not, will keep certain lower property value areas down.

In terms of Price Hill, my understanding is that the development is concentrated in the Incline District.

Plus I would think some district attorneys would like to get their hands on that deposition.

I also understand that the areas within the Palo Verdes high school district tend to be viewed more favorably by residents (potential tenants) with school age kids (a map outline is available online). 

My impression for each town is as follows:Columbia, Ellicott City - Great to live and Great school district, but looks like the area for family (not ideal for house hacking?)

@Carol Fenimore in Cleveland you typically find the areas with higher tax rates being in more desirable school districts than their immediate neighboring cities.

Based on your criteria, I would do the following:Buy a fixer in a great and/or up and coming school district.