- 0
- 3
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$340,000
Monthly Est:$1,692
3 Beds
3 Baths2 full baths + 1 half bath
1,646sqft
40 Harrison Ave, Trenton, MI 48183
$340,000
$1,692/moEst:
Get Pre-Approved
Condominium
Built in 1989
$225/mo HOA
-- sqft lot
$207/sq.ft
Description
Rare opportunities like this don't come along often! This exceptional 3-bedroom, 2.5-bath condominium is just the feet from the Detroit River, offering breathtaking water views and an unbeatable Trenton location. Step outside your door and enjoy the recently transformed Rotary Park featuring a brand-new boardwalk, water access, boat launch, playground, picnic areas, and beautiful green space—an incredible lifestyle right at your doorstep.Inside, you'll find a thoughtfully designed floor plan that's perfect for everyday living and entertaining. The ground level welcomes you with a spacious foyer and access to the oversized attached garage, offering room for two vehicles pl...
Continue Reading- Houzeo last checked: 5 hours ago
- Listing updated: August 14, 2026 at 2:52 pm
- Listing Provided by: James Anderson (734) 516-7976 | Real Estate One-Trenton (734) 675-7500
- Source: Realcomp MLS-MI | MLS#: 20261058032
- Originating MLS: Realcomp II Ltd
Part of
Property Details
Status
Pending
Type
Condominium
No. of Stories
-
County
City
Neighborhood
--
Year Built
1989
HOA Fees
$225/mo
Finished Area
1,646 sqft
Lot Size
-- sqft lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
20261058032
MLS Status
Pending
Days on Market
53
Cumulative Days on Market
14
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$225/ Monthly
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Water
Insurance
Sewer
Maintenance
Snow Removal
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: 3
Bathrooms: 3
Interior
Heating
Forced Air, Natural Gas
Appliances
Dishwasher, Dryer, Free Standing Gas Range, Free Standing Refrigerator, Microwave, Washer
Sewer
Public Sewer
Cooling
Central Air
Exterior Features
Balcony, Lighting, Private Entrance
Construction
Year Built
Year Built: 1989
Home type
Condominium
Foundation Details
Poured, Slab
Construction Materials
Wood Siding
Roof
Asphalt
Architectural Style
Colonial, Contemporary
Utilities & Energy
Security Features
Smoke Detectors
Laundry Features
Laundry Room
Electric
Circuit Breakers
Water Source
Public
Parking Features
Two Car Garage, Attached, Electricityin Garage, Garage Door Opener
Other Features
Patio And Porch Features
Covered
Subdivision Name
Wayne County Condo Sub Plan 276
Disclosures
Taxes Not Homestead Exempt
Lot Features
Adjacentto Public Land
Price History
| Date | Event | Price |
|---|---|---|
08/14/2026 Source: | Pending | $340,000 $207/sqft |
07/31/2026 Source: | Listed for Sale | $340,000 +32280.95% $207/sqft |
01/26/2012 Source: | Sold | $1,050 $1/sqft |
Nearby Homes
Find Homes by Property Features in Trenton, MI
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Sep 18, 2026, 10:15AM. 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
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 01:30 PM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
