NOT LISTED FOR SALE

1837 Squirrel Valley Dr Bloomfield Hills, MI 48304

Estimated Value: $609,246 - $672,000

4 Beds
2.5 Baths
3,496 Sq Ft
$182/Sq Ft Est. Value

Last Sold February 10, 2012

Last sale price $225,199 $64 Per Sq Ft

Est. 183% increase in value since last sale

Current estimated payment $3,685/month

248 Days on Market

Highlights

  • Colonial Architecture
  • Porch
  • Patio
  • No HOA
  • 3 Car Attached Garage
  • Forced Air Heating and Cooling System

About This Home

As of February 2012

Make an offer! REO PROPERTY-BANK OWNED. PROPERTY SOLD "AS IS" WITHOUT REPAIR, WARRANTY OR SELLER DISCLOSURE. The listing Broker and Seller assume no responsibility and make no guarantees, warranties or representations as to availability or accuracy of the property information, photographs, or other information depicted or described herein. There is a Web Technology fees of $199.SEE AGENT REMARKS FOR LOCKBOX CODE. Property Id:0006339782

Last Listed By

Randal Newhouse

Randy Newhouse Realty License #6501262600 Listed on: 05/06/2011

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1993

Lot Details

  • Fenced

Parking

  • 3 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 3,496 Sq Ft Home
  • 2-Story Property
  • Finished 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
  • Bloomfield North Estates Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1901151016

Home Details

Home Type

Single Family

Year Built

Built in 1993

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Assessment: YES
  • Year Built: 1993
  • Special Features: 20
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Room Count: 6
  • Total Bedrooms: 4
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Sq Ft Combined: 3496
  • Total Sq Ft: 3496

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exterior Features: Fenced
  • 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: Central Air
  • Heating: Forced Air
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Avondale

Lot Info

  • Lot Dimensions: 16117
  • Parcel Number: 1901151016

Tax Info

  • Tax Amount Summer: 3214.0000
  • Tax Amount Winter: 3561.0000
  • Total Tax: 6775.0000

MLS Schools

  • School District: Avondale

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 6, 2011
Closed on
Feb 25, 2012
Sold by
Hsbc Bank Usa National Association
Bought by
Naqvi Ali
Seller's Agent
Randal Newhouse
Randy Newhouse Realty
Buyer's Agent
Tony Dallo
Utica Realty LLC
List Price
$255,600
Sold Price
$225,199
Premium/Discount to List
-$30,401
-11.89%
Total Days on Market
248
Current Estimated Value
$636,812

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$411,613
Avg. Annual Appreciation
8.23%
Original Mortgage
$211,687
Outstanding Balance
$149,183
Interest Rate
3.89%
Mortgage Type
New Conventional
Estimated Equity
$492,840

Purchase Details

Closed on
Aug 17, 2010
Sold by
Greene Arthur J and Greene Brenda
Bought by
Hsbc Bank Usa Na

Purchase Details

Closed on
Jul 6, 2001
Sold by
Greene Arthur J
Bought by
Greene Arthur J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$378,000
Interest Rate
7.16%

Purchase Details

Closed on
Feb 20, 1997
Sold by
Greene Arthur J
Bought by
Greene Arthur J

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

  • 815 Great Oaks Dr, Bloomfield Hills, MI 48304

    $674,900

    • 4 Beds
    • 2.5 Baths
    • 2,719 Sq Ft
    • 815 Great Oaks Dr
    • Bloomfield Hills, MI

    Welcome to this beautifully maintained 4-bedroom, 2.5-bath Colonial, featuring a thoughtful mix of updates and classic charm. Step inside to find hardwood flooring throughout the living room, dining room, library, and hallway (2015), with hardwood also under the carpet in the family room and all bedrooms—perfect for future customization. The partially finished basement (2019) offers great

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 1965 Devonshire Rd, Bloomfield Hills, MI 48302

    $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

    Section Image
  • 5799 Blandford Ct, Bloomfield Hills, MI 48302

    $650,000

    • 3 Beds
    • 2.5 Baths
    • 2,027 Sq Ft
    • 5799 Blandford Ct
    • Bloomfield Hills, MI

    Welcome to this beautifully remodeled ranch!This home features a gourmet kitchen with granite countertops, aesthetically pleasing cabinetry, and a large center island that comfortably seats six. Stainless steel appliances, recessed lighting, and interior cabinet lighting truly make this gem shine.Enjoy hardwood floors throughout, a cedar closet, and large French patio doors flanked by additional

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 1048 Home Ln, Bloomfield Hills, MI 48304

    $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

    Section Image
  • 1021 Oak Tree Ln, Bloomfield Hills, MI 48304

    $565,000

    • 4 Beds
    • 3.5 Baths
    • 2,751 Sq Ft
    • 1021 Oak Tree Ln
    • Bloomfield Hills, MI

    Beautiful Bloomfield Hills Home with Endless Possibilities!!!This inviting home offers the perfect blend of beauty, space and untapped potential. Tucked away in a quiet cul-de-sac in the desired Shaker Heights Subdivision, this home features an open kitchen, formal dining room, private office or library, a large family room with fireplace, vaulted ceilings and lots of natural light. The

    Geri Anderson Max Broock, REALTORS®-Bloomfield Hills

    Section Image
  • 2166 Brenthaven Dr, Bloomfield Hills, MI 48304

    $470,000

    • 4 Beds
    • 2.5 Baths
    • 2,444 Sq Ft
    • 2166 Brenthaven Dr
    • Bloomfield Hills, MI

    Welcome to a lifestyle of comfort and ease in this beautifully maintained family home, located in the sought-after Adam's Square subdivision within the top-rated Bloomfield Hills School District. Designed for modern living, this spacious residence features an open-concept layout with hardwood floors and a remodeled kitchen, perfect for gathering and entertaining. The family room, bathed in

    Antonio Wells Max Broock, REALTORS®-Birmingham

    Section Image
  • 2470 Inglehill Pointe, Bloomfield Hills, MI 48304

    $739,999

    • 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
  • 1930 Hunters Ridge Dr, Bloomfield Hills, MI 48304

    $479,000

    • 4 Beds
    • 2.5 Baths
    • 2,662 Sq Ft
    • 1930 Hunters Ridge Dr
    • Bloomfield Hills, MI

    WOW! Come see this fantastic 4 bedroom home with Bloomfield Hills Schools! This beautiful property has it all - huge bedrooms, large finished basement with a wet bar, spacious workshop, cedar closet and generous storage, as well as an office/den, first floor laundry, pantry, gas fireplace, great yard, big deck for entertaining, epoxy garage floor and more. And you can take comfort that you're

    Adrian Lark Keller Williams Advantage

    Section Image
  • 2732 Eastways Rd, Bloomfield Hills, MI 48304

    $534,900

    • 4 Beds
    • 2.5 Baths
    • 2,665 Sq Ft
    • 2732 Eastways Rd
    • Bloomfield Hills, MI

    Brick colonial in the heart of Bloomfield Township, on almost a half an acre lot. Bloomfield Hills Schools: Eastover Elementary, North Hills Middle School and Bloomfield Hills High School. Walking distance to The International Academy, less than ten minute drive to Cranbrook and the Academy of Sacred Heart. Five minute drive to the Bloomfield Open Hunt, offering equestrian, racquet sports,

    Matthew Barker Max Broock, REALTORS®-Birmingham

    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
Naqvi Ali $225,199 Complete Title Services Of S
Hsbc Bank Usa Na $582,990 None Available
Greene Arthur J -- --
Greene Arthur J -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Naqvi Ali $46,000
Open Naqvi Ali $211,687
Previous Owner Greene Arthur J $504,000
Previous Owner Greene Arthur J $442,000
Previous Owner Greene Arthur J $378,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/10/2012 02/10/12 Sold $225,199 -11.9% $64 / Sq Ft
01/09/2012 01/09/12 Pending -- -- --
05/06/2011 05/06/11 For Sale $255,600 -- $73 / 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 $3,665 $269,570 $0 $0
2023 $3,496 $242,470 $0 $0
2022 $6,513 $222,160 $0 $0
2021 $6,354 $213,140 $0 $0
2020 $3,203 $202,170 $0 $0
2019 $6,205 $201,610 $0 $0
2018 $6,090 $201,130 $0 $0
2017 $5,996 $195,130 $0 $0
2016 $5,987 $178,350 $0 $0
2015 -- $157,920 $0 $0
2014 -- $162,680 $0 $0
2011 -- $141,480 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 211049107

Realcomp

APN: 19-01-151-016