When Buying or Selling ...

Call Joe Frieders

815-693-4958

Serving Dekalb, LaSalle & Kendall County areas since 1989

Joe has been selling Real Estate at Swanson Real Estate since 1989 and also the Managing Broker at Swanson Realtor for the last several years. In all those years Joe has sold hundred of homes, building lots and land. Learn more

Search All Areas

Thank you for your interest ...

Please enter the area that you are interested in researching below including area, property type and price range.  If you need immediate attention call Joe Frieders at 815-693-4958

Save
Ask
Tour
Hide
Share
$649,900
7 Days On Site

38W533 BERQUIST Drive
Geneva, IL 60134

For Sale|Single Family Residence|Active Under Contract
3
Beds
2
Total Baths
2
Full Baths
2,363
SqFt
$275
/SqFt
2009
Built
Subdivision:
Mill Creek
County:
Kane
Listing Courtesy of MRED as distributed by MLS Grid of RE/MAX All Pro - St Charles
Call Now: 815-786-9418
Is this the listing for you? We can help make it yours.
815-786-9418
38W533 BERQUIST Drive38W533 BERQUIST Drive38W533 BERQUIST Drive38W533 BERQUIST Drive
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$2,965
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$649,900
Days On Site 
7 Days
Bedrooms 
3
Inside Area (SqFt) 
2,363 sqft
Total Baths 
2
Full Baths 
2
Partial Baths 
N/A
Lot Size 
N/A
Year Built 
2009
MLS® Number 
12501034
Status 
Active Under Contract
Property Tax 
$12,794.66
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Assessor
Friends & Family
Recent Activity
yesterdayListing updated with changes from the MLS®
yesterdayStatus changed to Active Under Contract
a week agoListing first seen on site
General Features
Attached Garage 
Yes
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
3
Parking 
AsphaltGarage Door OpenerAttachedGarage
Parking Spaces 
3
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
SqFt Total 
2363
Style 
Ranch
Utilities 
Cable Available
Water Source 
Shared Well
Interior Features
Appliances 
Water SoftenerDouble OvenMicrowaveDishwasherRefrigeratorWasherDryerDisposalStainless Steel Appliance(s)CooktopWater Softener OwnedHumidifier
Basement 
Sump PumpUnfinishedBath/StubbedFull
Cooling 
Ceiling Fan(s)Central Air
Electric 
Circuit Breakers
Fireplace 
Yes
Fireplace Features 
Family RoomGas LogGas Starter
Fireplaces 
1
Flooring 
Hardwood
Heating 
Natural GasForced Air
Interior 
Cathedral Ceiling(s)
Laundry Features 
Main Level
Window Features 
Screens
Bedroom 2 
Dimensions - 11X12Level - Main
Bedroom 3 
Dimensions - 11X12Level - Main
Bedroom 4 
Breakfast Room 
Dimensions - 12X12Level - Main
Dining Room 
Dimensions - 12X15Level - Main
Family Room 
Great Room 
Dimensions - 20X24Level - Main
Kitchen 
Dimensions - 12X17Level - MainDescription - Eating Area-Breakfast Bar,Eating Area-Table Space,Island,Pantry-Closet,Granite Counters
Laundry 
Dimensions - 6X8Level - Main
Living Room 
Master Bedroom 
Dimensions - 17X17Level - Main
Office 
Dimensions - 13X13Level - Main
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
BrickOther
Fencing 
Fenced
Lot Features 
Corner LotLandscaped
Other Structures 
Pergola
Patio And Porch 
Deck
Roof 
Asphalt
Windows/Doors 
Screens
Community Features
Community Features 
ClubhouseParkTennis Court(s)Sidewalks
MLS Area 
Geneva
School District 
Geneva Community High School
Township 
Geneva
Schools
School District
Geneva Community High School
Elementary School
Heartland Elementary School
Middle School
Geneva Middle School
High School
Geneva Community High School
Listing Courtesy of MRED as distributed by MLS Grid of RE/MAX All Pro - St Charles



Based on information submitted to the MLS GRID as of 2025-11-06 05:23 PM UTC. 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.
Last checked: 2025-11-06 05:23 PM UTC
MRED DMCA Copyright Information Copyright © 2025 Midwest Real Estate Data LLC. All rights reserved.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

 

Joe Frieders, Managing Broker 

Swanson Real Estate 

815-786-9418 Sandwich

630-553-3333 Yorkville

815-693-4958 Direct

Areas Served: Dekalb, Lasalle, Kendall counties Illinois including Big Rock, Earlville, Hinckley, Leland,

Naperville, Newark, Oswego, Plano, Sandwich, Sheridan, Somonauk and Yorkville