Lots of examples of places built looking up somebody else's backsides. But they probably are not "Normal" streets.
They got a lot behind another house. So somebody builds a shack back there. Your street number is a 1/2 number. Like 442 1/2 Weird Street, My Town, USA. Mail man loves it if he has to walk behind another house. Lots of folks will never find your house.
The other way it happens, there is an entire lil street back there. Might have a street sign, might not, might be called a Private Way. It gets named some sort of Terrace or Place. Again the joys of folks trying to find it. After a while you figure out those type streets means it is in back looking up the other guys back side. Lots of them won't be in the book of maps for a city or the electronic nagivator will go nuts trying to find a new one, maybe even a old one with only a few houses. It can get lonely back there. Snow plow never comes, the World never knows you exist. Some big time cons maybe hiding out back there. The milkman can't even find it. Forget the UPS guy, he leaves all your packages with somebody else.
Yeah, it might affect your resale potential in today's status concerned World. You could always try for a resale to a proctologist. Rumor has it they enjoy that type of view from the backside of life.
I've looked for more than my share of Terraces or Places, some of them I never found either.