NOT LISTED FOR SALE

6213 Celeste Rd Unit 75 West Bloomfield, MI 48322

Estimated Value: $403,355 - $451,000

3 Beds
3 Baths
2,308 Sq Ft
$186/Sq Ft Est. Value

Last Sold February 13, 2017

Last sale price $308,000 $133 Per Sq Ft

Est. 40% increase in value since last sale

Current estimated payment $3,008/month

8 Days on Market

Highlights

  • Deck
  • 2 Car Direct Access Garage
  • Patio
  • Walled Lake Central High School Rated A-
  • Porch
  • Security System Owned

About This Home

As of February 2017

Immaculate detached 3 bedroom ranch condo with finished walk-out lower level backing to woods. Very spacious floor plan w/large foyer,Great Room with high ceilings and fireplace & deck overlooking the woods. Master bedroom with Master bath with tub & stall shower and very lg walk-in closet. Finished lower level with bedroom and bath and Family room w/fireplace and door wall to outside patio. Spacious Library with custom wall shelves that can house books, pictures etc. All appliances included with sale.
This condo is very well maintained and is great for entertaining. Show & Sell!!!!
Exclude side drapes in Master Bedroom.
BATVAI

Last Agent to Sell the Property

Florence Abel

Real Estate One-W Blmfld License #6502139912 Listed on: 12/20/2016

Real Estate One-W Blmfld

Last Buyer's Agent

Debbie Binder

Max Broock Realtors License #RCO-6501235983

Max Broock Realtors

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1986

Lot Details

  • Gated Home

HOA Fees

  • $450 Monthly HOA Fees

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Cedar

Interior Spaces

  • 2,308 Sq Ft Home
  • 1-Story Property
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Security System Owned

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Sump Pump

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Community Details

  • Herriman & Associates Association, Phone Number (734) 459-5440
  • Manor Homes At Aldingbrooke Occpn 395 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1829251080

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,494

Year Built

Built in 1986

Lot Details

0

HOA Fees

$450 per month

Listing Details

  • Property Type: Condominium
  • Architecture Style: Free Standing/Detached
  • Architecture Level: 1 Story
  • Year Built: 1986
  • Foundation Features: Sump Pump
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Humidifier, Security Alarm (owned)
  • Fireplace: Yes
  • Fireplace Locations: Family Room, Great Room
  • Room Count: 13
  • Total Bedrooms: 3
  • Total Bathrooms: 3.00
  • Full Bathrooms: 3
  • Basement: Yes
  • Basement Type: Finished, Walkout Access
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 4408
  • Sq Ft Lower Floor: 2100
  • Total Sq Ft: 2308
  • Sq Ft Total Bsmt: 2288

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick, Cedar
  • Exterior Features: Gate House, Lighting
  • Foundation Materials: Poured
  • Porch Type: Deck, Patio, 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: Herriman & Associates
  • Association Fee: Yes

Schools

  • School District: Walled Lake

Lot Info

  • Homestead: Yes
  • Parcel Number: 1829251080

Tax Info

  • Tax Amount Summer: 2149.0000
  • Tax Amount Winter: 1345.0000
  • Total Tax: 3494.0000

MLS Schools

  • School District: Walled Lake

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 12, 2025
Sold by
Levenson Alan and Levenson Adele
Bought by
Levenson Alan and Levenson Living Trust
Current Estimated Value
$429,839

Purchase Details

Listed on
Dec 20, 2016
Closed on
Feb 13, 2017
Sold by
The Ruth P Tobias Revocable Living Tr
Bought by
Levenson Alan and Levenson Adele
Seller's Agent
Florence Abel
Real Estate One-W Blmfld
Buyer's Agent
Debbie Binder
Max Broock Realtors
List Price
$308,000
Sold Price
$308,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.95%

Purchase Details

Closed on
Feb 17, 2004
Sold by
Tobias Ruth Podolsky and Tobias Harold S
Bought by
Tobias Ruth P and Ruth P Tobias Revocable Living Trust

Purchase Details

Closed on
May 13, 2002
Sold by
Tobias Harold S
Bought by
Harold S Tobias Tr
Source: Public Records

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

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
Levenson Alan -- None Listed On Document
Levenson Alan $308,000 None Available
Tobias Ruth P -- --
Harold S Tobias Tr -- --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/13/2017 02/13/17 Sold $308,000 0.0% $133 / Sq Ft
12/28/2016 12/28/16 Pending -- -- --
12/20/2016 12/20/16 For Sale $308,000 -- $133 / 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,357 $189,510 $0 $0
2022 $3,165 $162,960 $27,000 $135,960
2021 $5,205 $156,170 $0 $0
2020 $3,128 $155,400 $27,450 $127,950
2018 $5,028 $142,180 $27,450 $114,730
2015 -- $108,400 $0 $0
2014 -- $102,300 $0 $0
2011 -- $104,810 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 216116986

Realcomp

APN: 18-29-251-080