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.
    262 days
    |
    626
    |
    29
    |

    Zillow last checked: 8 hours ago

    Listing updated: December 22, 2025 at 09:09am

    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: 262 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

    $1,588/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
    $6,303/mo
    Principal & interest
    $4653
    Property taxes
    $1230
    Home insurance
    $420

      Climate risks

      Neighborhood: 48030

      Nearby schools

      GreatSchools rating

      Similar homes

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