The recommended new neighborhood provider is Comcast however, some of the 50 homes have U-verse or DISH.
AT&T perhaps isn't much interested in installing U-verse anymore so you may be left with Comcast as the only terrestrial option. You'll probably have Comcast broadband in any event but you should ask about U-verse broadband. Some have commented that their U-verse TV service has improved but that seems to be regional.
Comcast's X1 is getting a little long in the tooth but it is more or less capable. Until recently, TiVo may have been the more desirable option with Comcast but TiVo perhaps isn't what it used to be and X1 has invested 6 years into finally getting it working (after a miserably failed joint effort with TiVo). Six tuners can plow through 500MB pretty quickly. Recording capacities are relatively small and they may or may not offer eSATA expansion capability (my local Comcast does not even though they offer DVRs that feature eSATA ports). RF remote is an option depending on the particular DVR model. The remote looks and feels like a cheap universal remote.
The downside to Comcast is that they are in fierce competition with DIRECTV for nickel and diming customers with ancillary fees. RSN fees and local channel fees are considerable now and if you get phone service, they'll nail you with phone-associated fees (911, cost recovery, blah, blah blah). Comcast also has some relatively serious billing issues and has a documented history of overcharging some their customers.
PQ-wise, Comcast is nothing to write home about. In my area, they treat 720p content (ABC, Fox, Disney, ESPN) like a baby treats a diaper. Compression artifacting can be quite noticeable. Unless something has changed recently, UHD content must be streamed.
On the bright side, the on-demand programming is perhaps second to none.
