[bombcar]

Even if the provider is stupid AF you can usually get around the residential restriction by starting the discussion with the business side of the company; once the salesman has a nibble he's not gonna cut you free if he can help it.

And then get a 2 year term on whatever seems a "good deal" at the time (I had cable speeds and 5 IPs) and once that is up call them and "drop down" to whatever you actually need (cable speeds and 1 IP) - you'll find that at that point there will be various "packages" that were never advertised but the system is quite capable of supporting.

If all else fails, find a company that works with the provider and offers service over their "last mile".

You'll pay for all the above, but not as much as you might think, and business support is actually good in many, many cases. Fabled evil Comcast rolled a truck twice until they tracked down a problem, at no charge.

[mindslight]

Still sounds like a huge hassle compared to municipal fiber.