NOT LISTED FOR SALE

Estimated Value: $677,000 - $820,000

4 Beds
2.5 Baths
2,830 Sq Ft
$258/Sq Ft Est. Value

Last Sold August 24, 2020

Last sale price $479,000 $169 Per Sq Ft

Est. 52% increase in value since last sale

Current estimated payment $4,865/month

3 Days on Market

Highlights

  • Landscaped Professionally
  • Community Lake
  • Recreation Room
  • Patterson Elementary School Rated A+
  • Property is near a park
  • Vaulted Ceiling

About This Home

As of August 2020

Located on a quiet, interior lot and nestled along a beautiful winding street is where you will find your next home! Welcome to 3811 Celeste and the popular Rose Hill Farm Sub of Naperville. You will appreciate the generously sized rooms and open floor plan this beautiful home has to offer - perfect for today's busy lifestyles! The spacious kitchen is the perfect place to begin your day. Features include, updated counter tops & lighting fixtures, large planning desk, pantry closet, over-sized island with seating and plenty of room for your favorite dinner table. Step outside to the paver patio for your morning coffee or cozy up in the warmth of the inviting and spacious 21X16 family room featuring volume ceilings, 2-story fireplace and new skylights that allow for ample natural light to flood into the room year round. If you are working from home these day, no problem here - the private 1st flr office is located in the front of the house and is set behind semi-private, glass pained french-doors. Entertaining is a snap with the spacious formal living room that opens seamlessly to the dining room. If you find you need even more space, take the group downstairs to the finished rec room that offers plenty of space to spread out and take in a movie, play your favorite table game or just relax and let the kids play in the built-in clubhouse set under the staircase. There is even a guest bedroom on the lower level if the party runs late. At the end of the day, retire to one of the 4 bedrooms on the 2nd level -all with walk-in closets and black-out shades. Unwind and re-set for the next day in the master suite featuring a volume ceiling, walk-in closet and spacious bathroom with a dual sink vanity, jetted tub and separate shower. Many recent improvements and features include 1st flr Mud room with cubbies, 1st flr laundry with new service door to backyard, new roof, gutters and siding (2019), air conditioner (2020), Sprinkler system and more. All of this and Located in the award winning School District #204 - Neuqua Valley HS attd, blocks to many neighborhood amenities. Close to shopping, restaurants, Naperville Library, movie theater and YMCA. Under 15 minutes to downtown Naperville and I-55 - this home checks all the boxes! Call today to schedule your private viewing.

Last Agent to Sell the Property

Eva Burns

Redfin Corporation License #471004335 Listed on: 06/18/2020

Redfin Corporation

Last Buyer's Agent

Linda Boyle-Hentsch

Coldwell Banker Real Estate Group License #475134077

Coldwell Banker Real Estate Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,132

Year Built

  • Built in 1994

Lot Details

  • 0.27 Acre Lot
  • Lot Dimensions are 100x153x65x133
  • Fenced Yard
  • Landscaped Professionally
  • Sprinkler System

HOA Fees

  • $17 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Parking Included in Price

Home Design

  • Traditional Architecture
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,830 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Skylights
  • Fireplace With Gas Starter
  • Mud Room
  • Family Room with Fireplace
  • Living Room
  • Formal Dining Room
  • Den
  • Recreation Room
  • Lower Floor Utility Room

Kitchen

  • Built-In Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 5 Potential Bedrooms
  • Walk-In Closet
  • Dual Sinks
  • Whirlpool Bathtub
  • Separate Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Schools

  • Patterson Elementary School
  • Crone Middle School
  • Neuqua Valley High School

Utilities

  • Central Air
  • Humidifier
  • Heating System Uses Natural Gas

Additional Features

  • Brick Porch or Patio
  • Property is near a park

Community Details

  • Association fees include insurance
  • Rose Hill Farm HOA
  • Rose Hill Farms Subdivision, Spacious! Floorplan
  • Community Lake

Listing and Financial Details

  • Homeowner Tax Exemptions

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,132

Year Built

Built in 1994

Lot Details

0

HOA Fees

$17 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Type: Detached Single
  • Type Detached: 2 Stories
  • Ownership: Fee Simple w/ HO Assn.
  • ArchitecturalStyle: Traditional
  • New Construction: No
  • Property Sub-Type: 2 Stories
  • Subdivision Name: Rose Hill Farms
  • Year Built: 1994
  • Age: 26-30 Years
  • Built Before 1978 (Y/N): No
  • Disability Access and/or Equipped: No
  • General Information: School Bus Service,Commuter Bus
  • Rebuilt (Y/N): No
  • Rehab (Y/N): No
  • New Construction Y/N: No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Cooktop, Built-In Oven
  • Basement: Full
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: Gas Starter
  • Fireplaces: 1
  • Interior Amenities: Vaulted/Cathedral Ceilings, Skylight(s), Hardwood Floors, First Floor Laundry, Walk-In Closet(s)
  • LivingArea: 2830
  • Other Equipment: Humidifier, Ceiling Fan(s), Sump Pump, Sprinkler-Lawn, Backup Sump Pump;
  • Room Type: Bedroom 5, Den, Mud Room, Recreation Room, Utility Room-Lower Level
  • Estimated Total Finished Sq Ft: 0
  • Basement Description: Finished
  • Bathroom Amenities: Whirlpool,Separate Shower,Double Sink
  • Basement Bathrooms: No
  • Below Grade Bedrooms: 1
  • Dining Room: Separate
  • Total Sq Ft: 0
  • Fireplace Location: Family Room
  • Total Sq Ft: 0
  • Flooring: Carpet
  • ResoLivingAreaSource: Assessor

Exterior Features

  • ExteriorFeatures: Brick Paver Patio
  • Foundation Details: Concrete Perimeter
  • List Price: 479000
  • Lot Features: Fenced Yard, Landscaped
  • OtherStructures: None
  • Waterfront: No
  • Exterior Building Type: Brick,Cedar

Garage/Parking

  • Garage Spaces: 2
  • ParkingTotal: 2
  • Driveway: Asphalt
  • Garage Details: Garage Door Opener(s)
  • Garage On-Site: Yes
  • Garage Ownership: Owned
  • Garage Type: Attached
  • Parking: Garage

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Natural Gas
  • Laundry Features: Gas Dryer Hookup
  • Water Source: Public

Condo/Co-op/Association

  • Association Fee: 200
  • Association Fee Frequency: Annually
  • Community Features: Park, Lake, Sidewalks, Street Lights
  • Master Association Fee: No
  • Management Company: Self Managed
  • Management Contact Name: Rose Hill Farm HOA
  • Management Phone: 123-456-7890
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Association Fee Includes: Insurance

Schools

  • Elementary School: Patterson Elementary School
  • High School: Neuqua Valley High School
  • Middle/Junior School: Crone Middle School
  • Middle/Junior School District: 204

Lot Info

  • Lot Size Acres: 0.27
  • Lot Dimensions: 100X153X65X133
  • Rural (Y/N): N
  • Lot Size: .25-.49 Acre
  • Special Assessments: N
  • Zero Lot Line: No

Rental Info

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

Tax Info

  • Tax Annual Amount: 10132.04
  • Tax Year: 2019
  • Tax Exemptions: Homeowner

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 9, 2023
Sold by
Bakke Jason and Bakke Lauren
Bought by
Lauren Michelle Bakke Revocable Living Trust and Jason Michael Bakke Revocable Living Trust
Current Estimated Value
$730,371

Purchase Details

Listed on
Jun 18, 2020
Closed on
Aug 10, 2020
Sold by
Zorn Paul Z and Zorn Julie J
Bought by
Bakke Jason and Bakke Lauren
Seller's Agent
Eva Burns
Redfin Corporation
Buyer's Agent
Linda Boyle-Hentsch
Coldwell Banker Real Estate Group
List Price
$479,000
Sold Price
$479,000

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.12%
Original Mortgage
$383,200
Interest Rate
2.99%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 7, 2001
Sold by
Hipwell Thomas G and Hipwell Lisa A
Bought by
Zorn Paul A and Zorn Julie J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$275,000
Interest Rate
7.22%

Purchase Details

Closed on
Oct 13, 1994
Sold by
Beseda Builders Inc
Bought by
Hipwell Thomas G and Hipwell Lisa A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$190,000
Interest Rate
7.5%

Purchase Details

Closed on
Jun 3, 1994
Sold by
Chicago Title & Trust Company
Bought by
Beseda Builders Incorporated

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$206,000
Interest Rate
8.61%
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
Lauren Michelle Bakke Revocable Living Trust -- --
Bakke Jason $479,000 First American Title
Zorn Paul A $380,000 First American Title
Hipwell Thomas G $259,000 Chicago Title Insurance Co
Beseda Builders Incorporated $59,000 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Bakke Jason $383,200
Previous Owner Zorn Paul A $332,000
Previous Owner Zorn Paul A $194,000
Previous Owner Zorn Paul A $72,500
Previous Owner Zorn Paul A $247,500
Previous Owner Zorn Paul A $225,000
Previous Owner Zorn Paul A $29,000
Previous Owner Zorn Paul A $275,000
Previous Owner Hipwell Thomas G $190,000
Previous Owner Beseda Builders Incorporated $206,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/24/2020 08/24/20 Sold $479,000 0.0% $169 / Sq Ft
06/21/2020 06/21/20 Pending -- -- --
06/18/2020 06/18/20 For Sale $479,000 -- $169 / 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 $11,890 $189,523 $42,795 $146,728
2023 $11,890 $167,423 $37,805 $129,618
2022 $10,999 $157,808 $35,764 $122,044
2021 $10,510 $150,293 $34,061 $116,232
2020 $10,310 $147,911 $33,521 $114,390
2019 $10,132 $143,742 $32,576 $111,166
2018 $10,364 $144,351 $31,858 $112,493
2017 $10,205 $140,625 $31,036 $109,589
2016 $10,185 $137,598 $30,368 $107,230
2015 $9,619 $132,306 $29,200 $103,106
2014 $9,619 $122,933 $29,200 $93,733
2013 $9,619 $122,933 $29,200 $93,733
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Midwest Real Estate Data (MRED)

MLS Number: 10750361

Midwest Real Estate Data (MRED)

APN: 07-01-11-430-029