NOT LISTED FOR SALE

18524 Clairmont Cir E Northville, MI 48168

Estimated Value: $1,256,000 - $1,458,000

4 Beds
4.5 Baths
3,478 Sq Ft
$386/Sq Ft Est. Value

Last Sold November 09, 2021

Last sale price $860,000 $247 Per Sq Ft

Est. 56% increase in value since last sale

Current estimated payment $8,108/month

37 Days on Market

Highlights

  • Private Waterfront
  • Dock Facilities
  • Cape Cod Architecture
  • Ridge Wood Elementary School Rated A
  • Lake Privileges
  • Fireplace in Primary Bedroom

About This Home

As of November 2021

Recently Staged Lakefront Cape Cod in Stonewater Sub on a premium lot w/amazing lake view plus trees for privacy when enjoying the deck. Private beach with dock, 2 story foyer, 4 fireplaces, 1st floor master with glamour bath. Spacious kitchen with 42" cabinets with corian counters that opens to family room with fireplace. Princess suite with Jack and Jill bath. New dimensional roof (2016), newer hot water heater, two new ACs (2019), exterior siding painted (2021), full deck refinished and painted (2021), full brick elevation. Finished walk-out with direct access to beach and additional 2200 square foot of living space includes a full bath, rec room, exercise room, great room w/ fireplace and theater room. Immediate occupancy. All M/D approx.

Last Agent to Sell the Property

John Goodman

Century 21 Curran & Oberski License #6501250708 Listed on: 09/17/2021

Century 21 Curran & Oberski

Last Buyer's Agent

Jennifer Stelter

Michigan Premier Real Estate, LLC License #6501315841

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1999 | Remodeled in 2021

Lot Details

  • 0.36 Acre Lot
  • Lot Dimensions are 92.00x148.10
  • Private Waterfront
  • Beach Front
  • 128 Feet of Waterfront
  • Lake Front
  • Sprinkler System

HOA Fees

  • $121 Monthly HOA Fees

Home Design

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

Interior Spaces

  • 3,478 Sq Ft Home
  • 1.5-Story Property
  • Wet Bar
  • Sound System
  • Bar Fridge
  • Ceiling Fan
  • Gas Fireplace
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Security System Owned

Kitchen

  • Double Oven
  • Built-In Electric Oven
  • Gas Cooktop
  • Recirculated Exhaust Fan
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

  • Sump Pump
  • Fireplace in Basement

Parking

  • 3 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Dock Facilities
  • Lake Privileges
  • Deck
  • Exterior Lighting
  • Porch

Location

  • Ground Level

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

Community Details

  • Stonewater HOA, Phone Number (866) 788-5130
  • Stonewater Sub No 1 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 77029040084000

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,465

Year Built

Built in 1999 | Remodeled in 2021

Lot Details

0

HOA Fees

$121 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Cape Cod
  • Architecture Level: 1 1/2 Story
  • Year Built: 1999
  • State Equalized Value: 482600.0000
  • Year Renovated: 2021
  • Foundation Features: Sump Pump
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available, High Spd Internet Avail, Humidifier, Jetted Tub, Programmable Thermostat, Security Alarm (owned), Sound System, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Basement, Family Room, Living Room, Primary Bedroom
  • Room Count: 19
  • Total Bedrooms: 4
  • Total Bathrooms: 4.10
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished, Walk-Out Access
  • Kitchen Appliances: Built-In Electric Oven, Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Free-Standing Refrigerator, Gas Cooktop, Microwave, Washer, Bar Fridge
  • Sq Ft Combined: 5678
  • Sq Ft Lower Floor: 2200
  • Total Sq Ft: 3478
  • Sq Ft Total Bsmt: 2325

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: Mystic Lake
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exclusions: Yes
  • Exterior Features: Chimney Cap(s), Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 92
  • Porch Type: Deck, Porch
  • Road Frontage Type: Paved
  • Water Frontage Feet: 128.00
  • Waterfront Description: Beach Front, Lake Front, Lake Privileges, Private Water Frontage

Garage/Parking

  • Garage Size: 3 Car
  • Garage Features: Direct Access, 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: Trash
  • Association Fee Frequency: Annually
  • Phone: 8667885130
  • Association Fee: 1452
  • Association Contact: Stonewater HOA
  • Association Fee: Yes

Schools

  • School District: Northville

Lot Info

  • Homestead: Yes
  • Lot Features: Sprinkler(s)
  • Lot Size Area: 0.36
  • Lot Dimensions: 92.00X148.10
  • Parcel Number: 77029040084000

Tax Info

  • Tax Amount Summer: 8615.0000
  • Tax Amount Winter: 5850.0000
  • Total Tax: 14465.0000
  • Taxable Value: 393523.0000

Multi Family

  • Waterfront Features: Dock Facilities

MLS Schools

  • School District: Northville

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 17, 2021
Closed on
Nov 9, 2021
Sold by
Gangopadhyay Utpal and Gangopadhyay Suravi
Bought by
Shah Adityakumar and Sachdeva Moni
Seller's Agent
John Goodman
Century 21 Curran & Oberski
Buyer's Agent
Jennifer Stelter
Michigan Premier Real Estate, LLC
List Price
$925,000
Sold Price
$860,000
Premium/Discount to List
-$65,000
-7.03%
Current Estimated Value
$1,340,804

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$480,804
Avg. Annual Appreciation
11.90%

Purchase Details

Closed on
Jun 15, 2006
Sold by
Dalter Robert J and Dalter Renee
Bought by
Gangopadhyay Utpal

Purchase Details

Closed on
Aug 4, 2000
Sold by
Lumas Heritage Homes Llc
Bought by
Dalter Robert J
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
Shah Adityakumar $860,000 None Available
Gangopadhyay Utpal $825,000 Title Source Inc
Dalter Robert J -- --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/09/2021 11/09/21 Sold $860,000 -7.0% $247 / Sq Ft
10/25/2021 10/25/21 Pending -- -- --
09/17/2021 09/17/21 For Sale $925,000 -- $266 / 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
2025 $10,799 $662,900 $0 $0
2024 $10,799 $563,200 $0 $0
2023 $10,304 $481,900 $0 $0
2022 $16,322 $456,900 $0 $0
2021 $14,495 $449,700 $0 $0
2020 $14,465 $482,600 $0 $0
2019 $14,200 $471,200 $0 $0
2018 $8,068 $469,100 $0 $0
2017 $11,031 $464,400 $0 $0
2016 $13,184 $462,800 $0 $0
2015 $36,499 $452,100 $0 $0
2013 $35,359 $369,400 $0 $0
2012 $10,560 $345,300 $87,600 $257,700
Source: Public Records

Agents Affiliated with this Home

  • John Goodman

    Seller's Agent in 2021

    John Goodman

    Century 21 Curran & Oberski

    (248) 532-0608

    117 in this area

    533 Total Sales

    John Goodman
    Section Image
  • Jennifer Stelter

    Buyer's Agent in 2021

    Jennifer Stelter

    Michigan Premier Real Estate, LLC

    (248) 255-9355

    2 in this area

    26 Total Sales

    Jennifer Stelter
    Section Image

  • J

    Buyer's Agent in 2021

    Jennifer French

    Michigan Premier Real Estate, LLC

    (248) 366-1100

    1 in this area

    7 Total Sales

    Jennifer French
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 2210077284

Realcomp

APN: 77-029-04-0084-000

Michigan Wayne County Northville 48168

18524 Clairmont Cir E, Northville, MI

This home is located at 18524 Clairmont Cir E, Northville, MI 48168 since 17 September 2021 and is currently estimated at $1,340,804, approximately $385 per square foot. This property was built in 1999. 18524 Clairmont Cir E is a home located in Wayne County with nearby schools including Ridge Wood Elementary School, Hillside Middle School, and Northville High School.

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