You mean like the million dollar McMansions on the same block as a gas station, across the street from an office high rise? I think you’re over-estimating the effect of land prices.

What's the problem with gas station (provided it keeps mandatory distance from the buildings) or the office building near the residential ones? In fact, close offices are often cited as a pros for certain locations, people are even trying to rent as close as they can in some cities.

PS: I've lived the whole last year approximately 100m away from both gas station and large office complex. Neither bothered me at all, and it was a first floor.