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
Price cut: $32.4K (8/5)
$817,500
49775 Keycove St, Chesterfield, MI 48047
4beds
2,471sqft
Est.:
Single Family Residence
Built in 1958
0.25 Acres Lot
$800,700 Zestimate®
$331/sqft
$83/mo HOA
What's special
- 52 days
- on Zillow |
- 2,087 |
- 62 |
Zillow last checked: 7 hours ago
Listing updated: August 05, 2025 at 02:17am
Listed by:
Ryan Nelson 248-462-4741,
DOBI Real Estate 248-385-3350
Source: Realcomp II,MLS#: 20251009154

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Open house
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
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
- 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
- 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: $331/sqft
- Tax assessed value: $249,295
- Annual tax amount: $9,306
- Date on market: 6/20/2025
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Loading
- Loading