So this is definitely another strong element 

Pick a strategy and learn everything you can on that strategy (and of course your target market).Education is your foundation so do you want a strong and deep foundation, or a mickey mouse one?

I would strongly advise against this.

Given everything you've told us about her and her strong moral character, how long before she asks if "there is something she could do to change your mind"? 

I'm not familiar with your specific area, but if population stats look positive, job growth is good, and schools are good as you mentioned, there's a pretty strong chance you'll see appreciation over time.If you're truly looking for an investment though - I would consider looking for an investment property at some point down the line (maybe after you save some cash after this purchase) - something you can rent out to others, collect cash to pay your mortgage and potentially bring home some extra each month while you pay down that loan.

My set is 11 years old and going strong. 

I also suspect that because of the school district there would be a strong rental market, given that some families may want to live in Piedmont during some of their kids' school years.  

With your unique travel schedule you have the unique ability to Short term rent (airbnb) your living area while you are away, which could add a strong income for yourself!

Is it about just getting started in real estate investing, is it about subsidizing an otherwise unaffordable home to live in, is it about acquiring strong income producing properties?

Given the strong cashflow we decided to keep it for our portfolio instead of reducing the price.