NOT LISTED FOR SALE

47040 Brennan Dr Unit 138 Macomb, MI 48044

Estimated Value: $512,000 - $542,000

4 Beds
2 Baths
2,833 Sq Ft
$186/Sq Ft Est. Value

Last Sold January 12, 2023

Last sale price $455,000 $161 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $3,416/month

14 Days on Market

Highlights

  • Colonial Architecture
  • Hydromassage or Jetted Bathtub
  • Bar Fridge
  • Wood Flooring
  • Fenced Yard
  • Porch

About This Home

As of January 2023

WOW -WHERE DO I BEGIN ON THIS GORGEOUS FORMER BUILDER MODEL HOME, WITH ALL THE GOOD STUFF, STARTING WITH A CHEFS KITCHEN WITH PREMIUM CABINETS, MOSAIC BACKSPLASH, GRANITE COUNTERTOPS, STAINLESS STEEL APPLIANCES, HARDWOOD FLOORS THROUGHOUT, FORMAL DINING ROOM AND FRONT LIVING ROOM WITH WAINSCOTING, PLUS HUGE DEN WITH BAR, SOARING TWO STORY CEILINGS IN GREAT ROOM, PRIMARY BEDROOM WITH FULL BATH AND LARGE WALK-IN CLOSETS, DOOR WALL LEADING TO LARGE PATIO OVERLOOKING MANICURED DEEEEEP LOT!NEW FURNACE, CENTRAL AIR SYSTEM, INGROUND SPRINKLERS, OUTSTANDING BLUE RIBBON L'ANSE CREUSE SCHOOLS, CLOSE PROXIMITY TO I-94, THIS ONE HAS WAY TOO MANY FEATURES TO LIST!!!

Last Agent to Sell the Property

Hank Mendez

Real Estate One Inc-Shelby License #MISPE-6502355303 Listed on: 11/17/2022

Real Estate One Inc-Shelby

Last Buyer's Agent

Sarmad Bahnam

Prime Elite Realty License #RCO-6501410326

Prime Elite Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2003

Lot Details

  • Lot Dimensions are 73x183
  • Fenced Yard
  • Sprinkler System

HOA Fees

  • $27 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • 2,833 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Bar Fridge
  • Window Treatments
  • Great Room with Fireplace

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

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

Laundry

  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Community Sewer or Septic
  • Internet Available

Community Details

  • Casa Bella HOA
  • Woodberry Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0826375138

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,599

Year Built

Built in 2003

Lot Details

0

HOA Fees

$27 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Year Built: 2003
  • Mail City: Macomb
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cable/Internet Avail., Ceramic Floors, Hardwood Floors, Spa/Jetted Tub, Sump Pump, Walk-In Closet, Wet Bar/Bar, Window Treatment(s)
  • Appliances: Bar-Refrigerator, Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Grt Rm Fireplace
  • Basement: Yes
  • Basement: Full, Poured
  • Bedrooms: 4
  • Bedroom 1: On Upper Floor, Dimensions: 18 x 15
  • Bedroom 2: On Upper Floor, Dimensions: 14 x 10
  • Bedroom 3: On Upper Floor, Dimensions: 11 x 11
  • Bedroom 4: On Upper Floor, Dimensions: 15 x 12
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Bathroom 1: On Level: Upper
  • Bathroom 2: On Level: Upper
  • Great Room: On Entry Level, Dimensions: 19 x 17
  • Kitchen: On Entry Level, Dimensions: 13 x 13
  • Living Room: On Entry Level, Dimensions: 12 x 11
  • Below Grade Sq Ft: 1488
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 2833
  • Total Finished Sq Ft: 2833

Exterior Features

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

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 2
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 325
  • HOA Fee Frequency: Yearly
  • Association Contact: CASA BELLA
  • Association Phone: 248-655-1500
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 0826375138
  • Lot Dimensions: 73x183
  • Geo Subdivision: MI
  • Site/Lot Features: Subdivision

Rental Info

  • Pets Allowed: Yes

Tax Info

  • Summer Tax: Year: 2021, Amount: $3,469.00
  • Winter Tax: Year: 2021, Amount: $1,130.00
  • Total Tax: Year: 2021, Amount: $4,599.00

MLS Schools

  • School District: L'anse Creuse Public Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 17, 2022
Closed on
Dec 23, 2022
Sold by
Digiuseppe Christopher and Digiuseppe Linda
Bought by
Shamoun Noora
Seller's Agent
Hank Mendez
Real Estate One Inc-Shelby
Buyer's Agent
Sarmad Bahnam
Prime Elite Realty
List Price
$478,989
Sold Price
$455,000
Premium/Discount to List
-$23,989
-5.01%
Total Days on Market
14
Views
57
Current Estimated Value
$526,172

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$71,172
Avg. Annual Appreciation
6.19%
Original Mortgage
$432,250
Outstanding Balance
$421,087
Interest Rate
6.58%
Mortgage Type
New Conventional
Estimated Equity
$105,085

Purchase Details

Listed on
Aug 31, 2012
Closed on
Nov 30, 2012
Sold by
Fannie Mae
Bought by
Digiuseppe Christopher and Digiuseppe Linda
Seller's Agent
Janine Grillo
Weichert Realtors Excel
Buyer's Agent
Hank Mendez
Real Estate One Inc-Shelby
List Price
$285,000
Sold Price
$248,000
Premium/Discount to List
-$37,000
-12.98%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.18%
Original Mortgage
$243,508
Interest Rate
3.38%
Mortgage Type
FHA

Purchase Details

Closed on
Aug 17, 2012
Sold by
Brockett Mary
Bought by
Federal National Mortgage Association

Purchase Details

Closed on
Jun 25, 2012
Sold by
Bank Of America Na
Bought by
Federal National Mortgage Association

Purchase Details

Closed on
Jun 15, 2012
Sold by
Brockett Mary
Bought by
Bank Of America Na

Purchase Details

Closed on
Oct 4, 2010
Sold by
Brockett Mary and Furman Dorothy M
Bought by
Brockett Mary

Purchase Details

Closed on
Jan 1, 2009
Sold by
Brockett Mary
Bought by
Brockett Mary and Furman Dorothy M

Purchase Details

Closed on
Sep 14, 2007
Sold by
Columbia Homes Llc
Bought by
Brockett Mary

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 14, 2003
Sold by
Gtr Builders Inc
Bought by
Columbia Homes Llc
Source: Public Records

Similar Homes in Macomb, MI

  • 22119 Sturgeon River Dr Unit Lot 28, Macomb, MI 48042

    $589,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 22119 Sturgeon River Dr
    • Unit Lot 28
    • Macomb, MI

    BRAND NEW CONSTRUCTION HOME, 100% READY FOR IMMEDIATE OCCUPANCY!!! Sal Mar Building Company presents this new construction 2,900 sq. ft. Colonial with 4 bedrooms, 2 1/2 bathrooms, 3.5-car attached garage featuring white cabinetry, granite countertops throughout, gas fireplace in great room, wrought iron staircase and beautiful solid surface flooring throughout most of first floor. Builder is

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 50529 Summit View Dr Unit Lot 31, Macomb, MI 48042

    $589,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 50529 Summit View Dr
    • Unit Lot 31
    • Macomb, MI

    BRAND NEW CONSTRUCTION HOME, 100% READY FOR IMMEDIATE OCCUPANCY!!! Sal Mar Building Company presents this new construction 2,900 sq. ft. Colonial with 4 bedrooms, 2 1/2 bathrooms, 3.5-car attached garage featuring white cabinetry, granite countertops throughout, gas fireplace in great room, wrought iron staircase and beautiful solid surface flooring throughout most of first floor. Builder is

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 50567 Summit View Dr Unit Lot 32, Macomb, MI 48042

    $589,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 50567 Summit View Dr
    • Unit Lot 32
    • Macomb, MI

    BRAND NEW CONSTRUCTION HOME, 100% READY FOR IMMEDIATE OCCUPANCY!!! Sal Mar Building Company presents this new construction 2,900 sq. ft. Colonial with 4 bedrooms, 2 1/2 bathrooms, 3.5-car attached garage featuring white cabinetry, granite countertops throughout, gas fireplace in great room, wrought iron staircase and beautiful solid surface flooring throughout most of first floor. Builder is

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 50606 Summit View Dr Unit Lot 16, Macomb, MI 48042

    $569,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 50606 Summit View Dr
    • Unit Lot 16
    • Macomb, MI

    This new construction home is completed and ready for IMMEDIATE Occupancy. Salmar Building Company presents this 2,900 sq. ft. Colonial with 4 bedrooms, 2 1/2 bathrooms, 3.5-car attached garage featuring white cabinetry and Quartz countertops throughout, gas fireplace in great room, wrought iron staircase and beautiful solid surface flooring throughout most of first floor. Builder is including

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 50632 Summit View Dr Unit Lot 15, Macomb, MI 48042

    $569,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 50632 Summit View Dr
    • Unit Lot 15
    • Macomb, MI

    Brand New Home ready for IMMEDIATE OCCUPANCY. Salmar Building Company presents this 2,900 sq. ft. Colonial with 4 bedrooms, 2 1/2 bathrooms, 3.5-car attached garage featuring white cabinetry and Quartz countertops throughout, gas fireplace in great room, wrought iron staircase and beautiful solid surface flooring throughout most of first floor. Builder is including sod & sprinklers along with

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 50684 Summit View Dr Unit Lot 13, Macomb, MI 48042

    $569,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 50684 Summit View Dr
    • Unit Lot 13
    • Macomb, MI

    This new construction home can be completed within 90-days from acceptance of offer. Salmar Building Company presents this 2,900 sq. ft. Colonial with 4 bedrooms, 2 1/2 bathrooms, 3.5-car attached garage featuring white cabinetry and Quartz countertops throughout, gas fireplace in great room, wrought iron staircase and beautiful solid surface flooring throughout most of first floor. Builder is

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 22106 Grove Dr Unit Lot 43, Macomb, MI 48042

    $589,900

    • 4 Beds
    • 2.5 Baths
    • 2,828 Sq Ft
    • 22106 Grove Dr
    • Unit Lot 43
    • Macomb, MI

    Sal Mar Building Company presents this new construction home that is ready for Immediate Occupancy. Beautiful 2,900 sq. ft. Colonial featuring 4 bedrooms, 2 1/2 bathrooms; 3.5-car attached garage, white cabinetry throughout, quartz countertops throughout and gas fireplace in great room. Builder is including sod & sprinklers along with their standard kitchen appliance pkg which includes

    Thomas Zibkowski Real Estate One Inc-Shelby

    Section Image
  • 52588 Stafford Dr, Macomb, MI 48042

    $425,000

    • 4 Beds
    • 2.5 Baths
    • 2,354 Sq Ft
    • 52588 Stafford Dr
    • Macomb, MI

    This inviting colonial in Elan Estates offers a peaceful community without sacrificing convenience to shopping, schools, and expressways. The main level boasts a flowing layout that connects the heart of the home: a thoughtfully designed kitchen with granite counter-tops, SS appliances, a center island, pantry, and a seamless view into the inviting family room. A separate large living area offers

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 52630 Wellington Valley Dr, Macomb, MI 48042

    $613,800

    • 4 Beds
    • 2.5 Baths
    • 2,717 Sq Ft
    • 52630 Wellington Valley Dr
    • Macomb, MI

    STILL TIME TO MAKE THIS YOUR OWN BY MAKING YOUR SELECTIONS AND MOVE IN THIS SPRING!Welcome to this stunning new construction colonial in Macomb, Michigan, set on a nearly half-acre homesite backing to a peaceful creek! With 4 bedrooms and 2.5 baths, this home offers space, comfort, and modern conveniences for your ideal lifestyle. The daylight basement provides the perfect opportunity to create a

    David Petrouleas EXP Realty Shelby Twp

    Section Image

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
Shamoun Noora $455,000 --
Digiuseppe Christopher $248,000 Parks Title
Federal National Mortgage Association $2,500 None Available
Federal National Mortgage Association -- None Available
Bank Of America Na $325,324 None Available
Brockett Mary -- None Available
Brockett Mary -- None Available
Brockett Mary $352,000 Greco
Columbia Homes Llc -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Shamoun Noora $432,250
Previous Owner Digiuseppe Christopher $300,000
Previous Owner Digiuseppe Christopher $250,462
Previous Owner Digiuseppe Christopher $243,508
Previous Owner Brockett Mary $334,400
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/12/2023 01/12/23 Sold $455,000 -5.0% $161 / Sq Ft
12/01/2022 12/01/22 Pending -- -- --
11/17/2022 11/17/22 For Sale $478,989 +93.1% $169 / Sq Ft
11/30/2012 11/30/12 Sold $248,000 -13.0% $84 / Sq Ft
10/10/2012 10/10/12 Pending -- -- --
08/31/2012 08/31/12 For Sale $285,000 -- $96 / 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
2024 $5,367 $242,300 $0 $0
2023 $5,090 $217,900 $0 $0
2022 $4,725 $193,200 $0 $0
2021 $4,599 $186,200 $0 $0
2020 $3,436 $179,800 $0 $0
2019 $4,244 $173,400 $0 $0
2018 $4,134 $166,600 $0 $0
2017 $4,070 $161,720 $34,500 $127,220
2016 $3,851 $161,690 $0 $0
2015 $3,804 $152,610 $0 $0
2014 $3,804 $130,000 $23,500 $106,500
2013 $5,731 $130,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Michigan Multiple Listing Service

MLS Number: 50096121

Michigan Multiple Listing Service

APN: 20-08-26-375-138