NOT LISTED FOR SALE

37697 Mckenzie Ct Unit 14 Farmington Hills, MI 48331

Estimated Value: $588,000 - $651,000

5 Beds
3.5 Baths
3,019 Sq Ft
$209/Sq Ft Est. Value

Last Sold October 31, 2018

Last sale price $442,500 $147 Per Sq Ft

Est. 43% increase in value since last sale

Current estimated payment $4,330/month

26 Days on Market

Highlights

  • Colonial Architecture
  • Deck
  • Bar Fridge
  • Hillside Elementary School Rated A-
  • 2 Car Direct Access Garage
  • Fireplace in Basement

About This Home

As of October 2018

Welcome to 37697 McKenzie! This expansive and open-floorplan colonial totals over 4,200 of finished space! Welcomed by an inviting and grand 2-story foyer, the 1st floor flows perfectly and is featured by a large kitchen that overlooks a breakfast nook and family room - the perfect place for entertaining and hanging out! Off the back of the kitchen is an large deck where you can enjoy the beautiful scenery. Off the attached 2 car garage is a 1st floor laundry room and mud room. Upstairs are 4 perfectly sized bedrooms highlighted by an amazing master suite with generous master bathroom. The large finished lower level has a large media room, bar area, gym/rec room, 5th bedroom and full bathroom. Even a door-wall that allows you access the serene and secluded backyard! This home truly has it all! All measurements approx, BATVAI

Last Agent to Sell the Property

Sam Kaplunov

@properties Christie's Int'l R.E. Birmingham License #6501371423 Listed on: 08/31/2018

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

Last Buyer's Agent

Non Participant

Non Realcomp Office License #RCO

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1996

HOA Fees

  • $40 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • 3,019 Sq Ft Home
  • 2-Story Property
  • Bar Fridge
  • Gas Fireplace
  • Family Room with Fireplace
  • Washer

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms

Finished Basement

  • Walk-Out Basement
  • Sump Pump
  • Fireplace in Basement
  • Natural lighting in basement

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Deck

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • High Speed Internet

Community Details

  • Halstead Commons Condo Subdivision

Listing and Financial Details

  • Assessor Parcel Number 2307227026

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,964

Year Built

Built in 1996

Lot Details

0

HOA Fees

$40 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Assessment: 66.17
  • Year Built: 1996
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: High Spd Internet Avail
  • Fireplace: Yes
  • Fireplace Fuel: Gas, Natural
  • Fireplace Locations: Basement, Family Room
  • Room Count: 14
  • Total Bedrooms: 5
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Daylight, Finished, Walkout Access
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 4219
  • Sq Ft Lower Floor: 1200
  • Total Sq Ft: 3019
  • Sq Ft Total Bsmt: 1504

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exclusions: Yes
  • Foundation Materials: Poured
  • Frontage Feet: 128
  • Porch Type: Deck
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Direct Access, Door Opener, Electricity
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Association Fee: 475
  • Association Fee: Yes

Schools

  • School District: Farmington

Lot Info

  • Homestead: Yes
  • Lot Dimensions: Irregular
  • Parcel Number: 2307227026

Tax Info

  • Tax Amount Summer: 5638.0000
  • Tax Amount Winter: 1326.0000
  • Total Tax: 6964.0000

MLS Schools

  • School District: Farmington

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 24, 2020
Sold by
Passalacqua Bartolomeo and Passalacqua Aditi
Bought by
Johnson Robert and Johnson Mattie
Total Days on Market
26
Current Estimated Value
$630,952

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$517,998
Outstanding Balance
$465,658
Interest Rate
3%
Mortgage Type
VA
Estimated Equity
$165,294

Purchase Details

Listed on
Aug 31, 2018
Closed on
Oct 31, 2018
Sold by
Stanley Michael T and Stanley Elizabeth G
Bought by
Passalacqua Bartolomeo and Passalacqua Aditi
Seller's Agent
Sam Kaplunov
@properties Christie's Int'l R.E. Birmingham
Buyer's Agent
Non Participant
Non Realcomp Office
List Price
$469,900
Sold Price
$442,500
Premium/Discount to List
-$27,400
-5.83%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.53%
Original Mortgage
$398,250
Interest Rate
4.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 31, 2008
Sold by
Zughaib Marcel E and Zughaib Valerie S
Bought by
Stanley Michael T and Stanley Elizabeth G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$205,000
Interest Rate
6.39%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Similar Homes in Farmington Hills, MI

  • 34601 Brittany Dr, Farmington Hills, MI 48335

    $475,000

    • 4 Beds
    • 3 Baths
    • 1,988 Sq Ft
    • 34601 Brittany Dr
    • Farmington Hills, MI

    One of the highlights of this home is its peaceful setting and thoughtful design. It sits on a large lot backing up to the Heritage Park Nature Center, offering daily views of nature and added privacy. A spacious circular driveway makes for easy access and a warm welcome. Inside, the open-concept kitchen and living area are filled with natural light, creating a cozy and inviting space. Located in

    Kevin DeVergilio REALTEAM Real Estate

    Section Image
  • 38049 Lantern Hill Ct, Farmington Hills, MI 48331

    $715,000

    • 4 Beds
    • 3.5 Baths
    • 3,224 Sq Ft
    • 38049 Lantern Hill Ct
    • Farmington Hills, MI

    Spacious home that checks all the boxes. Large Primary suite with large Primary Bath including both jetted tub and shower, two sinks. Large entry hall with dramatic winding staircase. Island Kitchen with double ovens and refrigerator with "flex" drawer. Door walls to large deck overlooking wooded yard. Finished walkout basement with lots of unfinished storage space as well. Licensed Real Estate

    Paul Schwartz Schwartz Properties LLC

    Section Image
  • 38585 Horton Dr, Farmington Hills, MI 48331

    $585,000

    • 3 Beds
    • 3.5 Baths
    • 4,021 Sq Ft
    • 38585 Horton Dr
    • Farmington Hills, MI

    Stunning Home in Farmington Hills! This exceptional home in the sought-after and prestigious Strathmoor subdivision boasts a grand foyer leading to a spacious great room featuring a cathedral ceiling and marble fireplace. A versatile large flex room, perfect as a library or office, offers hardwood floors and elegant crown molding. The gourmet kitchen is a chef's dream with a generous eating area,

    Stanislav Leynzon Seller Nation

    Section Image
  • 30546 Knighton Dr, Farmington Hills, MI 48331

    $650,000

    • 5 Beds
    • 3.5 Baths
    • 2,664 Sq Ft
    • 30546 Knighton Dr
    • Farmington Hills, MI

    Welcome to 30546 Knighton Drive, a beautifully maintained and professionally updated colonial on a quiet street in the Country Ridge subdivision of Farmington Hills (Walled Lake School District). From the moment you arrive, you will appreciate the curb appeal as you observe the striking combination of brick and blue-toned Hardie Board siding (2016), enhanced by updated windows (2016 & 2021), and

    Mark Brown @properties Christie's Int'l RE Northville

    Section Image
  • 29580 Kenloch Dr, Farmington Hills, MI 48331

    $699,000

    • 6 Beds
    • 4.5 Baths
    • 4,004 Sq Ft
    • 29580 Kenloch Dr
    • Farmington Hills, MI

    This exceptional custom-made colonial home on a quiet Cul-De-Sac is hallmarked by sweeping views of serene Pond and water, it is one of only few large homes in the area that feature 6-bedrooms & 4 1/2 bathrooms with a finished walkout basement on the pond, it offers unique views to water from most rooms. The spacious custom kitchen comes with solid wood cabinets, pull out pantry shelves, and

    Sam Amona New Michigan Realty, LLC

    Section Image
  • 30645 Turtle Creek, Farmington Hills, MI 48331

    $526,000

    • 5 Beds
    • 4.5 Baths
    • 3,914 Sq Ft
    • 30645 Turtle Creek
    • Farmington Hills, MI

    Welcome to this one-owner 5BR, 4BA Colonial in the exclusive gated Ramblewood community. This light-filled home backs to serene woods and offers space, comfort, and privacy. The main level features a cozy living room with fireplace, spacious kitchen with pantry, formal dining, home office, family room, laundry, and mudroom to the large garage. Upstairs, the primary suite boasts a huge walk-in

    Thomas Gilliam RE/MAX Classic

    Section Image
  • 30797 Country Ridge Cir, Farmington Hills, MI 48331

    $749,000

    • 5 Beds
    • 3.5 Baths
    • 3,018 Sq Ft
    • 30797 Country Ridge Cir
    • Farmington Hills, MI

    Spacious Colonial in the prestigious Country Ridge Subdivision Welcome to this beautifully updated colonial-style home offering a total of 4,818 sq ft of finished living space, including a fully finished walkout basement. Located at the center of a cul-de-sac. During the subdivision’s construction, this home was the model for the community that showed thoughtful design, quality finishes, and

    Jeffry Kermath Kermath Realty LLC

    Section Image
  • 38996 Holsworth Ct, Farmington Hills, MI 48331

    $625,000

    • 4 Beds
    • 4.5 Baths
    • 2,485 Sq Ft
    • 38996 Holsworth Ct
    • Farmington Hills, MI

    THIS BEAUTIFULLY REMODELED AND FULLY UPDATED HOME LOCATED IN WALLED SCHOOL DISTRICT, HAS A NEW FIRST FLOOR PRIMARY SUITE AND SO MUCH MORE! If you are looking for that "move in ready home", that features 4 bedrooms, including a first floor Primary Suite, you owe it to yourself to view this gorgeous house! The first floor Primary Suite and Open Concept Kitchen/Dining/Living space is all new and

    Tom Gaunt KW Showcase Realty

    Section Image
  • 30886 Huntsman Dr E, Farmington Hills, MI 48331

    $549,900

    • 4 Beds
    • 5 Baths
    • 2,872 Sq Ft
    • 30886 Huntsman Dr E
    • Farmington Hills, MI

    Stunning Custom Ranch in Rolling Oaks West!This exquisite custom-built ranch home in the highly desirable Rolling Oaks West neighborhood offers privacy, comfort, and elegance. The expansive backyard with wooded views and a spacious deck is perfect for outdoor relaxation. Inside, the open-concept great room and dining room has 12’ ft. ceilings, and an abundance of windows streaming with natural

    Anita Blender Blender Realty LLC

    Section Image
See All Homes in Farmington Hills

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
Johnson Robert $499,999 Century Title Agency Svcs
Passalacqua Bartolomeo $442,500 Equity Title Agency Llc
Stanley Michael T $405,000 Title Express Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Johnson Robert $517,998
Previous Owner Passalacqua Bartolomeo $398,250
Previous Owner Stanley Michael T $170,000
Previous Owner Stanley Michael T $201,000
Previous Owner Stanley Michael T $205,000
Previous Owner Zughaib Marcel E $250,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/31/2018 10/31/18 Sold $442,500 -5.8% $147 / Sq Ft
09/26/2018 09/26/18 Pending -- -- --
08/31/2018 08/31/18 For Sale $469,900 -- $156 / 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 $8,971 $289,090 $55,000 $234,090
2022 $8,619 $242,310 $38,030 $204,280
2021 $12,296 $215,800 $38,030 $177,770
2020 $8,139 $217,350 $38,030 $179,320
2018 $7,127 $198,470 $0 $0
2015 -- $186,100 $0 $0
2014 -- $176,870 $0 $0
2011 -- $169,060 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Sam Kaplunov

    Seller's Agent in 2018

    Sam Kaplunov

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

    (248) 933-0471

    211 Total Sales

    Sam Kaplunov
    Section Image

  • N

    Buyer's Agent in 2018

    Non Participant

    Non Realcomp Office

  • U

    Buyer's Agent in 2018

    Unidentified Agent

    Unidentified Office

See All Agents

Map

Source: Realcomp

MLS Number: 218085207

Realcomp

APN: 23-07-227-026

Michigan Oakland County Farmington Hills 48331

37697 Mckenzie Ct Unit 14, Farmington Hills, MI

This home is located at 37697 Mckenzie Ct Unit 14, Farmington Hills, MI 48331 since 31 August 2018 and is currently estimated at $630,952, approximately $208 per square foot. This property was built in 1996. 37697 Mckenzie Ct Unit 14 is a home located in Oakland County with nearby schools including Hillside Elementary School, East Middle School, and North Farmington 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