One-of-a-Kind Sprawling Modern Luxury Ranch in St. Charles! Floor to Ceiling Glass and tall ceilings bring the light in! Discover the pinnacle of modern design and single-level living in this extraordinary custom ranch estate, offering nearly 4,500 sq ft of refined space on almost 2 acres with peaceful views of the Fox River. Designed with both elegance and function in mind, this home is ideal for multi-generational living, blended households, or anyone who values the freedom of flexible, separate living zones within a unified, luxury environment. From the grand foyer, two private wings branch off to create intentional separation while maintaining a warm, connected atmosphere. The south wing features a dramatic great room with soaring ceilings, a floor-to-ceiling fireplace, and expansive glass that floods the space with natural light. The showstopping chef's kitchen offers custom cabinetry, premium Thermador appliances, and generous counterspace, opening to a sunlit breakfast room and adjacent flex space-perfect as an office, art studio, or pantry. The primary suite includes a spa bath with soaking tub and walk-in shower. A den with attached full bath could convert to a 4th bedroom, and the powder room and laundry center complete this wing. The north wing is ideal for loved ones needing extra space and privacy-it includes a spacious family room with second fireplace, music area, and a full secondary kitchen. A second full primary suite features a walk-in closet and teak walk-in shower, plus another ensuite bedroom rounds out the wing. The home also offers a 3.5+ car extra-deep garage with ample storage and a small basement housing a 15x15 mechanical room. Ideally located just minutes from Downtown St Charles and near Randall Rd, Rt 31 & Rt 64 for easy access to shopping, dining, parks, trails & more. Just 6 years old-this home offers a like-new feel with plenty of room to add a pool and create your dream outdoor oasis!
Closed
$1,410,000
4N575 Old Quarry Rd, St Charles, IL 60174
3beds
4,480sqft
Single Family Residence
Built in 2018
1.72 Acres Lot
$1,338,000 Zestimate®
$315/sqft
$6,787 Estimated rent
Home value
$1,338,000
$1.27M - $1.40M
$6,787/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: July 18, 2025 at 01:37am
Listing courtesy of:
Tamara O'Connor, CRS,GRI 630-485-4214,
Premier Living Properties
Bought with:
Lana Erickson, AHWD,LHC
eXp Realty - Geneva
Shabana Karim
eXp Realty
Source: MRED as distributed by MLS GRID,MLS#: 12371967
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Features: Flooring (Hardwood), Bathroom (Full)
- Level: Main
- Area: 225 Square Feet
- Dimensions: 15X15
Bedroom 2
- Features: Flooring (Hardwood)
- Level: Main
- Area: 210 Square Feet
- Dimensions: 15X14
Bedroom 3
- Features: Flooring (Hardwood)
- Level: Main
- Area: 210 Square Feet
- Dimensions: 15X14
Breakfast room
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 100 Square Feet
- Dimensions: 10X10
Den
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 120 Square Feet
- Dimensions: 12X10
Dining room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 234 Square Feet
- Dimensions: 18X13
Family room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 360 Square Feet
- Dimensions: 20X18
Foyer
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 180 Square Feet
- Dimensions: 15X12
Kitchen
- Features: Kitchen (Eating Area-Breakfast Bar, Eating Area-Table Space), Flooring (Hardwood)
- Level: Main
- Area: 225 Square Feet
- Dimensions: 15X15
Kitchen 2nd
- Features: Flooring (Hardwood)
- Level: Main
- Area: 78 Square Feet
- Dimensions: 13X6
Laundry
- Level: Main
- Area: 64 Square Feet
- Dimensions: 8X8
Living room
- Features: Flooring (Hardwood)
- Level: Main
- Area: 270 Square Feet
- Dimensions: 18X15
Office
- Features: Flooring (Hardwood)
- Level: Main
- Area: 195 Square Feet
- Dimensions: 15X13
Heating
- Natural Gas, Forced Air, Steam, Radiant, Sep Heating Systems - 2+, Indv Controls, Zoned, Radiant Floor
Cooling
- Central Air
Appliances
- Laundry: Main Level
Features
- 1st Floor Bedroom, In-Law Floorplan, 1st Floor Full Bath, Built-in Features, Walk-In Closet(s), High Ceilings, Open Floorplan
- Flooring: Hardwood
- Basement: Unfinished,Storage Space,Partial
- Number of fireplaces: 2
- Fireplace features: Gas Starter, Family Room, Living Room
Interior area
- Total structure area: 4,960
- Total interior livable area: 4,480 sqft
Property
Parking
- Total spaces: 3.5
- Parking features: Asphalt, Circular Driveway, Garage Door Opener, On Site, Garage Owned, Attached, Garage
- Attached garage spaces: 3.5
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: No Disability Access
Features
- Stories: 1
- Patio & porch: Patio
Lot
- Size: 1.72 Acres
- Dimensions: 239X301X289X293
- Features: Corner Lot, Landscaped
Details
- Parcel number: 0921277001
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Stucco
- Foundation: Concrete Perimeter
- Roof: Rubber
Condition
- New construction: No
- Year built: 2018
Details
- Builder model: CUSTOM MODERN
Utilities & green energy
- Electric: Circuit Breakers, 200+ Amp Service
- Sewer: Septic Tank
- Water: Well
Community & neighborhood
Location
- Region: St Charles
HOA & financial
HOA
- Services included: None
Other
Other facts
- Listing terms: Cash
- Ownership: Fee Simple
Price history
| Date | Event | Price |
|---|---|---|
| 7/11/2025 | Sold | $1,410,000+0.7%$315/sqft |
Source:  MRED as distributed by MLS GRID #12371967 | ||
| 7/2/2025 | Pending sale | $1,399,900$312/sqft |
Source: MRED as distributed by MLS GRID #12371967 | ||
| 6/16/2025 | Contingent | $1,399,900$312/sqft |
Source: MRED as distributed by MLS GRID #12371967 | ||
| 5/29/2025 | Listed for sale | $1,399,900+543.6%$312/sqft |
Source: MRED as distributed by MLS GRID #12371967 | ||
| 9/7/2016 | Sold | $217,500-13%$49/sqft |
Source: Public Record | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $21,550 +5% | $320,400 +11.7% |
| 2023 | $20,521 +5.3% | $286,762 +7.9% |
| 2022 | $19,480 +6.1% | $265,670 +4.9% |
Find assessor info on the county website
Neighborhood: 60174
Nearby schools
GreatSchools rating
- 9/10Wild Rose Elementary SchoolGrades: K-5Distance: 1 mi
- 9/10Thompson Middle SchoolGrades: 6-8Distance: 1.6 mi
- 8/10St Charles North High SchoolGrades: 9-12Distance: 0.9 mi
Schools provided by the listing agent
- Elementary: Wild Rose Elementary School
- Middle: Thompson Middle School
- High: St Charles North High School
- District: 303
Source: MRED as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$1,338,000
2% more+ $26,760
With Zillow Showcase(estimated)
$1,364,760