Skip main navigation
For sale
  • $1,200,000

    23831 John R Rd, Hazel Park, MI 48030

    4beds
    5,425sqft
    : 
    Multi Family
    Built in 1951
    -- sqft lot
    $-- Zestimate®
    $221/sqft
    $-- HOA

    What's special

    Flex roomAbundant natural lightHardwood floorsWhite granite countertopsQuartz countertopsEnclosed porchDining room
    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.
    348 days
    |
    898
    |
    36
    |

    Zillow last checked: 7 hours ago

    Listing updated: January 07, 2026 at 05:08am

    Listed by:

    Christine Winans 248-646-6200,

    Berkshire Hathaway HomeServices Kee Realty Bham 248-646-6200

    Source: Realcomp II,MLS#: 20250022739MLS Logo

    Tour with a local agent

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 5
      • Full bathrooms: 3
      • 1/2 bathrooms: 2
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Features
      • Has basement: No
      • Has fireplace: No
      Interior area
      • Total interior livable area: 5,425 sqft
      • Finished area above ground: 5,425

      Property

      Features
      • Levels: One
      • Stories: 1
      • Exterior features: Lighting, Private Entrance
      • Pool features: None
      Lot
      • Size: 3,920.4 Square Feet
      • Dimensions: 40.00 x 100.00
      Details
      • Parcel number: 2526432022
      • Zoning description: Commercial, MultiFamily
      • Special conditions: Short Sale No,Standard

      Construction

      Type & style
      • Home type: MultiFamily
      • Architectural style: Raised Ranch
      • Property subtype: Multi Family
      Materials
      • Brick
      • Foundation: Slab
      Condition
      • New construction: No
      • Year built: 1951

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Above Ground Utilities

      Community & HOA

      Community
      • Features: Sidewalks
      • Subdivision: CAMPBELL BROS SUB
      Location
      • Region: Hazel Park

      Financial & listing details

      • Price per square foot: $221/sqft
      • Tax assessed value: $129,670
      • Annual tax amount: $11,242
      • Date on market: 4/7/2025
      • Cumulative days on market: 348 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $2,005/mo

        Price history

        Price history
        DateEventPrice
        4/7/2025Listed for sale$1,200,000+200.8%$221/sqft
        Source: Realcomp II #20250022739 Report a problem
        11/21/2023Listing removed--
        Source: Zillow Rentals Report a problem
        11/7/2023Listed for rent$1,800
        Source: Zillow Rentals Report a problem
        7/17/2020Listing removed$399,000$74/sqft
        Source: HWWB, REALTORS #40076204 Report a problem
        7/10/2020Listed for sale$399,000$74/sqft
        Source: HWWB, REALTORS #40076204 Report a problem

        Public tax history

        Public tax history
        Tax history is unavailable.

        BuyAbility℠ payment

        Est. payment
        $7,528/mo
        Principal & interest
        $6188
        Property taxes
        $1340
        More affordability tools

          Climate risks

          Neighborhood: 48030

          Getting around

          77 / 100
          Very Walkable
          56 / 100
          Bikeable

          Nearby schools

          GreatSchools rating

          Local experts in 48030

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel