Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

24104 S Old Farm Rd , Manhattan, IL 60442
$1,749,000
Est. Payment: $9,545.01/mo
4 Bed
6 Bath
7500 Sqft
1.4 Acres
Status: active | Days on site: 9
Get Pre-Qualified
28286 - 236193,235420
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

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.

Highlights

Listed by Jennifer Valentino , 708-295-6619 and John Valentino , (708) 305-1922 Better Homes & Gardens Real Estate , 708-859-0909. Midwest Real Estate Data mls logo

Property Type

Residential

Lot/Acreage
1.4

Year Built

2007

County

Will

Area

Manhattan/Wilton Center

School District

114

Listing ID

12686051

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:6
  • ▪ Full Bathrooms:4
  • ▪ 1/2 Bathrooms:2
Air Cond:Central Air
Fireplaces:
Basement:Finished,Full
Other:
  • ▪ Additional:Open Floorplan, Special Millwork, Granite Counters, Separate Dining Room, Pantry
Water:Shared Well

Exterior Features

Lot:Landscaped
Lot Dimensions:208 X 298
Garage Capacity:3
Sewer:Septic Tank
Parking Features:Yes,Garage Owned,Attached,Garage
Principal Interest
$9,545
Taxes
$1,799

Home Price

$1,749,000

Loan Details

30 yrs
7.25%

Down Payment

20%
$349,800
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$9,545.01

Principal

Taxes

Principal Taxes HOA Total
Monthly $9,545.01 $1,799.01 $0.00 $11,344.02
Yearly $114,540.13 $21,588.16 $0.00 $136,128.29
Total $3,436,203.78 $647,644.80 $0.00 $4,083,848.58
Lender profile image
Master Chief
Lender
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 2026
Market insight data is pulled from the same city as the listing being viewed (Manhattan, IL).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Based on information submitted to the MRED as of the date listed below. All data is obtained from various sources and has not been, and will not be, verified by broker or MRED. MRED 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. IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MTP or MRED. The use of the MRED Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time.

Based on information submitted to the MLS GRID as of the date listed below. 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. IDX information is provided exclusively for consumers' personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability. Some listings have been excluded from this website.

IDX service by Blueroof 360

Data last updated: 2026-10-27T13:00:05.000Z

© 2026 Midwest Real Estate Data

MLS Logo - Midwest Real Estate Data