NOT LISTED FOR SALE

21114 Prestwick Farmington Hills, MI 48335

Estimated Value: $724,000 - $871,000

4 Beds
3.5 Baths
3,542 Sq Ft
$225/Sq Ft Est. Value

Last Sold December 02, 2022

Last sale price $729,000 $206 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $5,260/month

9 Days on Market

Highlights

  • In Ground Pool
  • Built-In Refrigerator
  • Deck
  • Power Middle School Rated A-
  • Colonial Architecture
  • Covered Patio or Porch

About This Home

As of December 2022

A beautiful 4/5 bed 3.1 bath home awaits its lucky new owner with 3,542 sf of elegant interiors, a wonderful 1,200 sf finished basement & incredible outdoor space with a private, pebble tec in-ground pool! This one-of-a-kind gem also dazzles with all new exterior paint, new lush professional landscaping, a refinished deck, large new patio, built-in outdoor propane fire pit, soothing hot tub, plus new loggia with fireplace & fridge for fabulous outdoor entertaining. The voluminous great room with towering floor-to-ceiling windows & a fireplace affords a perfect setting for the host. A formal dining room with butler’s pantry & generous chef’s kitchen with open dining optimize living comfort. Other highlights include a primary suite with dual walk-in closets & spa bath with deep soaking tub, home office, loft/bonus room off an upstairs bedroom, refinished 2nd-story deck, tons of storage, new full house generator, new central A/C units, walkout LL with a wet bar, full bath, flex room or 5th bedroom & 3-car garage!

Last Agent to Sell the Property

Dan Gutfreund

Signature Sotheby's International Realty Bham License #6501367800 Listed on: 10/28/2022

Signature Sotheby's International Realty Bham

Last Buyer's Agent

John Goodman

Century 21 Curran & Oberski License #6501250708

Century 21 Curran & Oberski

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2001

Lot Details

  • 0.32 Acre Lot
  • Lot Dimensions are 90.03 x 153.98

HOA Fees

  • $67 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 3,542 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Bar Fridge
  • Ceiling Fan
  • Double Sided Fireplace
  • Great Room with Fireplace
  • Dining Room with Fireplace
  • Security System Leased
  • Finished Basement

Kitchen

  • Double Oven
  • Gas Cooktop
  • Recirculated Exhaust Fan
  • Microwave
  • Built-In Refrigerator
  • ENERGY STAR Qualified Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • In Ground Pool
  • Deck
  • Covered Patio or Porch

Location

  • Ground Level

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 2332301066

Community Details

Overview

  • Jeff Larson Association, Phone Number (586) 850-4407
  • Applebrooke Occpn 1207 Subdivision

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,977

Year Built

Built in 2001

Lot Details

0

HOA Fees

$67 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Assessment: 69.00
  • Year Built: 2001
  • State Equalized Value: 288590.0000
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Humidifier, Security Alarm (rented), Wet Bar
  • Fireplace: Yes
  • Fireplace Locations: Dining Room, Double Sided, Great Room
  • Total Bedrooms: 4
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished, Walk-Out Access
  • Kitchen Appliances: Built-In Refrigerator, Disposal, Double Oven, Dryer, ENERGY STAR® qualified dishwasher, Exhaust Fan, Gas Cooktop, Microwave, Washer, Bar Fridge
  • Total Sq Ft: 3542

Exterior Features

  • Roof Material: Asphalt
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exclusions: Yes
  • Exterior Features: Pool - Inground
  • Foundation Materials: Poured
  • Porch Type: Deck, Patio - Covered
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 3 Car
  • Garage Features: Electricity, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Phone: 586-850-4407
  • Association Fee: 804
  • Association Contact: Jeff Larson
  • Association Fee: Yes

Lot Info

  • Lot Size Area: 0.32
  • Lot Dimensions: 90.03 x 153.98
  • Parcel Number: 2332301066

Tax Info

  • Tax Amount Summer: 9248.0000
  • Tax Amount Winter: 1729.0000
  • Total Tax: 10977.0000
  • Taxable Value: 250360.0000

MLS Schools

  • School District: Farmington

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 28, 2022
Closed on
Dec 2, 2022
Sold by
Mccormick Kayla and Mccormick William
Bought by
Istephan Steven and Abo-Shasha Randa
Seller's Agent
Dan Gutfreund
Signature Sotheby's International Realty Bham
Buyer's Agent
John Goodman
Century 21 Curran & Oberski
List Price
$729,000
Sold Price
$729,000
Views
46
Current Estimated Value
$795,217

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$66,217
Avg. Annual Appreciation
3.04%
Original Mortgage
$583,200
Outstanding Balance
$563,540
Interest Rate
6.49%
Estimated Equity
$231,677

Purchase Details

Listed on
Feb 25, 2019
Closed on
Apr 30, 2019
Sold by
Houlihan Patrick W and Buesehing Susan M
Bought by
Mccormick Kayla and Mccormick William
Seller's Agent
Jo Ann Steuwe
Prime + Property
Buyer's Agent
Rocky Fowler
Keller Williams Advantage
List Price
$589,900
Sold Price
$575,000
Premium/Discount to List
-$14,900
-2.53%

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.83%
Original Mortgage
$517,443
Interest Rate
4%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 20, 2002
Sold by
Applebrooke Millcreek
Bought by
Houlihan Patrick W

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$420,000
Interest Rate
6.79%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Nov 12, 1999
Sold by
Applebrooke Associates
Bought by
Applebrooke Millcreek
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
Istephan Steven $729,000 Interstate Title
Mccormick Kayla $575,000 None Available
Houlihan Patrick W $542,230 --
Applebrooke Millcreek $120,750 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Istephan Steven $583,200
Previous Owner Mccormick Kayla $517,443
Previous Owner Houlihan Patrick W $420,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/02/2022 12/02/22 Sold $729,000 0.0% $206 / Sq Ft
11/07/2022 11/07/22 Pending -- -- --
10/28/2022 10/28/22 For Sale $729,000 +26.8% $206 / Sq Ft
04/30/2019 04/30/19 Sold $575,000 -2.5% $162 / Sq Ft View Prior Sale
03/11/2019 03/11/19 Pending -- -- --
02/25/2019 02/25/19 For Sale $589,900 -- $167 / 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 $12,119 $338,040 $55,000 $283,040
2022 $13,628 $288,590 $45,000 $243,590
2021 $10,925 $276,760 $45,000 $231,760
2020 $9,164 $239,030 $45,000 $194,030
2018 $7,851 $239,270 $0 $0
2015 -- $225,810 $0 $0
2014 -- $203,260 $0 $0
2011 -- $156,080 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20221056275

Realcomp

APN: 23-32-301-066