Property Attributes
- MLS#50205016
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityChesterfield Twp
- AreaChesterfield Twp
- NeighborhoodLottivue Subdivision #8
- Zip48047
- StyleColonial
- Year Built2002
- Taxes$ 23934
- Price$ 2,195,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms2
- Sqr Footage4805
- Lot Size0.34 Acres
Data Source:
MiRealSource (MIRS)
Property 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 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.
| Price History | |
|---|---|
| 4/22/2026 | Listed $2,250,000 |
| 7/21/2026 | 3$2,195,000 |
General Features
| Heating | Forced Air,Humidifier |
|---|---|
| Kitchen Level | Entry |
| Cooling | Ceiling Fan(s),Central A/C |
| Possession | Close Plus 16-29 Days |
| Fireplaces | Gas Fireplace,Grt Rm Fireplace,Other (FireplaceFeatures) |
| Garage | Attached Garage,Electric in Garage,Gar Door Opener,Side Loading Garage,Direct Access |
| Water | Public Water |
| Appliances | Bar-Refrigerator,Central Vacuum,Dishwasher,Disposal,Dryer,Humidifier,Microwave,Range/Oven,Refrigerator,Washer |
| Status | Active |
| Full Baths | 4 |
| Half Baths | 2 |
| Bathrooms | 6 |
| Year Built | 2002 |
| Parking | 3 or More Spaces,Garage,On Street,Paved Driveway |
| Pets Allowed | Yes |
| Subdivision | Lottivue Subdivision #8 |
| Water Heater | Gas |
| Style | Colonial |
| County | Macomb |
| Class | RESIDENTIAL |
| Type | Single Family |
| Ownership | Private |
| Association Name | See attached |
| New Construction Y/N | No |
| Associated Document Count | 7 |
| Status | Active |
| Zoning | Residential |
| Subdivision | MI |
| Sale/Rent | For Sale |
| Flood Insurance | Unknown |
| HOA Fee Includes | HOA |
| Manufactured Y/N | No |
| ROOMS | Den/Study/Lib,Entry,Exercise Room,First Floor Laundry,Great Room,Living Room,Recreation Room,Workshop,Primary Bedroom,Primary Bathroom,Basement Lavatory,First Flr Lavatory,Primary Bdrm Suite |
| Fee Amount | 995 |
| Fee Schedule | Yearly |
| Structure Style | 2 Story |
| Subj to Short Sale Apprvl | No |
| Home Warranty Y/N | No |
| Area | Chesterfield Twp (50009) |
| Primary City | Chesterfield |
| Virtual Tour | https://drive.google.com/file/d/18BC_R7mmoTKPzgTz0IPQwr35Y-C3ZgTc/view?usp=sharing |
| Directions | Enter Lotties Drive off Jefferson |
| City | Chesterfield Twp |
| School District | Anchor Bay School District |
| VIEW | Canal View |
| Pet Restrictions Y/N | No |
| Lease Y/N | No |
| Originating MLS | MiRealSource |
| Source MLS | MI Real Source |
| Financial Terms | Cash,Conventional |
| Legal Description | Lottivue Subdivision #8,Lot #161 |
| DOM | 148 |
| Postal Code | 48047 |
| Price Per Sq Ft Total AG | 456.82 |
Interior Features
| Interior Amenities | 9 ft + Ceilings,Interior Balcony,Cable/Internet Avail.,Hardwood Floors,Spa/Jetted Tub,Security System,Sump Pump,Walk-In Closet,Wet Bar/Bar,Window Treatment(s) |
|---|---|
| Family Room Level | Lower |
| Dining Room Level | Entry |
| Living Room Level | Entry |
| Basement | Egress/Daylight Windows,Finished,Full,Sump Pump |
| Bedroom 3 Level | Upper |
| Bedroom 1 Level | Upper |
| Bedroom 2 Level | Upper |
| Laundry Room Level | Entry |
| Kitchen Length | 18 |
| Family Room Length | 54 |
| Laundry Room Width | 16 |
| Family Room Width | 36 |
| Living Room Length | 25 |
| Bedroom 4 Width | 13 |
| Bedroom 2 Width | 13 |
| Bedroom 3 Width | 13 |
| Laundry Room Length | 10 |
| Dining Room Width | 17 |
| Bedroom 4 Length | 13 |
| Bedroom 2 Length | 13 |
| Living Room Width | 36 |
| Bedroom 3 Length | 13 |
| Dining Room Length | 15 |
| Kitchen Width | 16 |
| Beds | 4 |
| Fireplace? | Yes |
| Bedroom 1 Length | 27 |
| Bedroom 1 Width | 17 |
| Office Length | 14 |
| Office Width | 27 |
| Below Grade SqFt | 2808 |
| Above Grade SqFt | 4805 |
| Basement Y/N | Yes |
| Sitting Room Length | 14 |
| Sitting Room Level | Entry |
| Sitting Room Width | 14 |
| Fireplaces Total | 2 |
| Total SqFt Finished | 7255 |
| Bathroom 1 Length | 13 |
| Bathroom 1 Width | 15 |
| Bathroom 2 Length | 17 |
| Bathroom 2 Width | 8 |
| Bathroom 3 Length | 7 |
| Bathroom 3 Width | 10 |
| Bathroom 4 Length | 7 |
| Bathroom 4 Width | 8 |
Exterior Features
| Exterior | Brick |
|---|---|
| Exterior Amenities | Exterior Balcony,Inground Pool,Lawn Sprinkler,Patio,Porch,Swimming Pool,Fence Owned |
| Frontage | 122 |
| Garage Dimensions | 33.1 x 37 |
| Flood Plan | Unknown |
| Lot Size Area | 0.34 |
| Pool (Y/N) | Yes |
| Lot Dimensions | 91 x 153 x 170 x 142 |
| Garage # of Car | 3.5 |
| Water Features | Boat Facility,Canal Frontage,Dock/Pier Facility,Lake/River Access,Sea Wall,Water View,Waterfront |
| Roads | Paved Street |
| FOUNDATION TYPE | Basement |
| SEWER/SEPTIC | Public Sanitary |
| Waterfront Y/N | Yes |
| Garage Y/N | Yes |
| Frontage Type | Water |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary