Charming Lakefront Home in Harrison Township – Prime Location! Welcome to this 3-bedroom, 1and a half-bathroom ranch nestled on a generous lot with stunning lakefront views. This 1,000 sq. ft. home offers a unique opportunity to personalize and create your dream retreat by the water. Located in the highly desirable L'Anse Creuse School District, this property offers both tranquility and convenience. While the home could use some TLC, the potential is limitless. Imagine relaxing on your deck or enclosed sun room overlooking the serene lake or enjoying peaceful waterfront living just minutes from local amenities. Whether you’re a first-time buyer looking to make your mark or an investor seeking a fantastic opportunity, this property is ready for your vision. With a spacious yard, prime location, and a layout that fits a variety of lifestyles, this home offers excellent value. Don’t miss your chance to own a piece of lakefront paradise in Harrison Township!
Sold for $450,000
$450,000
37650 Maplehill St, Harrison Township, MI 48045
3beds
1,000sqft
Single Family Residence
Built in 1962
0.28 Acres Lot
$462,000 Zestimate®
$450/sqft
$1,705 Estimated rent
Home value
$462,000
$434,000 - $490,000
$1,705/mo
Zestimate® history
Owner options
List your home for rent
$1,705/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$1,705/mo
Rent Zestimate®
Refinance and save
$2,877/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$2,877/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Peaceful waterfront livingSpacious yardLakefront views
Zillow last checked:
Listing updated:
Listed by:
Dirk Prevost 586-214-6387,
Realty Executives Home Towne Chesterfield
Bought with:
Sinan Z Shakouri, 6501383104
Laramie International LLC
Source: MiRealSource,MLS#: 50184064
Originating MLS: MiRealSource
Originating MLS: MiRealSourceFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Bedroom 1
- Level: Entry
- Area: 156
- Dimensions: 13 x 12
Bedroom 2
- Level: Entry
- Area: 120
- Dimensions: 12 x 10
Bedroom 3
- Level: Entry
- Area: 88
- Dimensions: 8 x 11
Bathroom 1
- Level: First
Heating
- Baseboard, Natural Gas
Features
- Basement: Crawl Space
- Has fireplace: No
Interior area
- Total structure area: 1,000
- Total interior livable area: 1,000 sqft
- Finished area above ground: 1,000
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Waterfront features: Seawall, Waterfront
- Frontage type: Road
- Frontage length: 70
Lot
- Size: 0.28 Acres
- Dimensions: 70 x 175
- Features: Deep Lot - 150+ Ft.
Details
- Parcel number: 171229229002
- Special conditions: Trust
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
Condition
- Year built: 1962
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
Community & neighborhood
Location
- Region: Harrison Township
- Subdivision: Fresh Air Park Sub
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Ownership: Trust
Price history
| Date | Event | Price |
|---|---|---|
| 12/19/2025 | Sold | $450,000-5.1%$450/sqft |
Source:  MiRealSource #50184064 Report a problem | ||
| 11/20/2025 | Pending sale | $474,000$474/sqft |
Source: MiRealSource #50184064 Report a problem | ||
| 10/31/2025 | Price change | $474,000-5%$474/sqft |
Source: MiRealSource #50184064 Report a problem | ||
| 9/29/2025 | Price change | $499,000-4.8%$499/sqft |
Source: MiRealSource #50184064 Report a problem | ||
| 9/5/2025 | Price change | $524,000-4.7%$524/sqft |
Source: MiRealSource #50184064 Report a problem | ||
| 8/4/2025 | Listed for sale | $550,000$550/sqft |
Source: MiRealSource #50184064 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,005 +5% | $187,600 +2.1% |
| 2024 | $4,765 +5.3% | $183,800 +6.8% |
| 2023 | $4,527 +4.1% | $172,100 +7.4% |
| 2022 | $4,351 | $160,200 +0.5% |
| 2021 | -- | $159,400 +4.1% |
| 2020 | -- | $153,100 +9.8% |
| 2019 | -- | $139,400 +6.3% |
| 2018 | $3,931 | $131,200 +3.5% |
| 2017 | -- | $126,820 |
| 2016 | -- | $126,820 +1.3% |
| 2015 | -- | $125,230 -7.8% |
| 2012 | $3,135 | $135,850 -1.4% |
| 2010 | -- | $137,730 -1% |
| 2009 | -- | $139,080 -11.3% |
| 2008 | -- | $156,860 -2.3% |
| 2007 | $2,922 | $160,500 +2.1% |
| 2006 | -- | $157,130 +1.4% |
| 2004 | $2,729 +9.4% | $155,020 +1.5% |
| 2003 | $2,494 +12% | $152,670 +80.5% |
| 2001 | $2,228 +1.7% | $84,570 +3.2% |
| 2000 | $2,190 | $81,950 |
Find assessor info on the county website
Neighborhood: 48045
Nearby schools
GreatSchools rating
- 8/10Emma V. Lobbestael Elementary SchoolGrades: PK-5Distance: 0.5 mi
- 5/10L'anse Creuse Middle School - SouthGrades: 6-8Distance: 2.6 mi
- 8/10High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- District: L'anse Creuse Public Schools
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$462,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$462,000
- Michigan
- Macomb County
- Harrison Township
- 48045
- 37650 Maplehill St
Nearby cities
Nearby zip codes
Other Harrison Township Topics
- Apartments for Rent in 48045
- Houses for Sale in 48045
- Houses for Rent in 48045
- 48045 Real Estate
- Harrison Township Condos
- Houses for Sale in Harrison Township
- Newest Listings in Harrison Township
- Harrison Township Home Values
- Harrison Township Real Estate Agents
- Harrison Township Refinance
- Harrison Township Mortgage Rates
