NOT LISTED FOR SALE

2775 Squirrel Rd Bloomfield Hills, MI 48304

Estimated Value: $955,000 - $1,546,000

4 Beds
3.5 Baths
4,206 Sq Ft
$286/Sq Ft Est. Value

Last Sold November 27, 2012

Last sale price $471,500 $112 Per Sq Ft

Est. 155% increase in value since last sale

Current estimated payment $7,095/month

13 Days on Market

Highlights

  • Ranch Style House
  • No HOA
  • 3 Car Attached Garage
  • Eastover Elementary School Rated A
  • Porch
  • Patio

About This Home

As of November 2012

This is not a short sale. Spacious and sprawling ranch is nestled on 1.77 beautiful acres. Great family house with 4 bedrooms, 3 full baths and a large traditional dining room ideal for entertaining. New master suite with office and luxurious master bath added 2008. Must close by Nov 29, 2012. ** NO SHOWINGS UNTIL FURTHER NOTICE - MULTIPLE OFFER SITUATION - FINAL SHOWINGS HAVE BEEN SCHEDULED - HIGHEST AND BEST DUE THURSDAY OCTOBER 18, 2012 AT NOON **

Last Listed By

Matthew Duffield

Shamrock Acquisitions LLC License #6501355835 Listed on: 10/09/2012

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1952 | Remodeled in 1999

Lot Details

  • 1.77 Acre Lot
  • Lot Dimensions are 155 x 487

Parking

  • 3 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction

Interior Spaces

  • 4,206 Sq Ft Home
  • Ceiling Fan
  • Dining Room with Fireplace
  • Basement

Bedrooms and Bathrooms

  • 4 Bedrooms

Outdoor Features

  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association
  • Kentmoor No 1 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1912176019

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,224

Year Built

Built in 1952 | Remodeled in 1999

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 1952
  • Year Renovated: 1999
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Fireplace: Yes
  • Fireplace Locations: Dining Room
  • Room Count: 13
  • Total Bedrooms: 4
  • Total Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Sq Ft Combined: 4206
  • Total Sq Ft: 4206

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick
  • Frontage Feet: 155
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

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

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • 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: 223107.0000
  • Lot Size Area: 1.77
  • Lot Dimensions: 155 X 487
  • Parcel Number: 1912176019

Tax Info

  • Tax Amount Summer: 3141.0000
  • Tax Amount Winter: 3083.0000
  • Total Tax: 6224.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 9, 2012
Closed on
Nov 27, 2012
Sold by
Monahan Suzanne L and Monahan Lawrence J
Bought by
Hughes Christopher and Hughes Rebecca
Seller's Agent
Matthew Duffield
Shamrock Acquisitions LLC
Buyer's Agent
Jennifer Zardus
Coldwell Banker Weir Manuel-Bir
List Price
$394,900
Sold Price
$471,500
Premium/Discount to List
$76,600
19.4%
Total Days on Market
13
Current Estimated Value
$1,202,738

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$731,238
Avg. Annual Appreciation
7.79%

Purchase Details

Closed on
May 29, 2012
Sold by
Monahan Lawrence J and Monahan Suzanne L
Bought by
Deutsche Bank Trust Company Americas

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

Similar Homes in Bloomfield Hills, MI

  • 1256 Lenhill Ct, Bloomfield Hills, MI 48304

    $1,450,000

    • 4 Beds
    • 4 Baths
    • 4,463 Sq Ft
    • 1256 Lenhill Ct
    • Bloomfield Hills, MI

    This custom home is situated on an acre of lush wooded landscape, is LEED certified, & has a timeless design. Gracious living spaces feature HW floors, tall ceilings, & peaceful nature views from every window. Enjoy the convenience of a first-floor master suite w/spa bath & WIC. Lovely living room with vaulted ceilings, gas fireplace & skylights. The family room opens to the spacious kitchen with

    Frank Flynn The Agency Hall & Hunter

    Section Image
  • 1301 Romney Rd, Bloomfield Hills, MI 48304

    $949,900

    • 5 Beds
    • 4.5 Baths
    • 4,618 Sq Ft
    • 1301 Romney Rd
    • Bloomfield Hills, MI

    Nestled in the picturesque Kentmoor Sub, 4,618 sq ft home offers a blend of Luxury and Comfort. Huge open Great Room, with its own fireplace, creates a warm and inviting atmosphere perfect for large gatherings or quiet evenings, skylites offer more natural light. The expansive kitchen is a chefs dream, features a gas cooktop, double ovens. 2 dishwashers, granite countertops, under and above

    Tim Vagasky Real Estate One-Troy

    Section Image
  • 790 Hidden Pine Rd, Bloomfield Hills, MI 48304

    $1,194,900

    • 4 Beds
    • 3.5 Baths
    • 3,877 Sq Ft
    • 790 Hidden Pine Rd
    • Bloomfield Hills, MI

    Nestled on a serene cul-de-sac, this exceptional 4-bedroom home offers the perfect blend of elegance, comfort, and tranquility. Situated on a beautifully wooded lot, the property provides an ideal setting for those seeking both privacy and nature. Step inside to discover an inviting floor plan, highlighted by a formal dining room ideal for hosting gatherings. The well-appointed butler's quarters

    Dane Ramsden Keller Williams Paint Creek

    Section Image
  • 565 Tally Ho Ct, Bloomfield Hills, MI 48304

    $990,000

    • 4 Beds
    • 3.5 Baths
    • 3,429 Sq Ft
    • 565 Tally Ho Ct
    • Bloomfield Hills, MI

    Nestled in the prestigious Bloomfield Crossing subdivision, this meticulously updated Tudor home offers a seamless blend of classic elegance and sophistication. Boasting an extensive array of recent enhancements, including new triple-pane windows and slider doors, a premium Trex deck, custom plantation shutters, and a fully renovated mudroom and laundry room, no detail has been overlooked. A

    Joanne Mcglothlin Signature Sotheby's International Realty Bham

    Section Image
  • 1539 Bartley Ln, Bloomfield Hills, MI 48304

    $1,199,000

    • 6 Beds
    • 6.5 Baths
    • 5,262 Sq Ft
    • 1539 Bartley Ln
    • Bloomfield Hills, MI

    This spacious 6-bedroom, 6.5-bathroom home in Bloomfield Hills offers over 6,000 sq. ft. of living space, making it an excellent value for the price. Located on a quiet cul-de-sac with Bloomfield Hills Schools, this full-brick, three-story home features a grand two-story foyer, a large living room with a fireplace, and a chef-inspired kitchen with granite countertops, maple cabinets,

    Tushar Vakhariya KW Domain

    Section Image
  • 630 Willow Glen Ct, Bloomfield Hills, MI 48304

    $960,000

    • 4 Beds
    • 4 Baths
    • 3,716 Sq Ft
    • 630 Willow Glen Ct
    • Bloomfield Hills, MI

    Wow, wow, wow. Welcome to this Bloomfield Hills 3700 square-foot brick walkout colonial sitting on a 1.7-acre wooded lot. This home is something special. Extremely well-maintained with minimal traffic on a cul-de-sac, shared by two other homes. The property offers an amazing layout with a large kitchen, a two-story great room, a living room, dining room and office all on one floor. Home has

    Mike Sher Max Broock, REALTORS®-Bloomfield Hills

    Section Image
  • 215 Hadsell Dr, Bloomfield Hills, MI 48302

    $1,350,000

    • 5 Beds
    • 4 Baths
    • 5,168 Sq Ft
    • 215 Hadsell Dr
    • Bloomfield Hills, MI

    Modern Farmhouse Masterpiece in Bloomfield Twp.Situated in the prestigious Bloomfield Hills School District, this estate was built in 2019 with exceptional craftsmanship. Offering over 5,000 SQFT of finished luxury. Featuring 5 bedrooms, 4 full baths, wide-plank stained hardwood floors, 8-ft doors, and designer lighting throughout. The chef's kitchen stuns with dual oversized refrigerators,

    Kenny Lanzar Arterra Realty Michigan LLC

    Section Image
  • 320 N Berkshire Rd, Bloomfield Hills, MI 48302

    $1,300,000

    • 4 Beds
    • 5 Baths
    • 3,441 Sq Ft
    • 320 N Berkshire Rd
    • Bloomfield Hills, MI

    Tucked away on 1.5 acres of tranquil, wooded landscape, this impeccably maintained 4-bedroom, 3 full baths and 2 half baths offers over 3,400 square feet of open-concept living, plus a fully finished walkout basement designed for both relaxation and entertaining. The light-filled interior showcases expansive windows that frame the natural surroundings and flood the home with sunlight. The

    Midge Moran KW Showcase Realty

    Section Image
  • 80 Maywood Ave, Bloomfield Hills, MI 48304

    $1,000,000

    • 4 Beds
    • 3 Baths
    • 2,398 Sq Ft
    • 80 Maywood Ave
    • Bloomfield Hills, MI

    Walk to downtown Birmingham from your new summer-ready home! This gorgeous, updated ranch home sits in a perfect location in Bloomfield, and belongs to the highly regarded Birmingham school district. Just in time for summer enjoyment, the home features a professionally landscaped backyard oasis by Great Lakes Landscape Design, complete with a built-in grill, bar, tranquil water feature, and fire

    Carl P Cohen KW Domain

    Section Image

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
Hughes Christopher -- Title Source Inc
Deutsche Bank Trust Company Americas $300,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hughes Christopher $640,000
Closed Hughes Christopher $679,000
Closed Hughes Christopher $500,000
Closed Hughes Christopher $300,000
Closed Hughes Christopher $250,000
Previous Owner Monahan Lawrence J $137,000
Previous Owner Monahan Lawrence J $823,000
Previous Owner Monahan Lawrence $650,000
Previous Owner Monahan Lawrence $135,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/27/2012 11/27/12 Sold $471,500 +19.4% $112 / Sq Ft
10/22/2012 10/22/12 Pending -- -- --
10/09/2012 10/09/12 For Sale $394,900 -- $94 / 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,745 $422,930 $0 $0
2023 $4,553 $355,630 $0 $0
2022 $8,559 $361,100 $0 $0
2021 $8,499 $358,540 $0 $0
2020 $4,165 $331,500 $0 $0
2019 $7,994 $282,130 $0 $0
2018 $8,031 $273,680 $0 $0
2017 $6,666 $239,240 $0 $0
2016 $6,678 $242,490 $0 $0
2015 -- $222,800 $0 $0
2014 -- $171,860 $0 $0
2011 -- $158,450 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 212103976

Realcomp

APN: 19-12-176-019