38W413 Berquist Dr, Geneva, IL 60134
OFF MARKET

38W413 Berquist Dr
Geneva, IL 60134

  • 4 Beds
  • 3.5 Baths
  • 3,391 sqft

$671,000

Trulia Estimate
as of Jul 25, 2026
Est. Refi. Payment $4,730/mo*
Refinance Your Home

$671,000

Trulia Estimate
as of Jul 25, 2026
Est. Refi. Payment $4,730/mo*
Refinance Your Home
4 Beds
3.5 Baths
3,391 sqft

Local Information

  • Map ViewExplore the area around 38W413 Berquist Dr.
  • Schools1 Elementary School2 Middle Schools1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
2006
Living Area
3,391 sqft
Price/Sqft
$198
Parking
3 Car Garage
HOA
None

About this House

EXTRAORDINARY OPPORTUNITY to own a home in the highly sought out Mill Creek subdivision of Geneva. A rarely available Trenton III house features an architectural roof, new sidings, new HVAC, new water heater, and a new attic insulation. Enter the foyer that leads to the den, living room, and mud room. The spacious living room with tall ceilings and windows lead to a formal dinning room with a beautiful backyard view. Enter the gourmet kitchen with 42" cherry cabinets, island, new stainless steel appliances plus a full closet size pantry. The breakfast area with a sliding door to the backyard which is truly a tranquil oasis featuring a custom brink paved patio, fire pit, and fenced yard. A family room with a gas fireplace and big windows is a perfect spot for entertaining your guest or for relaxing & getting cozy by the fireplace. Set up a desk or entertainment media in the Den for a peaceful and quiet time to either work from home, read a bit, or for game nights with family and friends. The wood railings on the staircase from the front door and the living room leads to the second floor. The second floor features a master bedroom, three additional bedrooms, and three full bathrooms. An extensive master bedroom with two walk-in closets and a bright large bathroom with a bathtub, his & her vanities, and a standing shower is a place to retreat. The Second bedroom has a private full bathroom and large closet. The third and fourth bedroom has a big closet plus a jack & Jill bath. The partially finished basement with a tall ceiling can be converted into a dream basement as it has a rough-in for a future bathroom and an open place for a gym, recreation room, home theater, extra storage, etc. The large driveway fits four cars and the car garage has enough space for three cars and extra storage. The garage can be accessed from smartphones, keypads, or transmitters. The Mill Creek Community Park offers golf courses, tennis courts, hiking trails, baseball fields, and play grounds for kids. The house is minutes away from schools, dinning, shopping, and a Metra station to get to places!
38W413 Berquist Dr, Geneva, IL 60134 is a 4 bedroom, 4 bathroom, 3,391 sqft single-family home built in 2006. It last sold for $565,500 on Aug 9, 2023 (3% below the $580,000 asking price). It is currently off market. The Trulia Estimate is $671,000, with a rent estimate of $5,355/month.

Home Details for 38W413 Berquist Dr

Active Status

MLS Status: Closed

Interior Features

Interior Details
Basement: Partially Finished,FullNumber of Rooms: 10Types of Rooms: Master Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Breakfast Room, Den, Dining Room, Family Room, Kitchen, Laundry, Living Room, Mud Room
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 3Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 3391 Square Feet
Appliances & Utilities
Appliances: Range, Microwave, Dishwasher, Refrigerator, Disposal, Humidifier, Gas Water HeaterDishwasherDisposalMicrowaveRefrigerator
Heating & Cooling
Heating: Natural Gas,Forced AirHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Natural Gas
Fireplace & Spa
Number of Fireplaces: 1Fireplace: Gas Log, Gas Starter, Family RoomHas a FireplaceNo Spa
Gas & Electric
Electric: Circuit Breakers
Levels, Entrance, & Accessibility
Stories: 2Accessibility: No Disability Access
View
No View
Security
Security: Carbon Monoxide Detector(s)

Exterior Features

Exterior Home Features
Roof: AsphaltPatio / Porch: Patio, PorchFencing: FencedExterior: Fire PitFoundation: Concrete Perimeter
Parking & Garage
Number of Garage Spaces: 3Number of Covered Spaces: 3Has a GarageHas an Attached GarageHas Open ParkingParking Spaces: 3Parking: Asphalt,Garage Door Opener,On Site,Garage Owned,Attached,Garage
Frontage
Not on Waterfront
Water & Sewer
Sewer: Public Sewer

Property Information

Year Built
Year Built: 2006
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Traditional
Building
Construction Materials: Vinyl Siding, BrickNot a New ConstructionNo Additional Parcels
Property Information
Parcel Number: 1207252008Model Home Type: TRENTON 3

Price & Status

Price
List Price: $580,000
Status Change & Dates
Off Market Date: Sat Jul 08 2023Possession Timing: Close Of Escrow

Location

Direction & Address
City: GenevaCommunity: Mill Creek Oakmont
School Information
Elementary School: Heartland Elementary SchoolElementary School District: 304Jr High / Middle School: Geneva Middle SchoolJr High / Middle School District: 304High School: Geneva Community High SchoolHigh School District: 304

Building

Building Details
Builder Model: TRENTON 3

Community

Community Features: Park, Curbs, Sidewalks, Street Lights, Street Paved

HOA

HOA Fee Includes: None

Lot Information

Lot Area: 10560 sqft

Listing Info

Special Conditions: None

Offer

Listing Terms: VA

Business

Business Information
Ownership: Fee Simple

Miscellaneous

BasementMls Number: 11820442

Additional Information

ParkCurbsSidewalksStreet LightsStreet PavedSource Internet Entire Listing DisplayMRD REMARKSINTERNET: YesSource Internet Address Display
Last check for updates: about 8 hours ago
Listed by Nir Patel, (847) 495-5000
HomeSmart Connect
Bought with: Christopher Doyle, (708) 533-7908, RLTR MBA, Inc.
Source: MRED as distributed by MLS GRID, MLS#11820442

Price History for 38W413 Berquist Dr

DatePriceEventSource
08/09/2023$565,500Sold
MRED as distributed by MLS GRID #11820442
07/09/2023$580,000ContingentMRED as distributed by MLS GRID #11820442
06/30/2023$580,000Listed For SaleMRED as distributed by MLS GRID #11820442
06/17/2016$400,000Sold
N/A
04/30/2015$450,000PriceChange
Agent Provided
03/05/2015$459,000Listed For SaleAgent Provided
09/17/2010$418,000Sold
MRED as distributed by MLS GRID #07558712
08/07/2010$459,900PendingAgent Provided
06/20/2010$484,900Listed For SaleAgent Provided
09/13/2006$497,000Sold
N/A

Market trends in Geneva

Last updated June 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$587K
$73.67KMoM
Sale-to-List Price
101.2%
1.8%MoM
Price per sq ft
$255
$10MoM
Available listings
82
9MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2024
Tax$13,403
Assessment$549,204
Home facts updated by county records

Comparable Sales for 38W413 Berquist Dr

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0N621 Keenan Dr, Geneva, IL
0.07
Single-Family Home
$700,000
05/29/26
4
3.5
2,996
38W542 McQuire Pl, Geneva, IL
0.14
Single-Family Home
$665,000
08/18/25
4
3.5
2,567
0N622 Sounders Dr, Geneva, IL
0.10
Single-Family Home
$650,000
05/28/26
5
4.5
2,850
38W631 Callighan Pl, Geneva, IL
0.24
Single-Family Home
$660,000
05/01/26
4
3.5
3,250
38W424 Berquist Dr, Geneva, IL
0.04
Single-Family Home
$680,000
08/26/25
5
5
3,638
635 Samantha Cir, Geneva, IL
0.53
Single-Family Home
$559,000
06/08/26
4
2.5
2,465
948 Bluestem Dr, Geneva, IL
0.46
Single-Family Home
$740,000
04/20/26
5
3
3,048
814 Sunflower Dr, Geneva, IL
0.51
Single-Family Home
$830,000
08/25/25
5
5
3,422
3459 Wild Prairie Ln, Geneva, IL
0.55
Single-Family Home
$755,000
10/16/25
5
3.5
4,386

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 38W413 Berquist Dr.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Geneva

At least 172 Trulia users voted on each feature.

  • 97 % Say it's dog friendly

  • 91 % Say parking is easy

  • 91 % Say yards are well-kept

  • 89 % Say people would walk alone at night

  • 88 % Say car is needed

  • 86 % Say there are sidewalks

  • 86 % Say there's holiday spirit

  • 81 % Say it's quiet

  • 79 % Say kids play outside

  • 76 % Say streets are well-lit

  • 74 % Say there's wildlife

  • 69 % Say they plan to stay for at least 5 years

  • 64 % Say neighbors are friendly

  • 62 % Say there are community events

  • 60 % Say it's walkable to restaurants

  • 43 % Say it's walkable to grocery stores

Sourced by Trulia users. Learn more about our methodology.
  • Cheyenne Ianno
    "Close to everything you need! Plus there’s a lot of different ways to get to neighboring towns quickly with ease."
    0
    Flag
  • CYI
    "It’s safe for your kids to ride their bikes and play outside, there’s tons of history and interesting things to explore, and the schools are great. "
    0
    Flag
  • Everett
    "Very friend environment. Very safe. Nothing sketchy about the area. Very nice local places for ice cream, sitting down, and quick bites to eat"
    0
    Flag
  • Mlamanna731
    "Community events are going on usually about twice a month, usually downtown and sometimes in other neighborhoods "
    0
    Flag
  • Trudypeterson
    "Geneva Schools are 10/10!!! Really enjoy living here ... great place to raise a family... unfortunately it is in Illinois. SO MANY people looking to leave the state! "
    1
    Flag
  • Nbieganowski
    "There are nice sidewalks for dog walking. People are very dog friendly. Be careful of coyote at night in wooded areas."
    0
    Flag
  • Darjcar
    "Neighbors watch each other and care a lot. Very friendly and safe. Lots of kids having fun. Close to the hospital, shopping and train station. Lots of great restaurants in Geneva, walk the town and here great live music. Best town around! "
    0
    Flag
  • Elizabeth S.
    "Friendly neighbors, close shopping and dining, great historical downtown. Plenty of good schools and sports. "
    1
    Flag
  • Elizabeth S.
    "Many people have them and most are really well behaved. Most people with dogs are really friendly and nearly everyone picks up after bathroom stops. "
    1
    Flag
  • Cathy R.
    "I’m walking distance to restaurants on 3rd street, bike path, train station and river. Farmers Market is in my backyard. "
    1
    Flag
  • Trudypeterson
    "Geneva is a wonderful place to raise a family. The schools are great… It’s a beautiful town with lots of parks and shopping and places to eat. It is close to Chicago and the countryside ❤️"
    1
    Flag
  • Swimmom300
    "We have two grocery stores within three minutes of the house, we live right by the Geneva Commens, and to get downtown Geneva if you want probably 10 minutes if you ride your bicycle five minutes."
    1
    Flag
  • Melrose518
    "This is a very friendly neighborhood. Homes in general are kept up well.. There is a definite sense of community in our particular subdivision. Neighbors are always helping one another""
    0
    Flag
  • Paulcruby
    "I am.retired and do not have a commute. The Metra train is a convenient way to get into Chicago. Buses are also convenient for getting around locally. Geneva is also close to major highways that go into the city. Overall Geneva is in a good location with several options for commuting."
    1
    Flag
  • Dmdrab
    "Not so conjested like other areas of DuPage County, yet still feels connected as part of the Chicago western suburbs. No problem finding good schools, great doctors/specialists, and most people Seem Genuinely friendly."
    0
    Flag
  • Shauna B.
    "It’s always been very kid and family friendly! The Pepper Valley Pool and playground are an added perk to becoming a part of our community. "
    0
    Flag
  • Abbey L.
    "Block parties, down town Geneva seasonal events and other really awesome things through the park district "
    0
    Flag
  • Genevagirl
    "Easy and convenient. Clean character station, always get a seat! Locally, everything is 5 to 10 minutes away"
    0
    Flag
  • Elizstahl
    "Easy to get around. I only work about 15 minutes away, so the commute is easy. But we have the train station here in Geneva, so you can get downtown easily. "
    0
    Flag
  • Geneva Fan
    "Geneva is a delightful, pretty, very special place. Safe and friendly, it beautifully combines small town convenience with easy access to big city amenities when you wish. It is a privilege to live here."
    0
    Flag
  • mjwryaya
    "I believe everything about geneva is terrible. so even the commute is terrible. hate it here. commute is always long and people don’t know how to drive. "
    0
    Flag
  • Kmo7559
    "Safe area to live for children of all ages. Plenty of parks Always plenty of people outside No problem with asking next door for help. "
    0
    Flag
  • Drkim
    "Paths all around neighborhood always being used. Tons of people out walking their dogs. Geneva Commons has a lot of dog friendly stores"
    1
    Flag
  • Drkim
    "Tons of kids in my neighborhood of Fisher Farms. Beautiful trails. Schools are great. Tons of great restaurants. Lots of shopping available. Fox River is beautiful. We go kayaking on it. Very clean. Wonderful festivals. "
    0
    Flag
  • Janna B.
    "Christmas Walk, Holiday house tour, Wine Fest, live music, great food and shopping, farmers market, train to city"
    0
    Flag
  • Ejournell
    "It is near an Elementary school that kids can walk to and people walk and jog and walk their dogs regularly here. It also is a mature neighborhood with nice big trees. "
    0
    Flag
  • Carriep1211
    "Great Community to raise a Family ! Beautiful Parks, Great Schools and especially love The downtown area! "
    0
    Flag
  • Marsha Engle
    "Walk to Island Park for movies in the summer. Fast walk to train, forest preserve, festivals, shops. Everyone is very friendly. In fact, all of Geneva is lovely."
    0
    Flag
  • MattH
    "One of the nicest suburbs to live in. Good schools and churches. Clean yards, nice people, and Geneva has great festivals."
    0
    Flag
  • Nicbernas
    "Christmas Walk Home Tours Swedish Days Festival of the Vine A Bunch of Park District Events North Mill Creek neighborhood events "
    0
    Flag
  • Danielle S.
    "I've grown up here and I love it. Everybody is so nice and you can always feel safe. People walk dogs and exercise early in the morning, and during the summer there are plenty of pools around fo you to take your kids to. It's a great place to raise your kids, take it from one, it's great here."
    0
    Flag
  • Geo
    "Lots of parks are close. As well as many dog parks in the surrounding cities. Everyone enjoys meeting friendly dogs on 3rd street. Just be conscientious and pick up after your pup!"
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

6 pet-friendly rentals in Geneva, IL

Explore by feature - Garage

8 rentals with a garage in Geneva, IL

Explore by feature - Air Conditioning

11 rentals with air conditioning in Geneva, IL

Explore by feature - Pool

9 rentals with a pool in Geneva, IL

Explore by feature - Washer/dryer

9 rentals with a washer/dryer in Geneva, IL

Homes for sale near 38W413 Berquist Dr

Skip to last item
Skip to first item

Off Market Homes Near 38W413 Berquist Dr

Skip to last item
Skip to first item
Based on information submitted to the MLS GRID as of 2026. 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. Click here for more information