This dataset contains raw model results from 5 different scenario's as part of a publicationon the impact of system integration on system costs in a neigbhourhood energy- and water system. It is being made public to act as supplementary data for publication(s) and the PhD thesis of Els van der Roest. Also, it might be used by other researhers.The dataset was created during model runs in the period between July 2019 - April 2021.Abstract of the paper:The fossil-based energy system is in a transition towards a renewable energy system. One important aspect is the spatial and temporal mismatch between intermitted supply and continuous demand. To ensure a reliable and affordable energy system, we propose an integrated system approach, which requires the integration of electricity production, mobility, heating of buildings and water management with a major role for storage and conversion. The minimisation of energy transport in such an integrated system indicates the need for local optimisation. This study focuses on a comparison between different novel system designs for neighbourhood energy- and water systems with varying modes of system integration including all-electric, power-to-heat and power-to-hydrogen. A simulation model is developed to determine the energy and water balance and carry out economic analysis to calculate the system costs of various scenarios. We show that system costs are the lowest in a scenario that combines a hydrogen boiler and heat pumps for household heating, or a Power-to-X system that combines power-to-heat, seasonal heat storage and power-to-hydrogen (2,070 ���/household/year). Scenarios with electricity as the main energy carrier have higher retrofitting costs for buildings (insulation + heat pump) which leads to higher system cost (2,320-2,370 ���/household/year) than more integrated systems. We conclude that diversification in energy carriers can contribute to a smooth transition of existing residential areas.