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
$163Price/Sq.Ft.
$410/moHOA Dues
2 car garageParking
Listed by Dave Schneyer• Home Realty Partners
•248-973-7884 (broker)
Bought with Allan Mindell• National Realty Centers, Inc
Est. $2,471 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
$163/sq ft
Jun 26, 2026
Pending
—
Jun 22, 2026
Listed
$379,900
$172/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 #61004068
Jul 29, 2026
Sold
$360,000
$163/sq ft
Jun 26, 2026
Pending
—
Jun 22, 2026
Listed
$379,900
$172/sq ft
Jun 19, 2026
Coming Soon
$379,900
$172/sq ft
MiRealSource-MiMLS #20825576
Dec 18, 2013
Sold
$215,000
$97/sq ft
Nov 7, 2013
Listing Removed
—
Oct 24, 2013
Listed
$230,000
$104/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
$97/sq ft
Oct 24, 2013
Listed
$230,000
$104/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 Aug 13, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
# of Parking Spaces in Garage: 2
Garage Type: Attached Garage
Interior
Interior Features
# of Rooms (Total): 5
Bedroom Information
Bedroom 1 Level: Entry
Bedroom 1 Dimensions: 13 x 17
Bedroom 1 Floor Covering: Carpet
Bedroom 1 Floor Covering: Carpet
Bedroom 2 Level: Entry
Bedroom 2 Dimensions: 13 x 17
Bedroom 2 Floor Covering: Carpet
Bathroom Information
Basement
# of Bathrooms (Full): 3
# of Baths/Lavatories (Total): 3
Bathroom 1 Information
Bathroom 1 Floor Covering: Ceramic
Bathroom 1 Level: Entry
Bathroom 1 Length: 12
Bathroom 1 Width: 12
Bathroom 2 Information
Bathroom 2 Floor Covering: Ceramic
Bathroom 2 Level: Entry
Bathroom 2 Length: 15
Bathroom 2 Width: 12
Bathroom 3 Information
Bathroom 3 Floor Covering: Linoleum
Bathroom 3 Level: Basement
Bathroom 3 Length: 8
Bathroom 3 Width: 5
Laundry/Basement Information
Basement : Has Basement
Basement Type: Partially Finished
Exterior
Exterior Features
Exterior Construction: Brick
Foundation Type: Basement
Property Information
Pets Allowed: Yes
Property Type: Condominium
Structure Style: 1 Story
Year Built: 1986
Below Grade Sq. Ft.: 2212
Below Grade Sq. Ft. (Finished): 1800
Land Information
Land Contract: No
Roads: Paved Street
Financial
Tax/Assessments Information
Taxable Value: $116,935
Total Tax Amount: $3,722
Summer Tax Amount: $2,272
Winter Tax Amount: $1,450
Utilities
Utility Information
Heat/Fuel Type: Natural Gas
Water: Public Water
Heating System: Forced Air
Location
Unit 5 Information
Living Room Dimensions: L=4012
Homeowners Association Information
Has Association Fee
Fee Amount: $410
Fee Schedule: Monthly
School Information
School District: Walled Lake Cons School District
School District: Walled Lake Cons School District
Address Information
Street Designation: Road
Location Details
Directions: N of Maple S. of Walnut Lake on W side of Drake
Municipality Type: Township
Municipality: West Bloomfield Twp
Mail City: West Bloomfield
Subdivision: Manor Homes At Aldingbrooke Occpn 395
Municipality: West Bloomfield
Area (Municipality): West Bloomfield Twp (63184)
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 Aug 13, 2026
Other
Listing Information
Originating MLS: RealComp
No
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 1314
Average low and high temperatures (°F)
27
15
33
18
51
31
60
40
67
48
80
60
84
66
80
61
76
56
65
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
$379,000 – $458,000
Reach more buyers when you sell with Redfin. Plus, you'll save $3,979 in fees.