NOT LISTED FOR SALE

2517 Barclay Ave Unit 11 Shelby Township, MI 48317

Estimated Value: $377,000 - $448,000

4 Beds
3.5 Baths
1,573 Sq Ft
$262/Sq Ft Est. Value

Last Sold March 05, 2018

Last sale price $302,500 $192 Per Sq Ft

Est. 36% increase in value since last sale

Current estimated payment $2,584/month

Highlights

  • 20 Feet of Waterfront
  • Deck
  • 2 Car Direct Access Garage
  • Eppler Junior High School Rated A-
  • Ranch Style House
  • Bar Fridge

About This Home

As of March 2018

Enjoy Pure Michigan Summers in this beautiful Brick Ranch with Open-Concept Floor Plan on peaceful, serene Barclay Lake. Natural light floods the spacious Great Room featuring Vaulted Ceilings & clean-burning Fireplace with custom, hand-made wood mantle. Clean, bright Kitchen with Granite, SS appliances open to Breakfast area with Bay/Walkout Window to large Deck overlooking the Lake. Three Bedrooms on the main floor including Master with hand-scraped Hardwood Floors and private Bath. Professionally finished Walkout Lower Level with Glass Block Wet Bar, 4th Bedroom with
en-suite Bath, and Work-out Room. Rear Patio features newly-installed Sun Shade for protection and privacy. Fresh sand for your private beach (2017), and paddle boat included! Run, don't walk - this one won't last!! Licensed Michigan Realtor must be present at all showings - no exceptions. BATVAI. Exclusions: See List uploaded in Docs.

Last Agent to Sell the Property

Lucine Tarman

Home HeadQuarters License #6501369817 Listed on: 01/22/2018

Last Buyer's Agent

Lucine Tarman

Home HeadQuarters License #6501369817 Listed on: 01/22/2018

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1999 | Remodeled in 2015

Lot Details

  • 8,712 Sq Ft Lot
  • Lot Dimensions are 71 x 150 x 150 x 20
  • 20 Feet of Waterfront
  • Lake Front

HOA Fees

  • $29 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Vinyl Construction Material

Interior Spaces

  • 1,573 Sq Ft Home
  • Wet Bar
  • Bar Fridge
  • Ceiling Fan
  • Gas Fireplace
  • Great Room with Fireplace
  • Water Views

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Natural lighting in basement

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • Barclay Lake Village Condo #506 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 0730303011

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,873

Year Built

Built in 1999 | Remodeled in 2015

Lot Details

0

HOA Fees

$29 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 1999
  • Year Renovated: 2015
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Cable Available, High Spd Internet Avail, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Great Room
  • Room Count: 14
  • Total Bedrooms: 4
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Daylight, Finished, Walkout Access
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 2673
  • Sq Ft Lower Floor: 1100
  • Total Sq Ft: 1573
  • Sq Ft Total Bsmt: 1573

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: Barclay Lake
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Vinyl
  • Exterior Features: Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 71
  • Porch Type: Deck, Patio, Porch
  • Road Frontage Type: Paved
  • Water Frontage Feet: 20.00
  • Waterfront Description: Lake Front

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: 2+ Assigned Spaces, Attached, Direct Access, Door Opener, Electricity
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Association Fee: 350
  • Association Fee: Yes

Schools

  • School District: Utica

Lot Info

  • Homestead: Yes
  • List Price per Acre: 1500000.0000
  • Lot Features: Water View
  • Lot Size Area: 0.20
  • Lot Dimensions: 71 x 150 x 150 x 20
  • Parcel Number: 0730303011

Tax Info

  • Tax Amount Summer: 1633.0000
  • Tax Amount Winter: 1240.0000
  • Total Tax: 2873.0000

MLS Schools

  • School District: Utica

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 18, 2019
Sold by
Demaggio Lynda L
Bought by
Jo Phillip D Demaggio and Jo Lynda L Demaggio
Current Estimated Value
$412,077

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Outstanding Balance
$219,365
Interest Rate
4%
Mortgage Type
Credit Line Revolving
Estimated Equity
$192,712

Purchase Details

Closed on
Sep 28, 2018
Sold by
Demaggio Lynda L and Demaggio Phillip D
Bought by
Phillip D Demaggio and Phillip Lynda L Demaggio

Purchase Details

Listed on
Jan 22, 2018
Closed on
Mar 5, 2018
Sold by
Olson James and Olson Paula
Bought by
Demaggio Lynda L and Demaggio Phillip D
Seller's Agent
Lucine Tarman
Home HeadQuarters
Buyer's Agent
Lucine Tarman
Home HeadQuarters
List Price
$300,000
Sold Price
$302,500
Premium/Discount to List
$2,500
0.83%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.13%
Original Mortgage
$272,250
Interest Rate
4.15%
Mortgage Type
New Conventional

Purchase Details

Listed on
Aug 3, 2016
Closed on
Sep 21, 2016
Sold by
Bonn Eric W and Bonn Jennifer
Bought by
Olson James and Olson Paula
Seller's Agent
Randal Newhouse
Randy Newhouse Realty
Buyer's Agent
Lucine Tarman
Home HeadQuarters
List Price
$279,000
Sold Price
$265,000
Premium/Discount to List
-$14,000
-5.02%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.70%

Purchase Details

Closed on
Aug 5, 2011
Sold by
Fleming J Mark and Fleming Nicole Jean
Bought by
Bonn Eric W

Purchase Details

Closed on
Sep 8, 2005
Sold by
Dayar Abro Jr George H and Dayar Anrop
Bought by
Fleming J Mark

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$214,400
Interest Rate
5.89%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Aug 12, 2002
Sold by
Rios John D
Bought by
Abro George H

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$184,000
Interest Rate
6.24%
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
Jo Phillip D Demaggio -- None Available
Demaggio Lynda L -- None Available
Phillip D Demaggio -- None Available
Demaggio Lynda L $302,500 None Available
Olson James $265,000 Etitle Agency Inc
Bonn Eric W $185,000 Homeowners Title Agency
Fleming J Mark $268,000 Gta
Abro George H $230,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Jo Phillip D Demaggio $250,000
Previous Owner Demaggio Lynda L $272,250
Previous Owner Fleming J Mark $214,400
Previous Owner Abro George H $184,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/05/2018 03/05/18 Sold $302,500 +0.8% $192 / Sq Ft
01/22/2018 01/22/18 Pending -- -- --
01/22/2018 01/22/18 For Sale $300,000 +13.2% $191 / Sq Ft
09/29/2016 09/29/16 Sold $265,000 0.0% $168 / Sq Ft View Prior Sale
08/15/2016 08/15/16 Pending -- -- --
08/06/2016 08/06/16 Price Changed $265,000 -5.0% $168 / Sq Ft
08/03/2016 08/03/16 For Sale $279,000 -- $177 / Sq Ft
Source: Realcomp

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,520 $192,300 $0 $0
2024 $2,675 $175,200 $0 $0
2023 $2,534 $158,700 $0 $0
2022 $3,013 $139,600 $0 $0
2021 $3,975 $129,000 $0 $0
2020 $2,496 $144,100 $0 $0
2019 $3,895 $133,600 $0 $0
2018 $3,839 $126,300 $0 $0
2017 $3,660 $115,200 $26,550 $88,650
2016 $2,873 $115,200 $0 $0
2015 $2,831 $110,150 $0 $0
2013 $1,590 $97,700 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Lucine Tarman

    Seller's Agent in 2018

    Lucine Tarman

    Home HeadQuarters

    (248) 275-8944

    115 Total Sales

    Lucine Tarman
    Section Image

  • R

    Seller's Agent in 2016

    Randal Newhouse

    Randy Newhouse Realty

See All Agents

Map

Source: Realcomp

MLS Number: 218005230

Realcomp

APN: 23-07-30-303-011

Michigan Macomb County Shelby Township 48317

2517 Barclay Ave Unit 11, Shelby Township, MI

This home is located at 2517 Barclay Ave Unit 11, Shelby Township, MI 48317 since 22 January 2018 and is currently estimated at $412,077, approximately $261 per square foot. This property was built in 1999. 2517 Barclay Ave Unit 11 is a home located in Macomb County with nearby schools including Roberts Elementary School, Eppler Junior High School, and Utica High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Realcomp IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes