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

IDX Support

sales rep | Brivity IDX

Agent profile image in message

5762 Schmidt Ln , Yorkville, IL 60560
$825,000
Est. Payment: $4,426.51/mo
6 Bed
6 Bath
5255 Sqft
0.85 Acres
Status: new | Days on site: 3
Get Pre-Qualified
28839 - 248539
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

Nestled within the prestigious Farm Colony neighborhood, this extraordinary custom home was built with no expense spared on high end details and exceptional craftsmanship. With 7 bedrooms and 6 bathrooms, solid wood doors and moldings, and beautifully appointed living spaces, this home offers luxury, versatility, and remarkable indoor and outdoor entertaining. The main level welcomes you with a private office with its own separate entrance, offering added convenience and flexibility for those considering a home business, a spacious bedroom with a full bathroom suited for multigenerational living, a formal dining room, butler's pantry, and a spectacular gourmet kitchen featuring a two way fireplace shared with the spacious family room. Upstairs, the expansive primary suite provides a private retreat with a generous sitting area and luxurious en suite bathroom featuring a jetted whirlpool tub. Additional spacious bedrooms offer walk in closets, while a separate entertainment/game room adds flexibility. The fully finished attic provides even more room for a hobby space, creative studio, playroom, or additional gathering area. The finished lower level is designed for entertaining and extended stays, complete with a full wet bar, additional family room, workout area, updated full bathroom, and bedroom, offering a convenient in law suite arrangement. Step outside into an extensively upgraded backyard retreat showcasing a stunning saltwater pool with a waterfall and durable automatic safety cover, beautiful landscaping, multiple seating areas, a fire pit, and a playset. An extra large Master Spas Legend Series hot tub comfortably seats eight or more, creating another inviting place to unwind. A separate garage provides convenient storage for pool equipment, lawn equipment, and outdoor essentials. Additional highlights include heated garage flooring, dual furnaces and air conditioning units, dual water heaters, a water softener, and a Multi Flo septic system. Recently installed Cat 8 Ethernet cabling throughout the home supports high speed wired connectivity for work, streaming, and entertainment. From its custom finishes to its exceptional outdoor amenities, this one of a kind property offers an extraordinary place to call home!

Highlights

Listed by Melissa Walsh , 630-272-7263 Coldwell Banker Real Estate Group , 630-445-8367. Midwest Real Estate Data mls logo

Property Type

Residential

Lot/Acreage
0.85

HOA Fee

440 Annually

Year Built

2004

County

Kendall

Area

Yorkville / Bristol

Neighborhood

Fields of Farm Colony

School District

115

Listing ID

12756631

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:6
  • ▪ Bathrooms:6
  • ▪ Full Bathrooms:5
  • ▪ 1/2 Bathrooms:1
Appliances:Double Oven, Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Water Softener, Humidifier, Water-Softener Owned,CO Detectors,Ceiling Fan(s),Sump Pump
Air Cond:Central Air,Zoned,Dual
Fireplaces:Double Sided,Wood Burning,Gas Log,Gas Starter
Basement:Finished,Exterior Entry,Full
Other:
  • ▪ Additional:Cathedral Ceiling(s), Wet Bar, 1st Floor Bedroom, In-Law Floorplan
Water:Well

Exterior Features

Lot:Irregular Lot,Landscaped
Lot Dimensions:91X256X150X336
Garage Capacity:4
Roof:Asphalt
Others:
  • ▪ Additional:Balcony, Hot Tub
Sewer:Septic Tank
Parking Features:Concrete,Garage Door Opener,Heated Garage,Yes,Garage Owned,Attached,Garage
Principal Interest
$4,427
Taxes
$1,692
HOA
$440

Home Price

$825,000

Loan Details

30 yrs
7.08%

Down Payment

20%
$165,000
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:
$4,426.51

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $4,426.51 $1,691.75 $440.00 $6,558.26
Yearly $53,118.17 $20,301.00 $5,280.00 $78,699.17
Total $1,593,544.98 $609,030.00 $158,400.00 $2,360,974.98
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 (Yorkville, 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-27T02:55:04.000Z

© 2026 Midwest Real Estate Data

MLS Logo - Midwest Real Estate Data