I’m assuming they aren’t close enough to just run some cat6 between both houses and have a single instance govern them?

I’ll be honest though, although your plan sounds cool as fuck, it also sounds like a really terrifying project from a security perspective.