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!
Closed
$565,500
38W413 Berquist Dr, Geneva, IL 60134
4beds
3,391sqft
Single Family Residence
Built in 2006
10,560 Square Feet Lot
$680,200 Zestimate®
$167/sqft
$5,281 Estimated rent
Home value
$680,200
$646,000 - $714,000
$5,281/mo
Zestimate® history
Owner options
List your home for rent
$5,281/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,281/mo
Rent Zestimate®
Refinance and save
$4,064/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,064/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Gas fireplaceFenced yardExtra storageMinutes away from schoolsMill creek community parkLarge drivewayBig windows
Zillow last checked:
Listing updated:
Listing courtesy of:
Nir Patel 847-495-5000,
HomeSmart Connect
Bought with:
Christopher Doyle
RLTR MBA, Inc.
Source: MRED as distributed by MLS GRID,MLS#: 11820442
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Flooring (Carpet), Bathroom (Full)
- Level: Second
- Area: 352 Square Feet
- Dimensions: 22X16
Bedroom 2
- Features: Flooring (Carpet)
- Level: Second
- Area: 182 Square Feet
- Dimensions: 14X13
Bedroom 3
- Features: Flooring (Carpet)
- Level: Second
- Area: 169 Square Feet
- Dimensions: 13X13
Bedroom 4
- Features: Flooring (Carpet)
- Level: Second
- Area: 156 Square Feet
- Dimensions: 13X12
Breakfast room
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 169 Square Feet
- Dimensions: 13X13
Den
- Features: Flooring (Carpet)
- Level: Main
- Area: 156 Square Feet
- Dimensions: 13X12
Dining room
- Features: Flooring (Carpet)
- Level: Main
- Area: 156 Square Feet
- Dimensions: 13X12
Family room
- Features: Flooring (Carpet)
- Level: Main
- Area: 304 Square Feet
- Dimensions: 19X16
Kitchen
- Features: Kitchen (Eating Area-Table Space, Island, Pantry-Closet), Flooring (Ceramic Tile)
- Level: Main
- Area: 143 Square Feet
- Dimensions: 13X11
Laundry
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 91 Square Feet
- Dimensions: 13X7
Living room
- Features: Flooring (Carpet)
- Level: Main
- Area: 195 Square Feet
- Dimensions: 15X13
Mud room
- Features: Flooring (Ceramic Tile)
- Level: Main
- Area: 48 Square Feet
- Dimensions: 8X6
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Range, Microwave, Dishwasher, Refrigerator, Disposal, Humidifier, Gas Water Heater
Features
- Basement: Partially Finished,Full
- Number of fireplaces: 1
- Fireplace features: Gas Log, Gas Starter, Family Room
Interior area
- Total structure area: 0
- Total interior livable area: 3,391 sqft
Property
Parking
- Total spaces: 3
- Parking features: Asphalt, Garage Door Opener, On Site, Garage Owned, Attached, Garage
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: No Disability Access
Features
- Stories: 2
- Patio & porch: Patio, Porch
- Exterior features: Fire Pit
- Fencing: Fenced
Lot
- Size: 10,560 sqft
- Dimensions: 132 X 80
- Features: Landscaped
Details
- Parcel number: 1207252008
- Special conditions: None
- Other equipment: Ceiling Fan(s), Sump Pump, Sprinkler-Lawn
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Vinyl Siding, Brick
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2006
Details
- Builder model: TRENTON 3
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Carbon Monoxide Detector(s)
Community
- Community features: Park, Curbs, Sidewalks, Street Lights, Street Paved
Location
- Region: Geneva
- Subdivision: Mill Creek Oakmont
HOA & financial
HOA
- Services included: None
Other
Other facts
- Listing terms: VA
- Ownership: Fee Simple
Price history
| Date | Event | Price |
|---|---|---|
| 8/9/2023 | Sold | $565,500-2.5%$167/sqft |
Source:  MRED as distributed by MLS GRID #11820442 Report a problem | ||
| 7/9/2023 | Contingent | $580,000$171/sqft |
Source: MRED as distributed by MLS GRID #11820442 Report a problem | ||
| 6/30/2023 | Listed for sale | $580,000+45%$171/sqft |
Source: MRED as distributed by MLS GRID #11820442 Report a problem | ||
| 6/17/2016 | Sold | $400,000-11.1%$118/sqft |
Source: Public Record Report a problem | ||
| 4/30/2015 | Price change | $450,000-2%$133/sqft |
Source: CARE Real Estate #08851166 Report a problem | ||
| 3/5/2015 | Listed for sale | $459,000+9.8%$135/sqft |
Source: CARE Real Estate #08851166 Report a problem | ||
| 9/17/2010 | Sold | $418,000-9.1%$123/sqft |
Source: MRED as distributed by MLS GRID #07558712 Report a problem | ||
| 8/7/2010 | Pending sale | $459,900-5.2%$136/sqft |
Source: Keller Williams Realty St. Charles #07558712 Report a problem | ||
| 6/20/2010 | Listed for sale | $484,900-2.4%$143/sqft |
Source: Keller Williams Realty St. Charles #07558712 Report a problem | ||
| 9/13/2006 | Sold | $497,000$147/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $13,403 +2.8% | $183,068 +10% |
| 2023 | $13,041 +4.8% | $166,425 +7.6% |
| 2022 | $12,447 +2.7% | $154,642 +3.9% |
| 2021 | $12,115 +2.1% | $148,895 +1.6% |
| 2020 | $11,868 +0.6% | $146,622 +1.9% |
| 2019 | $11,795 -4.9% | $143,846 -4.9% |
| 2018 | $12,399 +1.5% | $151,214 +2.7% |
| 2017 | $12,217 -3.5% | $147,182 +1.4% |
| 2016 | $12,665 | $145,193 -5.1% |
| 2015 | -- | $153,009 +9.9% |
| 2014 | -- | $139,237 |
| 2013 | -- | $139,237 -4.5% |
| 2012 | -- | $145,752 -7.4% |
| 2011 | -- | $157,426 -3.3% |
| 2010 | -- | $162,849 -4.9% |
| 2009 | -- | $171,240 |
| 2008 | -- | $171,240 +4.7% |
| 2007 | -- | $163,584 +328.5% |
| 2006 | -- | $38,174 +1465.8% |
| 2005 | -- | $2,438 |
Find assessor info on the county website
Neighborhood: 60134
Nearby schools
GreatSchools rating
- 7/10Heartland Elementary SchoolGrades: K-5Distance: 1 mi
- 9/10Geneva Middle School NorthGrades: 6-8Distance: 0.9 mi
- 7/10Geneva Community High SchoolGrades: 9-12Distance: 2.8 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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$680,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$680,200
- Illinois
- Kane County
- Geneva
- 60134
- 38W413 Berquist Dr
Nearby cities
Nearby zip codes
Other Geneva Topics
