NOT LISTED FOR SALE

23451 Cliffview Ct Farmington Hills, MI 48336

Estimated Value: $398,011 - $453,000

4 Beds
3.5 Baths
2,670 Sq Ft
$158/Sq Ft Est. Value

Last Sold November 15, 2021

Last sale price $333,000 $125 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $2,714/month

2 Days on Market

Highlights

  • Built-In Refrigerator
  • Contemporary Architecture
  • Jetted Tub in Primary Bathroom
  • Deck
  • Wooded Lot
  • Ground Level Unit

About This Home

As of November 2021

Welcome home to the perfect mid-century modern, offering four bedrooms, three and a half bathrooms and a little over 2,600 square feet seated on over a half acre wooded, ravine lot with unreal views. This property boasts homeownership pride and has so much to offer including an enormous first-floor primary suite, an additional suite upstairs with an attached bath, vaulted ceilings, updated eat-in kitchen with granite countertops, two natural fireplaces, exposed brick throughout, spacious lower-level for entertaining with a designated gym area, private deck, and every room is illuminated with tons of natural light. This is a mid-century modern lover’s dream home! Schedule your showing today.

Last Agent to Sell the Property

Charles Siciliano

@properties Christie's Int'l R.E. Birmingham License #6501383141 Listed on: 09/17/2021

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

Last Buyer's Agent

Michael Burch

EXP Realty LLC License #RCO-6501401671

EXP Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1957 | Remodeled in 2010

Lot Details

  • 0.61 Acre Lot
  • Lot Dimensions are 121.00x155.00
  • Home fronts a stream
  • Property fronts a private road
  • Wooded Lot

Parking

  • Carport

Home Design

  • Contemporary Architecture
  • Split Level Home
  • Tri-Level Property
  • Block Foundation
  • Slab Foundation
  • Asphalt Roof

Interior Spaces

  • 2,670 Sq Ft Home
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Finished Basement
  • Walk-Out Basement
  • Washer

Kitchen

  • Built-In Electric Range
  • Built-In Refrigerator
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Jetted Tub in Primary Bathroom

Outdoor Features

  • Deck
  • Exterior Lighting
  • Porch

Location

  • Ground Level Unit

Utilities

  • Baseboard Heating
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Old Farm Colony No 1 Subdivision
  • Property is near a ravine

Listing and Financial Details

  • Assessor Parcel Number 2325252010

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,364

Year Built

Built in 1957 | Remodeled in 2010

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Contemporary, Split Level
  • Architecture Level: Tri-Level
  • Year Built: 1957
  • State Equalized Value: 137120.0000
  • Year Renovated: 2010
  • Entry Location: Ground Level
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 3

Interior Features

  • Interior Amenities: Cable Available, High Spd Internet Avail, Jetted Tub
  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Family Room, Living Room
  • Total Bedrooms: 4
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement Type: Finished, Walkout Access
  • Kitchen Appliances: Built-In Electric Range, Built-In Refrigerator, Dishwasher, Disposal, Washer
  • Total Sq Ft: 2670

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Slab
  • Construction Materials: Wood
  • Exterior Features: Lighting
  • Foundation Materials: Block
  • Porch Type: Deck, Porch
  • Road Frontage Type: Paved, Private
  • Waterfront Description: Stream

Garage/Parking

  • Garage Size: No Garage
  • Garage Features: Carport

Utilities

  • Heating Fuel: Natural Gas
  • Heating: Baseboard
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Community

Condo/Co-op/Association

  • Association Fee: No

Lot Info

  • Homestead: Yes
  • Lot Features: Hilly-Ravine, Wooded
  • Lot Size Area: 0.61
  • Lot Dimensions: 121.00X155.00
  • Parcel Number: 2325252010

Tax Info

  • Tax Amount Summer: 4414.0000
  • Tax Amount Winter: 950.0000
  • Total Tax: 5364.0000
  • Taxable Value: 116330.0000

MLS Schools

  • School District: Farmington

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 17, 2021
Closed on
Nov 15, 2021
Sold by
Elkjar and Brittanie
Bought by
Barnett Brian D and Barnett Roxana J
Seller's Agent
Charles Siciliano
@properties Christie's Int'l R.E. Birmingham
Buyer's Agent
Michael Burch
EXP Realty LLC
List Price
$350,000
Sold Price
$333,000
Premium/Discount to List
-$17,000
-4.86%
Current Estimated Value
$421,253

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$88,253
Avg. Annual Appreciation
6.07%

Purchase Details

Listed on
Jan 30, 2017
Closed on
Apr 20, 2017
Sold by
Daniels Gregory M
Bought by
Elkjar Christopher and Elkjar Brittanie
Seller's Agent
Jolie Warpool
Signature Sotheby's International Realty Bham
Buyer's Agent
Charles Siciliano
Good Company
List Price
$269,000
Sold Price
$254,500
Premium/Discount to List
-$14,500
-5.39%

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 27, 2015
Sold by
Daniels Dana M
Bought by
Daniels Gregory M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$176,000
Interest Rate
3.87%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 19, 2015
Sold by
Daniels Dana M and Daniels Gregory M
Bought by
Daniels Dana M and Daniels Gregory M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$176,000
Interest Rate
3.87%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 8, 2008
Sold by
Willnus Robert A
Bought by
Daniels Gregory and Vingarzan Dana

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$169,083
Interest Rate
6.55%
Mortgage Type
FHA

Purchase Details

Closed on
Apr 22, 2008
Sold by
Willnus Robert A
Bought by
Federal Home Loan Mortgage Corporation

Purchase Details

Closed on
Mar 24, 1998
Sold by
Cou Kathryn Schotthoefer
Bought by
Willnus Robert A
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
Barnett Brian D $333,000 Fidelity National Title
Elkjar Christopher $254,500 Interstate Title Inc
Daniels Gregory M -- Attorney
Daniels Dana M -- None Available
Daniels Gregory $170,000 Philip R Seaver Title Co Inc
Federal Home Loan Mortgage Corporation $192,235 None Available
Willnus Robert A $220,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Daniels Dana M $176,000
Previous Owner Daniels Gregory $169,083
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
11/15/2021 11/15/21 Sold $333,000 -4.9% $125 / Sq Ft
09/20/2021 09/20/21 Pending -- -- --
09/17/2021 09/17/21 For Sale $350,000 +37.5% $131 / Sq Ft
04/28/2017 04/28/17 Sold $254,500 -1.7% $106 / Sq Ft View Prior Sale
03/24/2017 03/24/17 Pending -- -- --
03/11/2017 03/11/17 Price Changed $259,000 -3.7% $108 / Sq Ft
01/30/2017 01/30/17 For Sale $269,000 -- $112 / 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,993 $178,320 $33,000 $145,320
2022 $5,758 $148,920 $21,990 $126,930
2021 $5,279 $137,120 $21,990 $115,130
2020 $4,399 $127,290 $21,990 $105,300
2018 $4,474 $99,110 $0 $0
2015 -- $78,640 $0 $0
2014 -- $62,670 $0 $0
2011 -- $61,630 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Charles Siciliano

    Seller's Agent in 2021

    Charles Siciliano

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

    (248) 385-7788

    4 in this area

    161 Total Sales

    Charles Siciliano
    Section Image

  • M

    Buyer's Agent in 2021

    Michael Burch

    EXP Realty LLC

    (888) 883-8509

    4 in this area

    38 Total Sales

    Michael Burch
    Section Image
  • Jolie Warpool

    Seller's Agent in 2017

    Jolie Warpool

    Signature Sotheby's International Realty Bham

    (248) 212-9080

    13 in this area

    42 Total Sales

    Jolie Warpool
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 2210076629

Realcomp

APN: 23-25-252-010

Michigan Oakland County Farmington Hills 48336

23451 Cliffview Ct, Farmington Hills, MI

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