Seller's Agent in 2021
Andrea Sims
Max Broock Realtors
(248) 613-2631
13 in this area
82 Total Sales
6237 Celeste Rd West Bloomfield, MI 48322
Estimated Value: $411,000 - $429,000
4
Beds
3.5
Baths
2,199
Sq Ft
$191/Sq Ft
Est. Value
Highlights
- Gated Community
- Contemporary Architecture
- 2 Car Direct Access Garage
- Walled Lake Central High School Rated A-
- Ground Level Unit
- Fireplace in Basement
About This Home
As of January 2021Welcome to this hard to find 1st floor master detached condo in a gated community. Walk into the huge great room with soaring ceilings. Neutral kitchen and 1st floor laundry. Spacious 1st floor master suite with large walk in closet. Additional 2 bedrooms and full bath upstairs. Large walk out lower level with kitchen, bedroom, and full bath. Plenty of storage too!
All measurements are approximate. Buyers/Buyer's agent to verify all information. Masks must be worn throughout all showings.
Last Agent to Sell the Property
Max Broock Realtors License #6501387924 Listed on: 11/05/2020
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 1986
Lot Details
- Property fronts a private road
- Gated Home
HOA Fees
- $450 Monthly HOA Fees
Home Design
- Contemporary Architecture
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
Interior Spaces
- 2,199 Sq Ft Home
- 2-Story Property
- Gas Fireplace
- Great Room with Fireplace
Kitchen
- Free-Standing Electric Oven
- Electric Cooktop
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
Laundry
- Dryer
- Washer
Finished Basement
- Sump Pump
- Fireplace in Basement
Parking
- 2 Car Direct Access Garage
- Garage Door Opener
Location
- Ground Level Unit
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 1829251076
Community Details
Overview
- Herriman & Associates Association, Phone Number (734) 459-5440
- Manor Homes At Aldingbrooke Occpn 395 Subdivision
Additional Features
- Laundry Facilities
- Gated Community
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Aug 8, 2023
Sold by
Harris Brenda C
Bought by
Harris Brenda C
Current Estimated Value
Purchase Details
Listed on
Nov 5, 2020
Closed on
Jan 20, 2021
Sold by
Lewis Terry and George Lewis Irrevocable Trust
Bought by
Harris Brenda C
Seller's Agent
Andrea Sims
Max Broock Realtors
Buyer's Agent
Kimberly Mccree
Community Choice Realty Inc
List Price
$300,000
Sold Price
$308,000
Premium/Discount to List
$8,000
2.67%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.58%
Purchase Details
Closed on
Dec 15, 1994
Sold by
Weber Sanford B
Bought by
Jack Sirotkin & George Lewis Trust
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 |
|---|---|---|---|
| Harris Brenda C | -- | None Listed On Document | |
| Harris Brenda C | $308,000 | None Available | |
| Jack Sirotkin & George Lewis Trust | $249,900 | -- |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 01/20/2021 01/20/21 | Sold | $308,000 | +2.7% | $140 / Sq Ft |
| 11/08/2020 11/08/20 | Pending | -- | -- | -- |
| 11/05/2020 11/05/20 | For Sale | $300,000 | -- | $136 / Sq Ft |
Source: Realcomp
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 |
|---|---|---|---|---|
| 2024 | $3,281 | $177,460 | $0 | $0 |
| 2022 | $3,093 | $153,000 | $27,000 | $126,000 |
| 2021 | $3,263 | $146,710 | $0 | $0 |
| 2020 | $1,961 | $145,750 | $27,450 | $118,300 |
| 2018 | $3,176 | $131,030 | $27,450 | $103,580 |
| 2015 | -- | $97,870 | $0 | $0 |
| 2014 | -- | $92,360 | $0 | $0 |
| 2011 | -- | $94,620 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Andrea Sims
-
Roberta Nebus
Seller Co-Listing Agent in 2021
Roberta Nebus
Real Estate One
(248) 345-0362
9 in this area
102 Total Sales
-
Kimberly Mccree
Buyer's Agent in 2021
Kimberly Mccree
Community Choice Realty Inc
(313) 686-0710
2 in this area
59 Total Sales
Map
Source: Realcomp
MLS Number: 2200088537
APN: 18-29-251-076
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.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 6196 Celeste Rd
- 5959 Bella Vista Dr
- 5616 Hillcrest Cir W
- 6579 Noble Rd
- 5608 Hillcrest Cir W Unit 80
- 5676 Hillcrest Cir E
- 5965 Crestwood Dr
- 5727 Royal Wood
- 5835 Drake Rd
- 6740 Ridgefield Cir Unit 103
- 6540 Ridgefield Cir Unit 204
- 6693 Maple Lakes Dr Unit 62
- 6677 Maple Lakes Dr
- 6716 Maple Lakes Dr
- 6715 Maple Lakes Dr Unit 70
- 6619 Ridgefield Cir Unit 205
- 6606 Leytonstone Blvd
- VL Leytonstone Blvd
- 6433 Walnut Lake Rd
- 5570 Wildrose Ave
- 6231 Celeste Rd
- 6243 Celeste Rd
- 6249 Celeste Rd
- 6225 Celeste Rd
- 6321 Celeste Ct
- 6255 Celeste Rd
- 6333 Celeste Ct
- 6261 Celeste Rd
- 6204 Celeste Rd Unit 77
- 6219 Celeste Rd
- 6213 Celeste Rd
- 6213 Celeste Rd Unit 75
- 6322 Celeste Ct Unit 63
- 6324 Celeste Ct
- 6324 Celeste Ct Unit 64
- 6196 Celeste Rd Unit 78
- 6335 Celeste Ct
- 6207 Celeste Rd
- 6267 Celeste Rd Unit 59
- 6190 Celeste Rd