When playing as Australia I founded a city on the coast AND next to a lake. The city only had 5 housing, meaning that it either got +3 from the fresh water OR +3 from the coast, instead of both. With a city that was on the coast and on a river I got the correct amount of +6 housing (total of 8), but not when the fresh water source was a lake.