Experience resort-style luxury living in this extraordinary custom-built executive estate offering approximately 7,500 square feet of beautifully finished living space designed for upscale entertaining, multigenerational living, and everyday comfort. Situated on a professionally landscaped 1.3-acre estate lot in unincorporated Manhattan within the highly sought-after Lincoln-Way West School District, this exceptional residence offers a combination of size, quality, privacy, and amenities rarely available in today's market. Featuring a private second-floor guest suite and a fully finished lower level designed for entertaining, work-from-home flexibility, guest accommodations, and extended living space, this home delivers a level of functionality and versatility seldom found in comparable properties. From the moment you arrive, the home impresses with its grand curb appeal, expansive circular driveway, and commanding architectural presence. Inside, you'll find extensive custom millwork, rich hardwood flooring, oversized living spaces, surround sound throughout, radiant heated floors, and thoughtfully designed entertaining areas across all levels. The heart of the home is a true chef's kitchen featuring premium Wolf and Sub-Zero appliances, double ovens, warming drawer, granite countertops, custom cabinetry, reverse osmosis drinking water system, an oversized pantry featuring an additional full-size Liebherr refrigerator, and expansive prep and gathering space ideal for entertaining on any scale. The spectacular four-seasons room creates a true year-round resort experience with radiant heated floors, fireplace, large entertaining bar, private half bath, and direct access to the pool and backyard retreat, allowing guests convenient access without tracking through the main living areas. Outdoor living is equally impressive with extensive stamped concrete entertaining areas, a heated in-ground pool with fiberoptic color-changing lights and decorative spray fountains, covered patio space, mature landscaping, a fully irrigated lawn and landscape system, and expansive green space offering both privacy and functionality. The luxurious primary suite serves as a private retreat featuring a spa-like atmosphere and oversized walk-in closet. Separate from the primary suite, the second level also features a private guest suite complete with its own balcony, walk-in closet, and living space, providing ideal accommodations for related living, extended family, guests, or multigenerational living arrangements. The fully finished lower level dramatically expands the home's versatility and entertainment potential with a massive recreation area, kitchenette and bar area, private enclosed office complete with custom built-in cabinetry and shelving, an additional office nook featuring two built-in workstations and custom shelving, an additional bedroom, full bath with steam shower, surround sound, radiant heated floors, and abundant storage throughout. Built with exceptional attention to quality and long-term functionality, the home also features radiant heated garage floors, whole-house generator, boiler system, three furnaces, 400-amp electrical service, Speed Queen laundry, whole-home reverse osmosis water filtration system, alarm system, well and septic systems, mudroom with custom built-ins, and extensive storage throughout. Properties offering this level of finished living space, multigenerational flexibility, resort-style outdoor living, and extensive custom upgrades seldom become available. This is a rare opportunity to own one of the area's most complete luxury estates, combining exceptional craftsmanship, functionality, and lifestyle in a truly remarkable setting.
Single-familyProperty Type
2007Year Built
1.4 acresLot Size
$233Price/Sq.Ft.
3 car garageParking
Listed by Jennifer Valentino• Better Homes & Gardens Real Estate
Listed by John Valentino• Better Homes & Gardens Real Estate
Truly ONE-OF-A-KIND! This BEAUTIFUL estate is located on 1.3 Acres. Cozy 4 Seasons Room w/ Fireplace, Full Finished Basement w/ 2nd kitchen, Central Vac & GRANITE throughout. Relax outdoors w/ your custom in-ground pool with LED lighting & TWO covered porches. Home has top of the line systems & whole house generator. Be ready to be IMPRESSED!
MRED as Distributed by MLS Grid #08433381
Sep 6, 2013
Listing Removed
—
Aug 30, 2013
Listed (Contingent)
—
MRED as Distributed by MLS Grid #08244753
Aug 24, 2013
Listing Removed
—
Aug 7, 2013
Price Changed (Price Change)
*
Mar 30, 2013
Price Changed (Price Change)
*
Feb 27, 2013
Price Changed (Price Change)
*
Jan 28, 2013
Price Changed (Price Change)
*
Jan 7, 2013
Listed (New)
*
MRED as Distributed by MLS Grid #08174973
Jan 1, 2013
Listing Removed
—
Oct 6, 2012
Listed (New)
*
MRED as Distributed by MLS Grid #08103949
Sep 28, 2012
Listing Removed
—
Aug 31, 2012
Price Changed (Price Change)
*
Aug 15, 2012
Price Changed (Price Change)
*
Jul 27, 2012
Price Changed (Price Change)
*
Jul 20, 2012
Price Changed (Price Change)
*
Jul 10, 2012
Price Changed (Price Change)
*
Jun 29, 2012
Listed (New)
*
MRED as Distributed by MLS Grid #07915199
Jun 29, 2012
Listing Removed
—
Jun 20, 2012
Price Changed (Price Change)
*
Apr 3, 2012
Price Changed (Price Change)
*
Feb 16, 2012
Price Changed (Reactivated)
*
Feb 16, 2012
Relisted (Reactivated)
—
Nov 23, 2011
Listing Removed
—
Sep 30, 2011
Listed (New)
*
Year
Property tax
Land + Additions
Assessment*
2024
$21,588 (+4.3%)
$38,150 + $209,500
$247,650
2023
$20,698 (+5.3%)
$35,300 + $196,400
$231,700
2022
$19,661 (−0.2%)
$28,150 + $189,550
$217,700
2021
$19,699 (+1.5%)
$28,150 + $189,550
$217,700
2020
$19,400 (+1.2%)
$28,150 + $185,850
$214,000
2019
$19,169 (+3.6%)
$26,400 + $185,850
$212,250
2018
$18,496 (−0.6%)
$26,400 + $177,350
$203,750
2017
$18,604 (−1.8%)
$26,400 + $177,350
$203,750
2015
$18,937 (+18.0%)
$26,400 + $177,350
$203,750
2013
$16,052 (+0.9%)
$25,400 + $156,250
$181,650
2012
$15,910 (+8.2%)
$31,750 + $161,100
$192,850
2011
$14,704 (+1.0%)
$38,250 + $162,750
$201,000
2010
$14,554 (+2.7%)
$42,500 + $167,800
$210,300
2008
$14,169 (+2.7%)
$42,500 + $169,500
$212,000
2007
$13,790
$42,500 + $169,500
$212,000
Public record
Public record
Zoning
Permits
Beds
—
Baths
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
1.39 Acres
Year renovated
—
Finished Sq. Ft.
5,065
Unfinished Sq. Ft.
—
Total Sq. Ft.
5,065
Year built
2007
Style
Other
County
Will County
APN
1412121030120000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 2, 2026.
R-1
Residential-Single-family District
R-1, R-2 and R-2A districts are primarily intended to accommodate detached houses on large lots in areas served by paved roads and where police, fire and emergency medical services are readily available. As with all residential districts, R-1, R-2 and R-2A districts also allow some other uses typically found within residential areas in Will County; Conservation design subdivisions are allowed and encouraged for new residential developments in R-1, R-2 and R-2A districts.
Permitted uses
Include but are not limited to:
Community / recreation center
Religious facility
Garden center
Housing-Group
Housing-Single unit
Educational/school
Fire house
Police station
Communications tower
Park & open space
Jul 10, 2015 • Final
Residential electrical upgrade
Electrical
Dec 10, 2007 • Final
In ground swimming pool
Pool and hot tub
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
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
3/10 Heat Factor
7 days above 103° expected this year, 15 days in 30 years
2/10 Wind Factor
0% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Manhattan, IL • 60442
Average low and high temperatures (°F)
30
14
39
21
56
33
64
42
72
49
82
62
86
67
82
62
81
56
70
46
51
35
37
22
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
Try the sun simulator tool to see how light moves across the property at different times of day and year.
Provided by Shadowmap
Redfin Estimate for 24104 S Old Farm Rd
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $760,000 and $1,175,000.
Nearby comparable homes
The Redfin Estimate uses 5 recent nearby sales, priced between $760K to $1.2M.