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 bath, his & her walk-in closets & private covered patio overlooking water. Beautiful Brazilian cherry hardwood floors throughout most of 1st floor. The entire backyard is open patio area with extensive landscaping & brick paver patios around built-in Gunite swimming pool & waterfront boardwalk. Quick possession available for the discriminating Buyer.
For sale
$2,250,000
49515 Regatta St, Chesterfield, MI 48047
4beds
7,255sqft
Single Family Residence
Built in 2002
0.34 Acres Lot
$2,086,500 Zestimate®
$310/sqft
$83/mo HOA
What's special
Waterfront boardwalkBuilt-in poolBuilt-in commercial grade appliancesLafata custom cabinetry
- 76 days |
- 1,820 |
- 63 |
Zillow last checked:
Listing updated:
Listed by:
Thomas Zibkowski 586-709-1727,
Real Estate One Inc-Shelby 586-532-5500,
Troy Zibkowski 586-453-8515,
Real Estate One Inc-Shelby
Source: MiRealSource,MLS#: 50205016
Originating MLS: MiRealSource
Originating MLS: MiRealSourceLoading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Rooms
- Room types: Den/Study/Lib, Entry, Exercise Room, Laundry, Great Room, Living Room, Recreation Room, Workshop, Master Bedroom, Master Bathroom, Basement Lavatory, First Flr Lavatory, Shared Bathroom, Breakfast Nook/Room
Bedroom 1
- Level: Upper
- Area: 459
- Dimensions: 27 x 17
Bedroom 2
- Level: Upper
- Area: 169
- Dimensions: 13 x 13
Bedroom 3
- Level: Upper
- Area: 169
- Dimensions: 13 x 13
Bedroom 4
- Level: Upper
- Area: 169
- Dimensions: 13 x 13
Bathroom 1
- Level: Upper
- Area: 195
- Dimensions: 13 x 15
Bathroom 2
- Level: Upper
- Area: 136
- Dimensions: 17 x 8
Bathroom 3
- Level: Upper
- Area: 70
- Dimensions: 7 x 10
Bathroom 4
- Level: Lower
- Area: 56
- Dimensions: 7 x 8
Dining room
- Level: Entry
- Area: 255
- Dimensions: 15 x 17
Family room
- Level: Lower
- Area: 1944
- Dimensions: 54 x 36
Kitchen
- Level: Entry
- Area: 288
- Dimensions: 18 x 16
Living room
- Level: Entry
- Area: 900
- Dimensions: 25 x 36
Office
- Level: Entry
- Area: 378
- Dimensions: 14 x 27
Heating
- Forced Air, Humidity Control, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Bar Fridge, Dishwasher, Disposal, Dryer, Humidifier, Microwave, Range/Oven, Refrigerator, Washer, Gas Water Heater
- Laundry: First Floor Laundry, Entry
Features
- High Ceilings, Interior Balcony, Sump Pump, Walk-In Closet(s), Bar, Central Vacuum, Eat-in Kitchen
- Flooring: Hardwood
- Windows: Window Treatments
- Basement: Daylight,Finished,Full,Sump Pump
- Number of fireplaces: 2
- Fireplace features: Gas, Great Room, Other
Interior area
- Total structure area: 7,613
- Total interior livable area: 7,255 sqft
- Finished area above ground: 4,805
- Finished area below ground: 2,450
Video & virtual tour
Property
Parking
- Total spaces: 3.5
- Parking features: 3 or More Spaces, Garage, On Street, Driveway, Attached, Electric in Garage, Garage Door Opener, Garage Faces Side, Direct Access
- Attached garage spaces: 3.5
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Porch
- Exterior features: Balcony, Lawn Sprinkler
- Has private pool: Yes
- Pool features: In Ground, Outdoor Pool
- Has spa: Yes
- Spa features: Spa/Jetted Tub
- Fencing: Fence Owned
- Has view: Yes
- View description: Water, Canal
- Has water view: Yes
- Water view: Water,Canal
- Waterfront features: Boat Facility, Canal Front, Dock/Pier Facility, Lake/River Access, Seawall, Waterfront
- Frontage length: 122
Lot
- Size: 0.34 Acres
- Dimensions: 91 x 153 x 170 x 142
- Features: Deep Lot - 150+ Ft., Large Lot - 65+ Ft., Cul-De-Sac, Dead End, Subdivision, Irregular Lot, Platted
Details
- Parcel number: 150926131011
- Zoning description: Residential
- Special conditions: Private
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement
Condition
- New construction: No
- Year built: 2002
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
- Utilities for property: Cable/Internet Avail.
Community & HOA
Community
- Security: Security System
- Subdivision: Lottivue Subdivision #8
HOA
- Has HOA: Yes
- Services included: HOA
- HOA fee: $995 annually
- HOA name: See attached
Location
- Region: Chesterfield
Financial & listing details
- Price per square foot: $310/sqft
- Annual tax amount: $23,528
- Date on market: 4/22/2026
- Cumulative days on market: 76 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Road surface type: Paved
Estimated market value
$2,086,500
$1.98M - $2.19M
$4,094/mo
Price history
| Date | Event | Price |
|---|---|---|
| 4/22/2026 | Listed for sale | $2,250,000+603.1%$310/sqft |
Source:  MiRealSource #50205016 Report a problem | ||
| 4/22/1999 | Sold | $320,000$44/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $22,771 +5% | $674,400 +5% |
| 2024 | $21,686 +5.2% | $642,100 +21.7% |
| 2023 | $20,623 +3% | $527,400 +9.4% |
| 2022 | $20,023 | $481,900 +3.1% |
| 2021 | -- | $467,500 +0.6% |
| 2020 | -- | $464,500 +6.6% |
| 2019 | -- | $435,700 +3.3% |
| 2018 | $12,003 +115.4% | $421,700 +9.1% |
| 2017 | $5,573 | $386,700 |
| 2016 | $5,573 | $386,700 +5.9% |
| 2015 | $5,573 | $365,100 +5.6% |
| 2014 | -- | $345,750 |
| 2012 | -- | -- |
| 2009 | -- | -- |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Lottivue
Nearby schools
GreatSchools rating
- 6/10Lottie M. Schmidt Elementary SchoolGrades: PK-5Distance: 0.4 mi
- 6/10Anchor Bay Middle School SouthGrades: 6-8Distance: 1.2 mi
- 7/10Anchor Bay High SchoolGrades: 9-12Distance: 4.2 mi
Schools provided by the listing agent
- District: Anchor Bay School District
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- Michigan
- Macomb County
- Chesterfield
- 48047
- Lottivue
- 49515 Regatta St
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Chesterfield Topics
