- 0
- 1
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
$2,195,000
Monthly Est:$10,925
4 Beds
6 Baths4 full baths + 2 half baths
7,255sqft
49515 Regatta St, Chesterfield, MI 48047
$2,195,000
$10,925/moEst:
Get Pre-Approved
Single Family Residence
Built in 2002
$82.92/mo HOA
14,810.4 sqft lot
$303/sq.ft
Description
Boater's entertaining waterfront paradise with 170' of canal frontage & built- in pool minutes from Lake St. Clair. Located in the highly sought after Lottivue Community is this custom-built colonial. Over 6,500 sq. ft. of finely appointed living area built with only the finest materials and craftmanship. Wrought iron staircase overlooking 2-story foyer & great room with wall of windows overlooking water. Chef's gourmet island kitchen with built-in commercial grade appliances & LaFata custom cabinetry. 2nd fireplace located in library with judges paneling & coffered ceiling. Finished lower level with wet bar & open entertaining area. Spacious primary suite with luxury bat...
Continue Reading- Houzeo last checked: 8 minutes ago
- Listing updated: July 21, 2026 at 3:49 pm
- Listing Provided by: Thomas Zibkowski , Troy Zibkowski | Real Estate One Inc-Shelby (586) 532-5500
- Source: Realcomp MLS-MI | MLS#: 58050205016
- Originating MLS: MiRealSource
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2002
HOA Fees
$82.92/mo
Finished Area
7,255 sqft
Lot Size
14,810.4 sqft lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
58050205016
MLS Status
Active
Days on Market
149
Cumulative Days on Market
90
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!
HOA Management
N/A
HOA Fees
$995/ Annually
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
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: 4
Bathrooms: 6
Interior
Appliances
Bar Fridge, Dishwasher, Disposal, Dryer, Humidifier, Microwave, Oven, Refrigerator, Range, Washer
Cooling
Ceiling Fans, Central Air
Heating
Forced Air, Humidity Control, Natural Gas
Exterior Features
Balcony
Interior Features
Balcony, Central Vacuum, Eat In Kitchen, Entrance Foyer, High Ceilings, High Speed Internet, Jetted Tub, Wet Bar, Walk In Closets
Sewer
Public Sewer
Flooring
Hardwood
Window Features
Egress Windows, Window Treatments
Construction
Year Built
Year Built: 2002
Home type
Single Family Residence
Foundation Details
Basement
Construction Materials
Brick
Architectural Style
Colonial
Property Condition
Platted Sub
Utilities & Energy
Fireplace Features
Gas, Great Room
Security Features
Security System
Water Source
Public
Pool Features
In Ground, Outdoor Pool
Parking Features
Assigned2spaces, Threeand Half Car Garage, Attached, Direct Access, Electricityin Garage, Garage, On Street, Garage Door Opener, Paved, Side Entrance
Basement
Daylight, Finished, Full, Sump Pump
Other Features
Subdivision Name
Lottivue Subdivision #8
Disclosures
Special Assessment, Flood Unk, No Encroachment, Taxes Homestead Exempt
Patio And Porch Features
Patio, Porch
Lot Features
Cul De Sac, Dead End Street, Irregular Lot, Water View, Sprinklers
Price History
| Date | Event | Price |
|---|---|---|
04/22/2026 Source: | Price Decreased | $2,195,000 -2.44% $303/sqft |
04/22/2026 Source: | Listed for Sale | $2,250,000 $310/sqft |
Nearby Homes
Find Homes by Property Features in Chesterfield, MI
Nearby New Homes For Sale
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Sep 19, 2026, 12:31PM. 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 11:00 AM
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.
