NOT LISTED FOR SALE

18401 Aqua Dr Macomb, MI 48042

Estimated Value: $492,970 - $533,000

3 Beds
2.5 Baths
3,393 Sq Ft
$151/Sq Ft Est. Value

Last Sold March 28, 2024

Last sale price $485,000 $143 Per Sq Ft

Est. 6% increase in value since last sale

Current estimated payment $3,093/month

4 Days on Market

Highlights

  • Ranch Style House
  • Wood Flooring
  • Breakfast Area or Nook
  • Cathedral Ceiling
  • Den
  • Bar Fridge

About This Home

As of March 2024

Welcome to your dream home in Macomb Township! This stunning 3 bedroom full brick ranch boasts elegance and comfort throughout. Finished basement complete with a convenient half bath & wet bar! Island/barstools for extra seating. 2 full & 2 half baths! This home offers ample space for recreation and relaxation. The kitchen is a chef's delight, featuring granite countertops, stainless steel appliances, and a beautiful subway tile backsplash. Vaulted ceilings with trim, stone fireplace, wood floors in office/den and a stamped concrete patio. Several upgrades throughout! Upgraded landscaping, sump pump w/ water backup, and Ring cameras surrounding the home will stay. Electrical vehicle charger/panel in the garage. Home backs up to a walking path for the subdivision. Don't miss your chance to own this meticulously maintained, super clean home—schedule your showing today and make it yours!

Last Agent to Sell the Property

Tina Pichette

RE/MAX First License #MISPE-6501268080 Listed on: 02/10/2024

RE/MAX First

Co-Listed By

Justin Pichette

RE/MAX First License #MISPE-6501393853

Last Buyer's Agent

John Maya

KW Domain License #6501426165

KW Domain

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2018

Lot Details

  • 0.25 Acre Lot
  • Lot Dimensions are 70 x 123
  • Sprinkler System

HOA Fees

  • $25 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • Bar Fridge
  • Cathedral Ceiling
  • Gas Fireplace
  • Window Treatments
  • Great Room with Fireplace
  • Den
  • Finished Basement
  • Sump Pump

Kitchen

  • Breakfast Area or Nook
  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level

Parking

  • 2.5 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Porch

Utilities

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

Community Details

  • Www.Cpmsupport.Com HOA
  • Clearstone Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 20-08-05-226-008

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,606

Year Built

Built in 2018

Lot Details

0

HOA Fees

$25 per month

Listing Details

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

Interior Features

  • Interior Amenities: Cable/Internet Avail., Cathedral/Vaulted Ceiling, Ceramic Floors, Sump Pump, Walk-In Closet, Window Treatment(s)
  • Appliances: Bar-Refrigerator, Dishwasher, Disposal, Microwave, Range/Oven, Refrigerator
  • Fireplace: Yes
  • Fireplaces: Grt Rm Fireplace, Gas Fireplace
  • Basement: Yes
  • Basement: Finished, Poured, Sump Pump
  • Bedrooms: 3
  • Bedroom 1: On 1st Floor, Dimensions: 15 x 14
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 1st Floor, Dimensions: 13 x 11
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On 1st Floor, Dimensions: 12 x 11
  • Bedroom 3 Floor Covering: Carpet
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Bathroom 1: Dimensions: 8 x 5, On Level: First, Flooring: Ceramic
  • Bathroom 2: Dimensions: 9 x 9, On Level: First, Flooring: Ceramic
  • Room Types: Den/Study/Lib, First Flr Lavatory, First Flr Full Bathroom, Primary Bdrm Suite, Breakfast Nook/Room, Pantry
  • Breakfast Nook: On 1st Floor, Dimensions: 15 x 14
  • Breakfast Nook Floor Covering: Ceramic
  • Great Room: On 1st Floor, Dimensions: 19 x 18
  • Great Room Floor Covering: Carpet
  • Kitchen: On 1st Floor, Dimensions: 14 x 11
  • Kitchen Floor Covering: Ceramic
  • Laundry: On 1st Floor, Dimensions: 7 x 6
  • Laundry Room Floor Covering: Ceramic
  • Library Den: On 1st Floor, Dimensions: 10 x 9
  • Library Den Floor Covering: Wood
  • Below Grade Sq Ft: 1893
  • Finished Below Grade Sq Ft: 1500
  • Above Grade Finished Sq Ft: 1893
  • Total Finished Sq Ft: 3393
  • Half Bathrooms: 1

Exterior Features

  • Exterior: Brick
  • Exterior Features: Lawn Sprinkler, Patio, Porch, Street Lights
  • Foundation: Basement
  • Frontage: 70
  • Road: City/County
  • Frontage Type: Road

Garage/Parking

  • Garage: Gar Door Opener, Attached Garage, Electric in Garage
  • Garage Spaces: 2.5
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 300
  • HOA Fee Frequency: Yearly
  • Association Contact: www.cpmsupport.com
  • Association Phone: 596-907-0820
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 20-08-05-226-008
  • Lot Dimensions: 70 X 123
  • Acreage: 0.25
  • Geo Subdivision: MI

Rental Info

  • Pets Allowed: Yes

Tax Info

  • Summer Tax: Year: 2023, Amount: $3,496.41
  • Winter Tax: Year: 2023, Amount: $2,109.78
  • Total Tax: Amount: $5,606.19

MLS Schools

  • School District: New Haven Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 10, 2024
Closed on
Mar 27, 2024
Sold by
Shore Jamie M and Shore Shelby D
Bought by
Koria Ashur
Seller's Agent
Tina Pichette
RE/MAX First
Buyer's Agent
John Maya
KW Domain
List Price
$479,500
Sold Price
$485,000
Premium/Discount to List
$5,500
1.15%
Views
144
Current Estimated Value
$512,493

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$27,493
Avg. Annual Appreciation
3.09%
Original Mortgage
$388,000
Outstanding Balance
$382,225
Interest Rate
6.9%
Mortgage Type
New Conventional
Estimated Equity
$130,268

Purchase Details

Listed on
Oct 23, 2018
Closed on
May 8, 2019
Sold by
Golden Homes Inc
Bought by
Shore Jamie M and Shore Shelby D
Seller's Agent
Anna Gallo
Keller Williams Paint Creek
Buyer's Agent
Rick Stitzel
Real Living Great Lakes RE-Roch
List Price
$339,900
Sold Price
$336,000
Premium/Discount to List
-$3,900
-1.15%

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.81%
Original Mortgage
$266,000
Interest Rate
4.1%
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

Date Buyer Sale Price Title Company
Koria Ashur $485,000 Visionary Title
Koria Ashur $485,000 Visionary Title
Shore Jamie M $336,000 Ata National Title Group Llc
Golden Homes Inc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Koria Ashur $388,000
Closed Koria Ashur $388,000
Previous Owner Golden Homes Inc $266,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/28/2024 03/28/24 Sold $485,000 +1.1% $143 / Sq Ft
02/14/2024 02/14/24 Pending -- -- --
02/10/2024 02/10/24 For Sale $479,500 +42.7% $141 / Sq Ft
05/14/2019 05/14/19 Sold $336,000 -0.7% $61 / Sq Ft View Prior Sale
03/24/2019 03/24/19 Pending -- -- --
03/22/2019 03/22/19 Price Changed $338,500 +0.5% $61 / Sq Ft
11/05/2018 11/05/18 Price Changed $336,900 -0.9% $61 / Sq Ft
10/23/2018 10/23/18 For Sale $339,900 -- $61 / 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,672 $227,600 $0 $0
2024 $37 $221,500 $0 $0
2023 $3,496 $206,600 $0 $0
2022 $5,331 $173,300 $0 $0
2021 $5,178 $161,500 $0 $0
2020 $3,171 $153,100 $0 $0
2019 $317 $145,300 $0 $0
2018 $716 $45,800 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Michigan Multiple Listing Service

MLS Number: 50133239

Michigan Multiple Listing Service

APN: 20-08-05-226-008