Welcome to the highly sought-after Aldingbrooke Condominium Community in West Bloomfield. This detached, end-unit ranch home offers over 2,200 square feet of main-level living space, plus more than 1,800 additional square feet in the finished lower level. The spacious main floor features a large primary suite complete with a private full bath, two walk-in closets, and a dedicated vanity area. A guest bedroom and a generous study—easily adaptable as a third bedroom—provide flexibility for family, guests, or a home office. The home's entrance is tucked behind a private gated courtyard, creating a charming outdoor retreat perfect for morning coffee or evening relaxation. Inside, a welcoming foyer opens to a light-filled great room with soaring vaulted ceilings, a cozy fireplace, and an adjoining dining area highlighted by a Tiffany-style chandelier and wet bar. The adjacent kitchen includes a breakfast nook and direct access to a new deck, offering additional space for everyday living and entertaining. A second full bathroom is conveniently located near the guest bedroom, study, and kitchen. Brand-new carpeting has just been installed throughout the main level. The finished lower level adds substantial living space, featuring two additional rooms, a third full bathroom, and a large open recreation or gathering area. An expansive unfinished storage space provides plenty of room for seasonal items and household storage. The attached two-car garage offers convenient access and ample parking. Immediate occupancy is available. The Manor Homes at Aldingbrooke is a gated community ideally located near the JCC of Metropolitan Detroit, Temple Israel, and Tam-O-Shanter Country Club. With quick access to M-5, Northwestern Highway, and I-696, commuting throughout the metro area is convenient and efficient.
CondoProperty Type
1986Year Built
$90Price/Sq.Ft.
$410/moHOA Dues
2 car garageParking
Listed by David Schneyer• Home Realty Partners
Bought with Allan Mindell• National Realty Centers, Inc
Est. $2,519 per month, based on comparable rentals
Sale and tax history for 6190 Celeste Rd
Sale History
Tax History
Date
Event
Price
REALCOMP #20261035481
Jul 29, 2026
Sold
$360,000
$90/sq ft
Jun 26, 2026
Pending
—
Jun 22, 2026
Listed
$379,900
$95/sq ft
MiRealSource-MiMLS #61004068
Jul 29, 2026
Sold
$360,000
$90/sq ft
Jun 26, 2026
Pending
—
Jun 22, 2026
Listed
$379,900
$95/sq ft
Jun 19, 2026
Coming Soon
$379,900
$95/sq ft
Welcome to the highly sought-after Aldingbrooke Condominium Community in West Bloomfield. This detached, end-unit ranch home offers over 2,200 square feet of main-level living space, plus more than 1,800 additional square feet in the finished lower level. The spacious main floor features a large primary suite complete with a private full bath, two walk-in closets, and a dedicated vanity area. A guest bedroom and a generous study--easily adaptable as a third bedroom--provide flexibility for family, guests, or a home office. The home's entrance is tucked behind a private gated courtyard, creating a charming outdoor retreat perfect for morning coffee or evening relaxation. Inside, a welcoming foyer opens to a light-filled great room with soaring vaulted ceilings, a cozy fireplace, and an adjoining dining area highlighted by a Tiffany-style chandelier and wet bar. The adjacent kitchen includes a breakfast nook and direct access to a new deck, offering additional space for everyday living and entertaining. A second full bathroom is conveniently located near the guest bedroom, study, and kitchen. Brand-new carpeting has just been installed throughout the main level. The finished lower level adds substantial living space, featuring two additional rooms, a third full bathroom, and a large open recreation or gathering area. An expansive unfinished storage space provides plenty of room for seasonal items and household storage. The attached two-car garage offers convenient access and ample parking. Immediate occupancy is available. The Manor Homes at Aldingbrooke is a gated community ideally located near the JCC of Metropolitan Detroit, Temple Israel, and Tam-O-Shanter Country Club. With quick access to M-5, Northwestern Highway, and I-696, commuting throughout the metro area is convenient and efficient.
MiRealSource-MiMLS #20825576
Dec 18, 2013
Sold
$215,000
$54/sq ft
Nov 7, 2013
Listing Removed
—
Oct 24, 2013
Listed
$230,000
$57/sq ft
H & B DUE 11-05 6PM. FREE STANDING, RANCH condo in Aldingbrook! Open floor plan. 2 bedrooms plus a den, w/ 3 full baths. Den has closets & can easily be converted to a 3rd bedroom. Large living room w/ wet bar. Master bedroom has a shower & tub, double vanity. 2 walk in closets. 1st fl laundry Large eat in kitchen w/ a sunny deck. Lower finished family room w/ a full bath, plus 2 full rooms for exercise or office. Tons of storage! Gated Community.
REALCOMP #213110377
Dec 18, 2013
Sold
$215,000
$54/sq ft
Oct 24, 2013
Listed
$230,000
$57/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$3,922 (−2.3%)
2024
$4,014 (+3.5%)
2023
$3,880 (+16.8%)
2022
$3,322 (−1.8%)
2021
$3,382 (+0.8%)
2020
$3,355 (+1.6%)
2019
$3,302 (+0.3%)
2018
$3,292 (+1.3%)
2017
$3,249 (+0.2%)
2016
$3,242 (−0.8%)
2015
$3,269
2014
$3,266
Public record
Beds
2
Baths
2
Stories
1
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
2,212
Year built
1986
Style
Condo/Co-op
County
Oakland County
APN
X -18-29-251-084
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Nov 5, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking Features: Attached
Interior
Bathroom Information
# of Full Bathrooms: 3
Heating & Cooling
Cooling: None
Has Heating
Heating: Forced Air, Natural Gas
Room Information
# of Rooms Total: 2
Has Basement
Basement Details: Partially Finished
Exterior
Building Information
Entry Location: GroundLevelwSteps
Above Grade Finished Area: 2,212
Above Grade Finished Area Units: Square Feet
Below Grade Finished Area: 1,800
Levels: One
Construction Materials: Brick
Foundation Details: Brick/Mortar
Property Features
Pets Allowed: Yes
Property Information
Property Type: Residential
Property Sub Type: Condominium
Raw Mls Property Sub Type: Condominium
Lot Information
Road Surface Type: Paved
Lot Size Units: Acres
Financial
Tax Information
Tax Annual Amount: $3,722
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Location
HOA Information
Has Homeowners Association
Association Fee: $410
Association Fee Frequency: Monthly
Derived Association Fee (Monthly): $410
Schools Information
High School District: WalledLake
Location Information
Directions: N of Maple S. of Walnut Lake on W side of Drake
Subdivision Name: MANOR HOMES AT ALDINGBROOKE OCCPN 395
Cross Street: W Drake N Maple
Public facts
Beds: 2
Baths: 2.0
Sq. Ft.: 2,212
Stories: 1.0
Lot Size: —
Style: Condo/Co-op
Year Built: 1986
Year Renovated: —
County: Oakland County
APN: X -18-29-251-084
Home facts updated by county records on Nov 5, 2026
Other
Listing Information
List AOR: RealcompIILtd
Around this home
Schools
Pleasant Lake Elementary School
Public K-5 • Assigned • 1.2mi
7/10
Walnut Creek Middle School
Public 6-8 • Assigned • 1.5mi
8/10
Walled Lake Central High School
Public 9-12 • Assigned • 3.8mi
6/10
Provided by GreatSchools
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
West Bloomfield, MI • 48322
Average low and high temperatures (°F)
27°
15°
33°
18°
51°
31°
60°
40°
67°
48°
80°
60°
85°
66°
79°
60°
76°
55°
64°
45°
49°
36°
35°
23°
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
78/ 100
Good sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.4 hrs
4.7 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$385,000 – $466,000
Reach more buyers when you sell with Redfin. Plus, you'll save $4,045 in fees.