NOT LISTED FOR SALE

4S170 Hazelcrest Dr Sugar Grove, IL 60554

Estimated Value: $472,000 - $534,000

4 Beds
3.5 Baths
2,975 Sq Ft
$166/Sq Ft Est. Value

Last Sold June 17, 2024

Last sale price $450,000 $151 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $3,403/month

2 Days on Market

Highlights

  • In Ground Pool
  • Deck
  • Wood Flooring
  • Multiple Garages
  • Recreation Room
  • Heated Sun or Florida Room

About This Home

As of June 2024

Live like you are on vacation every day! You will love the lifestyle that accompanies this amazing 4 bed 3 full 1 half bath home located on the most picturesque, park-like private 1-acre lot. There is so much to amaze even the most discerning new owners both inside and out. The moment you enter this immaculate home you will adore the spacious open floor plan and glowing cherry wood floors. The current owners have spared no expense creating this stunning space perfect for entertaining family and friends or spending quiet evenings at home. The kitchen has been updated with newer appliances and just off the kitchen is an eating space or full dining room. Spend time in the light, bright cozy family room and winters by the fireplace. The family room extends into the 4-season room, and you will be torn where you want to spend more time. This beautiful space is just right for summer nights by the pool, entertaining for all the summer holidays, movie nights and even the largest of holiday gatherings. Its wall-to-wall windows give the best views of the private backyard oasis and beyond. The first floor is complete with flex space for a living room, office, play space, the possibilities are endless! The upstairs is no less pleasing as the cherry wood floors continue throughout the second level and in the spacious 4 bedrooms. The private primary suite has a large walk-in closet with Elfa system, and ensuite bath. The lower level boasts the huge rec room with the most plush carpet, bar area and so much space to relax or entertain for the adults or kids. There is a 3rd full bath in the lower-level and plenty of space for storage. Although this home will amaze you inside, you may fall more in love with the outdoor beauty!! The stunning curb appeal, professional landscaping, large lot, and PGA putting green are the perfect setting for you to enjoy along with the 18'x36' in ground saltwater pool, large Trex deck and hot tub. This is truly the retreat you have been looking for! an 3+ Car garage gives you plenty of space to store all of your outdoor toys and equipment. This is the perfect location giving you privacy, but is close to schools, shopping, dining, entertainment, Metra, I-88 and more! Feel like you've escaped it all while just minutes from all that Sugar Grove and surrounding communities have to offer. There is so much NEW making this home ready for its new owners and there is nothing to do but move in and enjoy!! New pool liner, well pump, well tank, and sump pump - 2023, professional landscaping and stone walkway, washer, dryer and Bosch dishwasher - 2022, vinyl fence, PGA putting green, landscaping, cherry wood floors, LG refrigerator and carpet on the stairs - 2021, retaining wall and robotic pool vacuum - 2020, pool heater, trex deck, hot tub, sump and ejector pump -2019, driveway sealcoat, Gorilla basketball hoop and painted lines, garage heater - 2018, ALL new Anderson windows and screens (37 total) - 2017, furnace and a/c, mini split for sunroom - 2016, and roof - 2014. (Full list of improvements available upon request). You will not want to miss this one of a kind home!

Last Agent to Sell the Property

Shelly Voight

Berkshire Hathaway HomeServices Starck Real Estate License #475157633 Listed on: 05/16/2024

Berkshire Hathaway HomeServices Starck Real Estate

Last Buyer's Agent

Bob Wisdom

RE/MAX Horizon License #475122882

RE/MAX Horizon

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,479

Year Built

  • Built in 1978

Lot Details

  • Lot Dimensions are 112 x 257 x 263 x 211

Parking

  • 3.5 Car Garage
  • Multiple Garages
  • Heated Garage
  • Garage Door Opener
  • Driveway
  • Parking Included in Price

Home Design

  • Asphalt Roof
  • Radon Mitigation System

Interior Spaces

  • 2,975 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Ceiling Fan
  • Wood Burning Fireplace
  • Fireplace With Gas Starter
  • Family Room with Fireplace
  • Formal Dining Room
  • Recreation Room
  • Heated Sun or Florida Room
  • Storage Room
  • Wood Flooring
  • Unfinished Attic
  • Carbon Monoxide Detectors

Kitchen

  • Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Potential Bedrooms
  • Walk-In Closet

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Finished Basement Bathroom
  • Basement Storage

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • Deck
  • Patio

Schools

  • Harter Middle School
  • Kaneland High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Well
  • Gas Water Heater
  • Water Softener Leased
  • Private or Community Septic Tank

Community Details

  • Custom

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,479

Year Built

Built in 1978

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Year Built: 1978
  • Age: 41-50 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Water Softener Rented
  • Basement: Full
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Total Bedrooms: 4
  • Fireplace Features: Wood Burning, Gas Starter
  • Fireplaces: 1
  • Interior Amenities: Hardwood Floors, Walk-In Closet(s), Bookcases
  • LivingArea: 2975
  • Other Equipment: Water-Softener Rented, CO Detectors, Ceiling Fan(s), Sump Pump, Radon Mitigation System, Water Heater-Gas
  • Room Type: Heated Sun Room, Storage, Recreation Room
  • Estimated Total Finished Sq Ft: 2975
  • Basement Description: Finished,Storage Space
  • Basement Bathrooms: Yes
  • Below Grade Bedrooms: 0
  • Dining Room: Separate
  • Total Sq Ft: 2975
  • Fireplace Location: Family Room
  • Total Sq Ft: 2975
  • Upper Level Sq Ft: 2275
  • Attic: Unfinished
  • Lower Level Sq Ft: 700
  • ResoLivingAreaSource: Estimated

Exterior Features

  • ExteriorFeatures: Deck, Patio, Hot Tub, In Ground Pool
  • List Price: 450000
  • Roof: Asphalt
  • Waterfront: No
  • Exterior Building Type: Vinyl Siding,Brick

Garage/Parking

  • Garage Spaces: 3.5
  • ParkingTotal: 3.5
  • Driveway: Asphalt
  • Garage Details: Garage Door Opener(s),Heated,Multiple Garages
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached,Detached
  • Parking: Garage

Utilities

  • Sewer: Septic-Private
  • Cooling: Central Air, Zoned
  • Heating: Natural Gas, Forced Air, Sep Heating Systems - 2+, Zoned
  • Laundry Features: In Unit
  • Water Source: Private Well

Condo/Co-op/Association

  • Association Fee Frequency: Not Applicable
  • Master Association Fee: No
  • Master Association Fee Frequency: Not Required

Fee Information

  • Association Fee Includes: None

Schools

  • High School: Kaneland High School
  • Middle/Junior School: Harter Middle School
  • Middle/Junior School District: 302

Lot Info

  • Additional Parcels: No
  • Lot Dimensions: 112 X 257 X 263 X 211
  • Lot Size: 1.0-1.99 Acres
  • Special Assessments: N

Rental Info

  • Board Number: 3
  • Is Parking Included in Price: Yes

Tax Info

  • Tax Annual Amount: 8479.26
  • Tax Year: 2023
  • Tax Exemptions: Homeowner

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 21, 2025
Sold by
Merlak Ian C and Merlak Macey S
Bought by
Merlak Ian C and Merlak Macey S
Current Estimated Value
$487,604

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$381,280
Outstanding Balance
$380,944
Interest Rate
6.63%
Mortgage Type
New Conventional
Estimated Equity
$106,660

Purchase Details

Listed on
May 16, 2024
Closed on
Jun 13, 2024
Sold by
Kintopf Jenny L and Friedle Jamie
Bought by
Merlak Ian C and Merlak Macey S
Seller's Agent
Shelly Voight
Berkshire Hathaway HomeServices Starck Real Estate
Buyer's Agent
Bob Wisdom
RE/MAX Horizon
List Price
$450,000
Sold Price
$450,000
Views
101

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.23%
Original Mortgage
$405,000
Interest Rate
7.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 8, 2007
Sold by
Friedle Jamie and Kintopf Jenny L
Bought by
Friedle Jamie and Friedle Jenny L

Purchase Details

Closed on
Oct 14, 2005
Sold by
Carlson Jeffrey R and Carlson Diane M
Bought by
Friedle Jamie R and Kintopf Jenny L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$274,400
Interest Rate
6.5%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Jun 8, 2000
Sold by
Reuland Paul P and Reuland Marie E
Bought by
Carlson Jeffrey R and Carlson Dianne M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$208,000
Interest Rate
8.31%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Merlak Ian C -- None Listed On Document
Merlak Ian C $450,000 None Listed On Document
Friedle Jamie -- None Available
Friedle Jamie R $343,000 Chicago Title Insurance Comp
Carlson Jeffrey R $228,000 First American
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Merlak Ian C $381,280
Previous Owner Merlak Ian C $405,000
Previous Owner Friedle Jamie R $307,000
Previous Owner Friedle Jamie $313,500
Previous Owner Friedle Jamie R $304,000
Previous Owner Friedle Jamie R $76,000
Previous Owner Friedle Jamie R $274,400
Previous Owner Friedle Jamie R $68,600
Previous Owner Carlson Jeffrey R $45,000
Previous Owner Carlson Jeffrey R $223,000
Previous Owner Carlson Jeffrey R $208,000
Previous Owner Carlson Jeffrey R $208,000
Previous Owner Carlson Jeffrey R $208,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/17/2024 06/17/24 Sold $450,000 0.0% $151 / Sq Ft
05/19/2024 05/19/24 Pending -- -- --
05/16/2024 05/16/24 For Sale $450,000 -- $151 / Sq Ft
Source: Midwest Real Estate Data (MRED)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $8,793 $117,238 $31,407 $85,831
2023 $8,479 $105,734 $28,325 $77,409
2022 $8,169 $97,612 $26,149 $71,463
2021 $7,867 $92,893 $24,885 $68,008
2020 $7,756 $90,911 $24,354 $66,557
2019 $7,639 $87,939 $23,558 $64,381
2018 $7,449 $83,930 $25,058 $58,872
2017 $7,217 $80,155 $23,931 $56,224
2016 $7,041 $76,622 $22,876 $53,746
2015 -- $76,846 $21,284 $55,562
2014 -- $73,481 $20,352 $53,129
2013 -- $74,253 $20,566 $53,687
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 12057845

Midwest Real Estate Data (MRED)

APN: 14-06-226-004