NOT LISTED FOR SALE

6338 Celeste Rd Unit 47 West Bloomfield, MI 48322

Estimated Value: $377,000 - $421,000

3 Beds
2.5 Baths
2,212 Sq Ft
$450/mo HOA Fee

Last Sold April 01, 2019

Last sale price $270,000 $122 Per Sq Ft

Est. 47% increase in value since last sale

Current estimated payment $2,961/month

68 Days on Market

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 2019

FANTASTIC 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 Listed By

Laurie Koblin Glass

Max Broock, REALTORS®-Birmingham License #6506047370 Listed on: 01/03/2019

Max Broock, REALTORS®-Birmingham

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

Property Details

Home Type

Condominium

Est. Annual Taxes

$5,170

Year Built

Built in 1986

Lot Details

0

HOA Fees

$450 per month

Listing Details

  • Property Type: Condominium
  • Architecture Style: Contemporary, Ranch
  • Architecture Level: 1 Story
  • Year Built: 1986
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available, Humidifier, Security Alarm (owned)
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Family Room
  • Room Count: 11
  • Total Bedrooms: 3
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove
  • Sq Ft Combined: 4112
  • Sq Ft Lower Floor: 1900
  • Total Sq Ft: 2212
  • Sq Ft Total Bsmt: 2212

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exterior Features: Gate House, Grounds Maintenance, Lighting, Private Entry
  • Foundation Materials: Poured
  • Porch Type: Deck, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Direct Access, Door Opener, Electricity
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Monthly
  • Phone: 734-459-5440
  • Association Fee: 450
  • Association Contact: Harriman & Assoc.
  • Association Fee: Yes

Schools

  • School District: Walled Lake

Lot Info

  • Lot Features: Corner Lot, Gated Community
  • Parcel Number: 1829251052

Tax Info

  • Tax Amount Summer: 3800.0000
  • Tax Amount Winter: 1370.0000
  • Total Tax: 5170.0000

MLS Schools

  • School District: Walled Lake

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
Total Days on Market
68
Current Estimated Value
$397,055

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.46%

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Similar Homes in West Bloomfield, MI

  • 6196 Celeste Rd, West Bloomfield, MI 48322

    $359,900

    • 2 Beds
    • 2 Baths
    • 2,308 Sq Ft
    • 6196 Celeste Rd
    • West Bloomfield, MI

    This ranch-style condominium, situated in the secure gated community of Aldingbrooke, boasts a private entry courtyard and patio. Step into a flawlessly designed home with a grand entry foyer featuring elegant marble flooring. The spacious Living Room, adorned with a cathedral ceiling, seamlessly connects to a sizable dining room. Enjoy the sunlit kitchen and breakfast room adorned with beautiful

    Stacey Weinberg Real Broker Birmingham

    Section Image
  • 5523 Walnut Cir W, West Bloomfield, MI 48322

    $389,900

    • 3 Beds
    • 3 Baths
    • 1,604 Sq Ft
    • 5523 Walnut Cir W
    • West Bloomfield, MI

    Welcome to this Completely remodeled 3 bedroom, 3 bathroom condominium with a FINISHED WALK OUT BASEMENT. Nested in a prime West Bloomfield area, the exquisite condo offers the perfect blend of modern luxury. Enjoy an open floor plan with dramatic vaulted ceilings in the living room and master bedroom, plenty of natural sunlight, and a private patio. The kitchen has been remodeled with white

    Charles Tamou Top Agent Realty

    Section Image
  • 6715 Maple Lakes Dr Unit 70, West Bloomfield, MI 48322

    $315,000

    • 3 Beds
    • 3 Baths
    • 1,958 Sq Ft
    • 6715 Maple Lakes Dr
    • Unit 70
    • West Bloomfield, MI

    Exciting updates for 2024 make this condo a true gem! Picture stunning new laminate floors, fresh paint, and stylish new bathroom cabinetry. The heart of the home shines with newer granite countertops and elegant kitchen cabinets featuring a lovely stone backsplash. With an impressive 1,958 square feet of living space plus an additional 700 square feet in the beautifully newly finished basement,

    Francine Houseworth RE/MAX Classic

    Section Image
  • 5059 Pheasant Cove, West Bloomfield, MI 48323

    $435,000

    • 2 Beds
    • 2.5 Baths
    • 1,881 Sq Ft
    • 5059 Pheasant Cove
    • West Bloomfield, MI

    Discover this incredible tunrkey detached ranch in the Lagoons of West Bloomfield. Seller has just painted interior, added Quartz countertops in the kitchen and baths with square sinks and new faucets. It is designed for comfort and effortless entertaining The open floor plan flows seamlessly to a spacious wood deck overlooking a private, wooded backyard that overlooks the West Bloomfield trail

    Beth Borson National Realty Centers, Inc

    Section Image
  • 6202 Andrea Ln Unit 52, West Bloomfield, MI 48322

    $334,900

    • 3 Beds
    • 2.5 Baths
    • 1,716 Sq Ft
    • 6202 Andrea Ln
    • Unit 52
    • West Bloomfield, MI

    An exceptional, move-in ready condo in West Bloomfield, this home has been completely remodeled with quality, care, and style. The front door faces east, filling the kitchen and dining area with warm morning light a perfect start to each day. Every detail has been thoughtfully updated, starting with all new Wallside windows and sliding doors (2023), backed by a lifetime warranty. Inside, you’ll

    Teodora Djourova Clients First, REALTORS®

    Section Image
  • 6685 Heron Point, West Bloomfield, MI 48323

    $419,900

    • 3 Beds
    • 3.5 Baths
    • 2,780 Sq Ft
    • 6685 Heron Point
    • West Bloomfield, MI

    Nature Lover's Dream in the Heart of West Bloomfield!Don't miss out on this stunning detached condo in the Lagoons of West Bloomfield — an exceptional blend of serene nature and luxurious living! Nestled along Pontiac Trail and Halsted, this 2,800 sq ft gem offers 3 spacious bedrooms and 3.5 baths, all with breathtaking views and elegant finishes.Step inside to a grand great room with soaring

    Stephen Chenault Real Estate One-Plymouth

    Section Image
  • 6830 Heron Point Unit 8, West Bloomfield, MI 48323

    $414,900

    • 2 Beds
    • 2.5 Baths
    • 1,961 Sq Ft
    • 6830 Heron Point
    • Unit 8
    • West Bloomfield, MI

    This stunning freestanding ranch-style condo, nestled in a private setting with scenic views of the woods in highly desirable Lagoons of West Bloomfield! The beautifully landscaped property features 2 bedrooms, 2.5 bathrooms, and a library that could easily be converted into a third bedroom. A welcoming entryway with a vaulted ceiling and skylight leads into the spacious great room, which boasts

    Violetta Vilenchuk Michigan First Realty LLC

    Section Image
  • 7355 Sherwood Creek Ct, West Bloomfield, MI 48322

    $368,500

    • 3 Beds
    • 2 Baths
    • 1,932 Sq Ft
    • 7355 Sherwood Creek Ct
    • West Bloomfield, MI

    BEST LOCATION IN THE COMPLEX !!! THIS IS MORE LIKE A PRIVATE HOME THEN A Maintenance FREE condo! Huge private back yard faces a wooded area with no neighbors. Expansive deck for relaxing or entertaining. Discover this beautifully condominium located in the desirable area of West Bloomfield. (Home 2 doors down sold in December for $410k, this is a better location) This residence offers a

    Steven Koleno Beycome Brokerage Realty LLC

    Section Image
  • 7863 Woodingham, West Bloomfield, MI 48322

    $355,000

    • 3 Beds
    • 3 Baths
    • 2,531 Sq Ft
    • 7863 Woodingham
    • West Bloomfield, MI

    Welcome to this recently updated 3 bedroom 3 bath end unit, condo located inside Maple Place Woods. Kitchen boasts new countertops, stainless steel appliances and an updated backsplash. 3 full bathrooms have all been updated. Primary bedroom has ensuite as well as the 3rd lofted bedroom. Basement is set up and ready to be made your second kitchen with a bar area. Laundry room has newer washer and

    Erika Orr Fathom Realty

    Section Image
See All Homes in West Bloomfield

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

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

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Spiro Michael $209,000
Previous Owner Schiff Marilyn $244,000
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

Source: Public Records

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

    Seller's Agent in 2019

    Laurie Koblin Glass

    Max Broock, REALTORS®-Birmingham

    (248) 644-6700

    15 in this area

    347 Total Sales

    Laurie Koblin Glass
    Section Image
  • Dana Cooper

    Seller Co-Listing Agent in 2019

    Dana Cooper

    Max Broock, REALTORS®-Birmingham

    (248) 658-8030

    16 in this area

    363 Total Sales

    Dana Cooper
    Section Image

  • L

    Buyer Co-Listing Agent in 2019

    Laurie Glass

    Max Broock, REALTORS®-Birmingham

    (248) 217-8237

    1 in this area

    123 Total Sales

    Laurie Glass
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 218118851

Realcomp

APN: 18-29-251-052

Michigan Oakland County West Bloomfield Township

6338 Celeste Rd Unit 47, West Bloomfield Township, MI

Homes for Sale in West Bloomfield, MI

This home is located at 6338 Celeste Rd Unit 47, West Bloomfield, MI 48322 since 03 January 2019 and is currently estimated at $397,055, approximately $179 per square foot. This property was built in 1986. 6338 Celeste Rd Unit 47 is a home located in Oakland County with nearby schools including Walnut Creek Middle School, Walled Lake Central High School, and The Susan And Rabbi Harold Loss Ecc.

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.

Realcomp 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