You asked

how common were multi story houses in ancient israel, and how did that impact this law?

Reading with you…