NOT LISTED FOR SALE

Estimated Value: $655,000 - $681,308

3 Beds
2 Baths
2,122 Sq Ft
$316/Sq Ft Est. Value

Sale Details

Date Sold: January 2, 2026

Last sale price $660,000 $311 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $4,268 / mo

11 Days on Market

Highlights

  • Mud Room
  • Walk-In Pantry
  • Forced Air Heating and Cooling System
  • Indian Hills Elementary School Rated A-
  • Double Oven
  • Garage

About This Home

As of January 2026

Welcome to this truly move-in ready 8-year-old home, designed with custom details and cared for with pride. Originally built as the community’s spec home, every inch showcases thoughtful craftsmanship — from the elegant arched doorways and double step ceilings, to the convenient butler’s pantry. The open layout offers a spacious great room, double oven kitchen, first-floor laundry, walk-in pantry, and a functional mud room just off the 3-car garage. Since ownership, every update has been made with quality and style in mind. All light fixtures have been upgraded to Crate & Barrel with dimmers, the front porch was raised and finished with brick (2019), and a beautiful stamped concrete patio was added for relaxing or entertaining outdoors. The garage is a standout feature with added cabinetry and granite countertops, while extra-height toilets add comfort to the bathrooms. The hot water tank was serviced in 2024, offering peace of mind for years to come. Nestled on one of the few remaining lots that back up to a golf course in Macomb County, this home combines everyday functionality with rare scenic views. With its blend of elegance, upgrades, and unbeatable setting, this property is a rare find — ready to welcome you home.

Last Agent to Sell the Property

Jeff Glover

KW Professionals License #6501317808 Listed on: 11/11/2025

KW Professionals

Co-Listed By

Ashley Trefney

KW Professionals License #6501427729

Last Buyer's Agent

Troy Zibkowski

License #6501383573

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2016

Lot Details

  • 9,583 Sq Ft Lot
  • Lot Dimensions are 87.90x121.10

HOA Fees

  • $38 per month

Parking

  • Garage

Home Design

  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Stone Siding

Interior Spaces

  • 2,122 Sq Ft Home
  • Gas Fireplace
  • ENERGY STAR Qualified Windows
  • Mud Room
  • Great Room with Fireplace
  • Basement

Kitchen

  • Walk-In Pantry
  • Double Oven

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Utilities

  • Forced Air Heating and Cooling System
  • ENERGY STAR Qualified Air Conditioning
  • Furnace
  • Heating System Uses Natural Gas
  • ENERGY STAR Qualified Water Heater

Community Details

  • Inquire Association
  • The Orchards Hillcrest Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0421203004

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,391

Year Built

Built in 2016

Lot Details

9,583 Sq Ft Lot

HOA Fees

$38 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Year Built: 2016
  • State Equalized Value: 312400.00
  • Entry Location: GroundLevelwSteps
  • Property Sub Type: SingleFamilyResidence
  • LotSizeAcres: 0.22
  • Co List Office Mls Id: 324866
  • Co List Office Phone: 7344594700
  • Co List Office Mls Id: 324866
  • Above Grade Finished Sq Ft: 2122.00
  • Living Area: 2122.00
  • ClassName: Residential
  • ThirdPartyApprovalRequiredYN: No
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Basement: Yes
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: Gas, GreatRoom
  • Window Features: EnergyStarQualifiedWindows

Exterior Features

  • Waterfront: No
  • Foundation Details: Basement, Poured
  • Construction Materials: Brick, Stone
  • Road Frontage Type: Paved
  • Disclosures: TaxesHomesteadExempt
  • Home Warranty: No
  • Roof: Asphalt

Garage/Parking

  • Garage: Yes

Utilities

  • Cooling: CentralAir, ENERGYSTARQualifiedACEquipment
  • Heating: ENERGYSTARQualifiedFurnaceEquipment, ForcedAir, NaturalGas
  • Sewer: PublicSewer
  • Water Heater Fuel: ENERGYSTARQualifiedWaterHeater, NaturalGas
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fee Includes: SnowRemoval
  • Association Fee Frequency: Annually
  • Association Contact: Inquire

Schools

  • Junior High Dist: Romeo

Lot Info

  • Lot Dimensions: 87.90x121.10
  • Parcel Number: 0421203004
  • Land Lease Expiration Date: 2026-04-03

Tax Info

  • Tax Amount Summer: 5067.00
  • Tax Amount Winter: 2324.00
  • Tax Annual Amount: 7391.00

Multi Family

  • Above Grade Finished Area Units: SquareFeet

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 11, 2025
Closed on
Jan 2, 2026
Sold by
Bought by
Seller's Agent
Jeff Glover
KW Professionals
Buyer's Agent
Troy Zibkowski
List Price
$715,000
Sold Price
$660,000
Premium/Discount to List
-$55,000
-7.69%
Views
40
Current Estimated Value
$669,577

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$9,577
Avg. Annual Appreciation
2.76%

Purchase Details

Closed on
Sep 13, 2018
Sold by
Bought by

Purchase Details

Listed on
Dec 28, 2017
Closed on
Jun 29, 2018
Sold by
Bought by
Seller's Agent
Julie Garrisi
Brookstone, Realtors LLC
Buyer's Agent
Julie Garrisi
Brookstone, Realtors LLC
List Price
$449,900
Sold Price
$425,000
Premium/Discount to List
-$24,900
-5.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
5.81%
Original Mortgage
$336,000
Interest Rate
0.045%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$660,000 None Listed On Document
-- None Available
$425,000 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Previous Owner $336,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/02/2026 01/02/26 Sold $660,000 -7.7% $311 / Sq Ft
11/25/2025 11/25/25 Pending -- -- --
11/14/2025 11/14/25 For Sale $715,000 +68.2% $337 / Sq Ft
06/29/2018 06/29/18 Sold $425,000 -4.5% $205 / Sq Ft View Prior Sale
05/14/2018 05/14/18 Pending -- -- --
04/24/2018 04/24/18 Price Changed $444,900 -1.1% $214 / Sq Ft
12/28/2017 12/28/17 For Sale $449,900 -- $217 / Sq Ft
Source: Realcomp

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $7,375 $335,100 $0 $0
2025 $5,067 $312,400 $0 $0
2024 $48 $295,800 $0 $0
2023 $4,665 $267,700 $0 $0
2022 $6,482 $223,500 $0 $0
2021 $6,340 $215,500 $0 $0
2020 $4,319 $198,000 $0 $0
2019 $5,965 $199,200 $0 $0
2018 $8,575 $201,100 $0 $0
2017 $1,555 $47,500 $0 $0
2016 $1,540 $47,500 $0 $0
2015 -- $32,300 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20251053222

Realcomp

APN: 24-04-21-203-004

Your Personal Tour Guide

Ask me questions while you tour the home.