Three-bedroom house enjoys ‘one of most picturesque settings in the region’