Located on one of Birmingham’s most desirable streets, the grand front porch creates a warm welcome to this Nantucket style home. The dramatic grand entrance with domed ceiling creates the perfect floorplan for entertaining! Two story great room loaded with windows floods the room with natural light. Well appointed chef’s kitchen with dual islands, walk in pantry, butler’s pantry and beautiful coffered ceiling. First floor master suite boasts French doors to backyard, dual WIC, beautiful marble, lux spa tub and euro shower. Lower level is an extension of the grand upstairs. Stone fireplace and built-ins, 2nd kitchen, wine tasting room, nanny suite and so much more! Upstairs has a large en suite plus a Jack & Jill, each bedroom with its own WIC. 1st and 2nd floor laundry rooms. Stone patio off the breakfast room opens to beautifully landscaped backyard. So much more!
Crain HomesLicense #6501313842Listed on: 12/01/2020
Home Details
Home Type
Single Family
Est. Annual Taxes
Year Built
Built in 2004 | Remodeled in 2015
Lot Details
0.27 Acre Lot
Lot Dimensions are 80.00x148.00
Fenced
Sprinkler System
Home Design
Colonial Architecture
Poured Concrete
Wood Shingle Roof
Stone Siding
Chimney Cap
Interior Spaces
4,759 Sq Ft Home
2-Story Property
Wet Bar
Central Vacuum
Bar Fridge
Gas Fireplace
Great Room with Fireplace
Security System Owned
Kitchen
Free-Standing Gas Range
Range Hood
Recirculated Exhaust Fan
Microwave
Built-In Refrigerator
Ice Maker
Dishwasher
Wine Cooler
Stainless Steel Appliances
Disposal
Bedrooms and Bathrooms
6 Bedrooms
Jetted Tub in Primary Bathroom
Laundry
Dryer
Washer
Finished Basement
Sump Pump
Fireplace in Basement
Basement Window Egress
Parking
2 Car Direct Access Garage
Garage Door Opener
Outdoor Features
Spa
Covered patio or porch
Exterior Lighting
Utilities
Forced Air Heating and Cooling System
Humidifier
Vented Exhaust Fan
Heating System Uses Natural Gas
Programmable Thermostat
High Speed Internet
Cable TV Available
Additional Features
Air Purifier
Ground Level
Listing and Financial Details
Assessor Parcel Number 1935230002
Community Details
Overview
No Home Owners Association
Birmingham Park Allotment Subdivision
Amenities
Laundry Facilities
Home Details
Home Type
Single Family
Est. Annual Taxes
$38,622
Year Built
Built in 2004 | Remodeled in 2015
Lot Details
0
Listing Details
Property Type: Residential
Architecture Style: Colonial
Architecture Level: 2 Story
Year Built: 2004
State Equalized Value: 934560.0000
Year Renovated: 2015
Foundation Features: Sump Pump
Entry Location: Ground Level w/Steps
Special Features: None
Property Sub Type: Detached
Stories: 2
Interior Features
Interior Amenities: Air Purifier, Cable Available, Central Vacuum, Egress Window(s), High Spd Internet Avail, Humidifier, Jetted Tub, Programmable Thermostat, Security Alarm (owned), Spa/Hot-tub, Wet Bar
Fireplace: Yes
Fireplace Fuel: Gas, Natural
Fireplace Locations: Basement, Great Room
Room Count: 20
Total Bedrooms: 6
Total Bathrooms: 4.10
Full Bathrooms: 4
Half Bathrooms: 1
Basement: Yes
Basement Type: Daylight, Finished
Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Exhaust Fan, Ice Maker, Microwave, Free-Standing Gas Range, Range Hood, Built-In Refrigerator, Stainless Steel Appliance(s), Vented Exhaust Fan, Washer, Wine Cooler
Garage Features: Attached, Direct Access, Door Opener, Electricity
Garage: Yes
Utilities
Heating Fuel: Natural Gas
Cooling: Central Air
Heating: Forced Air
Sewer: Public Sewer (Sewer-Sanitary)
Water Source: Public (Municipal)
Laundry Facilities: Yes
Condo/Co-op/Association
Association Fee: No
Schools
School District: Birmingham
Lot Info
Homestead: Yes
List Price per Acre: 7962962.9630
Lot Features: Sprinkler(s)
Lot Size Area: 0.27
Lot Dimensions: 80.00X148.00
Parcel Number: 1935230002
Tax Info
Tax Amount Summer: 33779.0000
Tax Amount Winter: 4843.0000
Total Tax: 38622.0000
Taxable Value: 929950.0000
MLS Schools
School District: Birmingham
Ownership History
DateNameOwned ForOwner Type
Mar 2021 - PresentFipp David B and Fipp Jennifer A4 Years and 2 Months
Private Individual
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
61
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
Nov 2017 - Mar 2021Barry Scott and Barry Erica3 Years and 4 Months
Private Individual
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%
Mar 2015 - Nov 2017Trombley Roland and Trombley Christine2 Years and 8 Months
Private Individual
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
Mar 2011 - Mar 2015Lavorata Louis4 Years
Private Individual
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
Mar 2004 - Mar 2011Rudolph T Stonisch Iii Trust7 Years
Private Individual
Purchase Details
Closed on
Mar 3, 2004
Sold by
Robinson David E and Robinson Molly Gibbons
Bought by
Rudolph T Stonisch Iii Trust
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
Timeless sophistication meets resort-style living on one of Birmingham’s most sought-after streets! Rare combination of a first-floor primary suite, over a half-acre lot and a backyard oasis. Large circular driveway, covered front porch entry. Extensive crowd molding & custom millwork, hardwood floors throughout entry level. Gourmet granite kitchen featuring a 9’ island with countertop seating &
Cranbrook Custom Homes presenting a crafty contemporary first floor master in downtown Birmingham. Lot offering over a half acre of privacy with availability for in law suit and future pool. This Geneva offers a sleek open concept style in a downtown atmosphere, featuring expansive kitchen with oversized island and luxurious lanai for outdoor entertaining. Walking into the Geneva you are going to
Builder's own exceptional home in Quarton Lake Estates epitomizes spectacular quality, comfort & versatile design—open concept with nine-foot ceilings, impressive 2-story foyer with extra-wide hallways & stairs. Gourmet '21 kitchen renovation with island, breakfast nook, Wolf range, 2 Bosch dishwashers, Subzero fridge adjoins great room with Pewabic fireplace and enchanting screened porch which
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
Experience the epitome of contemporary living in this stunning 5,100 sq. ft. home, crafted by HM Homes in 2020. This 4-bedroom, 4.1-bath home boasts premium upgrades, including Thermador appliances, custom cabinetry, and elegant hardwood flooring throughout.Since their purchase, the sellers have enhanced the property with meticulous landscaping, privacy trees, a backyard retractable pergola, and
NEW CONSTRUCTION! Built with the highest quality materials. This is an exceptional home that you will be proud to own. The expansive great room, dining room and well-appointed kitchen are the heart of this beautiful home. Large entertainment area with additional bar and seating/counter space. The kitchen boasts Italian cabinetry, stone countertops and top-of-line Wolf and Sub Zero
Introducing 827 Larchlea; an incredible new construction in Birmingham on a RARE & COVETED 90’x145’ home site! Built and designed by award winning HM Homes, this property offers unparalleled features! Nestled west of Woodward on a gorgeous tree-lined street, this home is walkable to Lincoln St tennis courts, Linden Park trail, and downtown Birmingham! The home boasts a 2-car side entry attached
**CURRENTLY UNDER CONSTRUCTION - SHOWINGS WILL BEGIN MAY 23, 2025** GORGEOUS 'MODERN' NEW CONSTRUCTION HOME TO BE COMPLETED BY JUNE 30, 2025 - BEAUTIFULLY DESIGNED MASTERPIECE - 5 1/2 BATHS - HUGE GREAT ROOM W/LINEAR FIREPLACE - COVERED LOGGIA W/FIREPLACE - THREE CAR TANDEM STYLE GARAGE - GRAND WIDE OPEN FLOOR PLAN - QUALITY CUSTOM APPOINTMENTS & IMPORTED FIXTURES THROUGHOUT - EXQUISITE QUARTZ
Magnificent six bedroom, four full bath and one half bath brick colonial located in the heart of Quarton Lake Estates. This exquisite residence is the ultimate combination of luxury and lifestyle and its exceptional location is steps away from every world class amenities Downtown Birmingham has to offer. This spectacular home has been completely remodeled and features a new gourmet chefs kitchen
John Apap@properties Christie's Int'l R.E. Birmingham
Tax AssessmentTax 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.
This home is located at 175 Aspen Rd, Birmingham, MI 48009 since 01 December 2020 and is currently estimated at $2,764,244, approximately $580 per square foot. This property was built in 2004. 175 Aspen Rd is a home located in Oakland County with nearby schools including Pierce Elementary School, Derby Middle School, and Ernest W. Seaholm High School.
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.
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
