Because Mayfair's housing stock is older, a home inspection, typically $400 to $600, carries more weight there than in a newer subdivision, since major systems and any secondary suite's permit status vary widely from one house to the next.
Mayfair's proximity to downtown appeals to buyers who want a shorter commute over the larger lots and newer finishes of a suburb still filling in, so the tradeoff is location against condition rather than one neighbourhood simply being better than another.
Joel Dyck can walk you through Mayfair's specific streets before you decide it is the right fit. Get your hand-reviewed valuation from Joel Dyck.