Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Real Estate Group
Property view
Listing view 2
Listing view 3

37861 Elm, 
Harrison Twp, MI 48045

$339,900


3

Beds


1

Bath


1,100

Sq Ft


Single Family

Active

Listed by

Rena Abrhiem

Keller Williams Realty Lakeside

586-532-0500

Last updated:

May 15, 2026, 10:15 AM

MLS#

50201166

Source:

MI REALSOURCE

About This Home

37861 Elm

Turnkey waterfront investment opportunity with proven Airbnb appeal! This beautifully updated 3-bedroom, 1-bath home is currently tenant occupied and operating as a successful short-term rental, offering immediate income potential or the perfect future personal getaway. Nestled on a canal with direct access to Lake St. Clair, the property features stunning panoramic water views and an unbeatable lake-life setting guests love year-round. Inside, the home has been thoughtfully updated and designed for comfort and low-maintenance ownership, including an updated kitchen, remodeled full bath with tile walls and flooring, all appliances included, and a wall-mounted living room TV. A brand-new furnace installed in 2025 adds efficiency and peace of mind. Major improvements continue outside with full crawl space encapsulation by DryMich, a roof approximately 10 years old, stamped concrete patio, and newer driveway. Guests and owners alike will enjoy boating, kayaking, fishing, and relaxing waterfront sunsets right from the backyard canal frontage. Whether you're looking to expand your Airbnb portfolio, secure a cash-flowing waterfront property, or own a vacation-style retreat with income potential, this fully furnished-style opportunity checks every box. Rare chance to own an updated, income-producing waterfront home with direct access to Lake St. Clair!

Home Facts

Single Family

1 Bath

3 Bedrooms

Built in 1932

Price Summary

339,900

$309 per Sq. Ft.

MLS #:

50201166

Last Updated:

May 15, 2026, 10:15 AM

Added:

2 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

1

Full Bathrooms:

1

Interior

Living Area:

1,100 Sq. Ft.


Structure

Structure

Architectural Style:

Bungalow

Building Area:

1,100 Sq. Ft.

Year Built:

1932


Lot

Lot Size (Sq. Ft):

3,920


Finances & Disclosures

Finances

Price:

$339,900

Price per Sq. Ft:

$309 per Sq. Ft.

Source:MI REALSOURCE
The information being provided by Michigan Mls/Mirealsource is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 Michigan Mls/Mirealsource All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.