$999,500
About this home
A rare and remarkable opportunity on the sun-drenched shores of Webster Lake. 174 & 175 Lake Shore Drive presents a beautifully curated waterfront compound with 124 feet of pristine, east-facing frontage. Consisting of two fully reimagined year-round cottages, this one-of-a-kind property captures the essence of refined lakeside living where design and flexibility combine. The cottage at 175 is a true showpiece. Soaring cathedral ceilings and walls of glass frame lake views, while a seamless open layout flows effortlessly. Custom cabinetry, quartzite countertops, and Bosch appliances elevate the kitchen, while a spacious bedroom and custom walk in shower offer comfort and sophistication. Set just behind, 174 Lake Shore Drive offers a private and equally refined retreat with tranquil lake views. One bedroom, a dedicated office, full bath with custom quartzite surround, and a well-appointed kitchen with GE Profile appliances. Beautiful living spaces ideal for hosting guests, extended stays, or generating income without compromise. The grounds are nothing short of exceptional. Architecturally designed landscaping and hardscaping unfold across the property, complemented by cobblestone driveways, custom greenhouse, insulated workshop and parking pad for camper or boat. Granite steps lead to the water’s edge, where two docks and four boat slips invite endless days on the lake, while a Sundance spa offers a quiet place to unwind. Thoughtful modern enhancements include an integrated electric vehicle charging station, Mitsubishi heat pumps in both cottages, and electric fireplaces. Whether envisioned as a legacy retreat, a multi-generational escape, or a unique investment, this extraordinary waterfront offers a level of versatility and craftsmanship rarely found.
Highlights
Property details
- MLS
- Prime MLS
- MLS #
- 5082519
- Property type
- Single Family Residence
- Subdivision
- N/A
- Status
- Active
- Days on market
- 126
- On market date
- N/A
- Stories
- N/A
- Total bathrooms
- N/A
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- 0.27 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card.
- Enrollment
- 293
- Student:teacher ratio
- 9.8:1
- District
- Franklin School District
- Enrollment
- 357
- Student:teacher ratio
- 11.5:1
- District
- Franklin School District
- Enrollment
- 267
- Student:teacher ratio
- 11.1:1
- District
- Franklin School District
Walkability
Blended score for Franklin's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like

Copyright 2026 PrimeMLS. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of PrimeMLS. 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. Data last updated 07/27/26.







