This pristine Ranch with a true, separate IN-LAW is unlike any you've seen. You are really getting 2 gorgeous units in one. Perfect for extended family, possibly rental income /in-home business. If you're a snowbird, rent main house and keep in-law for when you want to come back to see family & friends. The perfect entertaining home. Gorgeous pool area (newer liner) with cabana which features a 1/2 bath and storage (no family/friends dripping water across your floors to get to a bathroom), amazing large decks/patio style area. Main home has 9 rooms-4 BR's (1 in LL), 2 dining areas, tons of hardwood, Fireplace. Lower level has newly redone Rec Room with 1 of the 4 BR's. Stunning entertaining space, perfect for family time or visitors. In-law with completely separate entrance has LR, Huge kitchen, BR, bath, storage area w/ new carpet in most areas. Included are 2 stoves, 2 dishwashers, 2 microwaves, 2 disposals, 2 refrigerators, 2 washers, 2 dryers and cabana refrigerator for drinks & snacks. Newer mini split A/C's. Multiple decks. Gorgeous landscaping. Don't miss this opportunity !!
Pending
$749,900
40 Farmington Cir, Marlborough, MA 01752
5beds
2,400sqft
Single Family Residence
Built in 1959
0.36 Acres Lot
$746,500 Zestimate®
$312/sqft
$-- HOA
What's special
Multiple decksStunning entertaining spaceGorgeous landscapingTons of hardwood
- 23 days
- 169
- 4
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Marsha St. Jean 508-254-0822,
Dora Naves & Associates 508-624-4858,
Marsha St. Jean 508-254-0822
Source: MLS PIN,MLS#: 73554228
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Heating
- Central, Baseboard, Electric Baseboard, Natural Gas
Cooling
- Ductless
Appliances
- Included: Gas Water Heater, Electric Water Heater, Other
- Laundry: Gas Dryer Hookup, Electric Dryer Hookup, Washer Hookup
Features
- Flooring: Tile, Carpet, Hardwood, Wood Laminate
- Basement: Full,Partially Finished,Sump Pump,Concrete
- Number of fireplaces: 1
Interior area
- Total structure area: 2,400
- Total interior livable area: 2,400 sqft
- Finished area above ground: 1,674
- Finished area below ground: 726
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Paved Drive, Off Street
- Uncovered spaces: 4
Accessibility
- Accessibility features: No
Features
- Patio & porch: Deck
- Exterior features: Deck, Pool - Inground, Cabana, Storage, Other
- Has private pool: Yes
- Pool features: In Ground
- Waterfront features: Lake/Pond, Unknown To Beach, Beach Ownership(Public)
Lot
- Size: 0.36 Acres
- Features: Level
Details
- Additional structures: Cabana
- Parcel number: 617495
- Zoning: res
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Frame
- Foundation: Concrete Perimeter, Irregular
- Roof: Shingle
Condition
- Year built: 1959
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: for Gas Range, for Gas Dryer, for Electric Dryer, Washer Hookup
Community & HOA
Community
- Features: Shopping, Park, Walk/Jog Trails, Golf, Medical Facility, Laundromat, Highway Access, Private School, Public School
- Subdivision: Farmington Acres
HOA
- Has HOA: No
Location
- Region: Marlborough
Financial & listing details
- Price per square foot: $312/sqft
- Tax assessed value: $577,100
- Annual tax amount: $6,764
- Date on market: 9/7/2026
- Exclusions: Grandmother's Rose Bush Near Chimney & Clematis Behind In-Law. Main House Dr Fixture May Be Replaced
- Road surface type: Paved
Estimated market value
$746,500
$709,000 - $784,000
$4,016/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/14/2026 | Pending sale | $749,900$312/sqft |
Source: MLS PIN #73554228 Report a problem | ||
| 7/31/2026 | Contingent | $749,900$312/sqft |
Source: MLS PIN #73554228 Report a problem | ||
| 7/23/2026 | Listed for sale | $749,900+581.7%$312/sqft |
Source: MLS PIN #73554228 Report a problem | ||
| 7/6/1998 | Sold | $110,000$46/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,690 -1.7% | $577,100 +2.1% |
| 2024 | $5,788 -0.7% | $565,200 +11.9% |
| 2023 | $5,828 +2.2% | $505,000 +16.2% |
| 2022 | $5,701 -1.1% | $434,500 +4% |
| 2021 | $5,763 +2.1% | $417,600 +4.9% |
| 2020 | $5,644 +2% | $398,000 +1.2% |
| 2019 | $5,534 +8% | $393,300 +12.3% |
| 2018 | $5,122 +1.8% | $350,100 +6.6% |
| 2017 | $5,030 +1.3% | $328,300 +1.4% |
| 2016 | $4,967 +3.7% | $323,800 +6.5% |
| 2015 | $4,789 +3.3% | $303,900 +5.6% |
| 2014 | $4,636 +2.3% | $287,800 -4.7% |
| 2013 | $4,532 +0.6% | $302,100 -0.7% |
| 2012 | $4,504 +6.2% | $304,300 |
| 2011 | $4,242 -4.5% | $304,300 -8.1% |
| 2010 | $4,441 -0.4% | $331,200 -5.3% |
| 2009 | $4,461 +0.7% | $349,600 +0.4% |
| 2008 | $4,430 -1.4% | $348,300 -1.9% |
| 2007 | $4,493 +6% | $355,200 +2.9% |
| 2006 | $4,240 +3% | $345,300 +15.6% |
| 2005 | $4,115 +18% | $298,600 +10.4% |
| 2004 | $3,488 +1.9% | $270,400 +3.5% |
| 2003 | $3,424 +4.5% | $261,200 +18.8% |
| 2001 | $3,275 +8.2% | $219,800 +18.4% |
| 2000 | $3,027 +35% | $185,600 +40.2% |
| 1998 | $2,242 | $132,400 |
Find assessor info on the county website
Monthly payment
Est. payment





