Based on the information you provided and the resources you shared, it seems that Fredericton, New Brunswick, is not significantly affected by the moderating effect of water. Most sources indicate that Fredericton experiences a semi-continental climate, suggesting that there might be some slight moderation from the surrounding water. However, it appears that because Fredericton is located inland and is not in close proximity to large bodies of water like the Bay of Fundy or Northumberland Strait, the moderating effect is minimal.
Southern New Brunswick, being closer to the Bay of Fundy, and eastern New Brunswick, being closer to the Northumberland Strait, do experience some moderation in temperature due to the warmer waters in those areas. This proximity to water helps moderate the temperatures in those regions.
However, it's important to note that the extent of the moderating effect can vary depending on various factors such as distance from the water, prevailing wind patterns, and ocean currents. The specific reasons for the Northumberland Strait being warmer are likely related to complex ocean currents, and that is a more detailed topic.
In summary, while some parts of New Brunswick may experience a moderating effect from nearby bodies of water, it seems that Fredericton, being further inland, does not experience a significant moderating effect from water sources.