When Buying or Selling ...

Call Joe Frieders

815-693-4958

Serving Dekalb, LaSalle & Kendall County areas since 1989

Joe has been selling Real Estate at Swanson Real Estate since 1989 and also the Managing Broker at Swanson Realtor for the last several years. In all those years Joe has sold hundred of homes, building lots and land. Learn more

Search All Areas

Thank you for your interest ...

Please enter the area that you are interested in researching below including area, property type and price range.  If you need immediate attention call Joe Frieders at 815-693-4958

Save
Ask
Tour
Hide
Share
$1,749,000
80 Days On Site

24104 S Old Farm Road
Manhattan, IL 60442

For Sale|Single Family Residence|Active
4
Beds
6
Total Baths
4
Full Baths
2
Partial Baths
7,500
SqFt
$233
/SqFt
2007
Built
County:
Will
Listing Courtesy of MRED as distributed by MLS Grid of Better Homes & Gardens Real Estate
Call Now: 815-786-9418
Is this the listing for you? We can help make it yours.
815-786-9418
24104 S Old Farm Road24104 S Old Farm Road24104 S Old Farm Road24104 S Old Farm Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$7,980
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,749,000
Days On Site 
80 Days
Bedrooms 
4
Inside Area (SqFt) 
7,500 sqft
Total Baths 
6
Full Baths 
4
Partial Baths 
2
Lot Size 
1.4 Acres
Year Built 
2007
MLS® Number 
12686051
Status 
Active
Property Tax 
$21,588.16
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Plans
Friends & Family
Recent Activity
2 months agoListing updated with changes from the MLS®
2 months agoStatus changed to Active
3 months agoListing first seen on site
General Features
Acres 
1.4
Attached Garage 
Yes
Garage 
Yes
Garage Spaces 
3
Parking 
AttachedGarage
Parking Spaces 
3
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
SqFt Total 
7300
Water Source 
Shared Well
Interior Features
Basement 
FinishedFull
Cooling 
Central Air
Heating 
Natural Gas
Interior 
Walk-In Closet(s)Entrance FoyerOpen FloorplanGranite CountersPantry
Bedroom 2 
Dimensions - 12X17Level - Second
Bedroom 3 
Dimensions - 14X17Level - Second
Bedroom 4 
Dimensions - 16X16Level - Second
Bedroom 5 
Dimensions - 16X18Level - Basement
Breakfast Room 
Dimensions - 14X11Level - Main
Dining Room 
Dimensions - 14X15Level - Main
Family Room 
Dimensions - 17X20Level - Main
Foyer 
Dimensions - 14X15Level - Main
Heated Sun Room 
Dimensions - 17X20Level - Main
Kitchen 
Dimensions - 14X16Level - Main
Kitchen- 2nd 
Dimensions - 10X7Level - Basement
Laundry 
Dimensions - 7X10Level - Main
Living Room 
Dimensions - 14X21Level - Main
Master Bedroom 
Dimensions - 17X28Level - Main
Office 
Dimensions - 12X12Level - Basement
Recreation Room 
Dimensions - 30X26Level - Basement
Utility Room-Lower Level 
Dimensions - 14X10Level - Basement
Walk In Closet 
Dimensions - 11X9Level - Basement
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Brick
Lot Features 
Landscaped
Patio And Porch 
Patio
Pool Features 
In Ground
Community Features
MLS Area 
Manhattan/Wilton Center
School District 
210
Township 
Manhattan
Schools
School District
210
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing Courtesy of MRED as distributed by MLS Grid of Better Homes & Gardens Real Estate



Based on information submitted to the MLS GRID as of 2026-09-13 08:43 AM UTC. 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.
Last checked: 2026-09-13 08:43 AM UTC
MRED DMCA Copyright Information Copyright © 2026 Midwest Real Estate Data LLC. All rights reserved.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

 

 

Joe Frieders, Managing Broker 

Swanson Real Estate 

815-786-9418 Sandwich

815-693-4958 Direct

 

Areas Served: Dekalb, Lasalle, Kendall counties Illinois including Big Rock, Earlville, Hinckley, Leland,

Naperville, Newark, Oswego, Plano, Sandwich, Sheridan, Somonauk and Yorkville