• Buy
  • Rent
  • Sell
  • Agents
New DevelopmentWorld of Elliman
The latest in luxury property, lifestyle & culture, curated just for you.

Company

  • About Us
  • Leadership
  • Offices
  • Press & News
  • Elliman Cares
  • Join as an Agent
  • Careers
  • Elliman Global
  • Investors

Resources

  • World of Elliman
  • Elliman Insider
  • Magazines
  • Market Reports
  • Research Reports
  • Elliman Private Listings
  • New Elliman Exclusives
  • Featured Cities
  • Guides to Buying & Selling

Brand Portfolio

  • New Development
  • Commercial
  • Relocation
  • Sports & Entertainment
  • Farm & Ranch
  • Building Broker Specialists
  • Title Services
  • Estate, Trust & Probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • Site Map
  • Terms
  • Privacy
  • Cookie Preferences
  • Do Not Sell or Share My Personal Information
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • Text of NYC Human Rights Law
  • New York City Commission on Human Rights
  • NYC Source of Income Discrimination Information
  • NYC Source of Income Discrimination Tenant FAQs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2026 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY. LISTING DATA REFRESHED ON MAR 19 2026 AT 2:50 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

SCAMMERS ARE IMPERSONATING REAL ESTATE AGENTS AND USING ACTIVE LISTINGS TO REQUEST FAKE DEPOSITS. SHOULD YOU HAVE A QUESTION ABOUT THE LEGITIMACY OF A DOUGLAS ELLIMAN AGENT OR LISTING, PLEASE CONTACT THE AGENT DIRECTLY VIA THE “AGENTS” LINK IN THE TOP MENU. DOUGLAS ELLIMAN WILL NEVER ASK FOR ANY PAYMENT TO RESERVE, HOLD, OR VIEW A PROPERTY. THESE CHARGES ARE PROHIBITED UNDER NEW YORK LAW. IF YOU RECEIVE A SUSPICIOUS REQUEST FOR MONEY, DO NOT SEND FUNDS. REPORT IT TO THE NYS DEPARTMENT OF STATE AND NOTIFY DOUGLAS ELLIMAN. YOU CAN READ THE NEW YORK STATE DEPARTMENT OF STATE'S CONSUMER ALERT HERE.

POWERED BY PURLIN.AI

374 W Barrett Ave

madison heights, MI 48071

$379,100

  • 3 BR
    2 BA, 1 HALF BA
    approx. 2,223 SF
  • SOLD

Interested? Let's Connect

Stunning newer construction with an impressive finished basement on a quiet dead-end street in the heart of metro-Detroit! Centrally located with quick and easy freeway access, this turn-key colonial presents an incredible offering featuring an ideal open floor plan with tall ceilings and ample natural light, an "entertainer's kitchen" with sleek shaker-style cabinets with cabinet crown, quartz counters, a large kitchen island with a breakfast bar, subway tile backsplash, stylish hanging light fixtures and stainless steel appliances, spacious dining area, cozy family room with a sliding door-wall out to a newly added rear patio (2021) with string-lights and a tranquil fenced-in yard (2021), private main-level power room, sizable bedrooms including a true Primary suite with a walk-in closet and an attached Primary bathroom with a granite-counter vanity and walk-in shower with glass enclosure, large second full bathroom with a granite-counter vanity and subway tile shower/tub combo, upstairs hallway laundry, newly finished basement (2024), with LVP flooring, all new drywall and trim, tastefully painted ceiling, added doors for utility and storage access, sump pump and egress window! 2-car detached garage with electricity, additional storage shed and a community park at the end of the block! Conveniently located off of I-696 and I-75 cutting several minutes off of any commute! An exceptional newer-construction value you won't find elsewhere at this price-point!

Details

2,223 Sq Ft

4,356 Sq Ft Lot Size

single family home

$7,190 Annual Tax

Built in 2020

MLS/Listing ID 20261009458

Amenities & Features

Construction - Vinyl Siding

Style - Colonial

Dishwasher

Disposal

Dryer

Free-standing Gas Range

Free-standing Refrigerator

Microwave

Stainless Steel Appliances

Washer

Parking - Detached

Parking - Driveway

Parking - Garage Door Opener

Parking - Two Car Garage

Lot - Cleared

Entrance Foyer

Heating - Forced Air

Heating - Natural Gas

Basement

Backyard

Fenced

Awnings

Lighting

Cooling - Central Air

Covered

Patio

Porch

Pets Allowed

Interested In 374 W Barrett Ave?