NOT LISTED FOR SALE

21477 John Dr Macomb, MI 48044

Estimated Value: $467,000 - $506,000

3 Beds
2 Baths
1,900 Sq Ft
$257/Sq Ft Est. Value

Last Sold November 02, 2018

Last sale price $312,400 $164 Per Sq Ft

Est. 57% increase in value since last sale

Current estimated payment $2,970/month

49 Days on Market

Highlights

  • Outdoor Pool
  • Ranch Style House
  • Whirlpool Bathtub
  • Shawnee Elementary School Rated A-
  • Wood Flooring
  • Fenced Yard

About This Home

As of November 2018

Newer Macomb Ranch on large premium lot that backs up to a creek. Open floor plan with soaring ceilings, large windows and loads of natural light. Spacious great-room with wide-plank wood flooring & corner gas fireplace opens to Large kitchen with Enormous island, Mission style cabinetry, Stainless appliances, Granite counters, Back-splash, Walk-in Pantry, Generous eating area, Command center and Drop Zone. Large Master Suite with Trey Ceiling, Walk-in closet, Master Bath with dual vanities, Whirlpool Tub, large Shower with Seat. Two more bedrooms with a Jack-n-Jill bath. Basement is extra deep with egress window & Prepped for an Additional Bathroom, 3 car garage, fenced backyard, Home is tucked away in the neighborhood & within walking distance to the elementary school.

Last Agent to Sell the Property

Kimberly Drescher

Real Estate One Inc-Shelby License #MISPE-6506046883 Listed on: 08/08/2018

Real Estate One Inc-Shelby

Last Buyer's Agent

Marianna Ruffino

Realty Executives Home Towne License #MISPE-6501390972

Realty Executives Home Towne

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2010

Lot Details

  • 9,148 Sq Ft Lot
  • Lot Dimensions are 70 x 130
  • Fenced Yard
  • Sprinkler System

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • 1,900 Sq Ft Home
  • Ceiling height of 9 feet or more
  • Gas Fireplace
  • Entryway
  • Family Room with Fireplace
  • Wood Flooring
  • Unfinished Basement
  • Sump Pump

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Whirlpool Bathtub
  • Hydromassage or Jetted Bathtub

Laundry

  • Laundry Room
  • Dryer
  • Washer

Pool

  • Outdoor Pool

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Gas Water Heater
  • Internet Available

Community Details

  • Gateway Farms Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 20-08-22-401-020

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,766

Year Built

Built in 2010

Lot Details

0

HOA Fees

$8 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • Total Tax Amount: 3766
  • Total Tax Year: 2017
  • Year Built: 2010
  • Mail City: Macomb Twp
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: 9 ft + Ceilings, Cable/Internet Avail., Hardwood Floors, Spa/Jetted Tub, Sump Pump, Walk-In Closet
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: FamRoom Fireplace, Gas Fireplace
  • Basement: Yes
  • Basement: Poured, Sump Pump, Unfinished
  • Bedrooms: 3
  • Bedroom 1: On Entry Level, Dimensions: 12 x 16
  • Bedroom 2: On Entry Level, Dimensions: 12 x 11
  • Bedroom 3: On Entry Level, Dimensions: 12 x 11
  • Bathrooms Description: Whirlpool/Hot Tub
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Room Types: Entry, First Floor Bedroom, First Floor Laundry, First Flr Primary Bedroom, Utility/Laundry Room, Primary Bedroom, Primary Bathroom
  • Breakfast Nook: On Entry Level, Dimensions: 12 x 11
  • Family Room: On Entry Level, Dimensions: 16 x 20
  • Kitchen: On Entry Level, Dimensions: 12 x 12
  • Other Room1: On Level: Second
  • Below Grade Sq Ft: 1900
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 1900
  • Total Finished Sq Ft: 1900

Exterior Features

  • Pool: Yes
  • Exterior: Brick
  • Exterior Features: Fenced Yard, Lawn Sprinkler
  • Foundation: Basement
  • Frontage: 70

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 3
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas, Tankless Hot Water
  • Cooling: Central A/C

Condo/Co-op/Association

  • HOA Fees: 100
  • HOA Fee Frequency: Yearly
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 20-08-22-401-020
  • Zoning: Residential
  • Lot Description: Large Lot - 65+ Ft.
  • Lot Dimensions: 70 x 130
  • Acreage: 0.21
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2017, Amount: $2,763.00
  • Winter Tax: Year: 2017, Amount: $1,003.00
  • Total Tax: Year: 2017, Amount: $3,766.00

MLS Schools

  • School District: Chippewa Valley Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 8, 2018
Closed on
Nov 2, 2018
Sold by
Hinchliffe Robert J
Bought by
Cercone Vincenzo
Seller's Agent
Kimberly Drescher
Real Estate One Inc-Shelby
Buyer's Agent
Marianna Ruffino
Realty Executives Home Towne
List Price
$329,900
Sold Price
$312,400
Premium/Discount to List
-$17,500
-5.3%
Current Estimated Value
$491,352

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$178,952
Avg. Annual Appreciation
6.43%
Original Mortgage
$168,000
Outstanding Balance
$105,827
Interest Rate
4.7%
Mortgage Type
New Conventional
Estimated Equity
$382,602

Purchase Details

Closed on
Jan 18, 2011
Sold by
Gemini Homes Incorporated
Bought by
Hinchliffe Robert J

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 20, 2009
Sold by
Cf Bancorp Mortgage Company Llc
Bought by
Gemini Homes Inc

Purchase Details

Closed on
Apr 2, 2009
Sold by
Madison Homes Inc
Bought by
Citizens First Mortgage Llc

Purchase Details

Closed on
May 5, 2004
Sold by
Polarity Development Co Llc
Bought by
Madison Homes Inc
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

Date Buyer Sale Price Title Company
Cercone Vincenzo $312,400 First American Title Insuran
Planet Home Lending Llc $240,000 None Available
Hinchliffe Robert J $234,717 Greco
Gemini Homes Inc $139,300 Cfs Title Insurance Agency
Citizens First Mortgage Llc $98,925 Cfs Title Insurance Agency
Madison Homes Inc $89,000 Greco
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Cercone Vincenzo $168,000
Previous Owner Hinchliffe Robert J $228,766
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/02/2018 11/02/18 Sold $312,400 -2.3% $164 / Sq Ft
09/26/2018 09/26/18 Pending -- -- --
09/25/2018 09/25/18 Price Changed $319,900 -3.0% $168 / Sq Ft
09/23/2018 09/23/18 For Sale $329,900 0.0% $174 / Sq Ft
09/13/2018 09/13/18 Pending -- -- --
09/10/2018 09/10/18 For Sale $329,900 0.0% $174 / Sq Ft
08/14/2018 08/14/18 Pending -- -- --
08/11/2018 08/11/18 Price Changed $329,900 -2.7% $174 / Sq Ft
08/08/2018 08/08/18 For Sale $339,000 -- $178 / Sq Ft
Source: Michigan Multiple Listing Service

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
2025 $4,656 $222,900 $0 $0
2024 $4,527 $218,000 $0 $0
2023 $4,294 $200,600 $0 $0
2022 $5,415 $178,300 $0 $0
2021 $5,261 $168,700 $0 $0
2020 $3,837 $159,500 $0 $0
2019 $4,747 $149,300 $0 $0
2018 $5,945 $144,000 $0 $0
2017 $3,766 $137,270 $32,500 $104,770
2016 $4,325 $137,270 $0 $0
2015 $3,530 $127,380 $0 $0
2014 $3,530 $115,410 $21,500 $93,910
2013 $2,557 $115,410 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31356460

Michigan Multiple Listing Service

APN: 20-08-22-401-020