• Buy
  • Rent
  • Sell
  • Agents
New DevelopmentWorld of Elliman
The latest in luxury property, lifestyle & culture, curated just for you.

Company

  • About Us
  • Leadership
  • Offices
  • Press & News
  • Elliman Cares
  • Join as an Agent
  • Careers
  • Elliman Global
  • Investors

Resources

  • World of Elliman
  • Elliman Insider
  • Magazines
  • Market Reports
  • Research Reports
  • Elliman Private Listings
  • New Elliman Exclusives
  • Featured Cities
  • Guides to Buying & Selling

Brand Portfolio

  • New Development
  • Commercial
  • Relocation
  • Sports & Entertainment
  • Farm & Ranch
  • Building Broker Specialists
  • Title Services
  • Estate, Trust & Probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • Site Map
  • Terms
  • Privacy
  • Cookie Preferences
  • Do Not Sell or Share My Personal Information
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • Text of NYC Human Rights Law
  • New York City Commission on Human Rights
  • NYC Source of Income Discrimination Information
  • NYC Source of Income Discrimination Tenant FAQs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2026 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY. LISTING DATA REFRESHED ON MAY 3 2026 AT 10:55 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

SCAMMERS ARE IMPERSONATING REAL ESTATE AGENTS AND USING ACTIVE LISTINGS TO REQUEST FAKE DEPOSITS. SHOULD YOU HAVE A QUESTION ABOUT THE LEGITIMACY OF A DOUGLAS ELLIMAN AGENT OR LISTING, PLEASE CONTACT THE AGENT DIRECTLY VIA THE “AGENTS” LINK IN THE TOP MENU. DOUGLAS ELLIMAN WILL NEVER ASK FOR ANY PAYMENT TO RESERVE, HOLD, OR VIEW A PROPERTY. THESE CHARGES ARE PROHIBITED UNDER NEW YORK LAW. IF YOU RECEIVE A SUSPICIOUS REQUEST FOR MONEY, DO NOT SEND FUNDS. REPORT IT TO THE NYS DEPARTMENT OF STATE AND NOTIFY DOUGLAS ELLIMAN. YOU CAN READ THE NEW YORK STATE DEPARTMENT OF STATE'S CONSUMER ALERT HERE.

This website has been translated using automated software for convenience. While reasonable efforts have been made to ensure accuracy, machine translation may contain errors and is not a substitute for human translation. Translations are provided “as is,” without any express or implied warranty regarding their accuracy, reliability, or completeness. Some content (including images or videos) may not be translated accurately. The official version of this website is the English version. Any discrepancies in translation are not binding and have no legal effect; the English version controls.

POWERED BY PURLIN.AI

4040 Rollins Ave

waterfordchartertownship_oakland, MI 48329

$679,900

  • 3 BR
    2 BA, 1 HALF BA
    approx. 2,785 SF
  • Contract signed

Interested? Let's Connect

Incredible opportunity to own a canal-front home with direct access to all-sports Lake Oakland, offering approximately 600 feet of frontage without the higher taxes typically associated with lakefront properties. This property features both an attached 22x22 garage and a detached 30x26 garage added in 2005, ideal for storage, hobbies, or workshop space. The detached garage includes a heater replaced in 2022, and a hoist in the garage is included.
Inside, the home offers a well-appointed kitchen with Welborne semi-custom cabinetry, a Wolf gas cooktop with built-in grill, Dacor Stove with Warming Drawer and unique barnwood fireplace mantels reclaimed from Michigan. Additional features include an electric fireplace (2021) and a living room addition completed in 2002.
Numerous updates provide peace of mind, including a new roof and skylight (2025), replaced main window (2025), fresh paint (2026), new carpet (2022), new dishwasher and refrigerator (2022), new attached garage door (2023), dock replaced (2022), and a remodeled half bathroom (2021). Built-in sprinkler system draws from the lake for both front and back yard irrigation.
A recent third-party appraisal was completed at $700,000. A rare combination of water access, functional garage space, and extensive updates makes this property a unique offering. Enjoy boating, relaxing, and waterfront living with a private dock included and boat hoist negotiable.

Details

2,785 Sq Ft

0.25 Private Acres Lot Size

single family home

$3,942 Annual Tax

Built in 1986

MLS/Listing ID 20261027771

Amenities & Features

Lot - Sprinklers

Style - Colonial

Construction - Brick

Construction - Aluminum Siding

Cooling - Central Air

Cooling - Ceiling Fans

Lighting

Fenced

Family Room Fireplace

Electric Fireplace

Basement

Heating - Natural Gas

Canal Front

Water Frontage Across the Road

Deck

Porch

Parking - Attached

Parking - Detached

Parking - Garage Door Opener

Parking - Garage Faces Front

Heating - Forced Air

Entrance Foyer

Parking - Workshop in Garage

Parking - Two Car Garage

Washer

Warming Drawer

Built-in Electric Oven

Dishwasher

Disposal

Dryer

Free-standing Refrigerator

Gas Cooktop

Microwave

Range Hood

Interested In 4040 Rollins Ave?