$1,662,500
SOLD MAR 2, 2015

175 Aspen Rd Birmingham, MI 48009

6 Beds
4.5 Baths
4,792 Sq Ft
0.28 Acres

Recently Sold

$347 Per Sq Ft

10% Below List Price

76 Days on Market

Highlights

  • Colonial Architecture
  • Jetted Tub in Primary Bathroom
  • Covered patio or porch
  • Pierce Elementary School Rated A
  • No HOA
  • 2 Car Direct Access Garage

About This Home

As of March 2021

Stunning home situated on one of Birmingham's most desired streets. Sellers took a great home and made it even better with upgrades galore! Gracious floor plan with over sized windows and sun-filled rooms. Gourmet kitchen is a showplace with dual islands, coffer ceiling, premium appliances, stunning stone & walk-in pantry. Hard to find first floor master suit with spa-like bath and french doors to the private backyard. Home also boast: 2 laundry facilities, 10ft ceilings, wide planked hardwoods, over-sized solid doors, 3 fireplaces and miles of custom millwork. Grand entrance with dome ceiling, and dramatic stairwell with custom iron rail. 3 ample bdrms upstairs with loft area and back stairwell to the gorgeous 2 story family rm. LL is finished with 2nd full kitchen, rec rm, 5th & potential 6th bdrm. LL also boast a handsome wine room with fine stone and dance area with ballet bar. Professional landscaping and great use of cobblestone & blue stone. All within walking distance to town!

Last Agent to Sell the Property

Sara Storch Lipnitz

The Agency Hall & Hunter License #6501309217

The Agency Hall & Hunter

Last Buyer's Agent

Barbara Draplin

Coldwell Banker Weir Manuel-Bir License #RCO-6501248179

Coldwell Banker Weir Manuel-Bir

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2004

Lot Details

  • 0.28 Acre Lot
  • Lot Dimensions are 80x148x80x148
  • Fenced
  • Level Lot

Home Design

  • Colonial Architecture
  • Poured Concrete
  • Wood Shingle Roof
  • Stone Siding

Interior Spaces

  • 4,792 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Bar Fridge
  • Ceiling Fan
  • Gas Fireplace
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Security System Owned

Kitchen

  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

  • Sump Pump
  • Fireplace in Basement

Parking

  • 2 Car Direct Access Garage
  • Garage Door Opener

Eco-Friendly Details

  • Air Purifier

Outdoor Features

  • Covered patio or porch
  • Exterior Lighting

Utilities

  • Humidifier
  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Birmingham Park Allotment Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1935230002

Home Details

Home Type

Single Family

Est. Annual Taxes

$26,573

Year Built

Built in 2004

Lot Details

0

Listing Details

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

Interior Features

  • Interior Amenities: Air Purifier, Cable Available, Central Vacuum, High Spd Internet Avail, Humidifier, Jetted Tub, Security Alarm (owned), Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Basement, Family Room, Great Room
  • Room Count: 16
  • Total Bedrooms: 6
  • Total Bathrooms: 4.10
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Refrigerator, Range/Stove, Washer
  • Sq Ft Combined: 7392
  • Sq Ft Lower Floor: 2600
  • Total Sq Ft: 4792
  • Sq Ft Total Bsmt: 2951

Exterior Features

  • Roof Material: Wood (Cedar)
  • Foundation Details: Basement
  • Construction Materials: Stone
  • Exterior Features: Fenced, Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 80
  • Porch Type: Patio, Porch, Porch - Covered
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 2 Car
  • Garage Features: Direct Access, Door Opener, Electricity, Side Entrance
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air, Zoned
  • 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: Birmingham

Lot Info

  • Homestead: Yes
  • List Price per Acre: 6569642.8571
  • Lot Features: Level
  • Lot Size Area: 0.28
  • Lot Dimensions: 80X148X80X148
  • Parcel Number: 1935230002

Tax Info

  • Tax Amount Summer: 22904.0000
  • Tax Amount Winter: 3669.0000
  • Total Tax: 26573.0000

MLS Schools

  • School District: Birmingham

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 1, 2020
Closed on
Mar 19, 2021
Sold by
Barry Scott and Barry Erica
Bought by
Fipp David B and Fipp Jennifer A
Seller's Agent
Shondell Patterson
Crain Homes
Buyer's Agent
Katherine Broock
Max Broock, REALTORS®-Birmingham
List Price
$2,150,000
Sold Price
$2,020,000
Premium/Discount to List
-$130,000
-6.05%
Total Days on Market
76
Current Estimated Value
$2,764,244

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$744,244
Avg. Annual Appreciation
7.83%
Original Mortgage
$1,616,000
Outstanding Balance
$1,472,612
Interest Rate
2.9%
Mortgage Type
New Conventional
Estimated Equity
$1,291,632

Purchase Details

Listed on
Sep 13, 2017
Closed on
Nov 13, 2017
Sold by
Barry Scott
Bought by
Barry Scott and Barry Erica
Seller's Agent
Cindy Obron Kahn
The Agency Hall & Hunter
Buyer's Agent
Shondell Patterson
Crain Homes
List Price
$1,999,000
Sold Price
$1,900,000
Premium/Discount to List
-$99,000
-4.95%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.83%

Purchase Details

Listed on
Nov 25, 2014
Closed on
Mar 2, 2015
Sold by
Lavorata Louis and Lavorata Karen
Bought by
Trombley Roland and Trombley Christine
Seller's Agent
Sara Storch Lipnitz
The Agency Hall & Hunter
Buyer's Agent
Barbara Draplin
Coldwell Banker Weir Manuel-Bir
List Price
$1,839,500
Sold Price
$1,662,500
Premium/Discount to List
-$177,000
-9.62%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.07%
Original Mortgage
$1,080,625
Interest Rate
3.12%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Mar 27, 2011
Sold by
The Rudolph T Stonisch Iii Trust and Stonisch Rudolph T
Bought by
Lavorata Louis

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
4.37%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 3, 2004
Sold by
Robinson David E and Robinson Molly Gibbons
Bought by
Rudolph T Stonisch Iii Trust

Map

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 Birmingham, MI

  • 404 Linden Rd, Birmingham, MI 48009

    $1,795,000

    • 4 Beds
    • 4.5 Baths
    • 3,536 Sq Ft
    • 404 Linden Rd
    • Birmingham, MI

    Nestled in the heart of Birmingham, this timeless 1927-built stucco home sits on an extraordinary 80x239 lot, offering the perfect blend of historic charm and modern luxury. The main level boasts elegant formal living and dining rooms, including a living room with a cozy gas fireplace, a comfortable sitting area, and a dedicated office featuring rich custom bookcases, cabinetry, and beautiful

    Cindy Obron Kahn The Agency Hall & Hunter

    Section Image
  • 578 Woodland St, Birmingham, MI 48009

    $2,100,000

    • 4 Beds
    • 4.5 Baths
    • 3,408 Sq Ft
    • 578 Woodland St
    • Birmingham, MI

    Experience upscale living at its finest in this stunning Birmingham residence, where thoughtful design and attention to detail shine throughout. Perfectly positioned within walking distance to downtown shops, acclaimed restaurants, vibrant parks, and the local farmers market, this home offers the perfect blend of convenience and luxury.Step inside to discover a fabulous interior where every

    Linda Eriksen Max Broock, REALTORS®-Birmingham

    Section Image
  • 751 S Bates St, Birmingham, MI 48009

    $1,799,900

    • 4 Beds
    • 5 Baths
    • 2,686 Sq Ft
    • 751 S Bates St
    • Birmingham, MI

    Steps away from downtown Birmingham, this exquisite residence is the ultimate combination of luxury and lifestyle. Just two blocks from every world class amenity of dining, shopping, pickleball courts, and parks that surround downtown Birmingham. Magnificent four bedroom, three full and two half bath. This spectacular home features a wide open floor plan, 10ft ceilings on the first floor with

    Renee Jadan EXP Z Real Estate

    Section Image
  • 664 Chesterfield Ave, Birmingham, MI 48009

    $1,795,000

    • 4 Beds
    • 6 Baths
    • 3,833 Sq Ft
    • 664 Chesterfield Ave
    • Birmingham, MI

    Beautiful Quarton Lake Estates home built in 1998 with numerous newer updates. First floor primary bedroom suite with a gorgeous new bath and double WIC's. Amazing open floor plan includes kitchen, nook and great room with gas fireplace that includes high vaulted ceiling with skylights.. Large center island with counter seating and new quartzite counters, SS double ovens and gas stove. Formal DR

    Chris Pero Max Broock, REALTORS®-Birmingham

    Section Image
  • 1684 W Lincoln St, Birmingham, MI 48009

    $1,599,999

    • 5 Beds
    • 5 Baths
    • 3,579 Sq Ft
    • 1684 W Lincoln St
    • Birmingham, MI

    Please submit all offers by Monday 5/19 - 6pm. Experience the perfect blend of luxury and comfort in this stunning custom-built (2019) residence, ideally located on a quiet cul-de-sac in one of Birmingham’s most sought-after neighborhoods. Just steps from parks, tennis, and pickleball courts, this home is designed for both upscale living and everyday family life. The open-concept main level is

    Renee Jadan EXP Z Real Estate

    Section Image
  • 1663 Fairway Dr, Birmingham, MI 48009

    $1,680,000

    • 5 Beds
    • 4.5 Baths
    • 3,285 Sq Ft
    • 1663 Fairway Dr
    • Birmingham, MI

    This stunning 5-bedroom, 4.5-bath colonial offers over 3,200 square feet of modern living and one of the largest yards you’ll find in Birmingham at this price point. Reimagined from the ground up in 2023, the home was completely rebuilt using the original, solid basement foundation, offering the benefits of new construction with the stability of time-tested bones. Inside, you’ll love the open,

    Paul Wolfert Century 21 Curran & Oberski

    Section Image
  • 1011 Pierce St, Birmingham, MI 48009

    $2,095,000

    • 4 Beds
    • 5.5 Baths
    • 3,935 Sq Ft
    • 1011 Pierce St
    • Birmingham, MI

    Stunning Brick Colonial Just Steps from Downtown Birmingham!Experience luxury living in this beautifully landscaped, 3-story brick colonial located within easy walking distance to downtown Birmingham's vibrant shops, restaurants, and year round events. Steps from Barnum park.This elegant home features an open-concept kitchen with Wolf and Sub-Zero appliances and a warm and inviting living room —

    Kathleen Remski @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 1850 Shipman Blvd, Birmingham, MI 48009

    $1,995,000

    • 5 Beds
    • 5.5 Baths
    • 3,349 Sq Ft
    • 1850 Shipman Blvd
    • Birmingham, MI

    Incredible new construction with 2 car attached garage, west of Woodward, nestled on one of Birmingham’s most desired streets and is walking distance to downtown Birmingham! Built by Live Well Custom homes, this sophisticated modern home has been designed to be just as functional as it is aesthetically pleasing with a perfect floor plan for indoor / outdoor entertaining boasting a clean open

    James Danley KW Domain

    Section Image
  • 1782 Stanley Blvd, Birmingham, MI 48009

    $1,899,900

    • 5 Beds
    • 5.5 Baths
    • 3,209 Sq Ft
    • 1782 Stanley Blvd
    • Birmingham, MI

    Incredible new construction with 2 car attached garage, west of Woodward, nestled on one of Birmingham’s most desired streets and is walking distance to downtown Birmingham! Built by Live Well Custom homes, this sophisticated modern home has been designed to be just as functional as it is aesthetically pleasing with a perfect floor plan for indoor / outdoor entertaining boasting a clean open

    James Danley KW Domain

    Section Image

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 -- Equity Title Agency Llc
Interfamily Deed Transfer -- None Available
Warranty Deed -- None Available
Warranty Deed $1,662,500 Cvt
Warranty Deed -- Interstate Title Inc
Warranty Deed -- Devon Title Agency
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,616,000 New Conventional
Previous Owner $1,347,500 Adjustable Rate Mortgage/ARM
Previous Owner $1,000,000 Credit Line Revolving
Previous Owner $1,119,800 Adjustable Rate Mortgage/ARM
Previous Owner $1,102,500 Adjustable Rate Mortgage/ARM
Previous Owner $1,080,625 Adjustable Rate Mortgage/ARM
Previous Owner $350,000 Credit Line Revolving
Previous Owner $417,000 New Conventional
Previous Owner $1,000,000 Future Advance Clause Open End Mortgage
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/26/2021 03/26/21 Sold $2,020,000 -6.0% $424 / Sq Ft
02/01/2021 02/01/21 Pending -- -- --
12/01/2020 12/01/20 For Sale $2,150,000 +13.2% $452 / Sq Ft
11/13/2017 11/13/17 Sold $1,900,000 -5.0% $396 / Sq Ft
10/25/2017 10/25/17 Pending -- -- --
09/13/2017 09/13/17 For Sale $1,999,000 +20.2% $417 / Sq Ft
03/02/2015 03/02/15 Sold $1,662,500 -9.6% $347 / Sq Ft
02/09/2015 02/09/15 Pending -- -- --
11/25/2014 11/25/14 For Sale $1,839,500 -- $384 / Sq Ft
Source: Realcomp

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 $33,680 $988,820 $0 $0
2023 $33,840 $987,450 $0 $0
2022 $36,685 $950,850 $0 $0
2021 $37,913 $950,060 $0 $0
2020 $33,779 $934,560 $0 $0
2019 $38,226 $929,400 $0 $0
2018 $38,133 $891,240 $0 $0
2017 $36,495 $869,990 $0 $0
2016 $36,562 $833,770 $0 $0
2015 -- $745,630 $0 $0
2014 -- $666,340 $0 $0
2011 -- $498,390 $0 $0
Source: Public Records

Source: Realcomp

MLS Number: 214121405

Realcomp

APN: 19-35-230-002