At least around here (Missouri, Kansas, Oklahoma), the schools usually sit on relatively large pieces of land, so there is enough room for several expansions without the school district having to buy any more property. 

Go to the zoning dept and find out everything you can about dwelling units/acre, service accessibility or septic and well requirements if not, taxes, special ordinances, improvement districts or ability to float municipal bonds and their general appetite for development.  

There are millions of dollars being invested into the millwork district.

Right now, I'm thinking that house hacking with a SFR in a growing neighborhood with a good school district would actually be a more sound strategy.

And, they should be willing to compile the following due diligence information for your review: who is jurisdictional authority; what is current zoning district;  when were onsite water/sewer lines installed; who owns (maintains) onsite lines; when were onsite water/sewer lines last inspected; does seller have copies of onsite water/sewer lines "as-built" plans; if seller doesn't have as-builts, can they be obtained from jurisdictional authority; does seller have clear title to all park owned homes (POH); who are POH manufacturers and when were homes built; etc.

This property is in the nicest school district of all of the state of Wisconsin, in one of the better neighborhoods.

The historical society  can dictate structural work, paint colors, things that change the appearance of the front of the home (including new energy efficient windows, etc), and in some districts even the landscaping.

We will reapportion districts using the Census to help conservatives.

If you're looking for something you can turn into a rental once you PCS you need to look at purchasing in the districts with great schools.. i.e. greenwood, CG, Carmel, Noblesville, Bloomington, People will pay more to live in those areas and you can most likely cover your expenses with a renter after you move out.

They really want to rent the property because of school district.