Erin Hill
Coldwell Banker Real Estate Group
(224) 970-3247
173 Total Sales
6 in Indian Creek
$110K - $455K Price Range
1504 Mansfield Dr Aurora, IL 60502
Indian Creek NeighborhoodEstimated Value: $549,000 - $675,000
3
Beds
3
Baths
2,133
Sq Ft
$284/Sq Ft
Est. Value
Highlights
- Open Floorplan
- Mature Trees
- Clubhouse
- Landscaped Professionally
- Community Lake
- Deck
About This Home
As of November 2025When Only THE BEST Will Do-This Gorgeous 'Expanded Greenbriar' Ranch with RARE 3 CAR GARAGE is THE ONE!! This One-of-a-Kind Home is located in the Highly Coveted 55+ 'Carillon at Stonegate' where Luxury Living is Paramount - A True Stand Out Home Situated on a Tranquil, Private, 11,325 Sq Ft Premium Lot with Front & Rear Outdoor Living Spaces! Spanning 2133 Sq Ft of Luxurious Main Level Living PLUS Full Basement, Fireplace, Overhead Surround Sound System, Neutral Warm Kitchen, Gorgeous Cabinetry, SS Appliances, Beautiful Hardwood Flooring, Upgraded Plush Carpet, Luxe Primary Ensuite, Huge 2nd Private Bedroom & Full Bathroom, Den (or can be another main level bedroom), Main Level Laundry Room - & The List Goes On & On - The Well Thought-out Finished Basement with Wet Bar, Full Bathroom, Bedroom, HUGE Recreation Room is sure to Impress the Entertainer & Overnight Host, also Suitable for Multigenerational Living - There is So Much Square Footage of Flexible Living, Entertaining, Storing your Treasures .... The Options are Endless!! Check Out These IMPRESSIVE DATES: 2023 WATER HEATER - 2022 AC, THERMOSTAT & IRRIGATION MECHANICALS - 2020 SS KITCHEN APPLIANCES & SUMP PUMP - 2017 WASHER & DRYER -2014 ROOF, SIDING, GUTTERS & DOWNSPOUTS!! Furnace is Serviced Annually & Works Perfect!! METICULOUSLY MAINTAINED BY THE ORIGINAL OWNER - THIS IS THE ONE YOU WILL WANT TO CALL HOME!! Carillon @ Stonegate is a Premier 55+ Active Adult Resort Style Community offering a Beautiful Clubhouse with Fitness Center, Gathering Room, Aerobics Room, Arts & Craft Room, Library, Card Room, Outdoor Pool, Multiple Walking Paths, Pond, Tennis, Pickle Ball Courts, Bocce Ball, Activities, Clubs, Trips & More - This is the Life You've Worked For!!
Last Agent to Sell the Property
Baird & Warner License #475143857 Listed on: 10/02/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $10,310
Year Built
- Built in 2005
Lot Details
- 11,326 Sq Ft Lot
- Next to a Nature Preserve
- Landscaped Professionally
- Paved or Partially Paved Lot
- Sprinkler System
- Mature Trees
- Backs to Trees or Woods
HOA Fees
- $265 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Parking Available
- Garage Door Opener
- Driveway
- Parking Included in Price
Home Design
- Ranch Style House
- Asphalt Roof
- Stone Siding
- Vinyl Siding
- Concrete Perimeter Foundation
Interior Spaces
- 2,133 Sq Ft Home
- Open Floorplan
- Wet Bar
- High Ceiling
- Gas Log Fireplace
- Drapes & Rods
- Window Screens
- Entrance Foyer
- Family Room with Fireplace
- Living Room
- Formal Dining Room
- Den
- Recreation Room
- Lower Floor Utility Room
- Storage Room
- Carbon Monoxide Detectors
Kitchen
- Range
- Microwave
- Dishwasher
- Stainless Steel Appliances
- Quartz Countertops
- Disposal
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 3 Bedrooms
- 3 Potential Bedrooms
- Walk-In Closet
- In-Law or Guest Suite
- Bathroom on Main Level
- 3 Full Bathrooms
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
Partially Finished Basement
- Basement Fills Entire Space Under The House
- Sump Pump
- Recreation or Family Area in Basement
- Finished Basement Bathroom
- Basement Storage
- Basement Window Egress
Accessible Home Design
- Accessibility Features
- Doors swing in
- Doors with lever handles
- Doors are 32 inches wide or more
- More Than Two Accessible Exits
Outdoor Features
- Deck
- Patio
Utilities
- Central Air
- Heating System Uses Natural Gas
- Lake Michigan Water
- Gas Water Heater
- Cable TV Available
Listing and Financial Details
- Senior Tax Exemptions
- Homeowner Tax Exemptions
Community Details
Overview
- Association fees include clubhouse, exercise facilities, pool, lawn care, snow removal
- Sandra Brisart Association, Phone Number (630) 978-6503
- Carillon At Stonegate Subdivision, Expanded Greenbriar Floorplan
- Property managed by MC Property Management
- Community Lake
Amenities
- Clubhouse
Recreation
- Tennis Courts
- Community Pool
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Oct 2, 2025
Closed on
Nov 12, 2025
Sold by
Wall Sharon G
Bought by
Seller's Agent
Angela Testa-Kerivan
Baird & Warner
Buyer's Agent
Julie Tobolski
Coldwell Banker Real Estate Group
List Price
$587,000
Sold Price
$565,000
Premium/Discount to List
-$22,000
-3.75%
Views
49
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$17,788
Avg. Annual Appreciation
8.86%
Original Mortgage
$452,000
Outstanding Balance
$448,880
Interest Rate
6.13%
Mortgage Type
New Conventional
Estimated Equity
$156,330
Purchase Details
Closed on
Jan 25, 2005
Sold by
Drh Cambridge Homes Inc
Bought by
Wall Jerry R and Wall Sharon G
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$95,000
Interest Rate
5.79%
Mortgage Type
Unknown
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Indian Creek, IL
-
Erin Hill
-
Joseph Deardurff
Joseph Deardurff
Keller Williams ONEChicago
(630) 864-6422
75 Total Sales
1 in Indian Creek
$229,900 Price
-
Oliva Escutia
Oliva Escutia
Real People Realty
(815) 893-2710
59 Total Sales
1 in Indian Creek
$333,000 Price
-
Carolyn Alzueta
Carolyn Alzueta
Charles Rutenberg Realty of IL
(630) 528-2679
149 Total Sales
1 in Indian Creek
$115,000 Price
-
Chris Vernald
Chris Vernald
Engel & Voelkers Chicago
(708) 859-7250
161 Total Sales
1 in Indian Creek
$385,000 Price
-
Jason Rosenberg
Jason Rosenberg
Infiniti Properties, Inc.
(833) 324-4132
171 Total Sales
1 in Indian Creek
$106,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $565,000 | Chicago Title | ||
| Wall Jerry R | $377,500 | Chicago Title Insurance Comp |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $452,000 | ||
| Previous Owner | Wall Sharon G | $88,000 | |
| Previous Owner | Wall Sharon | $91,000 | |
| Previous Owner | Wall Jerry R | $95,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 11/12/2025 11/12/25 | Sold | $565,000 | -3.7% | $265 / Sq Ft |
| 10/14/2025 10/14/25 | Pending | -- | -- | -- |
| 10/02/2025 10/02/25 | For Sale | $587,000 | -- | $275 / Sq Ft |
Source: Midwest Real Estate Data (MRED)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $10,843 | $182,024 | $33,403 | $148,621 |
| 2024 | $10,843 | $166,399 | $30,536 | $135,863 |
| 2023 | $9,915 | $148,677 | $27,284 | $121,393 |
| 2022 | $9,471 | $135,654 | $24,894 | $110,760 |
| 2021 | $9,308 | $126,296 | $23,177 | $103,119 |
| 2020 | $9,775 | $128,533 | $21,528 | $107,005 |
| 2019 | $9,524 | $119,089 | $19,946 | $99,143 |
| 2018 | $9,741 | $117,979 | $18,450 | $99,529 |
| 2017 | $10,658 | $119,684 | $19,832 | $99,852 |
| 2016 | $10,316 | $109,037 | $18,981 | $90,056 |
| 2015 | -- | $98,368 | $16,322 | $82,046 |
| 2014 | -- | $90,381 | $13,605 | $76,776 |
| 2013 | -- | $85,921 | $14,442 | $71,479 |
Source: Public Records
Agents Affiliated with this Home
-
Angela Testa-Kerivan
Seller's Agent in 2025
Angela Testa-Kerivan
Baird Warner
(630) 745-7653
4 in this area
112 Total Sales
-
Julie Tobolski
Buyer's Agent in 2025
Julie Tobolski
Coldwell Banker Real Estate Group
(630) 699-6340
1 in this area
48 Total Sales
Map
Source: Midwest Real Estate Data (MRED)
MLS Number: 12486168
APN: 15-12-430-001
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.
Listings courtesy of Midwest Real Estate Data (MRED) as distributed by MLS GRID.
Based on information submitted to the MLS GRID
Nearby Homes
- 2 E 87 St
- 2812 Preserve Cir Unit 9002
- 2816 Preserve Cir Unit 9003
- 1111 Stetson Ave
- 3165 Moorehead Dr
- 2198 Brookside Ln
- 2419 Woodglen Dr
- 1721 Daisy St
- 1715 Lily St
- 1740 Stable Ln
- 1058 Courtland Place
- 1119 Heathrow Ln
- 1179 Kingsley Ln
- 1585 Woodcrest Ct
- 2054 Selmarten Rd
- 1484 Mcclure Rd Unit 415
- 1132 Foxridge Ln Unit 12
- 2727 Downing Ct
- 1319 Cranbrook Cir
- 2067 Stephen St
- 1505 Mansfield Dr Unit 2
- 1473 Mansfield Dr
- 1545 Mansfield Dr
- 1465 Mansfield Dr
- 1577 Mansfield Dr
- 1528 Mansfield Dr
- 1585 Mansfield Dr
- 1512 Mansfield Dr
- 1480 Mansfield Dr Unit 1
- 1457 Mansfield Dr
- 1472 Mansfield Dr
- 1488 Mansfield Dr
- 1593 Mansfield Dr
- 1496 Mansfield Dr Unit 2
- 1536 Mansfield Dr
- 1464 Mansfield Dr
- 1449 Mansfield Dr
- 1617 Mansfield Dr Unit 2
- 1456 Mansfield Dr
- 1568 Mansfield Dr
Your Personal Tour Guide
Ask me questions while you tour the home.