buy
rent
sell
agents

new development WORLD OF ELLIMAN

YOUR NEXT HOME IS WAITING

Our exceptional agents will help you find it.

The latest in luxury property, lifestyle & culture, curated just for you.

company

about us
leadership
offices
press & news
elliman cares
join as an agent
careers
INTERNATIONAL PARTNERSHIP
investors

resources

WORLD OF ELLIMAN
elliman insider
magazines
market reports
research reports
Elliman Exclusives
Featured Cities
guides to buying & selling

brand portfolio

new development
commercial
relocation
property management
sports & entertainment
farm & ranch
building broker specialists
title services
master trust & probate

California
Colorado
Connecticut
Florida
Massachusetts
Mid-Atlantic
Nevada
New Jersey
New York
New York City
Texas
Vermont

SITE MAP
TERMS
PRIVACY
COOKIE PREFERENCES
DO NOT SELL OR SHARE MY PERSONAL INFORMATION

NYS Housing Discrimination Disclosure Notice & Form
NYS Standard Operating Procedure
NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
California Consumer Privacy Act Notice
Texas Consumer Protection Notice
Texas Real Estate Commission Information About Brokerage Services
text of new york city human rights law
new york city commission on human rights
nyc source of income discrimination information
nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON JUL 09 2025 AT 4:55 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

Mayfair

Luxury listings for sale in Mayfair

2 of 2 Homes

COMPARE

Exterior, Facade, Ranch

Exterior, Facade, Ranch

Exterior, Facade, Ranch

Backyard, Exterior

Backyard, Exterior

Backyard, Exterior

Backyard, Exterior

Interior, Wood Texture Flooring

Interior, Wood Texture Flooring

Interior, Wood Texture Flooring

Bathroom, Interior, Marble Walls

Dining room, Interior, Kitchen, Wood Texture Flooring

Dining room, Interior, Sun Room

Backyard, Exterior

Interior, Recessed Lighting

Interior, Washer

Backyard, Exterior

Backyard, Exterior

Backyard, Exterior

Interior, Wood Texture Flooring

Interior, Wood Texture Flooring

Bathroom, Interior

Interior, Marble Walls

Interior, Kitchen, Stainless Steel Appliances, Wood Texture Flooring

Interior, Kitchen

Backyard, Exterior

Backyard, Exterior

Backyard, Exterior

Backyard, Exterior

$459,900

3474 E Terrace Ave, Fresno, CA

Listing Courtesy of ENVISION REALTY, INC., GUSTAVO SILVA - 559-978-3876

Attached, Backyard, Exterior, Facade, Ranch

Backyard, Exterior

Empty room, Fireplace, Interior, Wood Texture Flooring

Empty room, Fireplace, Interior, Wood Texture Flooring

Empty room, Fireplace, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Interior, Kitchen, Wood Texture Flooring

Interior, Kitchen, Wood Texture Flooring

Interior, Wood Texture Flooring

Bathroom, Interior, Wood Texture Flooring

Bathroom, Dual Sink Vanities, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Empty room, Interior, Wood Texture Flooring

Backyard, Exterior

Backyard, Exterior

Backyard, Exterior

$282,500

2135 Arden Dr W, Fresno, CA

2 br1 BA1,031 sf

Listing Courtesy of REAL BROKER, MARIE MEZA - 559-246-4905