Petra Mattern
KW Showcase Realty
(248) 406-6904
24 Total Sales
7 in West Bloomfield Township
$325K - $620K Price Range
6231 Celeste Rd West Bloomfield, MI 48322
West Bloomfield Township NeighborhoodEstimated Value: $422,201
3
Beds
3
Baths
2,308
Sq Ft
30.61
Acre Lot
Highlights
- Deck
- Raised Ranch Architecture
- Porch
- Walled Lake Central High School Rated A-
- 2 Car Direct Access Garage
- Patio
About This Home
As of October 2013A must see Condominium in Aldenbrooke, one of West Bloomfield's premier communities. Lofted Ceilings, Crown Moldings, Marble, etc. 3 Bedrooms with a custom designed ENTRY level Master bedroom, walk-ins and bath. 2 full bathrooms, paneled library and a full deck overlooking the woods. Walkout Basement. A perfect home for busy Execs.. or retirees looking for quite seclusion yet offering plenty of room for the children and grandchildren when they visit.
Last Buyer's Agent
Jonathan Kello
Temporary Inactive Users License #RCO
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
Property Details
Home Type
- Condominium
Est. Annual Taxes
Year Built
- Built in 1986
Lot Details
- Gated Home
HOA Fees
- $410 Monthly HOA Fees
Home Design
- Raised Ranch Architecture
- Brick Exterior Construction
Interior Spaces
- 2,308 Sq Ft Home
- Living Room with Fireplace
- Partially Finished Basement
- Walk-Out Basement
Kitchen
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
- 3 Full Bathrooms
Laundry
- Dryer
- Washer
Parking
- 2 Car Direct Access Garage
- Garage Door Opener
Outdoor Features
- Deck
- Patio
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Natural Gas Water Heater
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number 1829251077
Community Details
Overview
- Manor Homes At Aldingbrooke Occpn 395 Subdivision
- On-Site Maintenance
Pet Policy
- Pets Allowed
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
Oct 20, 2014
Sold by
Glowacki James Matthew
Bought by
Current Estimated Value
Purchase Details
Listed on
Jul 18, 2013
Closed on
Oct 1, 2013
Sold by
Pyrros James
Bought by
Glowacki James M and Glowacki Lisa M
Seller's Agent
John Scott
RE/MAX Eclipse
Buyer's Agent
Jonathan Kello
Temporary Inactive Users
List Price
$249,000
Sold Price
$235,000
Premium/Discount to List
-$14,000
-5.62%
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.61%
Original Mortgage
$211,500
Interest Rate
4.58%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 31, 2006
Sold by
Pyrros James
Bought by
Pyrros James and James Pyrros Revocable Trust
Purchase Details
Closed on
Sep 13, 2005
Sold by
Pyrros James and Pyrros Christopher S
Bought by
Pyrros James
Purchase Details
Closed on
Mar 26, 2004
Sold by
Pyrros Gus
Bought by
Pyrros Gus and Gus Pyrros Revocable Trust Agreement
Home Values in the Area
Average Home Value in this Area
Agents Specializing in West Bloomfield Township, MI
-
Petra Mattern
-
Robert Prior
Robert Prior
Real Broker, LLC
(947) 219-0470
32 Total Sales
1 in West Bloomfield Township
$1,315,000 Price
-
Jonathan Pan
Jonathan Pan
KW Professionals
(947) 219-0909
59 Total Sales
2 in West Bloomfield Township
$268K - $380K Price Range
-
Ana Skidmore
Ana Skidmore
@properties Christie's Int'lAA
(734) 390-4679
39 Total Sales
1 in West Bloomfield Township
$379,900 Price
-
Ray Ashley
Ray Ashley
Coldwell Banker Town & Country
(810) 775-4839
53 Total Sales
2 in West Bloomfield Township
$500K - $576K Price Range
-
Jamie Scheett
Jamie Scheett
Responds QuicklyEpique Realty
(947) 500-6618
110 Total Sales
2 in West Bloomfield Township
$180K - $199K Price Range
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 Available | ||
| Glowacki James M | $235,000 | Embassy Title Agency Inc | |
| Pyrros James | -- | None Available | |
| Pyrros James | -- | -- | |
| Pyrros Gus | -- | -- |
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 | $170,000 | ||
| Closed | Glowacki James M | $211,500 |
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 |
|---|---|---|---|---|
| 10/02/2013 10/02/13 | Sold | $235,000 | -5.6% | $102 / Sq Ft |
| 10/01/2013 10/01/13 | Pending | -- | -- | -- |
| 07/18/2013 07/18/13 | For Sale | $249,000 | -- | $108 / 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 | $2,590 | $192,390 | $27,000 | $165,390 |
| 2024 | $2,515 | $189,720 | $0 | $0 |
| 2022 | $2,371 | $163,270 | $27,000 | $136,270 |
| 2021 | $3,899 | $156,470 | $0 | $0 |
| 2020 | $2,343 | $155,690 | $27,450 | $128,240 |
| 2018 | $3,796 | $142,140 | $27,450 | $114,690 |
| 2015 | -- | $108,370 | $0 | $0 |
| 2014 | -- | $102,270 | $0 | $0 |
| 2011 | -- | $104,770 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
John Scott
Seller's Agent in 2013
John Scott
RE/MAX
(248) 310-1946
14 Total Sales
-
JK
Buyer's Agent in 2013
Jonathan Kello
Temporary Inactive Users
Map
Source: Realcomp
MLS Number: 213071093
APN: 18-29-251-077
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
- 6273 Celeste Rd
- 6196 Celeste Rd
- 5655 Hillcrest Cir E Unit 60
- 5995 Bella Vista Dr
- 5590 Hillcrest Cir W
- 5610 Hillcrest Cir W
- 5663 Hillcrest Cir E Unit 64
- 5635 Stanhope St
- 5515 Walnut Cir W Unit 42
- 5612 Stanhope St
- 5679 Drake Hollow Dr W
- 5555 Stanhope St
- 6520 Brockhurst Blvd
- 6164 Palomino Ct
- 5725 Ridgewood Rd
- 5950 Pinetree Dr
- 5675 Carlburt St
- 6122 Trailwood Ln
- 6250 Walnut Lake Rd
- 6323 Drakeshire Ln
- 6338 Celeste Rd Unit 47
- 6196 Celeste Rd Unit 78
- 6201 Celeste Rd Unit 82
- 6195 Celeste Rd
- 6189 Celeste Rd
- 6207 Celeste Rd
- 6213 Celeste Rd
- 6219 Celeste Rd
- 6225 Celeste Rd
- 6243 Celeste Rd
- 6321 Celeste Ct
- 6333 Celeste Ct
- 6340 Celeste Ct
- 6336 Celeste Ct
- 6322 Celeste Ct Unit 63
- 6249 Celeste Rd
- 6255 Celeste Rd
- 6261 Celeste Rd
- 6267 Celeste Rd Unit 59
- 6279 Celeste Rd
Your Personal Tour Guide
Ask me questions while you tour the home.