Recommendations for an AP

[Tech9]

I use Gigabit ISP lines for business locations with about 180 clients.

 

[Piotrek]

or maybe segregate your traffic by using 2 smaller switches - keeping 10Gb on one and APs, etc on the other at lower bandwidth.

Pro XG 24 has 8 x 2.5 GbE RJ45 + 16 x 10 GbE RJ45 + 2 x 25G SFP28

In my experience, hard to saturate even 10 % of a 10 Gb ISP service with residential traffic.

Yes, but @ddaenen1 wants to upgrade LAN and I assume he knows what he's looking for.

but the rest of my LAN isn't

The tricky bit seems to be finding a decent 24p 10Gbe ports managed switch with VLAN capabilities and PoE++.

 

[Piotrek]

I use Gigabit ISP lines for business locations with about 180 clients.

I suspect it's a symmetrical connection.
Unfortunately, 100M/100M connections are often more expensive than 1G/100M, so it's better to buy 2G, 8G or 10Gbps download to get 600Mbps or 1Gbps upload (I use 2Gbps/600Mbps ISP line for business location with about 100 clients - the speed used usually does not exceed 100Mbps).