38W424 Berquist Drive
Geneva, IL 60134

Listing courtesy of Baird & Warner Fox Valley - Geneva

$723,000 (New)

Beds: 5
Baths: 5
Sq. Ft.: 3,638
Type: House
Listing #12350082
Welcome to this beautifully maintained Franklin model with 5-bedroom, 5-bathroom home located in the highly desirable Mill Creek community in Geneva, Illinois. Mill Creek is renowned for its scenic natural beauty, extensive trail system, two 18-hole golf courses, charming town center, and close proximity to outstanding amenities. This spacious property features an open-concept floor plan with a large family room and cozy fireplace, perfect for everyday living and entertaining. The chef's kitchen seamlessly connects to the main living areas, and a bright, airy conservatory-style sunroom provides panoramic views of the private, fenced-in, park-like backyard. The finished basement expands the living space, offering a flexible area for recreation, work, or fitness - and a posssible home theater setup with projector that will stay with the home, providing a true move-in-ready entertainment experience. A 3-car attached garage and beautifully landscaped grounds complete this impressive offering. Experience a harmonious blend of comfort, style, and convenience - all just moments from parks, trails, golf courses, and Geneva's vibrant local attractions. Discover the exceptional lifestyle waiting for you in Mill Creek, Geneva!
Property Features
Location Information
County: Kane
MLS Area: Geneva
Subdivision: Mill Creek
Township: Geneva
Interior Features
Total Rooms: 14
Bedrooms Above Grade: 4
Bedrooms Below Grade: 1
Additional Rooms: Eating Area, Loft, Recreation Room, Study, Bedroom 5, Exercise Room
Interior Features: Cathedral Ceiling(s), 1st Floor Bedroom, In-Law Floorplan, 1st Floor Full Bath, Built-in Features
Master Bedroom Size: 23X20
Master Bathroom Description: Full
Full Baths: 5
Bath Amenities: Whirlpool, Separate Shower, Double Sink
Has Dining Room: Yes
Dining Room Description: Separate
Dining Room Size: 13X11
Family Room Size: 19X17
Living Room Size: 14X12
Kitchen Size: 14X13
Has Fireplace: Yes
Number of Fireplaces: 1
Fireplace Features: Wood Burning
Heating: Natural Gas
Cooling: Central Air
Floors: Hardwood, Laminate
Laundry: Main Level, Sink
Additional Equipment: CO Detectors, Ceiling Fan(s), Sump Pump, Sprinkler-Lawn, Backup Sump Pump;, Water Heater-Gas
Appliances: Double Oven, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Humidifier
Basement Description: Finished, Full
Has Basement: Yes
Sizes of Other Bedrooms: 12X12, 12X11, 12X12
Exterior Features
Style: Traditional
Style: Traditional
Stories: 2 Stories
Construction: Brick, Cedar
Model: FRANKLIN
Foundation: Concrete Perimeter
Roof: Asphalt
Septic or Sewer: Public Sewer
Parking Features: Asphalt, Garage Door Opener, On Site, Garage Owned, Attached, Garage
Has Garage: Yes
Garage Spaces: 3
Parking Spaces: 3
Lot Size: .25-.49 Acre
Lot Size in Acres: 0.44
Dimensions: 124X154X125X154
School
High School District: GENEVA COMM UNIT SCH DIST 304
Elementary School: Heartland Elementary School
Middle School: Geneva Middle School
High School: Geneva Community High School
Additional Information
Possession: Closing
Property Type: SFR
Property SubType: Residential, 2 Stories
Property SubType 2: Detached Single
Attached/Detached SubType: 2 Stories
Year Built: 2006
Age: 16-20 Years
Parcel Number: 1207251005
Status: Active
Association Fee Frequency: Not Applicable
Association Fee Includes : None
General Information: School Bus Service, Commuter Train
Tax Year: 2024
Tax Amount: $15,976.6
Built Before 1978: No
General Information: School Bus Service, Commuter Train
Double Wide: No
Community Features: Park, Tennis Court(s), Sidewalks, Street Paved
Square Feet Source: Assessor


$ per month
Year Fixed. % Interest Rate.
Principal + Interest: $
Monthly Tax: $
Monthly Insurance: $
Term
yrs
Interest Rate
 % 
Down Payment
$
List Price:
$
Based on a fully amortized fixed rate loan. Ask your agent for the tax rates in your area. Insurance estimate is based on an average cost, your final premium cost will be determined by the type of coverage you select. This program only provides an estimate.
Logo
© 2025 Midwest Real Estate Data LLC. All rights reserved.
© 2025 MRED LLC. All rights reserved.
Based on information submitted to the MLS GRID as of MRED LLC 2025. All data is obtained from various sources and may not have been verified by the 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.

MLS logo
MRED DMCA Notice
NOTICE: Many homes contain recording devices, and buyers should be aware they may be recorded during a showing.
MRED LLC data last updated at May 31, 2025, 6:50 PM CT

Question About This Property?

  • This field is for validation purposes and should be left unchanged.