NOT LISTED FOR SALE

Estimated Value: $464,000 - $940,000

3 Beds
4 Baths
2,916 Sq Ft
$450/mo HOA Fee

Last Sold July 09, 2021

Last sale price $751,000 $258 Per Sq Ft

Est. 6% decrease in value since last sale

Current estimated payment $4,856/month

10 Days on Market

Highlights

  • Cape Cod Architecture
  • Deck
  • Balcony
  • West Hills Middle School Rated A
  • Corner Lot
  • 2.5 Car Attached Garage

About This Home

As of July 2021

SPECTACULAR TRANSFORMATION ON THIS TOTALLY RENOVATED CAMEO LAKE CONDO. Stunning Glass staircase, New thermal glass door walls, Red oak wood floors, 1st floor master with opulent master bath, Built-in custom designer master closet, 2 kitchen Islands, one with granite waterfall. Top of the Line GE Cafe White appliances with gold handles. LED lighting throughout, Walls removed to create stunning, modern open floor plan, amazing natural light throughout, Gas fireplace with book matched stone facade, designer window treatments, large beautiful deck, finished basement with granite waterfall bar area. Nothing's been missed in this ready to move in GEM. Lovely community. This ones a must see!

Last Listed By

Steven Mattler

Signature Sotheby's International Realty Bham License #6501301674 Listed on: 05/29/2021

Signature Sotheby's International Realty Bham

Property Details

Home Type

  • Condominium

Est. Annual Taxes

Year Built

  • Built in 1980 | Remodeled in 2021

HOA Fees

  • $450 Monthly HOA Fees

Home Design

  • Cape Cod Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 2,916 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Gas Fireplace
  • Great Room with Fireplace
  • Partially Finished Basement
  • Sump Pump

Kitchen

  • Built-In Gas Oven
  • Gas Cooktop
  • Microwave
  • ENERGY STAR Qualified Refrigerator
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms

Parking

  • 2.5 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Balcony
  • Deck
  • Exterior Lighting

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Vented Exhaust Fan
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1813277023

Community Details

Overview

  • Metro Group Association
  • Cameo Lake Of Wabeek Occpn 252 Subdivision
  • Property is near a ravine

Amenities

  • Community Barbecue Grill

Pet Policy

  • Pets Allowed

Property Details

Home Type

Condominium

Est. Annual Taxes

$5,731

Year Built

Built in 1980 | Remodeled in 2021

Lot Details

0

HOA Fees

$450 per month

Listing Details

  • Property Type: Condominium
  • Architecture Style: Cape Cod
  • Architecture Level: 2 Story
  • Year Built: 1980
  • State Equalized Value: 229950.0000
  • Year Renovated: 2021
  • Foundation Features: Sump Pump
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Condos
  • Stories: 2

Interior Features

  • Interior Amenities: Cable Available, Humidifier
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Great Room
  • Room Count: 12
  • Total Bedrooms: 3
  • Total Bathrooms: 2.20
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Partially Finished
  • Kitchen Appliances: Vented Exhaust Fan, Built-In Gas Oven, Dishwasher, Disposal, ENERGY STAR® qualified refrigerator, Free-Standing Refrigerator, Gas Cooktop, Microwave
  • Sq Ft Combined: 3916
  • Sq Ft Lower Floor: 1000
  • Total Sq Ft: 2916
  • Sq Ft Total Bsmt: 1721

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exterior Features: BBQ Grill, Lighting
  • Foundation Materials: Poured
  • Porch Type: Balcony, Deck
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2.5 Car
  • Garage Features: Electricity, Door Opener, Attached
  • 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)

Condo/Co-op/Association

  • HOA Fee Includes: Snow Removal, Maintenance Structure, Maintenance Grounds, Trash
  • Association Fee Frequency: Monthly
  • Association Fee: 450
  • Association Contact: Metro Group
  • Association Fee: Yes

Schools

  • School District: Bloomfield Hills

Lot Info

  • Homestead: Yes
  • Lot Features: Corner Lot, Hilly-Ravine
  • Parcel Number: 1813277023

Tax Info

  • Tax Amount Summer: 2963.0000
  • Tax Amount Winter: 2768.0000
  • Total Tax: 5731.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 14, 2023
Sold by
Stern Norton E and Stern Sherrie M
Bought by
Stern Family Agreement Of Trust and Stern
Total Days on Market
10
Current Estimated Value
$709,172

Purchase Details

Listed on
May 29, 2021
Closed on
Jul 9, 2021
Sold by
Pam Becker Properties Llc
Bought by
Stem Norton E and Stem Sherrie M
Seller's Agent
Steven Mattler
Signature Sotheby's International Realty Bham
Buyer's Agent
Steven Mattler
Signature Sotheby's International Realty Bham
List Price
$799,900
Sold Price
$751,000
Premium/Discount to List
-$48,900
-6.11%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-1.47%
Original Mortgage
$396,000
Interest Rate
2.96%
Mortgage Type
New Conventional

Purchase Details

Listed on
Oct 19, 2020
Closed on
Nov 24, 2020
Sold by
Mellen Barbara J
Bought by
Pam Becker Properties Llc
Seller's Agent
Andrea Sims
Max Broock Realtors
Buyer's Agent
Steven Mattler
Signature Sotheby's International Realty Bham
List Price
$390,000
Sold Price
$365,000
Premium/Discount to List
-$25,000
-6.41%

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 17, 2009
Sold by
Mellen Barbara
Bought by
Mellen Barbara J and The Barbara J Mellen Living Trust

Purchase Details

Closed on
Aug 18, 2008
Sold by
Lantor Arnold and Lantor Beverly
Bought by
Mellen Barbara

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$248,000
Interest Rate
6.43%
Mortgage Type
Unknown

Purchase Details

Closed on
Jan 12, 1998
Sold by
Heller Harold
Bought by
Lantor Arnold

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 Bloomfield Hills, MI

  • 1875 Wingate Rd, Bloomfield Hills, MI 48302

    $549,000

    • 4 Beds
    • 3.5 Baths
    • 2,434 Sq Ft
    • 1875 Wingate Rd
    • Bloomfield Hills, MI

    The setting could not be more beautiful and serene - overlooking the 8th tee box, private Fox Lake and beautifully wooded backdrop. This condo is 3 stories of peaceful westerly vistas bringing the outdoors inside complementing the many luxury amenities. A two story dining / family room (with Fireplace) provides access to the expansive deck, which can also be accessed from the updated kitchen.

    Daniel Teahan The Agency Hall & Hunter

    Section Image
  • 1921 Pine Ridge Ln, Bloomfield Hills, MI 48302

    $649,900

    • 3 Beds
    • 3.5 Baths
    • 2,088 Sq Ft
    • 1921 Pine Ridge Ln
    • Bloomfield Hills, MI

    ABSOLUTELY BREATHTAKING "WABEEK PINES" MODERN RANCH END UNIT CONDO - BEAUTIFUL LOCATION BACKING TO THE "WOODS" ON THE GOLF COURSE - VERY PRIVATE - OPEN FLOWING FLOOR PLAN, AN ENTERTAINERS DREAM - GORGEOUS MASTER SUITE W/UNBELIEVABLE UPDATED BATHROOM W/NEWER 'HEATED' TILE FLOORING, FLOATING DOUBLE VANITY, FRAMELESS SHOWER DOOR SURROUND, RAINFALL & HANDHELD SHOWER, NEWER PLUMBING FIXTURES, BIDET,

    Patrick Carolan Coldwell Banker Professionals Birm

    Section Image
  • 5134 Woodlands Dr, Bloomfield Hills, MI 48302

    $599,000

    • 2 Beds
    • 3.5 Baths
    • 2,030 Sq Ft
    • 5134 Woodlands Dr
    • Bloomfield Hills, MI

    Elegant Ranch Condo in the Woodlands on Gilbert Lake – Secure, Maintenance-Free LivingWelcome to this beautifully updated 2-bedroom, 3.5-bath ranch condo, nestled within the exclusive, gated Woodlands on Gilbert Lake community in the heart of Bloomfield. Offering 2,030 sq. ft. on the main floor, this quiet, all-brick end unit promises the perfect blend of privacy, comfort, and resort-style

    Leslie Mihalak RE/MAX First

    Section Image
  • 4074 Cranbrook Ct, Bloomfield Hills, MI 48301

    $525,000

    • 2 Beds
    • 3.5 Baths
    • 2,197 Sq Ft
    • 4074 Cranbrook Ct
    • Bloomfield Hills, MI

    Tucked away at the back of the Cranbrook Chase enclave, this serene retreat stands out in a peaceful, private setting. Gorgeous hardwood floors grace the main and second levels, paired with wool carpeting on the curved staircase. The Euro-style kitchen flows seamlessly into a dining room with a new Anderson doorwall (part of a $70,000 window upgrade, March 2024) opening to a spacious private

    Jennifer Doctor The Agency Hall & Hunter

    Section Image
  • 4047 Cranbrook Ct, Bloomfield Hills, MI 48301

    $600,000

    • 3 Beds
    • 3.5 Baths
    • 2,694 Sq Ft
    • 4047 Cranbrook Ct
    • Bloomfield Hills, MI

    Discover this incredible 3-bedroom, 3.5-bath brick colonial condo in the exclusive Cranbrook Chase community! With over 2,600 square feet of finished living space, this condo impresses from the moment you enter the 2-story foyer with a striking circular staircase. The formal dining room is perfect for holidays and entertaining, while the spacious great room features soaring windows that flood the

    Robert Torrey Real Broker LLC Bloomfield

    Section Image
  • 4017 Hidden Woods Dr, Bloomfield Hills, MI 48301

    $650,000

    • 2 Beds
    • 3 Baths
    • 2,048 Sq Ft
    • 4017 Hidden Woods Dr
    • Bloomfield Hills, MI

    As you enter through the gate at Hidden Woods and wind your way deep within the community, you will find a lovely, private, and secluded setting for this fabulous end unit Ranch condo* A charming covered front Porch welcomes you to sit for a minute and enjoy the peace and tranquility of being in the woods.* Upon entering, a grand Foyer awaits, opening to a Vaulted Living Room with FP with door

    Robin Wilson Real Estate One-Troy

    Section Image
  • 2389 Hickory Glen Dr Unit F19, Bloomfield Hills, MI 48304

    $649,000

    • 2 Beds
    • 3 Baths
    • 2,460 Sq Ft
    • 2389 Hickory Glen Dr
    • Unit F19
    • Bloomfield Hills, MI

    Constructed in 2017, this modern Bloomfield Hills condo is a recent addition to the 1980s Robertson Brothers community. Nestled away for privacy, it offers tranquil woodland views. The great room showcases a cathedral ceiling and a gas fireplace, leading to a rear deck. The kitchen features hardwood floors, a gas cooktop, stainless steel appliances, and quartz countertops. You'll also find a

    Katherine Broock Max Broock, REALTORS®-Birmingham

    Section Image
  • 2408 Hickory Glen Dr, Bloomfield Hills, MI 48304

    $649,999

    • 3 Beds
    • 3 Baths
    • 1,967 Sq Ft
    • 2408 Hickory Glen Dr
    • Bloomfield Hills, MI

    Welcome to Easy Living in the Sought-After Hickory Glen Community!This beautifully maintained ranch-style condo offers the perfect mix of comfort, functionality, and modern updates. From the moment you step inside, you’ll notice the gleaming hardwood floors and open, airy layout designed for everyday living and effortless entertaining. The main level features 2 spacious bedrooms and 2 full baths,

    John Apap @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 536 Cambridge Way, Bloomfield Hills, MI 48304

    $799,000

    • 3 Beds
    • 4 Baths
    • 2,800 Sq Ft
    • 536 Cambridge Way
    • Bloomfield Hills, MI

    Amazing new price on this stunning Lakefront condo-This is an absolute entertainers dream! Premium lakefront location, with warm and elegant design, featuring an open layout with the largest floorplan in this vibrant and active community! Enjoy expansive lake views with a finished walk-out lower level, featuring a spectacular wine cellar!! 3 bedrooms, 2 full and 2 half baths- the kitchen has

    Lisa Brennan The Agency Hall & Hunter

    Section Image

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
Stern Family Agreement Of Trust -- None Listed On Document
Stem Norton E $751,000 Interstate Title Inc
Pam Becker Properties Llc $365,000 Capital Title Ins Agcy Inc
Mellen Barbara J -- None Available
Mellen Barbara $305,000 Capital Title Ins Agency
Lantor Arnold $320,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Stem Norton E $396,000
Previous Owner Mellen Barbara J $232,000
Previous Owner Mellen Barbara $248,150
Previous Owner Mellen Barbara $248,000
Previous Owner Mellen Barbara Joan $244,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/09/2021 07/09/21 Sold $751,000 -6.1% $258 / Sq Ft
06/09/2021 06/09/21 Pending -- -- --
05/29/2021 05/29/21 For Sale $799,900 +119.2% $274 / Sq Ft
11/24/2020 11/24/20 Sold $365,000 -6.4% $125 / Sq Ft
11/03/2020 11/03/20 Pending -- -- --
10/19/2020 10/19/20 For Sale $390,000 -- $134 / 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 $5,474 $332,490 $0 $0
2022 $5,297 $266,750 $30,000 $236,750
2021 $11,815 $233,610 $0 $0
2020 $3,037 $230,450 $30,000 $200,450
2018 $5,756 $205,160 $25,000 $180,160
2015 -- $173,130 $0 $0
2014 -- $157,370 $0 $0
2011 -- $140,190 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 2210040470

Realcomp

APN: 18-13-277-023