$699,950
Under contractAbout this home
A Truly One-of-a-Kind Property! Offered for the first time in decades, this exceptional property has remained in the same family for generations and has been thoughtfully transformed by its current owner into something truly special. This beautifully remodeled classic double-dormered Cape/Farmhouse blends timeless New England charm with high-end modern amenities, featuring a welcoming wraparound farmer’s porch and craftsmanship throughout. The stunning custom kitchen is designed to impress, showcasing: • Sub-Zero refrigerator with custom cabinet-matching panels • Viking 6-burner cooktop with griddle • Viking vent hood • Double wall ovens (microwave + conventional/convection) • Pot filler faucet • Built-in beverage cooler • Granite countertops. Additional highlights include a forced hot water outdoor wood boiler that heats the detached garage and is plumbed directly into the Buderus gas fired, 3 zone boiler system, providing supplemental heat to the home as well. The hot water comes off the boiler into a new Super Store tank for endless hot water! Hardwired smoke detectors. There is a woodstove in the fireplace opening adding yet another additional heat source! The outbuildings and utility features make this property equally impressive: • 34' x 36' detached 2-car garage featuring radiant heated floors, mini-split heat/AC, abundant second-level storage, and a 12' lean-to. • 16' x 30' pole barn conveniently located behind the garage. • 30' x 52' RV garage with impressive 16' walls, thoughtfully positioned at the rear of the property. **THE SELLER MISTAKINGLY CHECKED YES ON 9a WHEREAS IT SHOULD BE NO ON THE PROPERTY DISCLOSURE** More details to come... Audio/Video recording equipment on property. DISCLOSURE NOTIFICATION MUST BE SIGNED PRIOR TO ENTERING THE PROPERTY Pre-approved buyers only. A current lender pre-approval letter or proof of funds equal to or exceeding the list price is REQUIRED prior to any showings.
Property details
- MLS
- Prime MLS
- MLS #
- 5087522
- Property type
- Single Family Residence
- Subdivision
- N/A
- Status
- Under contract
- Days on market
- 65
- On market date
- N/A
- Stories
- N/A
- Total bathrooms
- 1.5
- Garage spaces
- 3
- Parking spaces
- N/A
- Lot size
- 5.5 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
- 237
- Student:teacher ratio
- 7.4:1
- District
- Farmington School District
- Enrollment
- 295
- Student:teacher ratio
- 8.4:1
- District
- Farmington School District
- Enrollment
- 249
- Student:teacher ratio
- 10.4:1
- District
- Farmington School District
Walkability
Blended score for Farmington'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).
Market position
How this listing compares to current activity in Farmington, from live MLS data.
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/22/26.