Prettiest one on the market with the most features! Stunning seamless decor that flows from room to room. Beautiful new luxury vinyl, new paint finishes, and new carpeting make this a must see! Spectacular Mayfair home with 17 x 27 paver patio on premium pond location that will make you feel like you're vacationing at home. Incredible basement recreation room with huge bar for entertaining, stylish stone accent wall, loads of storage, and huge luxury bathroom with back-lit mirror and massive 6 x 8 steam shower, which is sure to exceed your expectations. First floor has 9 foot ceilings, loads of windows, stylish new lighting in the dining room and new mantel on the fireplace. Family room plus living room/sitting room that lends itself to so many uses. Kitchen with high end stainless appliances and 42" upper cabinets plus granite counter tops. Rare pond view yard! Large upstairs bedrooms are livable practically as two primary bedrooms. Third bedroom/guest room/office and 2nd floor laundry complete the picture. Update appliances in 2022 and 2026. New water heater 2025. This is an incredible location with paths, parks, green spaces, forest preserve, Whole Foods, DSW, Costco, restaurants, medical offices all practically out your front door! New roof 2026; special assessment fully paid. There is nothing in Mayfair quite like this one.
Details
MLS #
12738177
Listing Type
For Sale
Style
Condominium
HOA Dues
$543
Sub-Type
Resale
Status
Active Under Contract
Year
2008
Days On Site
26
Listing Provided By
RE/MAX Professionals Select | Max Shallow
Features
Bed(s)
3
Bath(s)
4 Total
SQ Feet
2,225
Garage
2
Basement
Y
Story(s)
2
Water Front
Yes
Property View
Water
Interior
Rooms Total
8
Cooling
Central Air
Heating
Natural Gas, Forced Air
Interior Features
Vaulted Ceiling(s), Storage
Appliances
Microwave, Dishwasher, High End Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Cooktop, Oven
Fireplaces Total
1
Laundry Features
Upper Level, Washer Hookup
Exterior
Roof
Asphalt
Foundation Details
Concrete Perimeter
Construction Materials
Vinyl Siding, Brick
Patio And Porch Features
Patio
Parking
Parking Features
Asphalt, Garage Door Opener, Yes, Garage Owned, Attached, Garage
Garage Spaces
2
Utilities
Sewer
Public Sewer
Electric
Circuit Breakers
Taxes
Tax Year
2025
Tax Annual Amount
9138.9
Area Information
State
IL
County
DuPage
City
Naperville
Zip Code
60540
Area
Naperville
Community Name
Mayfair
School District
Metea Valley High School
Elementary School
Cowlishaw Elementary School
High School
Metea Valley High School
Listing VS Median (in Mayfair)
Price: $575,000
low | high
Med: $450,000
71.739130434783% of Average
sqft: 2,225
low | high
Med: 2,529
36.337078651685% of Average
$ / sqft: $258
low | high
Med: $178
81.146526380938% of Average
On site: 26
low | high
Med: 6
100% of Average
Sourced by Back At You
Market Activity 60540
Date
Sales
Avg $ Per SqFt
Min Sale Price
Max Sale Price
Med Sale Price
Date: Aug 2026
Sales: 4
Avg $ Per SqFt: $425.58
Min Sale Price: $700,000
Max Sale Price: $1,800,000
Med Sale Price: $769,950
Date: Jul 2026
Sales: 39
Avg $ Per SqFt: $303.4
Min Sale Price: $265,000
Max Sale Price: $3,000,000
Med Sale Price: $680,000
Date: Jun 2026
Sales: 47
Avg $ Per SqFt: $286.64
Min Sale Price: $293,000
Max Sale Price: $1,807,500
Med Sale Price: $625,000
Date: May 2026
Sales: 50
Avg $ Per SqFt: $301.46
Min Sale Price: $298,900
Max Sale Price: $1,549,000
Med Sale Price: $662,500
Date: Apr 2026
Sales: 43
Avg $ Per SqFt: $300.72
Min Sale Price: $130,000
Max Sale Price: $2,300,000
Med Sale Price: $535,000
Date: Mar 2026
Sales: 30
Avg $ Per SqFt: $297.22
Min Sale Price: $340,000
Max Sale Price: $2,530,000
Med Sale Price: $764,000
Date: Feb 2026
Sales: 29
Avg $ Per SqFt: $295.76
Min Sale Price: $340,000
Max Sale Price: $2,199,000
Med Sale Price: $657,900
Date: Jan 2026
Sales: 22
Avg $ Per SqFt: $314.26
Min Sale Price: $272,000
Max Sale Price: $1,920,000
Med Sale Price: $514,777
Date: Dec 2025
Sales: 12
Avg $ Per SqFt: $271.66
Min Sale Price: $326,000
Max Sale Price: $990,000
Med Sale Price: $644,500
Date: Nov 2025
Sales: 17
Avg $ Per SqFt: $260.88
Min Sale Price: $266,500
Max Sale Price: $885,000
Med Sale Price: $590,000
Date: Oct 2025
Sales: 49
Avg $ Per SqFt: $265.34
Min Sale Price: $315,000
Max Sale Price: $3,869,000
Med Sale Price: $567,000
Date: Sep 2025
Sales: 34
Avg $ Per SqFt: $282.77
Min Sale Price: $234,900
Max Sale Price: $3,100,000
Med Sale Price: $627,500
Sourced by Back At You
Aug 2026
Sales:
4
Avg $ Per SqFt:
$425.58
Min Sale Price:
$700,000
Max Sale Price:
$1,800,000
Med Sale Price:
$769,950
Jul 2026
Sales:
39
Avg $ Per SqFt:
$303.4
Min Sale Price:
$265,000
Max Sale Price:
$3,000,000
Med Sale Price:
$680,000
Jun 2026
Sales:
47
Avg $ Per SqFt:
$286.64
Min Sale Price:
$293,000
Max Sale Price:
$1,807,500
Med Sale Price:
$625,000
May 2026
Sales:
50
Avg $ Per SqFt:
$301.46
Min Sale Price:
$298,900
Max Sale Price:
$1,549,000
Med Sale Price:
$662,500
Apr 2026
Sales:
43
Avg $ Per SqFt:
$300.72
Min Sale Price:
$130,000
Max Sale Price:
$2,300,000
Med Sale Price:
$535,000
Mar 2026
Sales:
30
Avg $ Per SqFt:
$297.22
Min Sale Price:
$340,000
Max Sale Price:
$2,530,000
Med Sale Price:
$764,000
Feb 2026
Sales:
29
Avg $ Per SqFt:
$295.76
Min Sale Price:
$340,000
Max Sale Price:
$2,199,000
Med Sale Price:
$657,900
Jan 2026
Sales:
22
Avg $ Per SqFt:
$314.26
Min Sale Price:
$272,000
Max Sale Price:
$1,920,000
Med Sale Price:
$514,777
Dec 2025
Sales:
12
Avg $ Per SqFt:
$271.66
Min Sale Price:
$326,000
Max Sale Price:
$990,000
Med Sale Price:
$644,500
Nov 2025
Sales:
17
Avg $ Per SqFt:
$260.88
Min Sale Price:
$266,500
Max Sale Price:
$885,000
Med Sale Price:
$590,000
Oct 2025
Sales:
49
Avg $ Per SqFt:
$265.34
Min Sale Price:
$315,000
Max Sale Price:
$3,869,000
Med Sale Price:
$567,000
Sep 2025
Sales:
34
Avg $ Per SqFt:
$282.77
Min Sale Price:
$234,900
Max Sale Price:
$3,100,000
Med Sale Price:
$627,500
MLS Number: 12738177
Max Shallow – (630) 615-2870 – max@theshallowteam.com
The information is being provided by MRED. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 MRED. All Rights Reserved.
MLS Number: 12738177
Max Shallow – (630) 615-2870 – max@theshallowteam.com