$515,000
SOLD JUN 1, 2023

2840 Squirrel Rd Bloomfield Hills, MI 48304

4 Beds
3.5 Baths
2,401 Sq Ft
0.46 Acres

Recently Sold

$214 Per Sq Ft

6% Below List Price

42 Days on Market

Highlights

  • Colonial Architecture
  • Deck
  • 2 Car Attached Garage
  • Eastover Elementary School Rated A
  • No HOA
  • Patio

About This Home

As of June 2023

Welcome home to a charming 4 bedroom, 3.5 bath, traditional colonial in a prestigious neighborhood of Bloomfield Hills. This lovely home features an updated kitchen with white cabinets, stainless steel appliances, and granite countertops. The spacious family room is complete with built-in bookshelves, a gas fireplace, crown molding, and a French door wall leading into the Florida room. The Florida room off the back of the home leads to a large Trex deck(2022) overlooking the peaceful hilltop backyard. The primary bathroom has been completely renovated as of 2022. The home also features a finished basement with walkout access. Attached Side Entry Garage, Gorgeous Picturesque Back Yard, Generous Sized Front Yard, and Plenty of Privacy, Plus So Much More! Fully functioning generator included with sale!

Last Agent to Sell the Property

David Tremblay

EXP Realty Shelby License #6506047919 Listed on: 04/03/2023

EXP Realty Shelby

Co-Listed By

Michael Scianna

EXP Realty Shelby License #6501373352

Last Buyer's Agent

Jennifer Caira-Lauff

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1964 | Remodeled in 2020

Lot Details

  • 0.46 Acre Lot
  • Lot Dimensions are 120x167

Home Design

  • Colonial Architecture
  • Poured Concrete
  • Asphalt Roof
  • Chimney Cap

Interior Spaces

  • 2,401 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Gas Fireplace
  • Family Room with Fireplace
  • Attic Fan
  • Finished Basement

Kitchen

  • Built-In Electric Oven
  • Electric Cooktop
  • ENERGY STAR Qualified Refrigerator
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Whole House Permanent Generator
  • Natural Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 1912153022
  • $9,284 Seller Concession

Community Details

Overview

  • No Home Owners Association
  • Bloomfield Hills Estates No 2 Bloomfield Twp Subdivision

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,694

Year Built

Built in 1964 | Remodeled in 2020

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Assessment: 1.00
  • Year Built: 1964
  • State Equalized Value: 214550.0000
  • Year Renovated: 2020
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: 220 Volts
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Family Room
  • Room Count: 13
  • Total Bedrooms: 4
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished, Walk-Out Access
  • Kitchen Appliances: Built-In Electric Oven, Dishwasher, Disposal, Electric Cooktop, ENERGY STAR® qualified refrigerator
  • Sq Ft Combined: 3051
  • Sq Ft Lower Floor: 650
  • Total Sq Ft: 2401
  • Sq Ft Total Bsmt: 981

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Aluminum
  • Exterior Features: Whole House Generator, Chimney Cap(s), Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 120
  • Porch Type: Deck, Patio
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Door Opener, Attached
  • Garage: Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Bloomfield Hills

Lot Info

  • Homestead: Yes
  • Lot Size Area: 0.46
  • Lot Dimensions: 120x167
  • Parcel Number: 1912153022

Tax Info

  • Tax Amount Summer: 3935.0000
  • Tax Amount Winter: 3759.0000
  • Total Tax: 7694.0000
  • Taxable Value: 206150.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 3, 2023
Closed on
May 31, 2023
Sold by
Dietrich Megan
Bought by
Rainville Patrick B
Seller's Agent
David Tremblay
EXP Realty Shelby
Buyer's Agent
Jennifer Caira-Lauff
List Price
$550,000
Sold Price
$515,000
Premium/Discount to List
-$35,000
-6.36%
Views
102
Current Estimated Value
$593,949

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$78,949
Avg. Annual Appreciation
6.26%
Original Mortgage
$480,290
Outstanding Balance
$470,397
Interest Rate
6.62%
Mortgage Type
FHA
Estimated Equity
$115,651

Purchase Details

Listed on
Mar 1, 2019
Closed on
May 2, 2019
Sold by
Leggett Raymond F and Leggett Lynn T
Bought by
Dietrich Megan
Seller's Agent
Jeff Glover
KW Professionals
Buyer's Agent
Andrew Dietrich
Coldwell Banker Weir Manuel-Clarkston
List Price
$429,500
Sold Price
$415,000
Premium/Discount to List
-$14,500
-3.38%

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 17, 1995
Sold by
Tofaute John L
Bought by
Leggett Raymond F and Leggett Lynn T

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$179,200
Interest Rate
8.64%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in Bloomfield Hills, MI

  • 868 Helston Rd, Bloomfield Hills, MI 48304

    $650,000

    • 5 Beds
    • 3.5 Baths
    • 2,865 Sq Ft
    • 868 Helston Rd
    • Bloomfield Hills, MI

    Welcome to this beautifully maintained and thoughtfully updated home on a serene, private .78-acre lot in the heart of Bloomfield Hills. Boasting timeless craftsmanship and modern functionality, this residence blends warmth, elegance, and convenience in one exceptional package. The gourmet kitchen features custom dark cherry cabinetry, granite countertops, GE Profile stainless steel appliances,

    Justin Ford EXP Realty Plymouth

    Section Image
  • 2491 Brenthaven Dr, Bloomfield Hills, MI 48304

    $450,000

    • 4 Beds
    • 2.5 Baths
    • 2,502 Sq Ft
    • 2491 Brenthaven Dr
    • Bloomfield Hills, MI

    Here’s your chance to own this spacious home nestled on a large lot just under a half acre. This home features hardwood floors throughout and large windows that allow an abundance of natural light. The updated kitchen boasts beautiful wood cabinets, granite countertops, and stainless steel appliances. It is a must see for this rare opportunity to own a home in the desired Adams Square Subdivision

    Sam Stevenson RE/MAX Eclipse Clarkston

    Section Image
  • 2200 Brenthaven Dr, Bloomfield Hills, MI 48304

    $647,888

    • 4 Beds
    • 2.5 Baths
    • 2,385 Sq Ft
    • 2200 Brenthaven Dr
    • Bloomfield Hills, MI

    Updates updates updates is all I can say. This 4 bedroom colonial is just amazing. It starts with new custom front door. Fresh hardwood floors throughout. New kitchen with white cabinets, custom quartz counters and back splash. Stainless steel stove, drawer microwave, custom hood fan, and dishwasher. Formal dining room and living room with large windows. Open floor plan on the first floor which

    Craig Minoletti Signature Sotheby's International Realty Bham

    Section Image
  • 1916 Squirrel Valley Dr, Bloomfield Hills, MI 48304

    $550,000

    • 4 Beds
    • 2.5 Baths
    • 3,014 Sq Ft
    • 1916 Squirrel Valley Dr
    • Bloomfield Hills, MI

    Welcome to this meticulously maintained, modern, move-in ready, 4 bedroom, 2 1/2 bathroom, renovated colonial 2020, located in a quiet, family friendly neighborhood, in highly sought after Bloomfield Hills. This open concept main floor flows effortlessly into the dining room, living room with a natural stone surround wood burning fireplace and large windows allowing ample natural light, eat-in

    Mark White EXP Realty - Mark White & Associates

    Section Image
  • 2625 Plum Brook Dr, Bloomfield Hills, MI 48304

    $435,000

    • 4 Beds
    • 2.5 Baths
    • 2,102 Sq Ft
    • 2625 Plum Brook Dr
    • Bloomfield Hills, MI

    This spacious 4-bedroom, 2.5-bath home offers a warm and functional layout, perfect for everyday living and entertaining. Refinished hardwood floors flow throughout. This home features two living spaces so take your pick for that TV! The thoughtfully updated kitchen features stainless steel appliances, while the first-floor laundry adds extra convenience. Upstairs you'll find four bedrooms,

    Kelly Mcree @properties Christie's Int'l R.E. Royal Oak

    Section Image
  • 2035 Wickford Ct, Bloomfield Hills, MI 48304

    $445,000

    • 4 Beds
    • 2.5 Baths
    • 2,522 Sq Ft
    • 2035 Wickford Ct
    • Bloomfield Hills, MI

    **OFFER DEADLINE OF 8 P.M. FRIDAY, JULY 11, 2025** Sought after Fox Hills Colonial located on one of the few coveted cul-de-sac streets in the heart of the sub. Large lot with mature trees, this home is ready for your family. Beautiful Hardwood Floors on the first floor foyer, kitchen and family room, which has a gas fireplace with custom glass doors. Newer kitchen with granite, large since,

    Anita Barratt Max Broock, REALTORS®-Birmingham

    Section Image
  • 1959 W Spinningwheel Ln, Bloomfield Hills, MI 48304

    $500,000

    • 4 Beds
    • 2.5 Baths
    • 2,352 Sq Ft
    • 1959 W Spinningwheel Ln
    • Bloomfield Hills, MI

    Situated in the heart of Bloomfield Hills, this elegant 4-bedroom, 2 & a half bath colonial blends timeless charm with modern updates. Thoughtfully maintained & move-in ready, the home features a new water heater, furnace, & A/C — all installed in 2024 for added peace of mind. The spacious floor plan offers comfortable everyday living and effortless entertaining along with a finished basement for

    Morgan Cecilio EXP Realty

    Section Image
  • 1987 Fox River Dr, Bloomfield Hills, MI 48304

    $529,000

    • 4 Beds
    • 2.5 Baths
    • 2,651 Sq Ft
    • 1987 Fox River Dr
    • Bloomfield Hills, MI

    Newly renovated open & contemporary cul-de-sac charmer with vaulted ceilings, modern updates & functional design across three spacious levels! Featuring exceptional curb-appeal & several improvements over the last few years, this property features two brand new full bathrooms (2024) with quartz vanities, subway tile backsplash, glass shower doors & 12x24 tile, large updated kitchen with quartz

    Nick Petrucci @properties Christie's Int'l R.E. Birmingham

    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 Type Sale Price Title Company
Warranty Deed $515,000 None Listed On Document
Warranty Deed $415,000 Ata National Title Group Llc
Deed $224,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $480,290 FHA
Previous Owner $399,000 New Conventional
Previous Owner $394,250 New Conventional
Previous Owner $323,463 New Conventional
Previous Owner $378,500 Unknown
Previous Owner $380,000 Unknown
Previous Owner $100,000 Credit Line Revolving
Previous Owner $250,000 Unknown
Previous Owner $179,200 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/01/2023 06/01/23 Sold $515,000 -3.7% $214 / Sq Ft
05/15/2023 05/15/23 Pending -- -- --
04/10/2023 04/10/23 Price Changed $535,000 -2.7% $223 / Sq Ft
04/03/2023 04/03/23 For Sale $550,000 +32.5% $229 / Sq Ft
05/02/2019 05/02/19 Sold $415,000 -3.4% $173 / Sq Ft
03/15/2019 03/15/19 Pending -- -- --
03/01/2019 03/01/19 For Sale $429,500 -- $179 / 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
2024 $4,674 $251,120 $0 $0
2023 $4,094 $229,560 $0 $0
2022 $7,694 $214,550 $0 $0
2021 $7,639 $199,570 $0 $0
2020 $3,884 $204,170 $0 $0
2019 $4,923 $234,370 $0 $0
2018 $4,617 $223,040 $0 $0
2017 $4,584 $217,400 $0 $0
2016 $4,592 $212,110 $0 $0
2015 -- $180,000 $0 $0
2014 -- $135,810 $0 $0
2011 -- $162,900 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20230023174

Realcomp

APN: 19-12-153-022