NOT LISTED FOR SALE

6189 Celeste Rd West Bloomfield, MI 48322

Estimated Value: $370,115 - $414,000

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

Last Sold June 14, 2017

Last sale price $265,500 $120 Per Sq Ft

Est. 48% increase in value since last sale

Current estimated payment $2,772/month

4 Days on Market

Highlights

  • Deck
  • Ranch Style House
  • 2 Car Direct Access Garage
  • Walled Lake Central High School Rated A-
  • Covered Patio or Porch
  • Wet Bar

About This Home

As of June 2017

NOTE: MULTIPLE OFFERS -HIGHEST & BEST DEADLINE-THURS 4/6/17 9:00 PM.FABULOUS RANCH CONDO IN DESIRABLE GATED COMMUNITY.MOSTLY NEUTRAL DECOR THRU-OUT.SPACIOUS FOYER W/TREYED CEILING,CERAMIC FLR.LOTS OF LRG WINDOWS & VAULTED CEILINGS LETS IN LIGHT & OFFERS OPEN FEELING.LR HAS GAS FP,RECESSED LIGHTS,WET BAR.GORGEOUS UPDTD KIT W/LARGE WORK ISLAND,GRANITE COUNTERS,CERAMIC BACKSPLASH,DUAL DW,COUNTER COOKTOP,DBL OVEN,WOOD FLRS,RECESSED LIGHTS,LOADS OF CABINET STORAGE BN W/WOOD FLR & DOORWALL TO DECK.1ST FLR LAUNDRY.LRG MAST SUITE W/DRESSING AREA, VLTD CEILING,HIS & HER WIC'S W/ORGANIZERS.LUXURY MAST BATH W/CERAMIC,SEP.SHOWER,DBLE SINKS. LRG WALK-IN CEDAR CLOSET.H2O-'12,GFA-'13.BACK-UP WATER SUMP PUMP.6 PANEL DRS,DEN W/CLOSET.

Last Agent to Sell the Property

Michelle Michael

RE/MAX Classic License #6502120271 Listed on: 04/03/2017

RE/MAX Classic

Last Buyer's Agent

Tony Moreno

Berkley Realty Group LLC License #6501378254

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 1986

Lot Details

  • Property fronts a private road
  • Private Entrance
  • Gated Home

HOA Fees

  • $450 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 2,212 Sq Ft Home
  • Wet Bar
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace
  • Unfinished Basement
  • Sump Pump
  • Security System Leased

Kitchen

  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Exterior Lighting

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1829251085

Community Details

Overview

  • Herriman Association, Phone Number (734) 453-5440
  • Manor Homes At Aldingbrooke Occpn 395 Subdivision
  • On-Site Maintenance

Pet Policy

  • Pets Allowed

Property Details

Home Type

Condominium

Est. Annual Taxes

$3,025

Year Built

Built in 1986

Lot Details

0

HOA Fees

$450 per month

Listing Details

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

Interior Features

  • Interior Amenities: Cable Available, High Spd Internet Avail, Humidifier, Programmable Thermostat, Security Alarm (rented), Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Living Room
  • Total Bedrooms: 2
  • Total Bathrooms: 2.00
  • Full Bathrooms: 2
  • Basement: Yes
  • Basement Type: Private, Unfinished
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Refrigerator, Range/Stove, Washer
  • Total Sq Ft: 2212

Exterior Features

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

Garage/Parking

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

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), 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-453-5440
  • Association Fee: 450
  • Association Contact: HERRIMAN
  • Association Fee: Yes

Lot Info

  • Homestead: Yes
  • Parcel Number: 1829251085

Tax Info

  • Tax Amount Summer: 1852.0000
  • Tax Amount Winter: 1173.0000
  • Total Tax: 3025.0000

MLS Schools

  • School District: Walled Lake

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 3, 2017
Closed on
Jun 14, 2017
Sold by
Klimko Thomas N and Klimko Beverly
Bought by
Friedman Martin and Friedman Marcia
Seller's Agent
Michelle Michael
RE/MAX Classic
Buyer's Agent
Tony Moreno
Berkley Realty Group LLC
List Price
$265,000
Sold Price
$265,500
Premium/Discount to List
$500
0.19%
Current Estimated Value
$393,279

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$127,779
Avg. Annual Appreciation
4.77%

Purchase Details

Closed on
Jun 29, 1998
Sold by
Mintz Neil Phillip
Bought by
Klimko Thoman N

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$214,000
Interest Rate
7.13%
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
Friedman Martin $265,500 None Available
Klimko Thoman N -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Klimko Thoman N $214,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/14/2017 06/14/17 Sold $265,500 +0.2% $120 / Sq Ft
04/07/2017 04/07/17 Pending -- -- --
04/03/2017 04/03/17 For Sale $265,000 -- $120 / 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 $2,990 $167,460 $0 $0
2022 $2,819 $144,450 $27,000 $117,450
2021 $4,636 $138,580 $0 $0
2020 $2,786 $137,980 $27,450 $110,530
2018 $4,513 $127,610 $27,450 $100,160
2015 -- $94,640 $0 $0
2014 -- $89,310 $0 $0
2011 -- $91,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • M

    Seller's Agent in 2017

    Michelle Michael

    RE/MAX of Southeast Michigan

    Section Image
  • Tony Moreno

    Buyer's Agent in 2017

    Tony Moreno

    Berkley Realty Group LLC

    (248) 514-9358

    3 in this area

    99 Total Sales

    Tony Moreno
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 217025723

Realcomp

APN: 18-29-251-085

Michigan Oakland County West Bloomfield Township

6189 Celeste Rd, West Bloomfield Township, MI

Not Listed for Sale

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