A hatch pattern is basically an array of lines in two directions. To create a pattern that skips a course with sand texture, would be extremely difficult.
The best solution for the wall you want is to
1.Use split face and paint tools to apply the pattern to the wall face or,
2.Edit the wall family to have split regions and apply the material to the necessary regions.
I will try to explan both of these methods as best as I can. In both of these methods you will need to create a custom material with the split face as a surface pattern. There is a default split face cmu that you can modify.
1. Split face is a tool that will divide the face of a wall, floor, ceiling, roof ..etc. You can then use the Paintbrush tool to apply your materials to the resulting faces. This method is time consuming and not recommended if you have a lot of these walls.
2. In the wall family go to Edit/New-->Edit structure. Make sure the Preview Pane is Visibile. Go to the Section Preview and you should see the tool buttons become available. You need to make a new layer/region with the new material applied to it but no thickness.
Click split region and select the heights you want to divide. You can do as many splits as necessary. Next click Assign layers and assign the new layer you created to the areas you want.
If you have any questions on this please feel free to ask.