The latest in luxury property, lifestyle & culture, curated just for you.

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont

  • 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 15 2026 AT 8:11 PM.

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

23831 JOHN R Rd

hazel park, MI 48030

$1,200,000

  • 3 BA, 2 HALF BA
    approx. 5,425 SF

Interested? Let's Connect

ONE BUILDING WITH 3 RESIDENTIAL MULTI-FAMILY APARTMENTS AND 2 COMMERCIAL SPACES-ALL PROPERTIES LEASED—in vibrant, downtown Hazel Park, located adjacent to renowned restaurant Mabel Gray. RESIDENTIAL: 3 BEDROOM: Impeccably renovated second-floor 1,567 Sq ft flat boasting three large bedrooms. Open-concept layout, with a large living room, dining room and entry. Stunning floors to the quartz countertops, shaker cabinetry, and stainless-steel appliances. Enclosed porch. Laundry room with a washer and dryer. Currently leased for $1,890/month. 1 BEDROOM: Impeccably renovated 532 Sq ft, second-floor flat. Abundant natural light illuminates the open-concept layout, with a living room, kitchen-dining combo, one bedroom and bath. Nicely renovated with quartz countertops, shaker cabinetry, and stainless-steel appliances. Currently leased for $1,000/month. STUDIO: Completely renovated 336 Sq ft studio features new hardwood floors that stretch throughout the living areas as well as bright light throughout. Kitchen/dining, flex room, and bath. The open floor plan and kitchen and living area have white shaker cabinets and soft close drawers, white granite countertops, sub-tile backsplash and quality stainless steel appliances. Currently leased for $850/month. COMMERCIAL SPACES: Prime first-floor commercial spaces. The 1,698 Sq. Ft space offers two large, versatile areas perfect for retail, office, or creative use. The spacious main room measures 38x19, providing ample space for customer engagement or open workspace. A generous rear space, 36x18, offers additional functionality for storage, private offices, or production. Currently leased for $3,180/month. The second prime 847 sq. ft commercial space offers one large, versatile area perfect for retail, office, or creative use. The spacious main room measures 38x19, providing ample space for customer engagement or open workspace. Currently leased for $1,696/month. Showings by appointment only.

Details

5,425 Sq Ft

3,920.4 Sq Ft Lot Size

investment

$11,242 Annual Tax

Built in 1951

MLS/Listing ID 20250022739

5 Units

Amenities & Features

Slab

Private Entrance

Lighting

Construction - Brick

Community - Sidewalks

Estimate my mortgage

TOTAL MONTHLY COST

$0

  • PRINCIPAL & INTEREST

    $0

  • PROPERTY TAXES

    $0

  • Common Charges

    $0

HOME PRICE
DOWN PAYMENT
TERM
INTEREST

Interested In 23831 JOHN R Rd?