NOT LISTED FOR SALE

19788 Trilogy Dr Macomb, MI 48042

Estimated Value: $509,000 - $574,000

3 Beds
2 Baths
2,180 Sq Ft
$247/Sq Ft Est. Value

Last Sold March 25, 2020

Last sale price $356,000 $163 Per Sq Ft

Est. 51% increase in value since last sale

Current estimated payment $3,475/month

5 Days on Market

Highlights

  • Deck
  • Balcony
  • Forced Air Heating System
  • Ranch Style House
  • Porch
  • 3 Car Garage

About This Home

As of March 2020

Don't miss out on this beautiful 3 bedroom, 2.5 bath Macomb Twp Ranch. Fall in love with the Brazilian cherry wood floors / crown molding throughout / Lafayta antique white cabinets / granite countertops / stone back splash. The master features tiered ceilings with a large WIC. The master en-suite has a double vanity with plenty of space & a stone tile shower. The 2nd & 3rd bedroom have plenty of natural light & space. The den features cathedral ceilings & wainscoting. You will love the spacious great room & gas fireplace with a custom wood mantel & surround. All appliances stay (SS Appliances in kitchen & high end washer / dryer). The 3 car garage features epoxy floors and direct access to the backyard. Step out of your kitchen door wall onto a beautiful maintenance free composite wood deck. The deck has two staircases, one leads to the exposed aggregate patio. The daylight basement is just over 2,000 square feet.

Last Agent to Sell the Property

Jacques Gagnon

Realty Executives Home Towne Shelby License #MISPE-6506048144 Listed on: 02/13/2020

Realty Executives Home Towne Shelby

Last Buyer's Agent

Paul Price

John Graham Realty, LLC License #6501326542

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2007

Lot Details

  • 0.26 Acre Lot
  • Lot Dimensions are 82 x 138
  • Sprinkler System

Parking

  • 3 Car Garage

Home Design

  • 2,180 Sq Ft Home
  • Ranch Style House
  • Brick Exterior Construction

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Outdoor Features

  • Balcony
  • Deck
  • Porch

Utilities

  • Forced Air Heating System
  • Heating System Uses Natural Gas

Additional Features

  • Basement

Community Details

  • Harmony Acres Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 20-08-16-274-008

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,618

Year Built

Built in 2007

Lot Details

0

Listing Details

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

Interior Features

  • Basement: Yes
  • Bedrooms: 3
  • Bedroom 1: On Entry Level, Dimensions: 16 x 14
  • Bedroom 2: On Entry Level, Dimensions: 11 x 11
  • Bedroom 3: On Entry Level, Dimensions: 11 x 10
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Bathroom 1: On Level: Entry
  • Bathroom 2: Dimensions: 8 x 6, On Level: Entry
  • Breakfast Nook: On Entry Level, Dimensions: 14 x 12
  • Great Room: On Entry Level, Dimensions: 22 x 17
  • Kitchen: On Entry Level, Dimensions: 11 x 12
  • Laundry: On Entry Level, Dimensions: 6 x 8
  • Library Den: On Entry Level, Dimensions: 12 x 12
  • Below Grade Sq Ft: 2050
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 2180
  • Total Finished Sq Ft: 2180

Exterior Features

  • Exterior: Brick
  • Exterior Features: Exterior Balcony, Deck, Lawn Sprinkler, Porch, Sidewalks, Street Lights
  • Foundation: Basement
  • Frontage: 82

Garage/Parking

  • Garage Spaces: 3
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water

Lot Info

  • Assessor Parcel Number: 20-08-16-274-008
  • Lot Description: Large Lot - 65+ Ft.
  • Lot Dimensions: 82 x 138
  • Acreage: 0.26
  • Geo Subdivision: MI
  • Site/Lot Features: Subdivision, Walk to School

Tax Info

  • Summer Tax: Year: 2018, Amount: $2,163.00
  • Winter Tax: Year: 2018, Amount: $1,455.00
  • Total Tax: Amount: $3,618.00

MLS Schools

  • School District: New Haven Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 28, 2021
Sold by
Waterstraat John and Waterstraat Tricia
Bought by
Waterstraat John S and Waterstraat Tricia H
Current Estimated Value
$537,786

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$147,750
Outstanding Balance
$115,806
Interest Rate
2.1%
Mortgage Type
New Conventional
Estimated Equity
$419,185

Purchase Details

Listed on
Feb 13, 2020
Closed on
Mar 25, 2020
Sold by
Dipiazza Steven
Bought by
Waterstrant John and Waterstrant Tricia
Seller's Agent
Jacques Gagnon
Realty Executives Home Towne Shelby
Buyer's Agent
Paul Price
John Graham Realty, LLC
List Price
$355,000
Sold Price
$356,000
Premium/Discount to List
$1,000
0.28%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.77%
Original Mortgage
$156,000
Interest Rate
3.4%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 15, 2020
Sold by
Fry Derrick and Saputo Fry Rosemary
Bought by
Dipiazza Steven

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$325,000
Interest Rate
3.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 25, 2011
Sold by
Trentacoste Francesco T and Trentacoste Danielle N
Bought by
Fry Derrick and Saputo Fry Rosemary

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$160,000
Interest Rate
4.02%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 18, 2008
Sold by
Royal Custom Homes Inc
Bought by
Trentacoste Francesco T and Trentacoste Danielle N

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$26,000
Interest Rate
6.22%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Jan 9, 2008
Sold by
Leone Construction Inc
Bought by
Royal Custom Homes Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$26,000
Interest Rate
6.22%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
May 11, 2006
Sold by
Huntington Woods Estates Inc
Bought by
Leone Construction Inc
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
Waterstraat John S -- None Available
Waterstrant John $356,000 None Available
Dipiazza Steven $345,000 Sterling Title Agency
Fry Derrick $200,000 Premier Title Agency Llc
Trentacoste Francesco T $90,000 Greco
Royal Custom Homes Inc -- Greco
Leone Construction Inc $1,080,000 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Waterstraat John S $12,000
Open Waterstraat John S $30,000
Open Waterstraat John S $147,750
Closed Waterstraat John $156,000
Previous Owner Dipiazza Steven $325,000
Previous Owner Fry Derrick J $157,000
Previous Owner Fry Derrick J $160,000
Previous Owner Royal Custom Homes Inc $26,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/25/2020 03/25/20 Sold $356,000 +0.3% $163 / Sq Ft
02/18/2020 02/18/20 Pending -- -- --
02/13/2020 02/13/20 For Sale $355,000 -- $163 / 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 $6,610 $240,700 $0 $0
2024 $4,146 $229,000 $0 $0
2023 $3,929 $218,700 $0 $0
2022 $5,991 $187,200 $0 $0
2021 $5,829 $176,800 $0 $0
2020 $2,523 $164,200 $0 $0
2019 $3,800 $157,500 $0 $0
2018 $3,618 $149,000 $0 $0
2017 $3,546 $140,380 $32,000 $108,380
2016 $3,363 $140,380 $0 $0
2015 $3,346 $124,570 $0 $0
2014 $3,346 $114,470 $19,000 $95,470
2013 $2,014 $114,470 $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: 50005756

Michigan Multiple Listing Service

APN: 20-08-16-274-008