Shirley Heseltine
Shirley A Heseltine Realty LLC
(734) 366-4736
53 Total Sales
1 in West Bloomfield Township
$384,000 Price
6237 Celeste Rd West Bloomfield, MI 48322
West Bloomfield Township NeighborhoodEstimated Value: $361,000 - $439,127
4
Beds
3.5
Baths
2,199
Sq Ft
$189/Sq Ft
Est. Value
Highlights
- Gated Community
- Ground Level Unit
- Fireplace in Basement
- Contemporary Architecture
- 2 Car Direct Access Garage
- Forced Air Heating and Cooling System
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
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
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
- Walk-Out 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
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
Closed on
Aug 8, 2023
Sold by
Bought by
Current Estimated Value
Purchase Details
Listed on
Nov 5, 2020
Closed on
Jan 20, 2021
Sold by
Bought by
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
5.52%
Original Mortgage
$261,800
Interest Rate
2.6%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 15, 1994
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in West Bloomfield Township, MI
-
Shirley Heseltine
-
Keri Sorenson
Keri Sorenson
National Realty Centers, Inc
(947) 886-8779
195 Total Sales
1 in West Bloomfield Township
$455,000 Price
-
Lorraine Gerich
Lorraine Gerich
Max Broock Realtors
(947) 210-4954
27 Total Sales
1 in West Bloomfield Township
$524,500 Price
-
Raymond Karoumy
Raymond Karoumy
Responds QuicklyTop Agent Realty
(586) 788-0902
93 Total Sales
2 in West Bloomfield Township
$705K - $790K Price Range
-
Shannon Hall
Shannon Hall
Real Estate One-Plymouth
(947) 282-9573
175 Total Sales
4 in West Bloomfield Township
$230K - $515K Price Range
-
Kevin Stewart
Kevin Stewart
Stewart Team R E Partners Inc
(586) 371-6887
147 Total Sales
1 in West Bloomfield Township
$292,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 |
|---|---|---|---|
| -- | None Listed On Document | ||
| $308,000 | None Available | ||
| $249,900 | -- |
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 |
|---|---|---|---|
| Previous Owner | $261,800 |
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 |
|---|---|---|---|---|
| 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
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 |
|---|---|---|---|---|
| 2025 | $3,379 | $181,290 | $27,000 | $154,290 |
| 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
Seller's Agent in 2021
Andrea Sims
Max Broock Realtors
(248) 613-2631
12 in this area
65 Total Sales
-
Roberta Nebus
Seller Co-Listing Agent in 2021
Roberta Nebus
Real Estate One
(248) 345-0362
1 in this area
37 Total Sales
-
Kimberly Mccree
Buyer's Agent in 2021
Kimberly Mccree
Community Choice Realty Inc
(313) 686-0710
17 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 2026 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
- 6273 Celeste Rd
- 5679 Drake Hollow Dr W
- 5666 Drake Hollow Dr E
- 5590 Hillcrest Cir W
- 5725 Ridgewood Rd
- 5601 Drake Hollow Dr W Unit 39
- 5635 Stanhope St
- 6164 Palomino Ct
- 5950 Pinetree Dr
- 6323 Drakeshire Ln
- 5675 Carlburt St
- 6580 Leytonstone Blvd
- 6580 Ridgefield Cir Unit 203
- 6606 Leytonstone Blvd
- 5510 Greenbriar Dr
- 5994 Kingsfield Dr
- 6540 Ridgefield Cir Unit 204
- 6693 Maple Lakes Dr Unit 62
- 6677 Maple Lakes Dr
- 6196 Celeste Rd Unit 78
- 6204 Celeste Rd Unit 77
- 6195 Celeste Rd
- 6335 Celeste Ct
- 6201 Celeste Rd Unit 82
- 6189 Celeste Rd
- 6207 Celeste Rd
- 6213 Celeste Rd
- 6213 Celeste Rd Unit 75
- 6333 Celeste Ct
- 6321 Celeste Ct
- 6231 Celeste Rd
- 6225 Celeste Rd
- 6219 Celeste Rd
- 6243 Celeste Rd
- 6249 Celeste Rd
- 6324 Celeste Ct
- 6324 Celeste Ct Unit 64
- 6322 Celeste Ct Unit 63
- 6336 Celeste Ct
Your Personal Tour Guide
Ask me questions while you tour the home.