$574,000
SOLD JUL 24, 2017

3361 Squirrel Rd Bloomfield Hills, MI 48304

3 Beds
2.5 Baths
3,296 Sq Ft
1.44 Acres

Recently Sold

$174 Per Sq Ft

4% Below List Price

13 Days on Market

Highlights

  • Water Views
  • Home fronts a pond
  • Colonial Architecture
  • Eastover Elementary School Rated A
  • 1.44 Acre Lot
  • Deck

About This Home

As of July 2023

“Town & Country” stone front beauty with amazing water and nature views quietly set back from the road on 1.4 acres. Open floor plan includes vaulted 2 story great room with fireplace, quality built-ins, floor to ceiling architectural windows and dining room with wet bar. 1st floor master with skylights, separate granite vanity with sink, granite bath with jet tub and shower, walk-in closet Kitchen with granite, breakfast bar, eating area, premium stainless steel appliances, access to wrap around deck. 2nd floor guest bedroom with dual entry granite bath. 3rd bedroom currently opened up and used as loft. Generous library off foyer (library could also be bedroom). Unfinished daylight window lower level has unlimited potential for additional living space also has fireplace and is graded to become walk-out. Outstanding views out of every window. Spectacular property.

Last Agent to Sell the Property

Lanie Hardy Cosgrove

KW Domain License #6501261101 Listed on: 06/08/2017

KW Domain

Co-Listed By

Leslie Hardy

KW Domain License #6501327467

Last Buyer's Agent

Lila Casenave Pappal

Coldwell Banker Weir Manuel-Bir License #RCO-6502415653

Coldwell Banker Weir Manuel-Bir

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1986

Lot Details

  • 1.44 Acre Lot
  • Lot Dimensions are 272x274x225x238
  • Home fronts a pond
  • Native Plants
  • Irregular Lot
  • 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
  • Sound System
  • Gas Fireplace
  • South/West Shading
  • Great Room with Fireplace
  • Water Views
  • Security System Owned

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Unfinished Basement

  • Sump Pump
  • Fireplace in Basement
  • Natural lighting in basement

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Exterior Lighting
  • Shed
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Community Details

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

Listing and Financial Details

  • Assessor Parcel Number 1912376017

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,328

Year Built

Built in 1986

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Year Built: 1986
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Humidifier, Jetted Tub, Security Alarm (owned), Sound System, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas, Natural
  • Fireplace Locations: Basement, Great Room
  • Room Count: 13
  • Total Bedrooms: 3
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Daylight, Unfinished
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 3296
  • Total Sq Ft: 3296
  • Sq Ft Total Bsmt: 2243

Exterior Features

  • Roof Material: Asphalt
  • Waterfront Name: Willow Pond
  • Foundation Details: Basement
  • Construction Materials: Brick, Cedar
  • Exclusions: Yes
  • Exterior Features: Lighting
  • Foundation Materials: Block
  • Frontage Feet: 272
  • Porch Type: Deck, Porch
  • Road Frontage Type: Paved
  • Sideof Street: E
  • Waterfront Description: Pond

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached, Direct Access, Door Opener, Electricity
  • 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: No

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Bloomfield Hills

Lot Info

  • Homestead: Yes
  • List Price per Acre: 413194.4444
  • Lot Features: Hilly-Ravine, Irregular, Water View, Native Plants, South/West Shading, Wooded
  • Lot Size Area: 1.44
  • Lot Dimensions: 272x274x225x238
  • Parcel Number: 1912376017

Tax Info

  • Tax Amount Summer: 3667.0000
  • Tax Amount Winter: 3661.0000
  • Total Tax: 7328.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
  • 4824 Quarton Rd, Bloomfield Hills, MI 48302

    $499,900

    • 3 Beds
    • 2.5 Baths
    • 2,358 Sq Ft
    • 4824 Quarton Rd
    • Bloomfield Hills, MI

    Situated closely to Franklin village and downtown Birmingham, 4824 Quarton Rd blends timeless colonial charm with modern comfort in one of Bloomfield Township's most desirable pockets. Set on 0.32 Acres, this home falls within the top-rated Birmingham School District and offers quick access to shopping, dining, parks, and everyday conveniences.Inside, you'll find 3 generously sized

    Logan Smith KW Domain

    Section Image
  • 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
  • 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
  • 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
  • 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
  • 1916 Squirrel Valley Dr, Bloomfield Hills, MI 48304

    $540,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
  • 4743 Burnley Dr, Bloomfield Hills, MI 48304

    $699,000

    • 4 Beds
    • 3.5 Baths
    • 2,411 Sq Ft
    • 4743 Burnley Dr
    • Bloomfield Hills, MI

    Move into this beautiful 4 bedroom, 3.5 bath, walk out ranch situated on over an acre in the desirable Charing Cross Estates. You will appreciate the open concept, light filled living space that adjoins the dining area and kitchen overlooking a serene green space with the Rouge River flowing through it. The fabulous kitchen has great prep space, island, Quartz countertops, Thermador double ovens,

    Tracey Roy The Charles Reinhart Company

    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: 217039377

Realcomp

APN: 19-12-376-017