Seller's Agent in 2019
Laurie Koblin Glass
Max Broock, REALTORS®-Birmingham
(248) 644-6700
16 in this area
348 Total Sales
6338 Celeste Rd Unit 47 West Bloomfield, MI 48322
Estimated Value: $385,000 - $428,000
3
Beds
2.5
Baths
2,212
Sq Ft
$450/mo
HOA Fee
Highlights
- Gated Community
- Deck
- Corner Lot
- Walled Lake Central High School Rated A-
- Contemporary Architecture
- 2 Car Direct Access Garage
About This Home
As of April 2019FANTASTIC detached end-unit condo in the gated Aldingbrooke Community! Over 4000 square feet of living space, 3 bedrooms and 2.1 baths. Huge great room has soaring ceiling, gas fireplace, floor-to-ceiling windows, large dining room and wet bar. White center-island kitchen has tons of cabinetry and large 12 x 10 eat in area that walks out to spacious deck for grilling and entertaining. 1st Floor master suite is a huge 400 sq. ft. retreat with 2 walk-in closets, tons of built-in cabinetry, and bath with double sinks, jetted tub and stand alone shower. Office/den has built-in wall unit and plantation shutters. Fabulously finished walk-out lower level is huge, with high ceilings, family room with wet bar, 2 additional bedrooms that have tons of closet space, a large bathroom, and storage room with great built-in shelving. 1st floor laundry/mudroom leads to attached 2-car garage. Move right into this fabulous and spacious condo with a great location in a wonderful community!
Last Agent to Sell the Property
Max Broock, REALTORS®-Birmingham License #6506047370 Listed on: 01/03/2019
Property Details
Home Type
- Condominium
Est. Annual Taxes
Year Built
- Built in 1986
Lot Details
- Private Entrance
- Gated Home
HOA Fees
- $450 Monthly HOA Fees
Home Design
- Contemporary Architecture
- Ranch Style House
- Brick Exterior Construction
- Poured Concrete
- Asphalt Roof
Interior Spaces
- 2,212 Sq Ft Home
- Gas Fireplace
- Family Room with Fireplace
- Security System Owned
- Dryer
- Finished Basement
Kitchen
- Microwave
- Dishwasher
- Disposal
Bedrooms and Bathrooms
- 3 Bedrooms
Parking
- 2 Car Direct Access Garage
- Garage Door Opener
Outdoor Features
- Deck
- Exterior Lighting
- Porch
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- Heating System Uses Natural Gas
- Natural Gas Water Heater
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number 1829251052
Community Details
Overview
- Harriman & Assoc. Association, Phone Number (734) 459-5440
- Manor Homes At Aldingbrooke Occpn 395 Subdivision
- On-Site Maintenance
Security
- Gated Community
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Nov 5, 2024
Sold by
Sriro Michael and Sriro Michael A
Bought by
Andrea F Sriro Living Trust and Sriro
Current Estimated Value
Purchase Details
Listed on
Jan 3, 2019
Closed on
Apr 1, 2019
Sold by
Schiff Marilyn
Bought by
Sriro Michael and Sriro Andrea
Seller's Agent
Laurie Koblin Glass
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Dana Cooper
Max Broock, REALTORS®-Birmingham
List Price
$307,000
Sold Price
$270,000
Premium/Discount to List
-$37,000
-12.05%
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.38%
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 |
|---|---|---|---|
| Andrea F Sriro Living Trust | -- | None Listed On Document | |
| Andrea F Sriro Living Trust | -- | None Listed On Document | |
| Sriro Michael | $270,000 | None Available |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 04/01/2019 04/01/19 | Sold | $270,000 | -9.7% | $122 / Sq Ft |
| 03/12/2019 03/12/19 | Pending | -- | -- | -- |
| 02/01/2019 02/01/19 | Price Changed | $299,000 | -2.6% | $135 / Sq Ft |
| 01/03/2019 01/03/19 | For Sale | $307,000 | -- | $139 / 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,593 | $197,170 | $0 | $0 |
| 2022 | $3,387 | $169,320 | $27,000 | $142,320 |
| 2021 | $5,570 | $162,210 | $0 | $0 |
| 2020 | $3,377 | $161,380 | $27,450 | $133,930 |
| 2018 | $5,191 | $144,530 | $27,450 | $117,080 |
| 2015 | -- | $110,630 | $0 | $0 |
| 2014 | -- | $104,400 | $0 | $0 |
| 2011 | -- | $106,960 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Laurie Koblin Glass
-
Dana Cooper
Seller Co-Listing Agent in 2019
Dana Cooper
Max Broock, REALTORS®-Birmingham
(248) 658-8030
18 in this area
364 Total Sales
-
Laurie Glass
L
Buyer Co-Listing Agent in 2019
Laurie Glass
Max Broock, REALTORS®-Birmingham
(248) 217-8237
1 in this area
104 Total Sales
Map
Source: Realcomp
MLS Number: 218118851
APN: 18-29-251-052
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
- 6319 Celeste Rd
- 6196 Celeste Rd
- 6579 Noble Rd
- 5611 Hillcrest Cir W Unit 50
- 5676 Hillcrest Cir E
- 5608 Hillcrest Cir W Unit 80
- 5959 Bella Vista Dr
- 6127 Wincliff Dr
- 5615 Carlburt St
- VL Leytonstone Blvd
- 6207 Timberwood N
- 5965 Crestwood Dr
- 5570 Wildrose Ave
- 5835 Drake Rd
- 0000 Blue Jay Way
- 6740 Ridgefield Cir Unit 103
- 6910 Leytonstone Blvd
- 6540 Ridgefield Cir Unit 204
- 5493 S Piccadilly
- 6693 Maple Lakes Dr Unit 62
- 6338 Celeste Rd
- 6332 Celeste Rd
- 6326 Celeste Rd
- 6320 Celeste Rd
- 6339 Tumbrage Ct Unit 39
- 6337 Celeste Rd
- 6337 Celeste Rd Unit 51
- 6331 Celeste Rd
- 6339 Tumbrage Ct Unit 39
- 6339 Tumbrage Ct
- 6339 Tumbrage Ct Unit 39
- 6325 Celeste Rd
- 6333 Tumbrage Ct
- 6291 Celeste Rd Unit 55
- 6327 Tumbrage Ct
- 6303 Tumbrage Ct Unit 45
- 6297 Tumbrage Ct
- 6309 Tumbrage Ct
- 6285 Celeste Rd Unit 56
- 6315 Tumbrage Ct