See Home Value
Kane 60134
38W413 Berquist Drive
$565,500
● House - Off Market

38W413 Berquist Drive

Geneva, IL 60134
bedrooms
4 Beds
bathrooms
4 Baths, 1 Half Bath
square feet
3,391 Ft²
$576,751
RealtyHop Estimate
-0.56%
Since Sep 1, 2023
National-US
Primary Model

About This Property

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!
Unit Size
3,391 Ft²
Days on Market
-
Land Size
-
Price per sqft
$171
Property Type
House
Property Taxes
$1,037
HOA Dues
-
Year Built
2006

Payment Calculator

Cap Rate Calculator

Last updated: 3 years ago (MRED MLS #11820442)

Price History

Date / Event Date Event Price
Aug 9, 2023 Sold
Sold
Jun 29, 2023 Listed by Homesmart Connect LLC $580,000
Listed by Homesmart Connect LLC

Property Highlights

Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 2006
  • Effective Year Built: 2006
  • Building Count: 1
  • Total Rooms: 10
  • Bedroom Count: 4
  • Bathroom Count: 4
  • Full Bathrooms: 3
  • Partial Bathrooms: 4
  • Building Condition: 0
  • Building Quality: 0
  • Construction Type: 0
  • Building Style: 28
  • Exterior Walls Type: 2
  • Interior Walls Type: 0
  • Roof Shape Type: 0
  • Roof Cover Type: 0
  • Floor Count: 200
  • Floor Cover: 0
  • Basement Type: 2
  • Basement Area: 1,840
  • Garage Type: 7
  • Parking Space Count: 3
  • Patio Type: 0
  • Porch Type: 0
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 10,560
  • Lot Size Depth Feet: 800
  • Lot Size Frontage Feet: 1,320
  • Total Building Area: 5,231
  • Gross Building Area: 5,231
  • Building Area: 3,391
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 1
  • Heating: 0
  • Heated Square Feet: 3,391
  • Heating Fuel Type: 0

    Utilities

  • Sewer System: 1
  • Water Service: 2

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: MILL CREEK
  • Land Acres: 0000000242
  • Standard Land Use Code: 1001
  • County Land Use Code: 0040
  • State Land Use Code: 0040
  • Legal Description 1: MILL CREEK NBHD O LT 97

Neighborhood

  • School District Name: Geneva Community Unit School District 304
  • Census Tract: 854800

Geography

  • Parcel: 12-07-252-008
  • Lot: 97
  • Municipality: GENEVA
  • Latitude: 41.8775
  • Longitude: -88.3681

    Address

  • Full Address: 38w413 Berquist Dr
  • Address - House Number: 38w413
  • Address - Street Name: Berquist
  • Address - Suffix Type: Dr
  • State: IL
  • City Name: Geneva
  • Carrier Code: R060
  • 4-Digit Zip Code: 6144
  • Zip Code: 60134

Valuation

    Tax

  • Tax Year: 2022
  • Tax Amount: $1,244,702
  • Tax Rate Code Area: GE018

    Appraisal Valuation

  • Standard Deviation: 0.1324
  • Valuation Date: Nov 29, 2023
  • Confidence Score: 84
  • Final Value: 576,144
  • High Value: 652,465
  • Low Value: 499,822

    Market Valuation

  • Market Total Value: $464,112
  • Market Land Value: $113,526
  • Market Improvement Value: $350,585

    Assessments Valuation

  • Assessed Year: 2022
  • Assessed Total Value: $154,642
  • Assessed Land Value: $37,827
  • Assessed Improvements Value: $116,815

    Sales

  • Current Sale Contract Date: Jul 21, 2023
  • Current Sale Recording Date: Aug 22, 2023
  • Current Sale Price:
  • Current Sale Document Type: 71
  • Current Sale Input Document Number: 28884
  • Previous Sale Recording Date: Jun 17, 2016
  • Previous Sale Contract Date: Jun 06, 2016
  • Previous Sale Amount: $400,000
  • Previous Sale Document Type: 27
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Kane


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals



Frequently Asked Questions

When was property at 38W413 Berquist Drive built and last sold?
The property at 38W413 Berquist Drive was built in 2006 and last sold on Jul 21, 2023 for $565,500.
How much is this home worth?
The estimated value of the home located at 38W413 Berquist Drive is $592,991.
What are some comparable homes to 38W413 Berquist Drive?
There are currently no comparable homes to 38W413 Berquist Drive.