NOT LISTED FOR SALE

40360 Prestwick Ct Unit 16 Northville, MI 48167

Estimated Value: $2,069,000 - $3,269,000

5 Beds
8 Baths
7,488 Sq Ft
$334/Sq Ft Est. Value

Last Sold March 25, 2013

Last sale price $1,718,300 $229 Per Sq Ft

Est. 46% increase in value since last sale

Current estimated payment $15,883/month

164 Days on Market

Highlights

  • Second Garage
  • 1.55 Acre Lot
  • Fireplace in Primary Bedroom
  • Novi High School Rated A+
  • Cape Cod Architecture
  • Wood Burning Stove

About This Home

As of March 2013

Luxurious details & exceptional quality in this architectural masterpiece.Located in prestigious Turnberry Estates, this home provides a stunning combination of sophistication & functionality.Luxurious master suite features his/her bathroom & closets.Gourmet kitchen w/enclosed grill room. 6 fireplaces.Huge LL w/home theater & exercise room. 2 3-car garages/workshop.A rare find in an exclusive gated subdivision.Recently appraised well over asking price

Last Agent to Sell the Property

Keith Brandt

Brandt Real Estate License #6501328150 Listed on: 10/10/2012

Co-Listed By

Lisa Brandt

Brandt Real Estate License #6501328149

Last Buyer's Agent

Todd Taliaferro

EXP Realty License #RCO-6501321161

EXP Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2000 | Remodeled in 2012

Lot Details

  • 1.55 Acre Lot
  • Lot Dimensions are 74x447x410x227
  • Property fronts a private road
  • Gated Home
  • Irregular Lot
  • Wooded Lot

HOA Fees

  • $400 Monthly HOA Fees

Home Design

  • Cape Cod Architecture
  • Brick Exterior Construction
  • Stone Siding

Interior Spaces

  • 7,488 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Sound System
  • Bar Fridge
  • Ceiling Fan
  • Wood Burning Stove
  • Gas Fireplace
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Security System Owned

Kitchen

  • Microwave
  • Freezer
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

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

Laundry

  • Dryer
  • Washer

Finished Basement

  • Fireplace in Basement
  • Natural lighting in basement

Parking

  • 6 Car Attached Garage
  • Second Garage
  • Workshop in Garage
  • Garage Door Opener

Eco-Friendly Details

  • Air Purifier

Outdoor Features

  • Balcony
  • Patio
  • Exterior Lighting
  • Porch

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 2236451016

Community Details

Overview

  • Turnberry Estates Occpn 1006 Subdivision
  • On-Site Maintenance

Amenities

  • Community Barbecue Grill

Home Details

Home Type

Single Family

Est. Annual Taxes

$26,955

Year Built

Built in 2000 | Remodeled in 2012

Lot Details

0

HOA Fees

$400 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Cape Cod
  • Architecture Level: 2 Story
  • Assessment: NONE OF RECORD
  • Year Built: 2000
  • Year Renovated: 2012
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Air Purifier, Cable Available, Humidifier, Intercom, Jetted Tub, Security Alarm (owned), Sound System, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas, Natural, Wood Stove
  • Fireplace Locations: Basement, Family Room, Great Room, Living Room, Primary Bedroom
  • Room Count: 28
  • Total Bedrooms: 5
  • Total Bathrooms: 6.20
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Daylight, Finished
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Freezer, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 12088
  • Sq Ft Lower Floor: 4600
  • Total Sq Ft: 7488
  • Sq Ft Total Bsmt: 4970

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick, Stone
  • Exterior Features: BBQ Grill, Gate House, Grounds Maintenance, Lighting
  • Frontage Feet: 74
  • Porch Type: Balcony, Patio, Porch
  • Road Frontage Type: Paved, Private, Pub. Sidewalk
  • Sideof Street: W

Garage/Parking

  • Garage Size: 6 or More
  • Garage Features: Attached, Door Opener, Side Entrance, Workshop
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee Frequency: Quarterly
  • Association Fee: 1200
  • Association Fee: No

Schools

  • School District: Novi

Lot Info

  • Homestead: Yes
  • List Price per Acre: 1209677.0000
  • Lot Features: Irregular, Wooded
  • Lot Size Area: 1.55
  • Lot Dimensions: 74X447X410X227
  • Parcel Number: 2236451016

Rental Info

  • Deposit Amount: 450000.00

Tax Info

  • Tax Amount Summer: 22355.0000
  • Tax Amount Winter: 4600.0000
  • Total Tax: 26955.0000

MLS Schools

  • School District: Novi

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 10, 2012
Closed on
Mar 22, 2013
Sold by
Tortora Kimberly
Bought by
Williams Randal E and Williams Megan R
Seller's Agent
Keith Brandt
Brandt Real Estate
Buyer's Agent
Todd Taliaferro
EXP Realty
List Price
$1,875,000
Sold Price
$1,718,300
Premium/Discount to List
-$156,700
-8.36%
Current Estimated Value
$2,502,254

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$783,954
Avg. Annual Appreciation
3.04%

Purchase Details

Closed on
Aug 28, 2009
Sold by
Countrywide Home Loans Inc
Bought by
Tortora Kimberly

Purchase Details

Closed on
Apr 29, 2008
Sold by
Losey Kenneth M and Losey Denise L
Bought by
Countrywide Home Loans Inc and Comerica Bank
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
Williams Randal E $1,718,300 Reputation First Title Agenc
Tortora Kimberly $1,200,000 Title One Inc
Countrywide Home Loans Inc $2,200,000 None Available
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/25/2013 03/25/13 Sold $1,718,300 -8.4% $229 / Sq Ft
03/23/2013 03/23/13 Pending -- -- --
10/10/2012 10/10/12 For Sale $1,875,000 -- $250 / 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
2023 $26,437 $873,690 $0 $0
2022 $30,311 $868,060 $0 $0
2020 $24,438 $981,000 $178,800 $802,200
2015 -- $799,950 $0 $0
2014 -- $723,000 $0 $0
2011 -- $832,400 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • K

    Seller's Agent in 2013

    Keith Brandt

    Brandt Real Estate

    Section Image

  • L

    Seller Co-Listing Agent in 2013

    Lisa Brandt

    Brandt Real Estate

    Section Image
  • Todd Taliaferro

    Buyer's Agent in 2013

    Todd Taliaferro

    EXP Realty

    (248) 207-9000

    4 in this area

    175 Total Sales

    Todd Taliaferro
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 212104671

Realcomp

APN: 22-36-451-016

Michigan Oakland County Northville 48167

40360 Prestwick Ct Unit 16, Northville, MI

This home is located at 40360 Prestwick Ct Unit 16, Northville, MI 48167 since 10 October 2012 and is currently estimated at $2,502,254, approximately $334 per square foot. This property was built in 2000. 40360 Prestwick Ct Unit 16 is a home located in Oakland County with nearby schools including Novi High School, Village Oaks Elementary School, and Novi Middle 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