$525,000
$25K PRICE DROP

5959 Rosetta St Dearborn Heights, MI 48127

Estimated payment $3,096/month

Total Views 5,102
2 Beds
1 Bath
1,236 Sq Ft
$425 Price per Sq Ft

Highlights

  • 0.28 Acre Lot
  • Ground Level Unit
  • Patio
  • Contemporary Architecture
  • No HOA
  • Sound System

About This Home

Mid-Century Modern masterpiece designed by Joseph St. Cyr, an associate and contemporary of Minoru Yamasaki, one of the 20th century’s most prominent architects. Offered for the very first time in over five decades. This rare architectural gem was designed in1956 and built with post and beam cantilever construction, and featured on the cover of the September 1960 issue of Better Homes & Gardens magazine. Thoughtfully preserved with timeless elegance and integrity, maintaining the original design elements that define mid-century modernism. This extraordinary property presents a once-in-a-lifetime opportunity to own a true piece of housing design history. As you approach the entrance you’re greeted by the sound of a waterfall cascading over a 6’ 8” tall by 9’ long fieldstone wall that sits in a decorative pool. The fieldstone wall continues from the outside into the home. Once inside you’ll find rich wood parquet floors throughout the home, with expansive floor-to-ceiling windows and mitered floor to ceiling glass at all four corners of the home. On the living room side of the fieldstone wall is a freestanding sculptural fireplace that floats above a concrete cantilevered ledge. Natural light pours in from every direction, illuminating the space and creating a serene connection to the surrounding outdoor landscape. The home opens out to a professionally landscaped park-like private backyard oasis. The interior design elements and choices include iconic Herman Miller and House of Denmark mid-century teak furniture, with hand-woven Tibetan geometric patterned area rugs, custom-built shelving and cabinetry, including various custom built-ins such as; TV, radio, phonograph player, and speakers. Seller will consider and entertain separate offers for the various iconic mid-century furniture pieces and rugs or include with the sale of the home with the right offer. For further inquiry and to arrange your private showing, contact Hassan T. Bazzi.

Listing Agent

Hassan Bazzi

Keller Williams Advantage License #6501340686 Listed on: 06/21/2025

Keller Williams Advantage

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1957

Lot Details

  • 0.28 Acre Lot
  • Lot Dimensions are 80x149.48
  • Back Yard Fenced
  • Sprinkler System

Home Design

  • Contemporary Architecture
  • Ranch Style House
  • Slab Foundation
  • Asphalt Roof
  • Rubber Roof
  • Concrete Siding
  • Metal Siding
  • Stone Siding

Interior Spaces

  • 1,236 Sq Ft Home
  • Furnished or left unfurnished upon request
  • Sound System
  • Gas Fireplace
  • Entrance Foyer
  • Living Room with Fireplace
  • Carbon Monoxide Detectors

Kitchen

  • Free-Standing Gas Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 1 Full Bathroom

Laundry

  • Dryer
  • Washer

Parking

  • Carport
  • Driveway

Outdoor Features

  • Patio
  • Exterior Lighting

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater

Listing and Financial Details

  • Assessor Parcel Number 33021010080002

Community Details

Overview

  • No Home Owners Association
  • Comeford Ford Road Park Sub Subdivision

Amenities

  • Community Barbecue Grill
  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,886

Year Built

Built in 1957

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Contemporary, Ranch
  • Architecture Level: 1 Story
  • Year Built: 1957
  • State Equalized Value: 120400.0000
  • Entry Location: Ground Level
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Smoke Alarm, Carbon Monoxide Alarm(s), Entrance Foyer, Furnished - Negotiable, Sound System
  • Fireplace: Yes
  • Fireplace Fuel: Natural
  • Fireplace Locations: Living Room
  • Room Count: 10
  • Total Bedrooms: 2
  • Total Bathrooms: 1.00
  • Full Bathrooms: 1
  • Kitchen Appliances: Vented Exhaust Fan, Dishwasher, Disposal, Dryer, Free-Standing Gas Range, Free-Standing Refrigerator, Microwave, Washer
  • Sq Ft Combined: 1236
  • Total Sq Ft: 1236

Exterior Features

  • Roof Material: Asphalt, Rubber
  • Foundation Details: Slab
  • Construction Materials: Aluminum, Concrete, Metal Siding, Stone, Wood
  • Exterior Features: BBQ Grill, Lighting, Fenced
  • Frontage Feet: 80
  • Porch Type: Patio
  • Road Frontage Type: Paved
  • Fencing: Back Yard, Fenced

Garage/Parking

  • Garage Size: No Garage
  • Garage Features: Carport, Covered, Driveway

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Dearborn

Lot Info

  • Homestead: Yes
  • Lot Features: Sprinkler(s)
  • Lot Size Area: 0.28
  • Lot Dimensions: 80X149.48
  • Parcel Number: 33021010080002

Tax Info

  • Tax Amount Summer: 2118.0000
  • Tax Amount Winter: 768.0000
  • Total Tax: 2886.0000
  • Taxable Value: 55272.0000

MLS Schools

  • School District: Dearborn

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





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
2025 $2,118 $137,800 $0 $0
2024 $2,118 $120,400 $0 $0
2023 $1,890 $107,500 $0 $0
2022 $2,537 $98,900 $0 $0
2021 $2,843 $93,700 $0 $0
2019 $2,818 $75,600 $0 $0
2018 $1,930 $65,800 $0 $0
2017 $1,623 $65,700 $0 $0
2016 $2,663 $64,200 $0 $0
2015 $4,440 $60,100 $0 $0
2013 $4,301 $46,900 $0 $0
2010 -- $50,200 $0 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/04/2025 08/04/25 Price Changed $525,000 -4.5% $425 / Sq Ft
06/21/2025 06/21/25 For Sale $550,000 -- $445 / Sq Ft
Source: Realcomp

Mortgage History

Date Status Loan Amount Loan Type
Closed $61,539 Unknown
Source: Public Records

Similar Homes in Dearborn Heights, MI

  • 6450 N Lafayette St, Dearborn Heights, MI 48127

    $489,900

    • 3 Beds
    • 2 Baths
    • 1,196 Sq Ft
    • 6450 N Lafayette St
    • Dearborn Heights, MI

    Gorgeous 130' X 135' lot can be split to create two buildable lots! Impeccably maintained 3-bedroom brick ranch situated on a 130’ x 135’ lot! Unmatched charm with quality materials that continue to last. Honey oak hardwood floors hiding beneath the carpet waiting to see the light for the first time in their history. Gleaming galley Kitchen with real chrome accents and a stainless fan hood and

    Bradley Strange Remerica Hometown One

    Section Image
  • 22204 Dolphin Ct, Dearborn Heights, MI 48127

    $499,900

    • 4 Beds
    • 2.5 Baths
    • 2,200 Sq Ft
    • 22204 Dolphin Ct
    • Dearborn Heights, MI

    COLONIAL HOME SITUATED IN A PRIVATE NEIGHBORHOOD ON A PRIVATE ROAD WITH ONLY FOUR HOMES. THE PROPERTY FEATURES 4 BEDROOMS, 2 1/2 BATHS, AND SPACIOUS ROOM SIZES, PROVIDING AMPLE LIVING SPACE. THE HOUSE SITS ON A .23 ACRE LOT, OFFERING A COMFORTABLE OUTDOOR AREA FOR RELAXATION OR ENTERTAINING. ADDITIONALLY, THE HOME HAS SEVERAL UPGRADES, INCLUDING AN UPDATED ROOF, NEW FURNACE, NEW HOT WATER TANK,

    Ali T. Charara Century 21 Curran & Oberski

    Section Image
  • 5908 Kinmore St, Dearborn Heights, MI 48127

    $629,900

    • 4 Beds
    • 3.5 Baths
    • 2,500 Sq Ft
    • 5908 Kinmore St
    • Dearborn Heights, MI

    LOCATION, LOCATION, LOCATION! Welcome to this stunning custom-built home completed in 2022, perfectly situated on a desirable corner lot in prime Dearborn Heights. This modern residence offers 4 spacious bedrooms and 3.5 luxurious bathrooms, including a primary suite with a full bath and walk-in closet. Enjoy premium features throughout, including solid bamboo flooring, porcelain tile bathrooms

    Hiam Harb Keller Williams Legacy

    Section Image
  • 8100 Lochdale St, Dearborn Heights, MI 48127

    $439,900

    • 4 Beds
    • 2.5 Baths
    • 1,758 Sq Ft
    • 8100 Lochdale St
    • Dearborn Heights, MI

    lovely, recently remodeled brick ranch that has just been listed. This home features 4 bedrooms, 2.1 bathrooms, a large family room, and over 1700 sq. Ft., making it a rare find in this location. The property has been updated from A to Z, and a detailed list of updates is attached for your review. Key features include an all-new kitchen with maple cabinets, granite countertops, and stainless

    Qassim Al-omairi ARG Realty

    Section Image
  • 26439 Midway St, Dearborn Heights, MI 48127

    $419,900

    • 4 Beds
    • 3 Baths
    • 1,494 Sq Ft
    • 26439 Midway St
    • Dearborn Heights, MI

    THIS IS ONE WON'T LAST, DONT EVEN SNEEZE IT WILL BE GONE. PRIME AREA/ RIGHT BEHIND TARGET/ FOUR BEDROOM BRICK RANCH WITH A HUGE FAMILY ROOM/THREE FULL BATHROOMS/FINISHED BASEMENT WITH SECOND FULL KITCHEN/ONE BEDROOM IN BASEMENT/TWO CAR GARAGE/HUGE FRONT PORCH WITH AWNING/ MARBLE TILES, UPDATED BATHROOMS, KITCHENS. ROOF, FURNACE,AC.HWT,WINDOWS,CEMENT AND MORE. VACANT IMM OCCUPANCY.

    Ali Farhat UBTEO

    Section Image
  • 26004 Shirley Ln, Dearborn Heights, MI 48127

    $490,000

    • 4 Beds
    • 4 Baths
    • 3,190 Sq Ft
    • 26004 Shirley Ln
    • Dearborn Heights, MI

    MULTIPLE OFFERS. Highest and Best Due Sunday, June 22 by 8 PM. This home has passed the residential sale inspection - a buyer can move right in without assuming any repairs. Located in the quiet and well-established Dearborn Heights neighborhood of Dearborn Oaks, where mature trees line wide streets, this property balances preservation with polish and offers a warm canvas for the next chapter.

    Jack Cassedy Berkshire Hathaway HomeService

    Section Image
  • 26006 Cherry Hill Rd, Dearborn Heights, MI 48127

    $487,900

    • 4 Beds
    • 2.5 Baths
    • 2,200 Sq Ft
    • 26006 Cherry Hill Rd
    • Dearborn Heights, MI

    A must see ,beautiful clean newly updated 4 bedroom house in one of the best areas in dearborn house with a huge clean in ground pool , beautiful corner 4 bedroom 2 & 1/2 bathrooms newly updated primary bedroom with big walk in closet and full bath,kitchen bathrooms flooring Big kitchen with an open concept beautiful family room and dinning room.You will fall in love with the huge double high

    Abir El Cheikh Ali ARG Realty

    Section Image
  • 6667 Amboy St, Dearborn Heights, MI 48127

    $399,900

    • 3 Beds
    • 3 Baths
    • 1,103 Sq Ft
    • 6667 Amboy St
    • Dearborn Heights, MI

    WELCOME TO THIS BEAUTIFULLY UPDATED 3 BEDROOM HOME IN ONE OF THE BEST AREAS OF DEARBORN HEIGHTS! SITUATED IN THE HIGHLY SOUGHT-AFTER CRESTWOOD SCHOOL DISTRICT, THIS PROPERTY WAS UPDATED IN 2025 AND OFFERS MODERN COMFORT WITH CLASSIC CHARM. SITTING ON A MASSIVE LOT, IT'S PERFECT FOR BUILDING YOUR DREAM BACKYARD OASIS. ENJOY A FINISHED BASEMENT FOR EXTRA LIVING SPACE, AND AN ATTACHED SPACIOUS 2-CAR

    Nizar Souwaidan Keller Williams Legacy

    Section Image
  • 1408 Amboy St, Dearborn Heights, MI 48127

    $489,900

    • 3 Beds
    • 1.5 Baths
    • 1,747 Sq Ft
    • 1408 Amboy St
    • Dearborn Heights, MI

    Nice Three bedroom brick ranch located at prime Dearborn Heights location, finished basement, Huge living room, Dining room with fireplace, Family Room with back yard access, Nice land scaping, Newer roof, great windows, newer water tank, newer Carpet, attached garage, nice yard, lots of storage space throughout, back yard deck, Nice bay window, spacious driveway, hardwood floors, nice kitchen

    Sam Sakka RE/MAX Leading Edge

    Section Image

Source: Realcomp

MLS Number: 20251010260

Realcomp

APN: 33-021-01-0080-002