Skip main navigation
Lot/land
    • $1,275,000

    15170 Fifteen Mile Rd, Sterling Heights, MI 48312

    --beds
    --baths
    2.35Acres
    Unimproved Land
    Built in ----
    2.35 Acres Lot
    $-- Zestimate®
    $--/sqft
    $-- HOA

    What's special

    Excellent frontageHighly visible development siteCorner exposureAttractive pond views
    Rare opportunity to acquire a highly visible development site at the northwest corner of 15 Mile Road and Hayes Road. Positioned along a major corridor with strong traffic counts, excellent frontage, and corner exposure, this property offers outstanding visibility and accessibility for a variety of potential development opportunities. The site is located diagonally across a recently constructed 106-unit residential development and is surrounded by established neighborhoods, retail amenities, parks, and community services. Attractive pond views and a highly desirable location further enhance the property's appeal. Opportunities of this size and location are becoming increasingly difficult to find. Whether your vision includes residential, multifamily, senior housing, mixed-use, or another development concept, this property deserves consideration.
    32 days
    |
    253
    |
    7
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Allen Kathawa 586-604-9064,

    Brookstone, Realtors LLC 248-963-0505

    Source: MiRealSource,MLS#: 50210516MLS LogoOriginating MLS: MiRealSource

      Facts & features

      Property

      Features
      • Frontage type: Road
      • Frontage length: 400
      Lot
      • Size: 2.35 Acres
      • Dimensions: 400 x 256
      • Features: Deep Lot - 150+ Ft., Large Lot - 65+ Ft., City Lot, Corner Lot, Main Street
      Details
      • Parcel number: 101036226008
      • Zoning description: Mixed Use,Multi-Family,Professional Office,Commercial,Residential,Site Condominium
      • Special conditions: Private

      Utilities & green energy

      • Gas: Natural Gas
      • Sewer: Public At Street
      • Water: Public Water at Street

      Community & HOA

      Community
      • Subdivision: Na
      HOA
      • Has HOA: No
      Location
      • Region: Sterling Heights

      Financial & listing details

      • Tax assessed value: $50,400
      • Annual tax amount: $1,351
      • Date on market: 6/8/2026
      • Cumulative days on market: 32 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,Land Contract
      • Road surface type: Paved

        Estimated market value

        Not available

        Estimated sales range

        Not available

        $1,499/mo

        Price history

        DateEventPrice
        6/8/2026Listed for sale$1,275,000-1.9%
        Source: MiRealSource #50210516 Report a problem
        5/20/2026Listing removed$1,299,900
        Source: Realcomp II #20261015305 Report a problem
        3/11/2026Listed for sale$1,299,900+30%
        Source: Realcomp II #20261015305 Report a problem
        3/3/2026Listing removed$1,000,000
        Source: eXp Realty #58050197714 Report a problem
        1/16/2026Listed for sale$1,000,000-16.7%
        Source: MiRealSource #50197714 Report a problem
        1/1/2026Listing removed$1,199,999
        Source: Realcomp II #20250019409 Report a problem
        3/26/2025Listed for sale$1,199,999-39.8%
        Source: Realcomp II #20250019409 Report a problem
        3/12/2025Listing removed$1,995,000
        Source: Realcomp II #20240086840 Report a problem
        3/7/2025Price change$1,995,000+66.3%
        Source: Realcomp II #20240086840 Report a problem
        11/21/2024Listed for sale$1,200,000+300%
        Source: Realcomp II #20240086840 Report a problem
        11/22/2021Sold$300,000-68.4%
        Source: Public Record Report a problem
        5/18/2021Listed for sale$950,000
        Source: Realcomp II #2210036662 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$1,290 +6.1%$25,200 +9.6%
        2024$1,216 +5.2%$23,000 +1.8%
        2023$1,156 +2.1%$22,600 +5.1%
        2022$1,133 $21,500
        2021-- $21,500 +11.4%
        2020-- $19,300
        2019-- $19,300 -63.8%
        2018$2,232 $53,300 +8.6%
        2017-- $49,100
        2016-- $49,100 +8.6%
        2015-- $45,200
        2012-- --
        2009-- --
        2001$1,974 +6.2%$43,500 +3.1%
        2000$1,859 $42,200
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: 48312

        Getting around

        43 / 100
        Car-Dependent
        40 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • District: Warren Consolidated Schools

        Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Sterling Heights Topics

              Search
              Updates
              Favorites
              Plan
              Inbox