Suburbia
Does Waterfront Realty have to sit next to a lake, and does it boost every lake?
No adjacency is needed; place it anywhere in your borough. It boosts only lakes in your own borough (all of them), never other players' lakes, and it pays nothing by itself. The bonus comes when tiles are placed next to those lakes.