OFF MARKET

Off Market Sep 2015 for $1.1M

$1,749,690

Est. refi paymentEst. refi $7,169/mo

•

7,451

sq ft

47 Aintree Rd, St Charles, IL 60174

About this home

Spectacular, rare and unparalleled views await the most discriminating buyer for this Exquisite Estate. Highly coveted east side, in-town location w/5+ acres including your own creek-fed lake, pool, tennis courts, manicured yard w/gardens & virgin forest! This all-brick, custom home boasts beautiful marble floors, gourmet kitchen w/new appliances, stunning library, HW floors, 4 fireplaces & a finished lower level..!

Single-familyProperty Type

1993Year Built

5.33 acresLot Size

$235Est. Price/Sq.Ft.

3 car garageParking

Listed by Debora McKay • Coldwell Banker Realty

Bought with Nicholas Kud • Baird & Warner

Redfin checked: 2 minutes ago

•Source:MRED as Distributed by MLS Grid #08808198

Redfin Estimate

$1,749,690

$625K since sold in September 2015$8,000 since July

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 92.8% higher than the average sale price ($908K) of 5 comparable homes.

SOLD JUL 27, 2026
$899,000
A
5 beds4.5 baths4,559 sq ft
504 Pin Oak Ct, St Charles, IL 60174
SOLD AUG 7, 2026
$805,000
B
5 beds4 baths3,637 sq ft
1005 Stonehedge Rd, St Charles, IL 60174
SOLD AUG 11, 2026
$772,000
C
5 beds4.5 baths3,826 sq ft
3112 Turnberry Rd, St Charles, IL 60174
SOLD APR 20, 2026
$802,500
D
5 beds3.5 baths3,781 sq ft
1304 Hawkins Ct, St Charles, IL 60174
SOLD APR 29, 2026
$1,260,000
E
4 beds4 baths6,405 sq ft
22 Aintree Rd, St Charles, IL 60174

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$982,829

Est. take-home

List your home with Redfin and save $8,748

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$4,835/mo

Redfin rental estimate

List your home for rent

Market trends in 60174, IL

Last updated July 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

102.3%

+0.4% MoM

Median sale price

$445K

$5K MoM

Avg. days on market

44d

0 days MoM

Recently sold homes

122

19 MoM

New listings for sale

NEW 9 HRS AGO
$474,900
4 beds2.5 baths1,724 sq ft
1581 Madison Ave, St Charles, IL 60174
OPEN SAT, 11AM TO 1PM
$439,900
4 beds2 baths2,000 sq ft
1120 S 12th Ave, St Charles, IL 60174
OPEN SAT, 1:30PM TO 3:30PM
$359,900
2 beds2 baths1,121 sq ft
805 Walnut Ave, St Charles, IL 60174
EARLY ACCESS
$779,000
4 beds2.5 baths3,070 sq ft
506 Pin Oak Ct, St Charles, IL 60174
$347,500
3 beds1.5 baths1,329 sq ft
806 Derby Crse, St Charles, IL 60174
$250,000
1 bed1.5 baths906 sq ft
111 S 5th Ave Unit E, St Charles, IL 60174
EARLY ACCESS
$545,000
4 beds2 baths2,016 sq ft
1001 Geneva Rd, St Charles, IL 60174
$490,000
3 beds1 bath2,538 sq ft
1316 S 4th St, St Charles, IL 60174
$354,900
3 beds1 bath1,073 sq ft
542 S 14th St, St Charles, IL 60174
$375,000
3 beds3 baths1,521 sq ft
605 Pheasant Trl, St Charles, IL 60174
See all

Provided by Redfin

Sale history for 47 Aintree Rd

Date

Event

Price

MRED as Distributed by MLS Grid #11262351

Apr 24, 2022

Listing Removed

—

Jan 30, 2022

Price Changed

Nov 3, 2021

Listed (Active)

MRED as Distributed by MLS Grid #11249519

Nov 3, 2021

Listing Removed

—

MRED as Distributed by MLS Grid #08808198

Sep 18, 2015

Sold (MLS) (Closed Sale)

$1,125,000

$151/sq ft

Aug 3, 2015

Contingent

—

Jul 27, 2015

Price Changed

$1,155,000

$155/sq ft

Jun 22, 2015

Price Changed

$1,185,000

$159/sq ft

May 24, 2015

Price Changed

$1,195,000

$160/sq ft

May 4, 2015

Price Changed

$1,295,000

$174/sq ft

Apr 13, 2015

Price Changed

$1,445,000

$194/sq ft

Jan 2, 2015

Listed (New)

$1,495,000

$201/sq ft

Public Records

Jun 23, 1992

Sold

$325,000

$44/sq ft

Public Records

May 23, 1990

Sold

$317,500

$43/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$31,933 (+2.7%)

$144,188 + $322,393

$466,581

2024

$31,096 (+3.9%)

$144,188 + $322,393

$466,581

2023

$29,939 (+5.7%)

$132,855 + $297,054

$429,909

2022

$28,335 (+2.3%)

$118,907 + $265,868

$384,775

2021

$27,710 (−2.8%)

$128,983 + $230,640

$359,623

2020

$28,503 (+1.8%)

$122,946 + $222,815

$345,761

2019

$28,008 (−2.7%)

$118,265 + $227,088

$345,353

2018

$28,779 (−4.3%)

$118,265 + $227,088

$345,353

2017

$30,074 (−4.9%)

$116,090 + $236,876

$352,966

2016

$31,618 (+6.4%)

$112,120 + $252,801

$364,921

2015

$29,708 (+5.1%)

$108,182 + $243,922

$352,104

2013

$28,259 (+7.3%)

$108,086 + $203,308

$311,394

2012

$26,343 (+1.7%)

$108,086 + $203,308

$311,394

2011

$25,905 (−3.9%)

$109,394 + $199,738

$309,132

2010

$26,963 (+6.4%)

$117,361 + $255,130

$372,491

2009

$25,330 (−4.3%)

$117,361 + $255,130

$372,491

2008

$26,481 (−0.5%)

$118,907 + $297,805

$416,712

2007

$26,608

$118,907 + $303,924

$422,831

Tax history for 47 Aintree Rd

Year

Property tax

Land + Additions

Assessment*

2025

$31,933 (+2.7%)

$144,188 + $322,393

$466,581

2024

$31,096 (+3.9%)

$144,188 + $322,393

$466,581

2023

$29,939 (+5.7%)

$132,855 + $297,054

$429,909

2022

$28,335 (+2.3%)

$118,907 + $265,868

$384,775

2021

$27,710 (−2.8%)

$128,983 + $230,640

$359,623

2020

$28,503 (+1.8%)

$122,946 + $222,815

$345,761

2019

$28,008 (−2.7%)

$118,265 + $227,088

$345,353

2018

$28,779 (−4.3%)

$118,265 + $227,088

$345,353

2017

$30,074 (−4.9%)

$116,090 + $236,876

$352,966

2016

$31,618 (+6.4%)

$112,120 + $252,801

$364,921

2015

$29,708 (+5.1%)

$108,182 + $243,922

$352,104

2013

$28,259 (+7.3%)

$108,086 + $203,308

$311,394

2012

$26,343 (+1.7%)

$108,086 + $203,308

$311,394

2011

$25,905 (−3.9%)

$109,394 + $199,738

$309,132

2010

$26,963 (+6.4%)

$117,361 + $255,130

$372,491

2009

$25,330 (−4.3%)

$117,361 + $255,130

$372,491

2008

$26,481 (−0.5%)

$118,907 + $297,805

$416,712

2007

$26,608

$118,907 + $303,924

$422,831

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

5.33 Acres

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Kane County

APN

0923100026

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 24, 2026.

RE-1

Single-Family Estate District

The purpose of the RE-1 Single-Family Estate District is to accommodate low-density residential development in newly annexed and/or semi-rural areas of the City. The minimum lot size in this district is 54,450 sq ft, or 1.25 acre, and permits semi-rural estate development characterized by dwellings surrounded by ample open space. Consistent with its semi-rural character, some single-family lots are large enough to accommodate agriculture and/or horse stables. The RE-1 District also provides for limited institutional uses compatible with surrounding residential neighborhoods.

Permitted uses

Include but are not limited to:

Agriculture
Housing-Group
Housing-Single unit
Infrastructure
Park & open space

Property details

Parking

Parking Information
# Of Cars: 3
# of Garage Spaces: 3
Parking: Garage
Garage Ownership: Owned
Garage On-Site: Yes
Garage Type: Attached
Garage Details: Garage Door Opener(s),Transmitter(s)
Driveway: Asphalt,Brick,Circular

Interior

Bathroom Information
# of Baths (Full): 4
# of Baths (1/2): 1
Bath Amenities: Whirlpool,Separate Shower,Double Sink
Basement Bathrooms (Y/N): Yes

Bedroom Information
# of Bedrooms: 4
# of Bedrooms Possible: 4

Room Information
Room Type: Exercise Room
Level: Second
Dimensions: 18 x 14
Flooring: Carpet

Room Information
Room Type: Heated Sun Room
Level: Main
Dimensions: 18 x 12
Flooring: Ceramic Tile

Room Information
Room Type: Recreation Room
Level: Walkout Basement
Dimensions: 36 x 15
Flooring: Wood Laminate

Room Information
Room Type: Bonus Room
Level: Walkout Basement
Dimensions: 28 x 15
Flooring: Carpet

Room Information
Room Type: Library
Level: Main
Dimensions: 28 x 16
Flooring: Hardwood

Room Information
Room Type: Other Room
Level: Walkout Basement
Dimensions: 18 x 16
Flooring: Other

Room Information
Room Type: Bedroom 2
Level: Second
Dimensions: 17 x 12
Flooring: Carpet

Room Information
Room Type: Bedroom 3
Level: Second
Dimensions: 17 x 12
Flooring: Carpet

Room Information
Room Type: Bedroom 4
Level: Second
Dimensions: 14 x 13
Flooring: Carpet

Room Information
Room Type: Dining Room
Level: Main
Dimensions: 16 x 16
Flooring: Marble

Room Information
Room Type: Family Room
Level: Main
Dimensions: 27 x 18
Flooring: Carpet

Room Information
Room Type: Kitchen
Level: Main
Dimensions: 27 x 15
Flooring: Hardwood

Room Information
Room Type: Laundry
Level: Second
Dimensions: 13 x 08
Flooring: Carpet

Room Information
Room Type: Living Room
Level: Main
Dimensions: 18 x 14
Flooring: Carpet

Room Information
Room Type: Master Bedroom
Level: Second
Dimensions: 22 x 18
Flooring: Carpet

Additional Rooms Information
Dining Room: Separate
Basement: Full, Walkout
Basement Description: Finished

Interior Features
Interior Features: Vaulted/Cathedral Ceilings, Hot Tub, Bar-Wet, Hardwood Floors
# of Rooms: 13

Equipment
Appliances: Range, Microwave, Dishwasher, Refrigerator
Humidifier, Central Vacuum, Security System, Intercom, Sprinkler-Lawn

Fireplace Information
# of Fireplaces: 4
Fireplace Location: Family Room,Living Room,Other
Fireplace Features: Wood Burning, Gas Log, Gas Starter

Exterior

Exterior Features
Exterior Features: Patio, Porch, Hot Tub, In Ground Pool

Building Information
Living Area Source: Assessor
Exterior Building Type: Brick
Age: 21-25 Years
Built Before 1978 (Y/N): No
Roof: Shake
Foundation Details: Concrete Perimeter

Property Information
Property Type: Detached Single
Property Type: 2 Stories
Ownership: Fee Simple w/ HO Assn.
Rehab (Y/N): No
General Information: School Bus Service
Parcel Number: 0923100026

Lot Information
Dimensions: 5.3285
Lot Size: 5.0-5.99 Acres
Lot Features: Horses Allowed, Landscaped, Pond(s), Water Rights, Water View, Wooded
WaterfrontYN: Yes

Financial

Tax Information
Tax Annual Amount: $28,259.32
Tax Year: 2013
Tax Exemptions: Homeowner

Financial Information
Finance Code: Conventional
Special Service Area: N

Utilities

Utility Information
Water Source: Public
Sewer: Public Sewer
Electric: 200+ Amp Service

Heating & Cooling
Heating: Natural Gas, Forced Air
Cooling: Central Air

Location

Community Information
Community Features: Pool, Sidewalks, Street Lights

Homeowners Association Information
Association Fee: $250
Association Fee Frequency: Annually
Association Fee Includes: Other

School Information
Elementary School District: 303
Middle Or Junior School District: 303
Middle Or Junior School: WREDLING MIDDLE SCHOOL
High School District: 303
High School: ST CHARLES EAST HIGH SCHOOL

Location Information
Township: ST. CHARLES
Corporate Limits: ST. CHARLES
Directions: MAIN ST (RT 64) TO DUNHAM RD OR RT 25 (N) TO COUNTRY CLUB TO AINTREE RD TO HOME

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 5.33 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Kane County
APN: 0923100026

Home facts updated by county records on Aug 24, 2026

Other

Listing Information
Holds Earnest Money: Yes
Possession: Closing, Negotiable

Around this home

Schools

Wredling Middle School

Public 6-8 • Assigned • 0.7mi

7/10

St Charles East High School

Public 9-12 • Assigned • 0.8mi

7/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

2/10 Heat Factor

7 days above 100° expected this year, 14 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

4/10 Air Factor

3 unhealthy days expected this year, 5 days in 30 years

Provided by First Street

Historical weather

St Charles, IL • 60174

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.2 hours in June and 3.4 hours in December, placing it below the U.S. average for solar exposure.

10.2 hrs

3.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.66M – $2.01M

Reach more buyers when you sell with Redfin. Save up to $17,497 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

OPEN SAT, 11AM TO 1PM3D WALKTHROUGH

$439,900

4 beds2 baths2,000 sq ft

1120 S 12th Ave, St Charles, IL 60174

VIDEO TOUR

$2,150,000

5 beds4.5 baths8,039 sq ft

2455 Persimmon Dr, St Charles, IL 60174

$1,799,000

4 beds5 baths10,000 sq ft

4N675 Old Farm Rd, St Charles, IL 60175

$487,500

3 beds2.5 baths2,010 sq ft

2862 Stockberry Ln, West Chicago, IL 60185

$1,100,000

3 beds2.5 baths3,000 sq ft

5N124 Grove Ave, St Charles, IL 60174

$4,995,000

7 beds10.5 baths13,500 sq ft

875 Country Club Rd, St Charles, IL 60174

New listings for sale in 60174

NEW 9 HRS AGO

$474,900

4 beds2.5 baths1,724 sq ft

1581 Madison Ave, St Charles, IL 60174

OPEN SAT, 11AM TO 1PM3D WALKTHROUGH

$439,900

4 beds2 baths2,000 sq ft

1120 S 12th Ave, St Charles, IL 60174

OPEN SAT, 1:30PM TO 3:30PM

$359,900

2 beds2 baths1,121 sq ft

805 Walnut Ave, St Charles, IL 60174

EARLY ACCESS@PROPERTIES COMING SOON

$779,000

4 beds2.5 baths3,070 sq ft

506 Pin Oak Ct, St Charles, IL 60174

$347,500

3 beds1.5 baths1,329 sq ft

806 Derby Crse, St Charles, IL 60174

$250,000

1 bed1.5 baths906 sq ft

111 S 5th Ave Unit E, St Charles, IL 60174

EARLY ACCESS@PROPERTIES COMING SOON

$545,000

4 beds2 baths2,016 sq ft

1001 Geneva Rd, St Charles, IL 60174

$490,000

3 beds1 bath2,538 sq ft

1316 S 4th St, St Charles, IL 60174

$354,900

3 beds1 bath1,073 sq ft

542 S 14th St, St Charles, IL 60174

Home values near 47 Aintree Rd

Data from public records.

Address	Redfin Estimate
41 Aintree Rd, St Charles, IL 4 Beds \| 4.5 Baths \| 4950 Sq. Ft.	$1,259,045
52 Whittington Crse, St Charles, IL 3 Beds \| 2.5 Baths \| 2221 Sq. Ft.	$461,893

Address	Redfin Estimate
53 Aintree Rd, St Charles, IL 7 Beds \| 5.5 Baths \| 5697 Sq. Ft.	$1,270,196
61 Whittington Crse, St Charles, IL 3 Beds \| 3.5 Baths \| - Sq. Ft.	$456,538

Address	Redfin Estimate
50 Whittington Crse, St Charles, IL 4 Beds \| 3.5 Baths \| 1894 Sq. Ft.	$421,569
34W737 Country Club Rd, Wayne, IL 4 Beds \| 6 Baths \| 8322 Sq. Ft.	$1,955,325

Property information provided by MRED as Distributed by MLS Grid when last listed in 2015. This data may not match . Learn more.

More real estate resources

Cities
Neighborhoods
Zip Codes
Popular Searches

Arlington Heights homes for sale
Naperville homes for sale
Chicago homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Downtown St. Charles homes for sale
Valley View homes for sale
Crane Road Estates homes for sale
Cambridge homes for sale
Downtown Geneva homes for sale

60134 homes for sale
60510 homes for sale
60174 homes for sale
60175 homes for sale
60177 homes for sale

Houses for rent in St. Charles	Agents near me	Glenview, IL homes for sale	St. Charles Housing Market
Houses for sale near me	Chicago, IL homes for sale	Evanston, IL homes for sale
Land for sale near me	Naperville, IL homes for sale	Oak Park, IL homes for sale
Open Houses near me	Schaumburg, IL homes for sale	St. Charles Property Records
Condos for sale near me	Arlington Heights, IL homes for sale	IL New Listings