Google street view image for 5580 N Herron Rd, Alpena, MI 49707

Off market dec 2007 for $222K

$342,456

Est. refi paymentEst. refi $1,532/mo

•

2.5 ba

•

1,940

sq ft

5580 N Herron Rd, Alpena, MI 49707

About this home

5580 N Herron Rd is a 1,940 square foot house on a 3.29 acre lot with 3 bedrooms and 2.5 bathrooms. - it last sold on December 11, 2007 for $222,000. Based on Redfin's Alpena data, we estimate the home's value is $342,456.

Single-familyProperty Type

3.29 acresLot Size

$177Est. Price/Sq.Ft.

Source:Public Records

Redfin Estimate

$342,456

$120K since sold in December 2007$6,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 46.5% higher than the average sale price ($234K) of 6 comparable homes.

SOLD SEP 17, 2026
$185,000
A
3 beds2 baths1,404 sq ft
8145 Long Rapids Rd, Alpena, MI 49707
SOLD AUG 3, 2026
$180,000
B
3 beds2 baths2,262 sq ft
6340 Dietz Rd, Alpena, MI 49707
SOLD APR 30, 2026
$220,000
C
3 beds2 baths1,248 sq ft
9024 Long Rapids Rd, Alpena, MI 49707
SOLD JAN 14, 2026
$202,500
D
3 beds2 baths2,272 sq ft
7863 Long Rapids Rd, Alpena, MI 49707
SOLD JUN 5, 2026
$289,900
E
3 beds2 baths2,624 sq ft
4892 M-65 North, Lachine, MI 49753
SOLD SEP 18, 2026
$325,000
F
4 beds2.5 baths2,144 sq ft
1454 Long Rapids Rd, Alpena, MI 49707

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$1,421/mo

Redfin rental estimate

List your home for rent

Market trends in 49707, MI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

98.0%

+0.5% MoM

Median sale price

$178K

$3K MoM

Avg. days on market

39d

2 days MoM

Recently sold homes

16 MoM

New listings for sale

NEW 2 HRS AGO
$189,000
3 beds1 bath1,236 sq ft
138 Gilchrist Ave, Alpena, MI 49707
NEW 14 HRS AGO
$160,000
3 beds1.5 baths1,586 sq ft
521 Tawas St, Alpena, MI 49707
NEW 19 HRS AGO
$194,000
3 beds1 bath1,020 sq ft
1291 Woodlane Dr, Alpena, MI 49707
NEW 19 HRS AGO
$89,900
3 beds1 bath1,875 sq ft
509 Mckinley Ave, Alpena, MI 49707
$196,500
4 beds1 bath2,310 sq ft
8083 Cathro Rd, Alpena, MI 49707
$224,000
4 beds1 bath2,048 sq ft
206 Liberty St, Alpena, MI 49707
FOR SALE BY OWNER
$95,000
3 beds2 baths— sq ft
9717 Haken Rd, Alpena, MI 49707
$124,900
2 beds1 bath939 sq ft
2337 Werth Rd, Alpena, MI 49707
$104,900
2 beds1 bath762 sq ft
1065 Pine Rd, Alpena, MI 49707
$195,500
3 beds1.5 baths2,356 sq ft
2737 S Third Ave, Alpena, MI 49707
See all

Provided by Redfin

Sale history for 5580 N Herron Rd

Tax history for 5580 N Herron Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Property details

Interior

Bathroom Information
# of Full Baths: 2
# of 1/2 Baths: 1

Heating & Cooling
Heating Type: Forced Air

Fireplace Information
# of Fireplaces: 1
Has Fireplace

Exterior

Exterior Information
Building Style Type: Bi-Level

Property Information
Living Sq. Ft: 1,940
Ground Floor Sq. Ft: 1,040
Building Sq. Ft: 1,940
Legal Description: T32N R6E SEC 36 COM AT NE COR GOVT LOT 1 TH S ALG E LN SD GOVT LOT 1326.27 FT TO CEN LONG RAPIDS RD TH S 02D 30M W 764 FT TH S 60D W 349 FT TH S 02D 30M W 100 FT TO POB TH N 87D 30M W 200 FT TH S 02D 30M W 224 FT TO N BANK OF RIVER TH E 226 FT TH N 0 2D 30M E 320 FT TO POB ALSO COM AT NE SEC COR TH S 1326.27 FT TO C/L LONG RAPIDS RD THE 1/8 COR TH 811.4 FT S ALG SEC LN TH S 50D 19M 40S W 42.87 FT TO POB TH S 50D 19M 40S W 338.85 FT TH S 00D 28M 40S W 331.85 FT TO BANK OF TH BY RIVER TH N 84D 21M 36S E 264.86 FT ALG SD BANK TH N 522.13 FT TO POB PART OF GOVT LOT 1 ALSO A STRIP OF LAND 16.5 FT WIDE FOR RDWY FROM HWY ON E SIDE OF LOT 1 THE NWLY LN DESC AS FOLLOWS COM AT A PT ON W LN OF HWY ON E SIDE OF LOT 1 SD PT BEING 790 FT S FROM C/L LONG

Parking & Garage Information
Garage/Parking Sq. Ft: 1,776

Lot Information
# of Buildings: 1
Land Sq. Ft: 143,312
Legal Lot Number: 1
Municipality Name: LONG RAPIDS TWP
Acres: 3.29
County Use Description: RESIDENTIAL IMPROVED
State Use Description: RESIDENTIAL

Financial

Assessor Information
Assessment Year: 2026

Public facts

Beds: 3
Baths: 2.5
Sq. Ft.: 1,940
Stories: —
Lot Size: 3.29 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Alpena County
APN: 032-036-000-035-00

Home facts updated by county records on Aug 10, 2026

Around this home

Schools

Wilson Community School

Public K-5 • Assigned • 8.2mi

6/10

Thunder Bay Junior High School

Public 6-8 • Assigned • 9.4mi

6/10

Alpena High School

Public 8-12 • Assigned • 9.5mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

5/10 Flood Factor

Estimated 51-63% chance of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

1/10 Heat Factor

7 days above 94° expected this year, 13 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

1/10 Air Factor

0 unhealthy days expected this year, 0 days in 30 years

Provided by First Street

Historical weather

Alpena, MI • 49707

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.7 hours in June and 2.3 hours in December, placing it below the U.S. average for solar exposure.

9.7 hrs

2.3 hrs

JuneDecember

Provided by Shadowmap

Is this your home?

Track this home’s value and nearby sales activity

Nearby similar homes

$299,000

Land— sq ft

3266 Long Rapids Rd, Alpena, MI 49707

$209,500

3 beds2 baths3,096 sq ft

1249 W Washington Ave, Alpena, MI 49707

(810) 987-1100

$225,000

Land— sq ft

16386 Paradise Rd, Lachine, MI 49753

$229,000

3 beds2.5 baths1,782 sq ft

16580 Moores Landing Rd, Lachine, MI 49753

$7,200

Land— sq ft

308 Geronimo Rd, Alpena, MI 49707

$950,000

5 beds3 baths4,400 sq ft

12270 M-32 W, Lachine, MI 49753

New listings for sale in 49707

NEW 2 HRS AGO

$189,000

3 beds1 bath1,236 sq ft

138 Gilchrist Ave, Alpena, MI 49707

NEW 14 HRS AGO3D WALKTHROUGH

$160,000

3 beds1.5 baths1,586 sq ft

521 Tawas St, Alpena, MI 49707

NEW 19 HRS AGO

$194,000

3 beds1 bath1,020 sq ft

1291 Woodlane Dr, Alpena, MI 49707

NEW 19 HRS AGO

$89,900

3 beds1 bath1,875 sq ft

509 Mckinley Ave, Alpena, MI 49707

$196,500

4 beds1 bath2,310 sq ft

8083 Cathro Rd, Alpena, MI 49707

$224,000

4 beds1 bath2,048 sq ft

206 Liberty St, Alpena, MI 49707

FOR SALE BY OWNER

$95,000

3 beds2 baths— sq ft

9717 Haken Rd, Alpena, MI 49707

$124,900

2 beds1 bath939 sq ft

2337 Werth Rd, Alpena, MI 49707

$104,900

2 beds1 bath762 sq ft

1065 Pine Rd, Alpena, MI 49707

Home values near 5580 N Herron Rd

Data from public records.

Address	Redfin Estimate
5588 North Herron Rd, Alpena, MI 2 Beds \| 1 Baths \| 2016 Sq. Ft.	$153,247
9270 Forest Ln, Alpena, MI - Beds \| 1 Baths \| 1125 Sq. Ft.	$220,118

Address	Redfin Estimate
5697 North Herron Rd, Alpena, MI 3 Beds \| 1 Baths \| 1105 Sq. Ft.	$128,169
8946 Long Rapids Rd, Alpena, MI - Beds \| 1 Baths \| 480 Sq. Ft.	$120,881

Address	Redfin Estimate
9310 Forest Ln, Alpena, MI 3 Beds \| 1 Baths \| 3968 Sq. Ft.	$563,125
159 Circle Dr, Alpena, MI - Beds \| 1 Baths \| 1058 Sq. Ft.	$167,109

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Alpena	Agents near me	Livonia, MI homes for sale	Alpena Housing Market
Houses for sale near me	Detroit, MI homes for sale	Novi, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Royal Oak, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Alpena Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Hubbard Lake homes for sale
Presque Isle Harbor homes for sale
Lost Lake Woods homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 49707, MI

Sale history for 5580 N Herron Rd

Tax history for 5580 N Herron Rd

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Is this your home?

Nearby similar homes

New listings for sale in 49707

Home values near 5580 N Herron Rd

More real estate resources