Rafay Qamar
Real Broker LLC
(833) 359-9113
1,072 Total Sales
1 in Rose Hill Farm
$400,000 Price
3776 Celeste Ln Naperville, IL 60564
Rose Hill Farm NeighborhoodEstimated Value: $735,000 - $868,938
4
Beds
6
Baths
3,938
Sq Ft
$204/Sq Ft
Est. Value
Highlights
- In Ground Pool
- Landscaped Professionally
- Recreation Room
- Patterson Elementary School Rated A+
- Property is near park
- Vaulted Ceiling
About This Home
As of August 2022One of the Largest Homes in Rose Hill Farms Subdivision! This Exclusive Custom Built Home Features an Indoor Volleyball/Basketball Court, Outdoor In Ground Heated Swimming Pool, Rec Room and More!!! With 7 Bedrooms and 4.2 Bathrooms including an Ensuite plus New Roof and Gutters, Electric Car Ready Garage,Updated Kitchen,Updated HVAC systems Bathroom Steam Shower, 1st Floor Laundry with laundry shoots from 2nd floor, Hardwood Floors..This Amazing Home will WOW you!!! There's no time like now to move with all the room in this home theres plenty to keep the family entertained! 1st Floor has separate Dining and Living room plus a Huge Breakfast room and an adjacent Family room...Walk In Pantry and Wet Bar...seeing is believing in this well built home! Move in and Live!!! We are Showing this Home Now Call us Today to set up a Viewing...
Last Buyer's Agent
@properties Christie's International Real Estate License #475186139
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $13,953
Year Built
- Built in 1996 | Remodeled in 2017
Lot Details
- 10,454 Sq Ft Lot
- Lot Dimensions are 81x125
- Fenced Yard
- Landscaped Professionally
- Paved or Partially Paved Lot
HOA Fees
- $15 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Garage Door Opener
- Driveway
- Parking Space is Owned
Home Design
- Traditional Architecture
- Asphalt Roof
- Concrete Perimeter Foundation
Interior Spaces
- 3,938 Sq Ft Home
- 2-Story Property
- Wet Bar
- Vaulted Ceiling
- Skylights
- Double Sided Fireplace
- Entrance Foyer
- Family Room with Fireplace
- Living Room
- Breakfast Room
- Formal Dining Room
- Home Office
- Recreation Room
- Home Gym
Kitchen
- Built-In Oven
- Cooktop with Range Hood
- Microwave
- High End Refrigerator
- Dishwasher
- Stainless Steel Appliances
Flooring
- Wood
- Ceramic Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- 6 Potential Bedrooms
- Main Floor Bedroom
- Walk-In Closet
- Dual Sinks
- Whirlpool Bathtub
- Steam Shower
- Shower Body Spray
- Separate Shower
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
- Laundry Chute
Finished Basement
- Basement Fills Entire Space Under The House
- Finished Basement Bathroom
Outdoor Features
- In Ground Pool
- Brick Porch or Patio
Location
- Property is near park
Schools
- Patterson Elementary School
- Crone Middle School
- Neuqua Valley High School
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- 200+ Amp Service
- Lake Michigan Water
Community Details
- Liz Jesse Association, Phone Number (630) 202-6878
- Rose Hill Farms Subdivision
- Property managed by Rose Hill Farms HOA
Listing and Financial Details
- Homeowner Tax Exemptions
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 15, 2020
Closed on
Aug 16, 2022
Sold by
Bought by
Seller's Agent
Michael Giliano
Compass
Buyer's Agent
Mallory Engstrom
@properties Christie's International Real Estate
List Price
$639,000
Sold Price
$625,000
Premium/Discount to List
-$14,000
-2.19%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$176,485
Avg. Annual Appreciation
6.48%
Original Mortgage
$593,750
Outstanding Balance
$562,631
Interest Rate
5.88%
Mortgage Type
New Conventional
Estimated Equity
$238,854
Purchase Details
Closed on
Jun 30, 2021
Sold by
Bought by
Purchase Details
Closed on
Jan 4, 2017
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$355,600
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Jan 29, 2015
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$355,900
Interest Rate
3.99%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jan 8, 1996
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Rose Hill Farm, IL
-
Rafay Qamar
-
Vipin Gulati
Vipin Gulati
RE/MAX Professionals Select
(708) 859-6295
264 Total Sales
1 in Rose Hill Farm
$355,500 Price
-
Vanessa Matthews
Vanessa Matthews
Responds QuicklyKeller Williams Preferred Rlty
(224) 458-2368
25 Total Sales
1 in Rose Hill Farm
$495,500 Price
-
Michael Giliano
Michael Giliano
Responds QuicklyCompass
(224) 258-0424
192 Total Sales
2 in Rose Hill Farm
$615K - $625K Price Range
-
Alice Chin
Alice Chin
Responds QuicklyCompass
(630) 394-5561
424 Total Sales
1 in Rose Hill Farm
$629,900 Price
-
Jill Lejsek
Jill Lejsek
Responds QuicklyBaird & Warner
(224) 258-0348
90 Total Sales
1 in Rose Hill Farm
$445,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $625,000 | Old Republic Title | ||
| -- | Attorney | ||
| -- | Citywide Title Corporation | ||
| -- | Attorney | ||
| $56,000 | Chicago Title Insurance Co |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $112,189 | ||
| Open | $593,750 | ||
| Previous Owner | $508,000 | ||
| Previous Owner | $474,300 | ||
| Previous Owner | $355,600 | ||
| Previous Owner | $355,900 | ||
| Previous Owner | $359,400 | ||
| Previous Owner | $368,500 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $250,000 | ||
| Previous Owner | $600,000 | ||
| Previous Owner | $83,000 | ||
| Previous Owner | $66,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 08/18/2022 08/18/22 | Sold | $625,000 | -2.2% | $159 / Sq Ft |
| 11/15/2020 11/15/20 | Pending | -- | -- | -- |
| 09/14/2020 09/14/20 | For Sale | $639,000 | -- | $162 / Sq Ft |
Source: Midwest Real Estate Data (MRED)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $17,193 | $258,088 | $42,795 | $215,293 |
| 2023 | $16,381 | $227,993 | $37,805 | $190,188 |
| 2022 | $15,636 | $214,836 | $35,764 | $179,072 |
| 2021 | $14,467 | $204,606 | $34,061 | $170,545 |
| 2020 | $14,193 | $201,364 | $33,521 | $167,843 |
| 2019 | $13,953 | $195,689 | $32,576 | $163,113 |
| 2018 | $13,280 | $183,282 | $31,858 | $151,424 |
| 2017 | $13,079 | $178,551 | $31,036 | $147,515 |
| 2016 | $13,057 | $174,708 | $30,368 | $144,340 |
| 2015 | $13,256 | $167,988 | $29,200 | $138,788 |
| 2014 | $13,256 | $167,149 | $29,200 | $137,949 |
| 2013 | $13,256 | $167,149 | $29,200 | $137,949 |
Source: Public Records
Agents Affiliated with this Home
-
Michael Giliano
Seller's Agent in 2022
Michael Giliano
Compass
(312) 319-1168
2 in this area
192 Total Sales
-
Mitchell Giliano
Seller Co-Listing Agent in 2022
Mitchell Giliano
Compass
(630) 816-0244
1 in this area
39 Total Sales
-
Mallory Engstrom
Buyer's Agent in 2022
Mallory Engstrom
@ Properties
(480) 463-0096
1 in this area
28 Total Sales
Map
Source: Midwest Real Estate Data (MRED)
MLS Number: 10857773
APN: 07-01-11-429-027
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.
Listings courtesy of Midwest Real Estate Data (MRED) as distributed by MLS GRID.
Based on information submitted to the MLS GRID
Nearby Homes
- 3804 Petra Ct
- 3827 Petra Ct Unit 1
- 3936 Garnette Ct
- 3718 Tramore Ct
- 957 Winners Cup Ct
- 3415 Timber Creek Ln
- 124 Periwinkle Ln
- 158 Cider St
- 130 Periwinkle Ln
- 2815 Forest Creek Ln
- 1611 Conan Doyle Rd
- 1877 Marne Rd
- 11S556 Book Rd
- 4303 Ariel Ct
- 11S560 Whittington Ln Unit 4
- 1259 Old Mill Ct
- 1813 Trevino Cir
- 2219 Haider Ave Unit 1
- 2721 Springdale Cir
- 10 Timber Mill Ct
- 3772 Celeste Ln
- 3784 Celeste Ln
- 3768 Celeste Ln
- 3823 Relstar Ct
- 3819 Relstar Ct
- 3804 Celeste Ln
- 3775 Celeste Ln
- 3771 Celeste Ln
- 3808 Petra Ct
- 3827 Relstar Ct Unit 1
- 3815 Relstar Ct
- 3812 Petra Ct
- 3811 Relstar Ct
- 3831 Relstar Ct
- 3816 Petra Ct Unit 3816
- 3816 Petra Ct
- 3807 Relstar Ct
- 3820 Petra Ct
- 3835 Relstar Ct
- 3764 Celeste Ln
Your Personal Tour Guide
Ask me questions while you tour the home.