NOT LISTED FOR SALE

2700 Squirrel Rd Bloomfield Hills, MI 48304

Estimated Value: $516,000 - $3,167,099

4 Beds
4 Baths
2,256 Sq Ft
$818/Sq Ft Est. Value

Last Sold September 27, 2013

Last sale price $1,200,000 $532 Per Sq Ft

Est. 54% increase in value since last sale

Current estimated payment $11,896/month

141 Days on Market

Highlights

  • Lake Front
  • Home fronts a pond
  • Lake Privileges
  • Eastover Elementary School Rated A
  • 9.93 Acre Lot
  • Deck

About This Home

As of September 2013

AN OPPORTUNITY TO OWN YOUR OWN ESTATE WITH 9.93 ACRES, 1,094 FT FRONTAGE ALONG A STREAM WITH ROLLING TOPOGRAPHY! THIS 4 BEDRM HOME OFFERS AN INDOOR OLYMPIC SIZE POOL WITH SCENIC VIEWS TO THE LAND AND STREAM. THE L/L WALKOUT HAS AN OFFICE/LIBRARY WITH A NATURAL F/P, A BEDRM WITH A FULL BATH, FORMER STEAM RM, POTENTIAL WINE RM WITH ACCESS TO THE INDOOR POOL. POTENTIAL OF 4 LOT SPLITS ALONG THE STREAM. NEW OWNERS TO VERIFY WETLANDS /FLOOD ZONE.

Last Agent to Sell the Property

Robert Weltman

Real Estate One-Royal Oak License #6501164287 Listed on: 04/09/2013

Real Estate One-Royal Oak

Last Buyer's Agent

Donna Blakeney

Lady of the Lakes Real Estate, Inc. License #6502342854

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1955

Lot Details

  • 9.93 Acre Lot
  • Lot Dimensions are 1065x635
  • Home fronts a pond
  • Lake Front
  • Wooded Lot

Parking

  • 2 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction

Interior Spaces

  • 2,256 Sq Ft Home
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Water Views
  • Partially Finished Basement
  • Sump Pump

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Full Bathrooms

Eco-Friendly Details

  • Air Purifier

Outdoor Features

  • Lake Privileges
  • Deck
  • Exterior Lighting

Utilities

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

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 1912101003

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,874

Year Built

Built in 1955

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 1955
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Air Purifier
  • Fireplace: Yes
  • Fireplace Locations: Family Room, Great Room
  • Room Count: 13
  • Total Bedrooms: 4
  • Total Bathrooms: 4.00
  • Full Bathrooms: 4
  • Basement: Yes
  • Basement Type: Partially Finished
  • Sq Ft Combined: 3756
  • Sq Ft Lower Floor: 1500
  • Total Sq Ft: 2256
  • Sq Ft Total Bsmt: 2256

Exterior Features

  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exterior Features: Lighting
  • Frontage Feet: 1065
  • Porch Type: Deck
  • Road Frontage Type: Paved
  • Waterfront Description: Lake Front, Lake/River Priv, Pond

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas, Oil
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • 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: 130916.0000
  • Lot Features: Water View, Wooded
  • Lot Size Area: 9.93
  • Lot Dimensions: 1065X635
  • Parcel Number: 1912101003

Tax Info

  • Tax Amount Summer: 5019.0000
  • Tax Amount Winter: 4855.0000
  • Total Tax: 9874.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 9, 2013
Closed on
Sep 27, 2013
Sold by
The Stanford R Ovshinsky Revocable Trust
Bought by
A Good Year Trust
Seller's Agent
Robert Weltman
Real Estate One-Royal Oak
Buyer's Agent
Donna Blakeney
Lady of the Lakes Real Estate, Inc.
List Price
$1,400,000
Sold Price
$1,200,000
Premium/Discount to List
-$200,000
-14.29%
Current Estimated Value
$1,846,033

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$646,033
Avg. Annual Appreciation
3.45%

Purchase Details

Closed on
Apr 1, 2008
Sold by
Ovshinsky Stanford R
Bought by
Ovshinsky Stanford R and The Iris M Ovshinsky Irrevocable Trust

Purchase Details

Closed on
Feb 19, 2003
Sold by
Ovshinsky Stanford R and Ovshinsky Iris M
Bought by
The Stanford R Ovshinsky Revocable Trust and The Iris M Ovshinsky Revocable Trust

Purchase Details

Closed on
Feb 13, 2003
Sold by
Ovshinsky Stanford R
Bought by
Ovshinsky Stanford R and Ovshinky Iris M

Purchase Details

Closed on
Jul 24, 1998
Sold by
Ovshinsky Stanford R
Bought by
Stanford R Ovshinsky Tr
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
A Good Year Trust -- Capital Title Ins Agency
Ovshinsky Stanford R -- None Available
Ovshinsky Stanford R -- None Available
The Stanford R Ovshinsky Revocable Trust -- --
Ovshinsky Stanford R -- --
Stanford R Ovshinsky Tr -- --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/27/2013 09/27/13 Sold $1,200,000 -14.3% $532 / Sq Ft
08/28/2013 08/28/13 Pending -- -- --
04/09/2013 04/09/13 For Sale $1,400,000 -- $621 / 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 $25,310 $1,689,620 $0 $0
2023 $24,493 $1,583,170 $0 $0
2022 $48,083 $1,542,310 $0 $0
2021 $48,260 $1,480,360 $0 $0
2020 $28,931 $1,442,860 $0 $0
2019 $30,637 $905,370 $0 $0
2018 $19,452 $683,430 $0 $0
2017 $10,553 $495,930 $0 $0
2016 $10,705 $642,140 $0 $0
2015 -- $626,480 $0 $0
2014 -- $261,220 $0 $0
2011 -- $250,440 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Robert Weltman

    Seller's Agent in 2013

    Robert Weltman

    Real Estate One

    (248) 408-5171

    35 Total Sales

    Robert Weltman
    Section Image

  • D

    Buyer's Agent in 2013

    Donna Blakeney

    Lady of the Lakes Real Estate, Inc.

    (734) 674-9374

    2 Total Sales

    Donna Blakeney
    Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 213032221

Realcomp

APN: 19-12-101-003

Michigan Oakland County Bloomfield Hills 48304

2700 Squirrel Rd, Bloomfield Hills, MI

This home is located at 2700 Squirrel Rd, Bloomfield Hills, MI 48304 since 09 April 2013 and is currently estimated at $1,846,033, approximately $818 per square foot. This property was built in 1955. 2700 Squirrel Rd is a home located in Oakland County with nearby schools including Eastover Elementary School, Bloomfield Hills High School, and Academy of Sacred Heart.

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.

Realcomp 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