REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Tue

Jun

Wed

Jun

Thu

Jun

Ryan Fagin

ryan@faginknight.com +1(517) 643-5498

$ 899,900

Est. payment | -/mo

4 Beds

2.5 Baths

2,471 SqFt

Save Virtual Tour

$ 899,900

Est. payment | -/mo

Save Virtual Tour

4 Beds

2.5 Baths

2,471 SqFt

OPEN HOUSE

Thu Jun 19, 4:00pm - 7:00pm

Fri Jun 20, 4:00pm - 7:00pm

Sun Jun 22, 11:00am - 1:30pm

Key Details

Property Type Single Family Home

Sub Type Ranch

Listing Status Coming Soon

Purchase Type For Sale

Square Footage 2,471 sqft

Price per Sqft $364

Subdivision Lottivue

MLS Listing ID 20251009154

Style Ranch

Bedrooms 4

Full Baths 2

Half Baths 1

HOA Fees $83/mo

HOA Y/N yes

Year Built 1958

Annual Tax Amount $9,306

Lot Size 10,890 Sqft

Acres 0.25

Lot Dimensions 121X90

Property Sub-Type Ranch

Source Realcomp II Ltd

Property Description

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.

Location

State MI

County Macomb

Area Chesterfield Twp

Direction S of 23 Mile, West off Jefferson into Lottivue Subdivision (Lottivue Dr) and left on Keycove

Body of Water Lake St. Clair

Rooms

Kitchen Built-In Electric Oven, Built-In Electric Range, Convection Oven, Disposal, Exhaust Fan, Free-Standing Refrigerator, Range Hood, Self Cleaning Oven, Warming Drawer

Interior

Interior Features 220 Volts, ENERGY STAR® Qualified Window(s), Furnished - No

Hot Water Natural Gas, Tankless

Heating Baseboard, Hot Water

Cooling Ceiling Fan(s), Central Air

Fireplaces Type Gas

Fireplace yes

Appliance Built-In Electric Oven, Built-In Electric Range, Convection Oven, Disposal, Exhaust Fan, Free-Standing Refrigerator, Range Hood, Self Cleaning Oven, Warming Drawer

Heat Source Natural Gas

Laundry 1

Exterior

Exterior Feature Whole House Generator, Chimney Cap(s), Gutter Guard System, Lighting, Fenced

Parking Features Side Entrance, Direct Access, Electricity, Door Opener, Heated, Attached, Driveway, Oversized

Garage Description 2 Car, 2.5 Car

Fence Back Yard, Fenced

Waterfront Description Canal Access,Canal Front,Direct Water Frontage,Water Front

Water Access Desc All Sports Lake,Dock Facilities,Sea Wall,

Roof Type Asphalt

Porch Deck, Patio, Porch

Road Frontage Paved

Garage yes

Building

Lot Description Sprinkler(s), Water View

Foundation Crawl

Sewer Public Sewer (Sewer-Sanitary)

Water Public (Municipal)

Architectural Style Ranch

Warranty No

Level or Stories 1 Story

Additional Building Outbuilding(s) Allowed, Second Garage

Structure Type Aluminum,Brick

Schools

School District Anchor Bay

Others

Pets Allowed Yes

Tax ID 0926208002

Ownership Short Sale - No,Private Owned

Acceptable Financing Cash, Conventional

Rebuilt Year 2025

Listing Terms Cash, Conventional

Financing Cash,Conventional

Virtual Tour https://youtu.be/UCblIazM030?si=RkKuRPCxwWJPCEKg

Listed by Ryan Nelson of DOBI Real Estate

"My job is to find and attract mastery-based agents to the office, protect the culture, and make sure everyone is happy! "

+1(517) 643-5498

ryan@faginknight.com

9471 Wendover Court, Brighton, Michigan, 48116, United States

49775 Keycove Street Chesterfield Twp, MI 48047