$813,000
SOLD JUL 12, 2023

3361 Squirrel Rd Bloomfield Hills, MI 48304

5 Beds
3.5 Baths
3,296 Sq Ft
1.44 Acres

Recently Sold

$247 Per Sq Ft

1% Below List Price

4 Days on Market

Highlights

  • 200 Feet of Waterfront
  • Home fronts a pond
  • 1.44 Acre Lot
  • Eastover Elementary School Rated A
  • Built-In Freezer
  • Colonial Architecture

About This Home

As of July 2023

Outstanding Bloomfield colonial on a 1.5-acre lot with a private pond. This house is something truly special offering the finest amenities surrounded by nature. First floor master, Bloomfield schools, private water feature enjoyed off of your large deck. Five nicely distributed bedrooms, 3 & ½ baths, study, lower level great room, fully finished and highly livable daylight basement with tons of natural sunlight. The home offers large rooms throughout, a new kitchen with high-end appliances, and so much more. You’ll never find a more serene environment for less than $1 million in Bloomfield Hills. This is a special house offering high ceilings, hardwood floors, finished surfaces, and tons of square footage. Don’t let this one slip through your fingers, show and purchase today. Other notables include a second walk-in closet and a music/exercise room on the lower level, two fireplaces, a two-story family room, and amazing views. Fourth and fifth bedrooms on lower level with egress windows, and 2 car attached garage. Wonderful views throughout the home. Home sits back away from the busy hustle and bustle of traffic and deadlines!*Showing notice preferred*

Last Agent to Sell the Property

Mike Sher

Max Broock, REALTORS®-Bloomfield Hills License #6502346400 Listed on: 06/09/2023

Max Broock, REALTORS®-Bloomfield Hills

Last Buyer's Agent

Joan Hardy Brown

The Agency Hall & Hunter License #6501303248

The Agency Hall & Hunter

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1986 | Remodeled in 2020

Lot Details

  • 1.44 Acre Lot
  • Lot Dimensions are 273x238x274x219
  • Home fronts a pond
  • 200 Feet of Waterfront
  • Fenced
  • Wooded Lot

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Asphalt Roof
  • Cedar

Interior Spaces

  • 3,296 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Gas Fireplace
  • Great Room with Fireplace
  • Water Views

Kitchen

  • Double Oven
  • Built-In Gas Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Microwave
  • Built-In Freezer
  • Dishwasher
  • Wine Refrigerator

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

  • Fireplace in Basement
  • Natural lighting in basement

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Shared Waterfront
  • Balcony
  • Deck
  • Exterior Lighting
  • Shed
  • Porch

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Natural Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1912376017
  • $2,500 Seller Concession

Community Details

Overview

  • No Home Owners Association
  • Eastover Farms No 2 Subdivision
  • Property is near a ravine

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,303

Year Built

Built in 1986 | Remodeled in 2020

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Year Built: 1986
  • State Equalized Value: 376310.0000
  • Year Renovated: 2020
  • Entry Location: Ground Level
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cable Available, Humidifier, Jetted Tub, Programmable Thermostat, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Basement, Great Room
  • Room Count: 20
  • Total Bedrooms: 5
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Daylight, Finished
  • Kitchen Appliances: Built-In Freezer, Built-In Gas Oven, Dishwasher, Double Oven, Dryer, Gas Cooktop, Microwave, Range Hood, Warming Drawer, Washer, Wine Refrigerator
  • Sq Ft Combined: 4896
  • Sq Ft Lower Floor: 1600
  • Total Sq Ft: 3296
  • Sq Ft Total Bsmt: 2179

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: Willow Pond
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Cedar
  • Exterior Features: Lighting, Fenced
  • Foundation Materials: Block
  • Frontage Feet: 273
  • Porch Type: Balcony, Deck, Porch
  • Road Frontage Type: Paved, Pub. Sidewalk
  • Sideof Street: E
  • Water Frontage Feet: 200.00
  • Waterfront Description: Pond, Shared Water Frontage
  • Fencing: Fenced, Fence Allowed

Garage/Parking

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

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Septic Tank (Existing)
  • 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
  • List Price per Acre: 568750.0000
  • Lot Features: Hilly-Ravine, Wooded, Water View
  • Lot Size Area: 1.44
  • Lot Dimensions: 273x238x274x219
  • Parcel Number: 1912376017

Tax Info

  • Tax Amount Summer: 5781.0000
  • Tax Amount Winter: 5522.0000
  • Total Tax: 11303.0000
  • Taxable Value: 302880.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 9, 2023
Closed on
Jul 12, 2023
Sold by
Pilger Dale and Pilger Miyuki
Bought by
Casey Thomas
Seller's Agent
Mike Sher
Max Broock, REALTORS®-Bloomfield Hills
Buyer's Agent
Joan Hardy Brown
The Agency Hall & Hunter
List Price
$819,000
Sold Price
$813,000
Premium/Discount to List
-$6,000
-0.73%
Views
157
Current Estimated Value
$937,247

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$124,247
Avg. Annual Appreciation
7.29%
Original Mortgage
$650,400
Outstanding Balance
$637,861
Interest Rate
6.71%
Mortgage Type
New Conventional
Estimated Equity
$299,386

Purchase Details

Listed on
Jun 8, 2017
Closed on
Jul 24, 2017
Sold by
Walainis James R and Jereck Carolyn M
Bought by
Pilger Dale and Pilger Miyuki
Seller's Agent
Lanie Hardy Cosgrove
KW Domain
Buyer's Agent
Lila Casenave Pappal
Coldwell Banker Weir Manuel-Bir
List Price
$595,000
Sold Price
$574,000
Premium/Discount to List
-$21,000
-3.53%

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.00%
Original Mortgage
$200,000
Interest Rate
3.9%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 10, 2001
Sold by
Keeling Janet L
Bought by
Walainis James R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$87,375
Interest Rate
6.97%

Purchase Details

Closed on
Sep 25, 1998
Sold by
Gutowski Janet L
Bought by
Keeling Janet L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$103,800
Interest Rate
6.8%
Source: Public Records

Similar Homes in Bloomfield Hills, MI

  • 830 Jonathan Ln, Bloomfield Hills, MI 48302

    $675,000

    • 3 Beds
    • 4 Baths
    • 2,440 Sq Ft
    • 830 Jonathan Ln
    • Bloomfield Hills, MI

    Bloomfield Hills Sprawling Ranch with Room to Roam!Tucked away on a quiet, dead-end street and surrounded by mature trees and lush landscaping, this sought-after Bloomfield Hills ranch offers privacy and serenity on nearly 3/4 of an acre. The circular driveway welcomes guests while adding convenience and ample parking.Inside, a generous floor plan features a spacious first-floor primary

    Linda Wells RE/MAX Classic

    Section Image
  • 3365 BlooMcRest Dr, Bloomfield Hills, MI 48304

    $849,900

    • 4 Beds
    • 2.5 Baths
    • 3,363 Sq Ft
    • 3365 BlooMcRest Dr
    • Bloomfield Hills, MI

    Welcome home to this spacious and elegant sprawling ranch, ideally situated in the heart of desirable Bloomfield Hills. Thoughtfully updated and meticulously maintained, this beautiful residence combines timeless style with modern comfort and functionality. Step inside to an open, functional floor plan filled with natural light, offering generous living spaces that create a warm and cozy

    Kegan Gilpin @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 745 Hawthorne Dr, Bloomfield Hills, MI 48304

    $849,900

    • 5 Beds
    • 3 Baths
    • 3,216 Sq Ft
    • 745 Hawthorne Dr
    • Bloomfield Hills, MI

    Completely renovated from top to bottom, this stunning quad-level home offers an expansive 3,200+ square feet of unparalleled comfort and luxury living space. The brand new kitchen opens to both living area with fireplace and dining areas. With a few steps take you up to the generous size bedrooms and stunning bathrooms. The lower level features huge family room with fireplace, sliding doors to

    Nash Khraishi Homes Main Realty LLC

    Section Image
  • 3788 Crestlake Dr, Bloomfield Hills, MI 48304

    $725,000

    • 3 Beds
    • 4 Baths
    • 2,556 Sq Ft
    • 3788 Crestlake Dr
    • Bloomfield Hills, MI

    This quiet modern Bloomfield Hills Ranch is nestled on a beautiful lot located perfectly for easy access to downtown Birmingham. You will experience a meticulously maintained home designed for entertaining as well, the views of the tranquil garden are visible from every room. The interior is open and bright throughout the entire home. 3 bedrooms, 2 full bathrooms & 2 half baths, wonderful Master

    Wendi Miller Good Company

    Section Image
  • 759 Rock Spring Rd, Bloomfield Hills, MI 48304

    $749,900

    • 4 Beds
    • 4 Baths
    • 2,732 Sq Ft
    • 759 Rock Spring Rd
    • Bloomfield Hills, MI

    Welcome to Hickory Heights! Perfectly positioned in the sought-after Hickory Heights neighborhood, this beautifully maintained and thoughtfully updated tri-level home is full of warmth, functionality, and high-end finishes. The main living area features a spacious open layout with a large island with seating, prep sink, and beverage center—an entertainer’s dream. The gourmet kitchen is outfitted

    Ashley Crain Crain Homes

    Section Image
  • 796 Rock Spring Rd, Bloomfield Hills, MI 48304

    $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

    Section Image
  • 2525 Crofton Ct, Bloomfield Hills, MI 48304

    $799,900

    • 3 Beds
    • 3.5 Baths
    • 2,948 Sq Ft
    • 2525 Crofton Ct
    • Bloomfield Hills, MI

    Brick and Stone cape cod with a first floor primary bedroom suite sitting on a beautiful .7 acre lot. Spacious white kitchen with center island and eat in nook. Large living room with wood floors and gas fireplace. Formal Dining Room. Separate office/den. Primary suite includes a WIC, en suite bath with soaking tub and shower stall and access out to a newer composite deck. Two additional

    Chris Pero Max Broock, REALTORS®-Birmingham

    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
  • 2470 Inglehill Pointe, Bloomfield Hills, MI 48304

    $715,000

    • 3 Beds
    • 2.5 Baths
    • 2,577 Sq Ft
    • 2470 Inglehill Pointe
    • Bloomfield Hills, MI

    Welcome home to this beautifully updated detached condo in the prestigious Heathers community.Offering approximately 2,600 square feet of thoughtfully designed living space, this 3 bedroom, 2.1 bath residence features a striking two-story foyer that sets the tone from the moment you enter. The kitchen boasts generous counter space, granite countertops, and flows seamlessly into the light-filled

    Abe Koumaiha KW Domain

    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 $813,000 Capital Title
Warranty Deed $813,000 Capital Title
Warranty Deed $574,000 None Available
Deed -- --
Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $650,400 New Conventional
Previous Owner $225,000 New Conventional
Previous Owner $200,000 New Conventional
Previous Owner $191,000 New Conventional
Previous Owner $115,000 Credit Line Revolving
Previous Owner $450,200 Unknown
Previous Owner $87,375 No Value Available
Previous Owner $103,800 No Value Available
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/12/2023 07/12/23 Sold $813,000 -0.7% $247 / Sq Ft
06/13/2023 06/13/23 Pending -- -- --
06/09/2023 06/09/23 For Sale $819,000 +42.7% $248 / Sq Ft
07/24/2017 07/24/17 Sold $574,000 -3.5% $174 / Sq Ft
06/21/2017 06/21/17 Pending -- -- --
06/08/2017 06/08/17 For Sale $595,000 -- $181 / 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 $7,901 $424,480 $0 $0
2023 $6,015 $416,570 $0 $0
2022 $11,303 $376,310 $0 $0
2021 $11,222 $354,190 $0 $0
2020 $5,501 $323,160 $0 $0
2019 $10,559 $286,450 $0 $0
2018 $10,608 $277,130 $0 $0
2017 $7,299 $264,510 $0 $0
2016 $7,312 $281,640 $0 $0
2015 -- $272,470 $0 $0
2014 -- $211,160 $0 $0
2011 -- $229,930 $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: 20230046043

Realcomp

APN: 19-12-376-017