49775 keycove street, chesterfield, MI 48047

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.

Water Name:  lake st. clair
Water Description:  All Sports Lake,Canal Frontage,Dock/Pier Facility,Sea Wall,Water View,Waterfront

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 information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. ©2026
All information provided is deemed reliable but is not guaranteed and should be independently verified. Participants are required to indicate on their websites that the information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing By: Ryan Nelson of DOBI Real Estate

This listing last updated: Sat, March 28, 2026 at 4:34:31 PM EDT

MIRealSource Listing Data Last Updated On Thursday, April 2 2026 at 12:15pm