New Listing

Listing Tools

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.

Property Details of 24104 South Old Farm Road

Property Details

Interior Features

Utilities and Appliances

Community

Other Details

Map Location

Driving Directions

Listed by Jennifer Valentino of Better Homes & Garden Real Estate

Based on information submitted to MRED  as of June 25, 2026 . All data is obtained from various sources and has not been, and will not be, verified by broker or MRED.   All information should be independently reviewed and verified for accuracy.  Properties may or may not be listed by the office/agent presenting the information. NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from 4 Sale Realty Advantage, LLC. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.