This sounds like a very bad idea unless you want to have the child(ren) sleep in your room. I’m not sure how new a dad you are, but be prepared for frequent visits in the middle of the night (even in middle school), whether out of nerves, illness, worries about finals etc.
Remember the laws of supply and demand – the reason you are looking at these homes probably means they are a good price. The reason that they are well priced is because people with kids don’t want them. Never forget that you will want to sell it someday.
And privacy? HA! Good luck with that. (I have one in middle school, one in high school and one about to leave for college….). The youngest walks through my room every morning to get to our bathroom so she can use my makeup.
