Seller's Agent in 2023
David Tremblay
EXP Realty Shelby
(586) 531-6999
110 Total Sales
2840 Squirrel Rd Bloomfield Hills, MI 48304
Estimated Value: $565,000 - $599,000
4
Beds
3.5
Baths
2,401
Sq Ft
$240/Sq Ft
Est. Value
Highlights
- Colonial Architecture
- Deck
- 2 Car Attached Garage
- Eastover Elementary School Rated A
- No HOA
- Patio
About This Home
As of June 2023Welcome 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!
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
- Finished Basement
- Walk-Out Basement
- Attic Fan
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
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%
Total Days on Market
42
Views
102
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$61,242
Avg. Annual Appreciation
5.99%
Original Mortgage
$480,290
Outstanding Balance
$470,397
Interest Rate
6.62%
Mortgage Type
FHA
Estimated Equity
$105,845
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
Glover Agency
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
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Rainville Patrick B | $515,000 | None Listed On Document | |
| Dietrich Megan | $415,000 | Ata National Title Group Llc | |
| Leggett Raymond F | $224,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Rainville Patrick B | $480,290 | |
| Previous Owner | Dietrich Megan | $399,000 | |
| Previous Owner | Dietrich Megan | $394,250 | |
| Previous Owner | Leggett Raymond F | $323,463 | |
| Previous Owner | Leggett Raymond F | $378,500 | |
| Previous Owner | Leggett Raymond F | $380,000 | |
| Previous Owner | Leggett Ray E | $100,000 | |
| Previous Owner | Leggett Raymond | $250,000 | |
| Previous Owner | Leggett Raymond F | $179,200 |
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
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
-
David Tremblay
-
Michael Scianna
Seller Co-Listing Agent in 2023
Michael Scianna
EXP Realty Shelby
(888) 501-7085
117 Total Sales
-
J
Buyer's Agent in 2023
Jennifer Caira-Lauff
-
Glover Agency
Seller's Agent in 2019
Glover Agency
KW Professionals
(734) 259-1100
2,261 Total Sales
-
Susan Berry
Seller Co-Listing Agent in 2019
Susan Berry
Berkshire Hathaway HomeServices Kee Realty Bham
(313) 286-6686
101 Total Sales
-
Andrew Dietrich
A
Buyer's Agent in 2019
Andrew Dietrich
Coldwell Banker Weir Manuel-Clarkston
(248) 625-1000
4 Total Sales
Map
Similar Homes in Bloomfield Hills, MI
-
$525,000
- 5 Beds
- 3.5 Baths
- 2,674 Sq Ft
- 1965 Devonshire Rd
- Bloomfield Hills, MI
Discover luxury and comfort in this stunning 5-bedroom home located in the prestigious Bloomfield Hills neighborhood with Bloomfield Hills school. Offering 2,675 sq ft of beautifully designed living space, this exquisite residence features two master suites, 3 full bathrooms, and 1 half bath, perfect for accommodating family and guests.Step into elegance with marble bathrooms, including a
Anthony Djon Anthony Djon Luxury Real Estate
-
$675,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 nestled on a serene and private .78-acre lot in the heart of Bloomfield Hills. Boasting timeless craftsmanship and modern functionality, this residence combines warmth, elegance, and convenience in one exceptional package. The gourmet kitchen features custom dark cherry cabinetry, granite countertops, GE Profile stainless steel
Justin Ford EXP Realty Plymouth
-
$699,900
- 4 Beds
- 3.5 Baths
- 3,560 Sq Ft
- 1048 Home Ln
- Bloomfield Hills, MI
This immaculate and pristine residence offers approximately 3600 sq ft of cozy living space, featuring 4 bedrooms and 3.1 bathrooms. The home boasts exceptional curb appeal and is conveniently located near I-75, Somerset Mall, and the internationally acclaimed International Academy. Enjoy the expansive floor plan with a cathedral great room and a balcony that provides stunning views. The granite
Mary Jane Doherty KW Domain
-
$689,000
- 5 Beds
- 3.5 Baths
- 4,209 Sq Ft
- 796 Rock Spring Rd
- Bloomfield Hills, MI
Incredible opportunity to live in Bloomfield Hills with Bloomfield Hills Schools on extra large ravine lot. Expansive property with gorgeous, sweeping views, lush mature trees, extensive privacy, and room for a pool in stunning Hickory Heights neighborhood. Move in ready or customize to your liking, the potential in this home is endless. Comprehensive floor plan offers extensive options for every
Amanda Fisher Max Broock, REALTORS®-Birmingham
-
$585,000
- 3 Beds
- 3 Baths
- 2,228 Sq Ft
- 95 Hillsdale Rd
- Bloomfield Hills, MI
Discover luxury living in this 3-bedroom, 3-bathroom brick ranch, perfectly situated on a sprawling 0.8-acre corner lot in the heart of Bloomfield Hills. Boasting 2,300 sq. ft. of above-ground living space with a fully finished basement, this home offers modern elegance, thoughtful design, and premium finishes throughout.Step inside to a grand marble foyer that sets the tone for the
Edinam Moten Bridge Cross Realty
-
$699,000
- 3 Beds
- 4 Baths
- 2,606 Sq Ft
- 3558 Darcy Dr
- Bloomfield Hills, MI
Incredible opportunity to be in the heart of Bloomfield with this expansive mid century inspired quad level home, with entry level garage, soaring natural light and vaulted ceilings all situated on a private lot and quiet cul de sac street. Fresh, clean and move in ready with opportunity to update, expand, or simply enjoy with newer three zone HVAC and AC, water heater, roof as well as new
Renee Lossia Acho KW Domain
-
$549,900
- 3 Beds
- 4 Baths
- 1,513 Sq Ft
- 218 S Glengarry Rd
- Bloomfield Hills, MI
Spectacular three bedroom, two full bath and two half bath brick ranch located in the highly coveted Bloomfield Village South neighborhood. This charming residence features an open floor plan with large windows, hardwood floors, FP in the living room, updated kitchen with seating area, three season room off the dining room with extra SF not included in the above ground SF. The lower level is
John Apap @properties Christie's Int'l R.E. Birmingham
-
$670,000
- 4 Beds
- 3 Baths
- 2,890 Sq Ft
- 1615 Bracken Rd
- Bloomfield Hills, MI
Welcome home to your spacious and beautifully updated ranch. The generous foyer opens to a stunning home of warmth and comfort. Sun filled open floor plan with spacious rooms and hardwood flooring. The family room, dining room and living room, with their own cozy fireplace make this home great for family time, entertaining or relaxing. Beautiful chef inspired kitchen has premium maple
Marilyn Lentz Oakland Hills Real Estate Corp
Source: Realcomp
MLS Number: 20230023174
APN: 19-12-153-022
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.
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
- 4.8 Acres Westview Rd
- 790 Hidden Pine Rd
- 868 Helston Rd
- 2491 Brenthaven Dr
- 2472 Brenthaven Dr
- 2732 Eastways Rd
- 815 Great Oaks Dr
- 1301 Romney Rd
- 773 Woodchester Dr
- 816 Palms Rd
- 175 Bridgeview Dr
- 145 Bridgeview Dr
- 155 Bridgeview Dr
- 3052 Westman Ct
- 920 Southdown Rd
- 170 Bridgeview Dr
- 892 Tartan Trail
- 883 Tartan Trail Unit 207
- 100 Bridgeview Dr
- 2488 Inglehill Point