Skip main navigation
Coming soon 06/22
  • $379,900

    6190 Celeste Rd, West Bloomfield, MI 48322

    2beds
    4,012sqft
    : 
    Loading
    Get pre-qualified
    Condominium
    Built in 1986
    -- sqft lot
    $-- Zestimate®
    $95/sqft
    $410/mo HOA

    What's special

    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.
    3 days
    |
    72
    |
    2
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Dave Schneyer 248-755-1876,

    Home Realty Partners 248-973-7884

    Source: Realcomp II,MLS#: 20261035481MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 3
      • Full bathrooms: 3
      Primary bedroom
      • Level: Entry
      • Area: 221
      • Dimensions: 13 X 17
      Bedroom
      • Level: Entry
      • Area: 221
      • Dimensions: 13 X 17
      Other
      • Level: Entry
      • Area: 144
      • Dimensions: 12 X 12
      Other
      • Level: Entry
      • Area: 180
      • Dimensions: 15 X 12
      Other
      • Level: Basement
      • Area: 40
      • Dimensions: 8 X 5
      Heating
      • Forced Air, Natural Gas
      Features
      • Basement: Partially Finished
      • Has fireplace: No
      Interior area
      • Total interior livable area: 4,012 sqft
      • Finished area above ground: 2,212
      • Finished area below ground: 1,800

      Property

      Parking
      • Total spaces: 2
      • Parking features: Two Car Garage, Attached
      • Attached garage spaces: 2
      Features
      • Levels: One
      • Stories: 1
      • Entry location: GroundLevelwSteps
      Details
      • Parcel number: 1829251084
      • Special conditions: Short Sale No,Standard

      Construction

      Type & style
      • Home type: Condo
      • Architectural style: Free Standing Detached
      • Property subtype: Condominium
      Materials
      • Brick
      • Foundation: Basement, Brick Mortar
      Condition
      • New construction: No
      • Year built: 1986

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: MANOR HOMES AT ALDINGBROOKE OCCPN 395
      HOA
      • Has HOA: Yes
      • HOA fee: $410 monthly
      Location
      • Region: West Bloomfield

      Financial & listing details

      • Price per square foot: $95/sqft
      • Tax assessed value: $116,935
      • Annual tax amount: $3,722
      • Date on market: 6/22/2026
      • Cumulative days on market: 4 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $2,503/mo

        Price history

        Price history is unavailable.

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Est. payment

          Payment breakdown

          Explore the cost of this home by adjusting the details. Changes won't be saved.
          All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
          HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
          Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
          See how much you could borrow to make a competitive offer.

          Climate risks

          Neighborhood: 48322

          Getting around

          13 / 100
          Car-Dependent
          26 / 100
          Somewhat Bikeable

          Nearby schools

          GreatSchools rating

          A local agent can set up tours, give advice and negotiate with sellers.

          Browse local experts

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel