Seller's Agent in 2021
Jessica Cauley Kuhn
Epique Inc.
(586) 630-1319
8 in this area
95 Total Sales
5543 Celestial Ct Shelby Township, MI 48316
Estimated Value: $543,000 - $720,907
3
Beds
4
Baths
5,076
Sq Ft
$130/Sq Ft
Est. Value
Highlights
- Access To Lake
- Home Theater
- Recreation Room
- Morgan Elementary School Rated A-
- Waterfront
- Ranch Style House
About This Home
As of November 2021Welcome home to this custom ranch w/panoramic lake views! The main floor features a gourmet kitchen w/granite counters, high-end appliances, & huge island overlooking the great room w/ gas fireplace. Settle in for your morning coffee in the sunny breakfast nook or head on out to the upper or lower patios to enjoy the tranquil sound of the fountain! Each bedroom has its own full bath including a primary en suite w/dual vanities, soaker tub & WIC. Work from home in the first floor study w/french pocket doors! Look forward to parties on the lake & entertaining your guests in the finished walkout bsmt w/2nd kitchen, bath, bedroom, wine cellar, home gym, theatre w/ projector, rec area, murphy bed & more! Green-conscious buyers will appreciate the solar panels & pump from the lake for watering the lawn as well as the keyhole gardening beds for seasonal vegetables! High-tech lighting, & nest smart home thermostat stay!
Last Agent to Sell the Property
Epique Inc. License #MISPE-6506045501 Listed on: 08/18/2021
Co-Listed By
Jason Volltrauer
Cauley Kuhn Realty, LLC License #MISPE-6501435069
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 2001
Lot Details
- 0.32 Acre Lot
- Lot Dimensions are 100x150x56x50x120
- Waterfront
- Cul-De-Sac
- Street terminates at a dead end
- Sprinkler System
HOA Fees
- $25 Monthly HOA Fees
Home Design
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
Interior Spaces
- Cathedral Ceiling
- Ceiling Fan
- Gas Fireplace
- Entryway
- Great Room with Fireplace
- Home Theater
- Home Office
- Recreation Room
- Bonus Room
- Home Gym
Kitchen
- Oven or Range
- Microwave
- Dishwasher
Flooring
- Wood
- Carpet
- Ceramic Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
- 4 Full Bathrooms
- Hydromassage or Jetted Bathtub
Laundry
- Laundry Room
- Dryer
- Washer
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Interior Basement Entry
- Fireplace in Basement
Parking
- 3 Car Direct Access Garage
- Heated Garage
- Workshop in Garage
- Side Facing Garage
- Garage Door Opener
Outdoor Features
- Access To Lake
- Balcony
- Patio
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
- Septic Tank
- Internet Available
Community Details
- John Vermulen HOA
- Twilight Sub 4 Subdivision
Listing and Financial Details
- Assessor Parcel Number 23-07-08-279-010
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 18, 2021
Closed on
Nov 5, 2021
Sold by
Conrad John and Kelso Jenifer
Bought by
Watts David and Watts Heather
Seller's Agent
Jessica Cauley Kuhn
Epique Inc.
Buyer's Agent
Lindsay Anderson
EXP Realty
List Price
$550,000
Sold Price
$545,000
Premium/Discount to List
-$5,000
-0.91%
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
$114,477
Avg. Annual Appreciation
4.23%
Original Mortgage
$490,500
Outstanding Balance
$452,632
Interest Rate
3.05%
Mortgage Type
New Conventional
Estimated Equity
$185,732
Purchase Details
Closed on
Jun 4, 2021
Sold by
Conrad John B and Kelso Jenifer
Bought by
Conrad John and Kelso Jenifer
Purchase Details
Listed on
Sep 11, 2015
Closed on
Apr 11, 2016
Sold by
Fattore Norma J and Fattore William P
Bought by
Conrad John B and Keso Jenifer
Seller's Agent
Katie Weaver
Berkshire Hathaway HomeServices Kee Realty Wash
Buyer's Agent
Karen Fortuna
Century 21 Professionals Clinton
List Price
$499,900
Sold Price
$404,000
Premium/Discount to List
-$95,900
-19.18%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.99%
Original Mortgage
$303,000
Interest Rate
3.68%
Mortgage Type
New Conventional
Purchase Details
Closed on
Feb 2, 2000
Sold by
Pradko Fred
Bought by
Fattore William P
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Watts David | $545,000 | Devon Title Agency | |
| Conrad John | -- | None Available | |
| Conrad John B | $404,000 | Premier Title Agency Llc | |
| Fattore William P | $81,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Watts David | $490,500 | |
| Previous Owner | Conrad John B | $303,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 11/05/2021 11/05/21 | Sold | $545,000 | -0.9% | $107 / Sq Ft |
| 10/09/2021 10/09/21 | Pending | -- | -- | -- |
| 09/30/2021 09/30/21 | Price Changed | $550,000 | 0.0% | $108 / Sq Ft |
| 09/30/2021 09/30/21 | For Sale | $550,000 | -1.8% | $108 / Sq Ft |
| 09/12/2021 09/12/21 | Pending | -- | -- | -- |
| 08/27/2021 08/27/21 | For Sale | $560,000 | 0.0% | $110 / Sq Ft |
| 08/23/2021 08/23/21 | Pending | -- | -- | -- |
| 08/20/2021 08/20/21 | For Sale | $560,000 | +38.6% | $110 / Sq Ft |
| 04/11/2016 04/11/16 | Sold | $404,000 | -3.6% | $84 / Sq Ft |
| 02/29/2016 02/29/16 | Pending | -- | -- | -- |
| 12/07/2015 12/07/15 | Price Changed | $419,000 | -6.9% | $87 / Sq Ft |
| 11/24/2015 11/24/15 | Price Changed | $449,900 | -7.0% | $94 / Sq Ft |
| 10/19/2015 10/19/15 | Price Changed | $484,000 | -3.2% | $101 / Sq Ft |
| 09/11/2015 09/11/15 | For Sale | $499,900 | -- | $104 / Sq Ft |
Source: Michigan Multiple Listing Service
Tax History Compared to Growth
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 |
|---|---|---|---|---|
| 2025 | $10,321 | $382,800 | $0 | $0 |
| 2024 | $6,109 | $371,100 | $0 | $0 |
| 2023 | $5,786 | $322,700 | $0 | $0 |
| 2022 | $9,333 | $304,300 | $0 | $0 |
| 2021 | $7,895 | $282,100 | $0 | $0 |
| 2020 | $4,632 | $315,200 | $0 | $0 |
| 2019 | $7,228 | $273,100 | $0 | $0 |
| 2018 | $7,086 | $244,700 | $0 | $0 |
| 2017 | $7,012 | $227,600 | $33,600 | $194,000 |
| 2016 | $5,285 | $227,600 | $0 | $0 |
| 2015 | $5,209 | $216,500 | $0 | $0 |
| 2013 | $5,849 | $192,250 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Jessica Cauley Kuhn
-
J
Seller Co-Listing Agent in 2021
Jason Volltrauer
Cauley Kuhn Realty, LLC
-
Lindsay Anderson
L
Buyer's Agent in 2021
Lindsay Anderson
EXP Realty
(586) 663-5018
2 in this area
41 Total Sales
-
Katie Weaver
Seller's Agent in 2016
Katie Weaver
Berkshire Hathaway HomeServices Kee Realty Wash
(586) 331-3163
36 Total Sales
-
Karen Fortuna
Buyer's Agent in 2016
Karen Fortuna
Century 21 Professionals Clinton
(586) 994-9821
2 in this area
76 Total Sales
Map
Source: Michigan Multiple Listing Service
MLS Number: 50052247
APN: 23-07-08-279-010
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.
Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2025 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.
Nearby Homes
- 53910 Sophia Dr
- 54407 Grand Blvd
- 54413 Grand Blvd
- 54425 Grand Blvd
- 54431 Grand Blvd
- 54437 Grand Blvd
- 55330 Hanford Ct
- 54232 Mound Rd
- 5628 Skylite Ln
- 5633 Debra Rd
- 54645 Gemini Dr
- 53626 Debra Dr
- 54695 Camden Ct
- 54778 Camden Ct
- 54824 Camden Ct
- 54729 Camden Ct
- 53246 Sophia Dr
- 54808 Camden Ct
- 54815 Camden Ct
- 54714 Camden Ct
- 5565 Celestial Ct
- 5500 Woodmire Dr
- 5514 Woodmire Dr
- 5583 Celestial Ct
- 5550 Celestial Ct
- 5556 Woodmire Dr
- 5572 Celestial Ct
- 5594 Woodmire Dr
- 5532 Celestial Ct
- 5601 Celestial Ct
- 5594 Celestial Ct
- 5616 Woodmire Dr
- 5961 Woodmire Dr
- 0 Woodmire Dr
- Lot 54 Woodmire Dr
- 5501 Woodmire Dr
- 5510 Celestial Ct
- 5494 Woodmire Dr
- 5531 Woodmire Dr
- 5638 Woodmire Dr