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
$640,900 Zestimate®
$167/sqft
$4,279 Estimated rent
Home value
$640,900
$609,000 - $673,000
$4,279/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: August 09, 2023 at 08:10pm
Listing courtesy of:
Nir Patel 224-633-9177,
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 | ||
| 7/9/2023 | Contingent | $580,000$171/sqft |
Source: MRED as distributed by MLS GRID #11820442 | ||
| 6/30/2023 | Listed for sale | $580,000+45%$171/sqft |
Source: MRED as distributed by MLS GRID #11820442 | ||
| 6/17/2016 | Sold | $400,000-11.1%$118/sqft |
Source: Public Record | ||
| 4/30/2015 | Price change | $450,000-2%$133/sqft |
Source: CARE Real Estate #08851166 | ||
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% |
Find assessor info on the county website
Neighborhood: 60134
Nearby schools
GreatSchools rating
- 5/10Heartland Elementary SchoolGrades: K-5Distance: 1 mi
- 10/10Geneva Middle School NorthGrades: 6-8Distance: 0.9 mi
- 9/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 pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$640,900
2% more+ $12,818
With Zillow Showcase(estimated)
$653,718