Highest and best due by Monday 11-3 by 1pm. Beautiful ranch home opportunity in the Mill Creek Subdivision. This home is nestled on a tree-lined street of red maples. As you approach, a covered porch leads to a gorgeous leaded glass entry door with sidelights. Inside, an open floor plan features soaring ceilings, cherry hardwood floors, and white trim with multi-piece crown moldings and chair rail. The flexible layout includes a formal dining room off the entry and a formal living room that can also serve as a main-floor den. The vaulted great room with a stone fireplace offers views of the gourmet kitchen, which boasts maple cabinets, granite countertops, stainless appliances, a large island, a walk-in pantry closet, and a separate eating area. This space seamlessly opens into a sunroom, surrounded by two walls of windows, providing access to the Trex deck with Pergola (as is) with views of the beautifully landscaped yard with wrought iron fence and sprinkler system. The split bedroom layout offers privacy with the primary suite on one side of the home with a large walk-in closet, bay window, and a primary bath with a soaking tub, dual vanity, and a step-in spray shower. The two additional bedrooms are on the opposite side of the home with ample closets and access to a hall bath. The back service hall leads to the laundry room (washer/dryer included) with cherry cabinets and a utility sink, and access to the oversized three-car garage. Awaiting your touches is the deep pour full unfinished basement with bath rough in. Mill Creek, in beautiful Geneva, IL, offers walking trails, a small downtown area, a community pool, and a golf course. Enjoy easy access to Downtown Geneva with its fine dining, shopping, Metra train, and the Fox River Valley bike trails.
Contingent
$649,900
38W533 Berquist Dr, Geneva, IL 60134
3beds
2,363sqft
Est.:
Single Family Residence
Built in 2009
-- sqft lot
$-- Zestimate®
$275/sqft
$-- HOA
What's special
Soaring ceilingsHall bathLarge islandWrought iron fenceOpen floor planSplit bedroom layoutGourmet kitchen
- 41 days |
- 124 |
- 2 |
Likely to sell faster than
Zillow last checked: 8 hours ago
Listing updated: November 07, 2025 at 12:02am
Listing courtesy of:
Michelle Collingbourne 630-688-8207,
RE/MAX All Pro - St Charles
Source: MRED as distributed by MLS GRID,MLS#: 12501034
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Rooms
- Room types: Breakfast Room, Great Room, Office
Primary bedroom
- Features: Flooring (Carpet), Window Treatments (Blinds), Bathroom (Full)
- Level: Main
- Area: 289 Square Feet
- Dimensions: 17X17
Bedroom 2
- Features: Flooring (Carpet), Window Treatments (Blinds)
- Level: Main
- Area: 132 Square Feet
- Dimensions: 11X12
Bedroom 3
- Features: Flooring (Carpet), Window Treatments (Blinds)
- Level: Main
- Area: 132 Square Feet
- Dimensions: 11X12
Breakfast room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12X12
Dining room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 180 Square Feet
- Dimensions: 12X15
Great room
- Features: Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 480 Square Feet
- Dimensions: 20X24
Kitchen
- Features: Kitchen (Eating Area-Breakfast Bar, Eating Area-Table Space, Island, Pantry-Closet, Granite Counters), Flooring (Hardwood), Window Treatments (Blinds)
- Level: Main
- Area: 204 Square Feet
- Dimensions: 12X17
Laundry
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 48 Square Feet
- Dimensions: 6X8
Office
- Features: Flooring (Carpet), Window Treatments (Blinds)
- Level: Main
- Area: 169 Square Feet
- Dimensions: 13X13
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Double Oven, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Cooktop, Water Softener Owned, Humidifier
- Laundry: Main Level
Features
- Cathedral Ceiling(s), 1st Floor Bedroom, 1st Floor Full Bath
- Flooring: Hardwood
- Windows: Screens
- Basement: Unfinished,Bath/Stubbed,Full
- Attic: Full
- Number of fireplaces: 1
- Fireplace features: Gas Log, Gas Starter, Family Room
Interior area
- Total structure area: 2,363
- Total interior livable area: 2,363 sqft
Property
Parking
- Total spaces: 3
- Parking features: Asphalt, Garage Door Opener, Garage Owned, Attached, Garage
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: No Disability Access
Features
- Stories: 1
- Patio & porch: Deck
- Fencing: Fenced
Lot
- Dimensions: 85X107X90X132
- Features: Corner Lot, Landscaped
Details
- Additional structures: Pergola
- Parcel number: 1207178005
- Special conditions: Home Warranty
- Other equipment: Water-Softener Owned, TV-Cable, Ceiling Fan(s), Sump Pump, Sprinkler-Lawn, Radon Mitigation System
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Other
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2009
Details
- Builder model: Abbey IV
- Warranty included: Yes
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Shared Well
Community & HOA
Community
- Features: Clubhouse, Park, Tennis Court(s), Sidewalks, Street Paved
- Security: Carbon Monoxide Detector(s)
- Subdivision: Mill Creek
HOA
- Services included: None
Location
- Region: Geneva
Financial & listing details
- Price per square foot: $275/sqft
- Tax assessed value: $522,192
- Annual tax amount: $12,794
- Date on market: 10/30/2025
- Ownership: Fee Simple
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 11/5/2025 | Contingent | $649,900$275/sqft |
Source:  MRED as distributed by MLS GRID #12501034 Report a problem | ||
| 10/30/2025 | Listed for sale | $649,900+45.7%$275/sqft |
Source: MRED as distributed by MLS GRID #12501034 Report a problem | ||
| 11/17/2014 | Sold | $446,000-0.7%$189/sqft |
Source: MRED as distributed by MLS GRID #08733972 Report a problem | ||
| 9/29/2014 | Pending sale | $449,000$190/sqft |
Source: Hemming & Sylvester Properties #08733972 Report a problem | ||
| 9/22/2014 | Listed for sale | $449,000-12.6%$190/sqft |
Source: Hemming & Sylvester Properties #08733972 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $12,795 +3.3% | $174,064 +10% |
| 2023 | $12,383 +2.7% | $158,240 +7.6% |
| 2022 | $12,063 +2.9% | $147,036 +3.9% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$4,533/mo
Principal & interest
$3163
Property taxes
$1143
Home insurance
$227
Climate risks
Neighborhood: 60134
Nearby schools
GreatSchools rating
- 5/10Heartland Elementary SchoolGrades: K-5Distance: 1.1 mi
- 10/10Geneva Middle School NorthGrades: 6-8Distance: 1 mi
- 9/10Geneva Community High SchoolGrades: 9-12Distance: 2.9 mi
Schools provided by the listing agent
- Elementary: Heartland Elementary School
- Middle: Geneva Middle School
- High: Geneva Community High School
- District: 304
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.
- Loading
