Skip main navigation
For sale
  • Price cut: $32.4K (8/5)
    $817,500

    49775 Keycove St, Chesterfield, MI 48047

    4beds
    2,471sqft
    : 
    Single Family Residence
    Built in 1958
    0.25 Acres Lot
    $800,700 Zestimate®
    $331/sqft
    $83/mo HOA

    What's special

    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.
    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#: 20251009154MLS Logo
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 49775 Keycove St.

    Next available tour time:Today at 11am

    Open house

    • Sun, Aug 10

      1:00 PM - 3:00 PM

    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