Welcome to your dream home on the water! Nestled just four houses from the shores of iconic Lake St. Clair, this beautifully remodeled ranch offers luxury, comfort, and a lifestyle like no other. Located on a quiet cul-de-sac in the coveted Lottivue subdivision, this one-of-a-kind property combines modern elegance with rare waterfront amenities. From the moment you arrive, you'll notice this home is a true showstopper. Every inch has been thoughtfully redesigned with over $300,000 in high-end renovations creating a fresh, modern aesthetic that’s both functional and stunning. Whether it’s the gourmet kitchen, the spa-inspired baths, or the open-concept living spaces, nothing has been left untouched. A full list of updates is available online. One of only three homes in the entire subdivision to feature a massive 45 foot-attached boathouse, this is a rare opportunity for boating enthusiasts. Launch your adventures right from your backyard and explore the expansive blue waters of Lake St. Clair famed for world-class fishing, sailing, jet-skiing, and sunset cruises. Imagine morning coffee on the canal, evening boat rides under cotton-candy skies, and entertaining friends steps from the lake all with the top-rated Anchor Bay School District at your doorstep. If you’re looking for luxury, location, and lake life wrapped into one, this is it.
For sale
$775,000
49775 Keycove St, Chesterfield, MI 48047
4beds
2,471sqft
Est.:
Single Family Residence
Built in 1958
0.25 Acres Lot
$737,600 Zestimate®
$314/sqft
$83/mo HOA
What's special
- 54 days |
- 2,846 |
- 76 |
Zillow last checked: 7 hours ago
Listing updated: March 28, 2026 at 09:08am
Listed by:
Ryan Nelson 248-462-4741,
DOBI Real Estate 248-385-3350
Source: Realcomp II,MLS#: 20261008078
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Entry
- Area: 255
- Dimensions: 17 X 15
Bedroom
- Level: Entry
- Area: 132
- Dimensions: 11 X 12
Bedroom
- Level: Entry
- Area: 144
- Dimensions: 12 X 12
Bedroom
- Level: Entry
- Area: 130
- Dimensions: 10 X 13
Primary bathroom
- Level: Entry
- Area: 108
- Dimensions: 12 X 9
Other
- Level: Entry
Other
- Level: Entry
Dining room
- Level: Entry
- Area: 144
- Dimensions: 16 X 9
Family room
- Level: Entry
- Area: 240
- Dimensions: 15 X 16
Kitchen
- Level: Entry
- Area: 260
- Dimensions: 20 X 13
Laundry
- Level: Entry
- Area: 70
- Dimensions: 10 X 7
Living room
- Level: Entry
- Area: 322
- Dimensions: 14 X 23
Heating
- Baseboard, Hot Water, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Built In Electric Oven, Built In Electric Range, Convection Oven, Disposal, Exhaust Fan, Free Standing Refrigerator, Range Hood, Self Cleaning Oven, Warming Drawer, Wine Refrigerator
- Laundry: Gas Dryer Hookup, Washer Hookup
Features
- Windows: Energy Star Qualified Windows
- Has basement: No
- Has fireplace: Yes
- Fireplace features: Family Room, Gas, Great Room, Kitchen, Living Room, Master Bedroom
Interior area
- Total interior livable area: 2,471 sqft
- Finished area above ground: 2,471
Video & virtual tour
Property
Parking
- Total spaces: 4.5
- Parking features: Twoand Half Car Garage, Two Car Garage, Attached, Direct Access, Driveway, Electricityin Garage, Heated Garage, Garage Door Opener, Oversized, Side Entrance
- Attached garage spaces: 4.5
Features
- Levels: One
- Stories: 1
- Entry location: GroundLevel
- Patio & porch: Deck, Patio, Porch
- Exterior features: Chimney Caps, Gutter Guard System, Lighting
- Pool features: None
- Fencing: Back Yard,Fenced
- On waterfront: Yes
- Waterfront features: All Sports Lake, Canal Access, Canal Front, Direct Water Frontage, Dock Facilities, Seawall, Waterfront
- Body of water: Lake St. Clair
Lot
- Size: 0.25 Acres
- Dimensions: 121 x 90
- Features: Water View, Sprinklers
Details
- Additional structures: Outbuildings Allowed, Second Garage
- Parcel number: 0926208002
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Aluminum Siding, Brick
- Foundation: Crawl Space
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1958
- Major remodel year: 2025
Utilities & green energy
- Electric: Volts 220, Generator
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Above Ground Utilities
Community & HOA
Community
- Subdivision: LOTTIVUE
HOA
- Has HOA: Yes
- Services included: Other
- HOA fee: $83 monthly
- HOA phone: 248-655-1500
Location
- Region: Chesterfield
Financial & listing details
- Price per square foot: $314/sqft
- Tax assessed value: $249,295
- Annual tax amount: $9,306
- Date on market: 2/10/2026
- Cumulative days on market: 54 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Estimated market value
$737,600
$701,000 - $774,000
$3,300/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 2/10/2026 | Listed for sale | $775,000-0.1%$314/sqft |
Source: | ||
| 10/2/2025 | Listing removed | $775,500$314/sqft |
Source: | ||
| 9/14/2025 | Listed for sale | $775,500-5.1%$314/sqft |
Source: | ||
| 8/21/2025 | Listing removed | $817,500$331/sqft |
Source: | ||
| 8/5/2025 | Price change | $817,500-3.8%$331/sqft |
Source: | ||
| 7/22/2025 | Price change | $849,900-1.7%$344/sqft |
Source: | ||
| 7/9/2025 | Price change | $864,900-2.8%$350/sqft |
Source: | ||
| 6/27/2025 | Price change | $889,900-1.1%$360/sqft |
Source: | ||
| 6/20/2025 | Listed for sale | $899,900+15.5%$364/sqft |
Source: | ||
| 9/29/2023 | Listing removed | -- |
Source: | ||
| 9/27/2023 | Price change | $779,000-2.5%$315/sqft |
Source: | ||
| 9/19/2023 | Listed for sale | $799,000-0.1%$323/sqft |
Source: | ||
| 9/17/2023 | Listing removed | -- |
Source: Owner Report a problem | ||
| 9/16/2023 | Price change | $799,999-1.8%$324/sqft |
Source: Owner Report a problem | ||
| 9/12/2023 | Price change | $814,500+42.9%$330/sqft |
Source: Owner Report a problem | ||
| 12/29/2021 | Pending sale | $570,000$231/sqft |
Source: | ||
| 12/20/2021 | Price change | $570,000-5%$231/sqft |
Source: | ||
| 12/3/2021 | Price change | $599,900-6.3%$243/sqft |
Source: | ||
| 11/17/2021 | Price change | $639,900-5.2%$259/sqft |
Source: | ||
| 11/11/2021 | Listed for sale | $675,000+125%$273/sqft |
Source: | ||
| 3/24/2021 | Listing removed | -- |
Source: Owner Report a problem | ||
| 3/11/2014 | Sold | $300,000-6.2%$121/sqft |
Source: Public Record Report a problem | ||
| 9/10/2013 | Listed for sale | $319,900+1.6%$129/sqft |
Source: Owner Report a problem | ||
| 5/25/2007 | Sold | $315,000+166.9%$127/sqft |
Source: Public Record Report a problem | ||
| 10/25/1994 | Sold | $118,000$48/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,306 +9.4% | $292,400 +7% |
| 2024 | $8,508 +35.1% | $273,300 +19.9% |
| 2023 | $6,297 +2.8% | $227,900 +15.7% |
| 2022 | $6,122 | $197,000 +1.7% |
| 2021 | -- | $193,700 +4.6% |
| 2020 | -- | $185,100 +6.1% |
| 2019 | -- | $174,400 +4.4% |
| 2018 | $5,437 +131.7% | $167,100 +7% |
| 2017 | $2,347 | $156,200 |
| 2016 | $2,347 | $156,200 +4.4% |
| 2015 | $2,347 | $149,600 +3.3% |
| 2014 | -- | $144,850 |
| 2012 | -- | -- |
| 2009 | -- | -- |
| 2001 | $4,732 +3.3% | $144,339 +3.2% |
| 2000 | $4,579 | $139,864 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$4,793/mo
Principal & interest
$3857
Property taxes
$853
HOA Fees
$83
More affordability tools
Climate risks
Neighborhood: Lottivue
Nearby schools
GreatSchools rating
- 7/10Lottie M. Schmidt Elementary SchoolGrades: K-5Distance: 0.5 mi
- 5/10Anchor Bay Middle School SouthGrades: 6-8Distance: 1.4 mi
- 8/10Anchor Bay High SchoolGrades: 9-12Distance: 4 mi
Local experts in 48047
- Michigan
- Macomb County
- Chesterfield
- 48047
- Lottivue
- 49775 Keycove St






