NOT LISTED FOR SALE

5040 Blue Spruce Dr Ypsilanti, MI 48197

Estimated Value: $477,000 - $533,000

3 Beds
2.5 Baths
2,484 Sq Ft
$205/Sq Ft Est. Value

Last Sold August 29, 2016

Last sale price $269,500 $108 Per Sq Ft

Est. 88% increase in value since last sale

Current estimated payment $3,394/month

70 Days on Market

Highlights

  • Spa
  • Colonial Architecture
  • Vaulted Ceiling
  • Allen Elementary School Rated A
  • Deck
  • Wood Flooring

About This Home

As of August 2016

Spacious Hickory Pointe colonial on a beautiful corner lot w/ a 3 car side entry garage. This home feels like a 4 bedroom with a large master suite and an attached nursery room that could also be a study or workout area complete with french doors for privacy. Master includes a walk-in-closet, bath w/ shower and jetted tub The open floor plan features a 2 story foyer, 9' ceilings and a large kitchen w/ center island that opens to a family room w/ a fireplace. New carpet throughout. Outside features include a large deck, sprinkler system, and beautiful landscaping. All this and lower Pittsfield Township Taxes. Ann Arbor Schools. 1 year Home Trust Warranty included. Walk to adjoining Hickory Woods Park and community pool. HOA $325 annually. Enjoy the convenience of a 15 min ride to Metro air airport, shopping, subdivision is a quick 10-15 minute commute to downtown Ann Arbor, Eastern, UofM and St. Joe Hospitals with easy access to US 23 and I 94, universities and downtown Ann Arbor., Primary Bath

Last Agent to Sell the Property

Tammi Ebenhoeh

The Charles Reinhart Company License #6501326158 Listed on: 06/17/2016

The Charles Reinhart Company

Last Buyer's Agent

No Member

Non Member Sales

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,124

Year Built

  • Built in 1999

Lot Details

  • 0.28 Acre Lot
  • Sprinkler System
  • Property is zoned PUD, PUD

HOA Fees

  • $27 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Vinyl Siding

Interior Spaces

  • 2,484 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • 1 Fireplace
  • Window Treatments
  • Living Room
  • Dining Area
  • Basement Fills Entire Space Under The House
  • Home Security System

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Oven
  • Range
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Outdoor Features

  • Spa
  • Deck
  • Porch

Schools

  • Allen Elementary School
  • Scarlett Middle School
  • Huron High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Satellite Dish
  • Cable TV Available

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,124

Year Built

Built in 1999

Lot Details

0

HOA Fees

$27 per month

Parking

3

Listing Details

  • Property Sub-Type: Single Family Residence
  • Property Type: Residential
  • New Construction: No
  • ArchitecturalStyle: Colonial
  • Stories: 2
  • Year Built: 1999
  • ResoPropertyType: Residential
  • Location Property Info:Property Sub-Type: Single Family Residence
  • General Property Info:New Construction2: No
  • General Property Info:Basement: Yes
  • General Property Info:Total Fin SqFt All Levels: 2484.0
  • General Property Info:Main Level Laundry: Yes
  • Tax Info:Annual Property Tax: 4124.0
  • Tax Info:Zoning3: PUD
  • Heat Type:Forced Air: Yes
  • Air Conditioning:Central Air: Yes
  • Substructure:Full: Yes
  • Appliances Dryer: Yes
  • Appliances Refrigerators: Yes
  • Washers: Yes
  • Heat Source:Natural Gas3: Yes
  • General Property Info:Total Fireplaces: 1.0
  • Utilities Attached:Cable: Yes
  • Utilities Attached:Natural Gas: Yes
  • Sewer:Public: Yes
  • Water:Public2: Yes
  • General Property Info:Fireplace: Yes
  • Additional Items:Ceiling Fans: Yes
  • Additional Items:Window Treatments: Yes
  • Landscape:Underground Sprinkler: Yes
  • Additional Items:Hot Tub Spa: Yes
  • General Property Info:SqFt Above Grade: 2484.0
  • Additional Items:Vaulted Ceilings: Yes
  • Laundry Features Main Level: Yes
  • General Property Info Elementary School2: Allen Elementary School
  • General Property Info High School: Huron High School
  • General Property Info Middle School2: Scarlett Middle School
  • General Property Info Garage YN: Yes
  • Flooring:Wood Floor: Yes
  • Other Equipment:Satellite Dish2: Yes
  • Flooring:Vinyl Floor: Yes
  • Flooring:Carpet Floor: Yes
  • Architectural Style:Colonial: Yes
  • Security Features:Security System: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Oven, Range, Refrigerator, Washer
  • Flooring: Carpet, Vinyl, Wood
  • Interior Amenities: Ceiling Fan(s), Garage Door Opener, Hot Tub Spa, Eat-in Kitchen
  • Fireplace: Yes
  • Fireplaces: 1
  • Total Bedrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Basement: Full
  • LivingArea: 2484.0
  • Other Equipment: Satellite Dish
  • Window Features: Window Treatments
  • General Property Info:Stories2: 2.0
  • Kitchen Features:Eating Area: Yes
  • Appliances:Oven: Yes
  • Appliances Range: Yes
  • Kitchen Features:Breakfast Nook: Yes
  • Appliances Dishwasher: Yes

Exterior Features

  • Construction Materials: Brick, Vinyl Siding
  • List Price: 275000.0
  • Lot Features: Sidewalk
  • Patio and Porch Features: Deck, Porch(es)
  • Exterior Material:Vinyl Siding: Yes
  • Exterior Material:Brick: Yes
  • Patio and Porch Features:Porch(es): Yes
  • Patio and Porch Features:Deck(s): Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Garage: Yes
  • Parking Features: Attached
  • Additional Items:Garage Door Opener: Yes
  • Parking Features Attached2: Yes
  • General Property Info:Garage Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Forced Air
  • Heating: Yes
  • Laundry Features: Main Level
  • Security Features: Security System
  • Sewer: Public
  • Utilities: Natural Gas Connected, Cable Connected, Storm Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Association Fee: 325.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Info:Approx Assoc Fee2: 325.0
  • Association Info:Assoc Fee Payable: Annually

Schools

  • Elementary School: Allen Elementary School
  • High School: Huron High School
  • Middle/Junior School: Scarlett Middle School

Lot Info

  • Lot Size Acres: 0.28
  • Lot Size Area: 0.28
  • Lot Size Sq Ft: 12197.0
  • Zoning Description: PUD
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 4124.0
  • Tax Year: 2016

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 17, 2016
Closed on
Aug 26, 2016
Sold by
Ludlam Anthony V and Ludlam Miranda Lau
Bought by
Richmond Prter
Seller's Agent
Tammi Ebenhoeh
The Charles Reinhart Company
Buyer's Agent
No Member
Non Member Sales
List Price
$285,000
Sold Price
$269,500
Premium/Discount to List
-$15,500
-5.44%
Current Estimated Value
$506,375

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$236,875
Avg. Annual Appreciation
7.27%
Original Mortgage
$242,550
Interest Rate
3.48%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 15, 2008
Sold by
Hamilton George O and Hamilton Mary Ann
Bought by
Ludlam Anthony V and Lau Miranda

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$212,800
Interest Rate
6.55%

Purchase Details

Closed on
May 15, 2003
Sold by
Davis Vince R and Davis Deborah
Bought by
Hamilton George O and Hamilton Mary Ann
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
Richmond Prter $269,500 Liberty Title
Ludlam Anthony V $224,000 Liberty Title
Hamilton George O $285,000 Metropolitan Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Richmond Peter $100,000
Open Richmond Peter $229,400
Closed Richmond Prter $242,550
Previous Owner Ludlam Anthony $192,000
Previous Owner Ludlam Anthony $199,000
Previous Owner Ludlam Anthony $208,000
Previous Owner Ludlam Anthony V $212,800
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/29/2016 08/29/16 Sold $269,500 -5.4% $108 / Sq Ft
08/26/2016 08/26/16 Pending -- -- --
06/17/2016 06/17/16 For Sale $285,000 -- $115 / Sq Ft
Source: Southwestern Michigan Association of REALTORS®

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 $7,137 $263,525 $0 $0
2024 $5,076 $249,914 $0 $0
2023 $4,587 $216,000 $0 $0
2022 $6,887 $195,600 $0 $0
2021 $6,523 $173,700 $0 $0
2020 $6,321 $165,900 $0 $0
2019 $5,547 $142,100 $142,100 $0
2018 $5,467 $136,600 $0 $0
2017 $5,336 $134,800 $0 $0
2016 $2,870 $112,852 $0 $0
2015 -- $112,515 $0 $0
2014 -- $109,000 $0 $0
2013 -- $109,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Tammi Ebenhoeh

    Seller's Agent in 2016

    Tammi Ebenhoeh

    The Charles Reinhart Company

    (734) 276-4663

    30 in this area

    181 Total Sales

    Section Image

  • N

    Buyer's Agent in 2016

    No Member

    Non Member Sales

See All Agents

Map

Source: Southwestern Michigan Association of REALTORS®

MLS Number: 23108301

Southwestern Michigan Association of REALTORS®

APN: 12-24-112-056

Michigan Washtenaw County Ypsilanti 48197

5040 Blue Spruce Dr, Ypsilanti, MI

This home is located at 5040 Blue Spruce Dr, Ypsilanti, MI 48197 since 17 June 2016 and is currently estimated at $510,156, approximately $205 per square foot. This property was built in 1999. 5040 Blue Spruce Dr is a home located in Washtenaw County with nearby schools including Allen Elementary School, Scarlett Middle School, and Huron 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.

Southwestern Michigan Association of REALTORS® Information is deemed reliable but not guaranteed.
Copyright 2025 MichRIC, LLC. All rights reserved.

Nearby Homes