When located in a residential district or a residential sub-district of an SPD, where the average depth of at least two existing front yards on lots within 100 feet of the lot in question and within the same block front is less or greater than the least front yard depth prescribed elsewhere in this chapter, the required depth of the front yard on such lot shall be modified. In such case, this shall not be less than the average depth of the existing front yards on the two lots immediately adjoining, or, in the case of a corner lot, the depth of the front yard on the lot immediately adjoining, provided, that the depth of a front yard on any lot shall be at least ten feet and need not exceed 50 feet.