For Sale
3D Tour3D Tour
Condo for sale at 25540 Waterview Dr, Harrison Township, MI 48045 | MLS# 58050217746 | Listing updated on 2026-08-18
Photo 1 of Condo for sale at 25540 Waterview Dr, Harrison Township, MI 48045 | MLS# 58050217746 | Listing updated on 2026-08-18
Photo 2 of Condo for sale at 25540 Waterview Dr, Harrison Township, MI 48045 | MLS# 58050217746 | Listing updated on 2026-08-18
Photo 3 of Condo for sale at 25540 Waterview Dr, Harrison Township, MI 48045 | MLS# 58050217746 | Listing updated on 2026-08-18
Photo 4 of Condo for sale at 25540 Waterview Dr, Harrison Township, MI 48045 | MLS# 58050217746 | Listing updated on 2026-08-18
30+
Beds Icon

Virtual Tour

Beds Icon

Street View

$299,900

Monthly Est:$1,493

  • Beds Icon2 Beds
  • Beds Icon
    2 Baths
  • Beds Icon1,825sqft

25540 Waterview Dr, Harrison Township, MI 48045

$1,493/moEst:

Get Pre-Approved

  • Condominium

  • Built in 1989

  • $300/mo HOA

  • -- sqft lot

  • $164/sq.ft

Description

Beautifully Updated Ranch-style 2 bedroom, 2 full bath condominium with attached garage and Lake St. Clair views!! Open-concept floor plan features a spacious great room with fireplace and large windows showcasing a park-like setting with tons of natural light, updated kitchen with granite countertops and oak cabinets, large primary suite with updated bathroom and large walk-in closet, laundry room with new washer and dryer, new flooring throughout, and a fantastic deck with lake views that can be accessed through the great room and the primary suite!! A peaceful and private setting with only 20 units. This is easy living with low HOA that covers water, snow removal, property maintenance and access to Lakesides Estates residents only Boardwalk with deck and tables! ** Great location close to schools, marinas, restaurants, and Metro Park!! **

  • Houzeo last checked: 3 hours ago
  • Listing updated: August 18, 2026 at 4:56 pm
  • Listing Provided by: Jennifer Frustaci Adlhoch | Adlhoch & Associates, REALTORS (313) 882-5200
  • Source: Realcomp MLS-MI | MLS#: 58050217746 Realcomp MLS-MI
  • Originating MLS: MiRealSource

Property Details

  • Status

    Active

  • Type

    Condominium

  • No. of Stories

    -

  • County

    Macomb County

  • City

    Harrison Township

  • Neighborhood

    --

  • Year Built

    1989

  • HOA Fees

    $300/mo

  • Finished Area

    1,825 sqft

  • Lot Size

    -- sqft lot

  • Basement Area

    - sqft

  • MLS Name

    Realcomp MLS

  • MLS Number

    58050217746

  • MLS Status

    Active

  • Days on Market

    63

  • Cumulative Days on Market

    59

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

HOA Management

N/A

HOA Fees

$300/ Monthly

Amenities

Amenities and services may be covered by one or multiple associations and service providers.

Snow Removal Snow Removal

Maintenance Maintenance

Water Water

Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 2

    Bathrooms: 2

Interior

  • Heating

    Forced Air, Natural Gas

  • Flooring

    Hardwood

  • Interior Features

    Walk In Closets

  • Sewer

    Public Sewer

  • Cooling

    Central Air

  • Appliances

    Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Range, Washer

Construction

  • Year Built

    Year Built: 1989

  • Home type

    Condominium

  • Foundation Details

    Slab

  • Construction Materials

    Brick, Vinyl Siding, Wood Siding

  • Architectural Style

    Ranch

Utilities & Energy

  • Pool Features

    None

  • Water Source

    Public

  • Basement

    Sump Pump

  • Fireplace Features

    Gas

  • Parking Features

    One Car Garage, Attached, Electricityin Garage

Other Features

  • Disclosures

    Taxes Not Homestead Exempt

  • Subdivision Name

    Lakeside Estates

Price History

DateEventPrice

08/07/2026

Source: mls_logoMiRealSource MLS-MI #50217746

Listed for Sale

$299,900 -6.28%

$164/sqft

07/14/2026

Source: mls_logoRealcomp MLS-MI #58050214858

Off Market

$320,000

$175/sqft

07/14/2026

Source: mls_logoRealcomp MLS-MI #58050214858

Listed for Sale

$320,000

$175/sqft

07/14/2026

Source: mls_logoMiRealSource MLS-MI #50210708

Listing Removed

$320,000

$175/sqft

06/09/2026

Source: mls_logoMiRealSource MLS-MI #50210708

Price Decreased

$320,000 -4.48%

$175/sqft

Show more

Nearby Homes

Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Oct 09, 2026, 02:30PM. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified. IDX provided courtesy of Realcomp II Ltd. via Andover Real Estate & Houzeo, Copyright 2026 Realcomp II Ltd. Shareholders Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Listing Information presented by local MLS brokerage: Andover Real Estate, local REALTOR®- Scott Rubin - (248)206-3666 . Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. ​© 2024 Realcomp II Ltd. MLS. All Rights Reserved.

Advertising Broker: Andover Real Estate | Andover Real Estate