Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

40 Farmington Circle, Marlborough MA 01752

Active

40 Farmington Circle, Marlborough MA 01752

$749,900

Estimated $5,184/month Calculator

Single Family

5 Bedrooms

Baths

2400

Total Parking: 4

15,549 (0.36)

Built in 1959

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 !! SHOWINGS START AT OPEN HOUSE SUNDAY, JULY 26, 2026, 1-3pm

This home has been viewed 5 times

Last Checked: July 25th, 2026 at 10:03am (Source: MLS PIN #73554228)

Air Conditioning

Waterview

Lead Paint Free

General Information for 40 Farmington Circle, Marlborough MA 01752

Listing ID73554228

Property TypeSingle Family / Detached

Price$749,900 ($312.46/SqFt)

StyleColonial

CityMarlborough

CountyMiddlesex

MLS AreaEast Marlborough

Neighborhood(s)

Garage Parking0

Zoningres

Year Built1959

Year Built SourceOwner

Year Built DetailsActual

Handicap Access / Features0

Interior Features for 40 Farmington Circle, Marlborough MA 01752

Approximate Living Area Total2400

Living Area Includes BasementYes

Rooms12

Bedrooms5

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric

Exterior Features for 40 Farmington Circle, Marlborough MA 01752

Approximate Lot Size (Acres)0.36

Approximate Lot Size (Square Feet)15549

Total Parking4

Garage Parking0

WaterPublic

SewerPublic Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction MaterialsFrame

Road Frontage Type

Patio & PorchCovered

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections110 Volts

Water ViewsNo

Water Views Features

Waterfront0

Waterfront FeaturesRiver

Pool FeaturesAssociation

Horse Permitted0

Horse AmenitiesRiver

Disclosures for 40 Farmington Circle, Marlborough MA 01752

Lead PaintNone

UFFI

Living Area Includes BasementYes

Living Area Disclosure

Building Area SourceOther

Special Listing Conditions

ExclusionsWasher & Dryer

Compensation Based On

Financial Information for 40 Farmington Circle, Marlborough MA 01752

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax6764.06

Tax Year2027

Assessed Value$0

Location Information for 40 Farmington Circle, Marlborough MA 01752

Neighborhood(s)

MLS AreaEast Marlborough

Area AmenitiesWalk/jog Trails

Contact Information for 40 Farmington Circle, Marlborough MA 01752

Agent

Name: Marsha St. Jean

Office

Name: Dora Naves & Associates

Phone: 508-624-4858

Team Members

Payment Calculator

, Interest

Property Taxes 563.67

Principal & Interest 4620.65

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Dora Naves & Associates

Marsha St. Jean

Agent Phone

Office Phone

(508) 624-4858

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 0.36 acres (15,549 SqFt)
    [add_date] => 2026-07-24 10:33:34
    [address] => Farmington Circle
    [agent] => Array
        (
            [address] => 39 Boise Road
            [city] => Marlborough
            [id] => BB981380
            [name] => Marsha St. Jean
            [national_association] => 453000384
            [office] => BB3955
            [state] => MA
            [zip] => 01752
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Range
        )

[approx_living_area_total] => 2400
    [approx_lot_size_acres] => 0.36
    [approx_lot_size_sqft] => 15549
    [assessed_value] => $0
    [association] => 
    [association_fee] => Array
        (
        )

[association_fee_frequency] => Array
        (
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => 0
    [basement] => Array
        (
            [0] => Full
        )

[bathrooms] => 
    [bedrooms] => 5
    [building_amenities] => Array
        (
        )

[building_area_source] => Array
        (
            [0] => Other
        )

[building_management] => Array
        (
        )

[building_debug] => 
    [building_id] => 
    [building_parent] => 0
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Array
        (
            [0] => Single Family
        )

[cap_rate] => 
    [city] => Marlborough
    [community_features] => Array
        (
            [0] => Walk/jog Trails
        )

[compensation_based_on] => Array
        (
        )

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
            [0] => Frame
        )

[construction_status] => 
    [cooling] => Array
        (
            [0] => 1
            [1] => Split
        )

[cooperating_agent_commission] => Array
        (
        )

[county] => Middlesex
    [cultivation_acres] => 
    [date_available_note] => 
    [deposit_amount] => Array
        (
        )

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => 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 !!   SHOWINGS START AT OPEN HOUSE SUNDAY, JULY 26, 2026, 1-3pm
    [disclosures] => 
    [documents_available] => Array
        (
        )

[electric] => Array
        (
        )

[electric_expense] => Array
        (
        )

[elementary_school] => 
    [en_suite_bath] => Array
        (
            [0] => Yes
        )

[energy_features] => 
    [entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Washer & Dryer
        )

[exterior_features] => Array
        (
            [0] => Porch
        )

[facilitator_compensation] => 
    [fee_paid_by_tennant] => 
    [financial_data_source] => Array
        (
        )

[fireplaces] => Array
        (
        )

[first_month_required] => Array
        (
        )

[floor_number] => 0
    [flooring] => Array
        (
            [0] => Tile
        )

[for_sale_by_owner] => 
    [foundation_area] => 
    [foundation_materials] => Array
        (
        )

[frontage_length] => 
    [full_baths] => 
    [garage_parking] => 0
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

[half_baths] => 
    [handicap_access] => 0
    [heating] => 
    [heating_expense] => Array
        (
        )

[high_school] => 
    [horse_features] => Array
        (
            [0] => River
        )

[horse_permitted] => 0
    [hot_water] => Array
        (
        )

[id] => 
    [insurance_expense] => Array
        (
        )

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2026-07-25 10:03:35
    [laundry_features] => Array
        (
            [0] => Archway
        )

[lead_paint] => Array
        (
            [0] => None
        )

[lease_term] => Array
        (
        )

[levels_in_unit] => 
    [living_area] => 
    [living_area_disclosure] => Array
        (
        )

[living_area_includes_basement] => Array
        (
            [0] => Yes
        )

[lot_features] => Array
        (
            [0] => Gentle Sloping
        )

[management_expense] => Array
        (
        )

[middle_school] => 
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => East Marlborough
    [mls_id] => 73554228
    [neighborhoods] => 
    [net_income_calc] => -6764
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => BB3955
            [name] => Dora Naves & Associates
            [phone] => 508-624-4858
        )

[operating_expense] => Array
        (
        )

[optional_fee_includes] => Array
        (
        )

[optional_price] => 0
    [outdoor_space_available] => Array
        (
        )

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => 1
        )

[pasture_area] => 
    [patio_and_porch] => Array
        (
            [0] => Covered
        )

[perc_test] => Array
        (
        )

[perc_test_date] => 
    [pet_policy] => Array
        (
            [0] => Allowed
        )

[phone] => 
    [pool_features] => Array
        (
            [0] => Association
        )

[price] => 749900
    [price_per_sqft] => 312.46
    [price_per_unit] => 749900
    [private_pool] => 
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => 6764.06
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Asphalt/fiberglass Shingles
        )

[rooms] => 12
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Public Sewer
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

[state] => Massachusetts
    [state_code] => MA
    [status] => Array
        (
            [0] => Active
        )

[street_number] => 40
    [structure_type] => Array
        (
        )

[style] => Array
        (
            [0] => Colonial
        )

[subagent_compensation] => 
    [tag_accessible_features] => 
    [tag_air_conditioning] => 1
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 
    [tag_elevator] => 
    [tag_equestrian] => 
    [tag_garage_parking] => 
    [tag_generator] => 
    [tag_green_features] => 
    [tag_laundry] => 1
    [tag_lead_paint_free] => 1
    [tag_loft] => 
    [tag_pet_friendly] => 
    [tag_pre_construction] => 
    [tag_private_outdoor_space] => 
    [tag_private_pool] => 
    [tag_professional_management] => 
    [tag_recently_renovated] => 
    [tag_senior_community] => 
    [tag_townhouse] => 
    [tag_waterfront] => 
    [tag_waterview] => 1
    [tax_year] => 2027
    [team] => BB981380
    [team_agents] => Array
        (
            [BB981380] => Array
                (
                    [agent_mls_id] => BB981380
                    [full_name] => Marsha St. Jean
                    [address] => 39 Boise Road
                    [city] => Marlborough
                    [state] => MA
                    [postal_code] => 01752
                    [national_association_id] => 453000384
                    [office_mls_id] => BB3955
                )

)

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => 
    [total_gross_expense] => 6764
    [total_gross_income] => 0
    [total_parking] => 4
    [trash_expense] => Array
        (
        )

[travel_routes] => 
    [uffi] => Array
        (
        )

[unit_1_bathrooms] => 
    [unit_1_bedrooms] => 
    [unit_1_floor] => 
    [unit_1_lease] => Array
        (
        )

[unit_1_levels] => 
    [unit_1_rent] => Array
        (
        )

[unit_2_bathrooms] => 
    [unit_2_bedrooms] => 
    [unit_2_floor] => 
    [unit_2_lease] => Array
        (
        )

[unit_2_levels] => 
    [unit_2_rent] => Array
        (
        )

[unit_3_bathrooms] => 
    [unit_3_bedrooms] => 
    [unit_3_floor] => 
    [unit_3_lease] => Array
        (
        )

[unit_3_levels] => 
    [unit_3_rent] => Array
        (
        )

[unit_4_bathrooms] => 
    [unit_4_bedrooms] => 
    [unit_4_floor] => 
    [unit_4_lease] => Array
        (
        )

[unit_4_levels] => 
    [unit_4_rent] => Array
        (
        )

[unit_level] => 
    [unit_number] => 
    [units_owner_occupied] => 
    [unparsed] => 40 Farmington Circle, Marlborough MA 01752
    [utilities] => Array
        (
            [0] => 110 Volts
        )

[view] => Array
        (
        )

[water] => Array
        (
            [0] => Public
        )

[water_expense] => Array
        (
        )

[water_views] => Array
        (
            [0] => No
        )

[water_views_features] => Array
        (
        )

[waterfront] => 0
    [waterfront_features] => Array
        (
            [0] => River
        )

[raw] => 
)

EXIT

31 More Photos