# 9460 U.S. 23, Alpena, MI 49707

> **TL;DR:** 3bd/2ba single family, $425,000 ($191/sqft), built 1979, 2,226 sqft.
> Fireplace, Waterfront. Est. $2,273/mo. Listed 82 days.

## Property at a Glance

| Attribute | Value |
|-----------|-------|
| Price | $425,000 |
| Price/sqft | $191 |
| Bedrooms | 3 |
| Bathrooms | 2 full |
| Square Feet | 2,226 |
| Year Built | 1979 |
| Property Type | Single Family (Other) |
| Status | Active |
| Days on Market | 82 |

## Why This Home Stands Out

- **Waterfront** - Waterfront location listed

## Estimated Monthly Costs

| Category | Amount |
|----------|--------|
| Principal & Interest (20% down, 30-year at 6.5%) | $2,149 |
| Estimated Insurance | $124 |
| **Total** | **$2,273** |

## Nearby Schools

- **Elementary:** Hinks
- **High:** Alpena

## Key Amenities

- Fireplace
- Waterfront

## Property Highlights

- Built in 1979
- Fireplace
- Waterfront

## Description

### Agent Description
This unique 3 bedroom 2 full bathroom property offers 123 Feet of southern facing frontage on highly coveted Long Lake. It's a quick boat ride to the famous Long Lake Sandies or a visit to the Sand Bar and Grill. The large nearly 2/3 acre lot has tremendous potential. This property will need a full remodel utilizing what appears to be a solid foundation with a walk-out basement or build your new dream home. Close proximity to Rockport State Park provides Lake Huron Access with boat launch, dark sky viewing area, panoramic views, world class fossil hunting, sinkholes, and hiking trails in 4,237 acres

## Location

- **Address:** 9460 U.S. 23, Alpena, MI 49707
- **County:** Alpena
- **Neighborhood:** Dubeys Log Cabin Sub
- **Coordinates:** 45.184848, -83.424325
- **Google Maps:** https://www.google.com/maps?q=45.184848,-83.424325

## Listing Agent

- **Name:** Leo Fitzpatrick
- **Brokerage:** Fitzpatrick Realty LLC
- **Phone:** 9894646447
- **Broker Phone:** (989) 464-6447
- **Listing URL:** [View original listing](https://www.realtor.com/realestateandhomes-detail/9460-US-Highway-23-N_Alpena_MI_49707_M35705-11716?f=listhub&s=WWMLSMI&m=201841035&c=propsimple)

## Photos

![9460 U.S. 23 - Photo 1](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3021825259r.jpg)

![9460 U.S. 23 - Photo 2](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3117597172r.jpg)

![9460 U.S. 23 - Photo 3](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f854857063r.jpg)

![9460 U.S. 23 - Photo 4](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2390565761r.jpg)

![9460 U.S. 23 - Photo 5](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1873407625r.jpg)

![9460 U.S. 23 - Photo 6](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3387935092r.jpg)

![9460 U.S. 23 - Photo 7](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3827562188r.jpg)

![9460 U.S. 23 - Photo 8](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2623059994r.jpg)

![9460 U.S. 23 - Photo 9](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1741756129r.jpg)

![9460 U.S. 23 - Photo 10](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1188166951r.jpg)

![9460 U.S. 23 - Photo 11](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3300943194r.jpg)

![9460 U.S. 23 - Photo 12](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2234167671r.jpg)

![9460 U.S. 23 - Photo 13](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1993596324r.jpg)

![9460 U.S. 23 - Photo 14](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3753225211r.jpg)

![9460 U.S. 23 - Photo 15](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3233343466r.jpg)

![9460 U.S. 23 - Photo 16](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2821329070r.jpg)

![9460 U.S. 23 - Photo 17](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1978294810r.jpg)

![9460 U.S. 23 - Photo 18](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1735891858r.jpg)

![9460 U.S. 23 - Photo 19](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f162041479r.jpg)

![9460 U.S. 23 - Photo 20](http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f199386039r.jpg)

---

**MLS#:** 201841035 | **Updated:** 2026-07-02
**Source:** listhub

*Copyright © 2026 Water Wonderland Board of Realtors®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.*

[View on PropertySimple](https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035)

---

## Structured Data

```json
{
  "@context": "https://schema.org",
  "@type": "RealEstateListing",
  "@id": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035#listing",
  "url": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035",
  "name": "9460 U.S. 23, Alpena, MI 49707",
  "description": "This unique 3 bedroom 2 full bathroom property offers 123 Feet of southern facing frontage on highly coveted Long Lake. It's a quick boat ride to the famous Long Lake Sandies or a visit to the Sand Bar and Grill. The large nearly 2/3 acre lot has tremendous potential. This property will need a full remodel utilizing what appears to be a solid foundation with a walk-out basement or build your new dream home. Close proximity to Rockport State Park provides Lake Huron Access with boat launch, dark sky viewing area, panoramic views, world class fossil hunting, sinkholes, and hiking trails in 4,237 acres",
  "image": [
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3021825259r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3117597172r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f854857063r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2390565761r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1873407625r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3387935092r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3827562188r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2623059994r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1741756129r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1188166951r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3300943194r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2234167671r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1993596324r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3753225211r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3233343466r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2821329070r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1978294810r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1735891858r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f162041479r.jpg",
    "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f199386039r.jpg"
  ],
  "primaryImageOfPage": {
    "@type": "ImageObject",
    "url": "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3021825259r.jpg",
    "caption": "9460 U.S. 23 - Alpena, MI"
  },
  "datePosted": "2026-06-24T00:00:00+00:00",
  "dateModified": "2026-07-02T02:53:54.337668+00:00",
  "mainEntity": {
    "@type": "Accommodation",
    "@id": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035#property",
    "name": "9460 U.S. 23, Alpena, MI 49707",
    "address": {
      "@type": "PostalAddress",
      "streetAddress": "9460 U.S. 23",
      "addressLocality": "Alpena",
      "addressRegion": "MI",
      "postalCode": "49707",
      "addressCountry": "US"
    },
    "geo": {
      "@type": "GeoCoordinates",
      "latitude": 45.184848,
      "longitude": -83.424325
    },
    "image": [
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3021825259r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3117597172r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f854857063r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2390565761r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1873407625r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3387935092r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3827562188r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2623059994r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1741756129r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1188166951r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3300943194r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2234167671r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1993596324r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3753225211r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f3233343466r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f2821329070r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1978294810r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f1735891858r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f162041479r.jpg",
      "http://lh.rdcpix.com/1564332e1c910e77929ffdae1fa349ffl-f199386039r.jpg"
    ],
    "identifier": {
      "@type": "PropertyValue",
      "propertyID": "MLS",
      "value": "201841035"
    },
    "accommodationCategory": "Other",
    "numberOfBedrooms": 3,
    "numberOfBathroomsTotal": 2,
    "numberOfFullBathrooms": 2,
    "floorSize": {
      "@type": "QuantitativeValue",
      "value": 2226,
      "unitCode": "FTK",
      "unitText": "square feet"
    },
    "yearBuilt": 1979,
    "amenityFeature": [
      {
        "@type": "LocationFeatureSpecification",
        "name": "Heating",
        "value": "Baseboard, Hot Water(Heating), Wood"
      },
      {
        "@type": "LocationFeatureSpecification",
        "name": "Construction Materials",
        "value": "Frame"
      },
      {
        "@type": "LocationFeatureSpecification",
        "name": "Fireplace",
        "value": true
      },
      {
        "@type": "LocationFeatureSpecification",
        "name": "Waterfront",
        "value": true
      }
    ],
    "additionalProperty": [
      {
        "@type": "PropertyValue",
        "name": "Property Subtype",
        "value": "Other"
      }
    ]
  },
  "offers": {
    "@type": "Offer",
    "@id": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035#offer",
    "url": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035",
    "price": 425000,
    "priceCurrency": "USD",
    "businessFunction": "http://purl.org/goodrelations/v1#Sell",
    "availability": "https://schema.org/InStock",
    "seller": {
      "@id": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035#agent"
    }
  },
  "provider": {
    "@type": "Person",
    "@id": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035#agent",
    "name": "Leo Fitzpatrick",
    "telephone": "9894646447",
    "worksFor": {
      "@type": "Organization",
      "@id": "https://www.propertysimple.ai/listing/9460-u-s-23-alpena-mi-49707-01841035#brokerage",
      "name": "Fitzpatrick Realty LLC",
      "telephone": "(989) 464-6447"
    }
  }
}
```