Ipswich Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

4 Beech Brook Farm Rd Middleton. MA 01949

$2,249,900

Single Family

4 Bedrooms

3.5 Bathrooms

6,300 sq ft

7 Parking Spots

1.62 Acres

Built in 2024

Fabulous New Construction. Amazing privacy abounds with this magnificent property situated at the prestigious Beech Brook Farm Estates, the North Shore’s spectacular, private, and new four home luxury subdivision. Property will be ready for occupancy this summer. Buyers still have time to add the finishing touches on this lifetime home tucked away in a perfectly positioned cul de sac. 4 Beech Brook Farm features a 70,000 SF+ lot boarded by a tree line, conservation land and a meadow. A spacious Master BR Suite with deck, gourmet kitchen, three car garage, outdoor areas for entertaining, cathedral ceilings, lofts, home office, a bonus room, and a finished lower level are just some of the features. The possibilities are endless! More photos coming soon.

This listing has been viewed 39 times in the past 209 days

Last Updated: October 7th, 2024 at 8:33pm

Conservation Area

Highway Access

House Of Worship

Public School

Golf

Private School

General Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Property TypeResidential

Property Sub TypeResidential

Price$2,249,900

Price per sqft$357.13

MLS #73223746

Handicap Access / FeaturesNo

List Date2024-04-13

List Price$2,249,900

Special Listing ConditionsNo

Specific Zoning CodeRES

StateMassachusetts

Street NameBeech Brook Farm Rd

Style

TownMiddleton

CityMiddleton

Zip Code01949

CountyEssex

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces3

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones3

Attached/DetachedYes

Sold Date

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourceOther

Building Area Total6300

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces3

Listing Service

UnparsedAddress4 Beech Brook Farm Rd, Middleton MA 01949

Zoning

Interior Features for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Master BathYes

* Approx. Living Area Total6,300 sq ft

Living Area Includes BasementYes

* Living Area Source0

Bedrooms4

* # Fireplaces1

Bathrooms (Total)3.5

Full Baths3

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area DisclosureLiving Area is approximate at this time and is tak

Living Area Includes BasementYes

Door FeaturesNo

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate

Beech Brook Farm Estates

Exterior Features for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

* Approximate Lot Size1.62 acres

Covered Parking Spaces3

Lot FeaturesGentle Sloping, Wooded

* Parking Spaces7

* Sewer Utilities

* Water Utilities

* Year Built2024

Year Built Details

Year Built SourceBuilder

Year Built Effective

Construction MaterialsFrame

Exterior Features

Foundation Area

Foundation MaterialsConcrete Perimeter

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)70,426 Sqft

Disclosures for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Buyer Agent Compensation2

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ONNet Sale Price

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintNone

Living Area DisclosureLiving Area is approximate at this time and is tak

Living Area Includes BasementYes

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation1

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Association Fee$0

Association Fee Frequency

Associaton Fee IncludesNo

AssociationNo

Assessed Value

Real Estate Tax$0

Tax Year

MLSPIN_SOLD_PRICE_PER_SQFT$0

OriginalListPrice$2,249,900

Lifestyle Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront FeaturesNo

Location information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Elementary School

Middle School

High School

Neighborhood/Sub-DivisionBeech Brook Farm Estates

Neighborhood (WPL, not MLS)Ipswich

Marketing History for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

MLSPIN_MARKET_TIME_BROKER125

MLSPIN_MARKET_TIME_PROPERTY125

PurchaseContractDate

Agent Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Agent NameChuck Andre

Agent MLS IDCT000306

Agent Phone #617-312-7156

Agent Phone Area

Office NameRE/MAX Andrew Realty Services

Office Phone781-395-7676

Office Phone Area

Office MLS IDAC2354

Buyer Agent MLS ID

Buyer Office MLS ID

Team MembersB0527470

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 13863.17

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Chuck Andre

RE/MAX Andrew Realty Services

Agent Phone

(617) 312-7156

Office Phone

(781) 395-7676

Text Agent Call Agent Call Office

Array
(
    [id] => 305464
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73223746
    [mls_id_num] => 73223746
    [parent] => 0
    [pic_numb] => 11
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 12
    [location4_id] => 184
    [location5_id] => 1340
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Essex
    [location4_name] => Middleton
    [location5_name] => Beech Brook Farm Estates
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 2249900
    [price_unit] => 260
    [price_si] => 2249900
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 4
    [bedrooms_max] => 0
    [rooms] => 11
    [rooms_max] => 0
    [bathrooms] => 3.5
    [bathrooms_max] => 0
    [living_area] => 6300
    [living_area_unit] => 1
    [living_area_si] => 585.9
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 1.62
    [lot_area_unit] => 1
    [lot_area_si] => 0.15066
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.60072500
    [googlemap_ln] => -71.01411800
    [geopoints] => �������</O��Q��q���LE@
    [finalized] => 1
    [add_date] => 2024-04-27 09:10:45
    [last_finalize_date] => 2024-10-07 20:33:19
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 2024
    [zip_id] => 6251
    [zip_name] => 01949
    [last_modified_time_stamp] => 2024-10-09 10:58:51
    [post_code] => 
    [meta_description] => 4 Bedrooms Bedrooms 11 Rooms Rooms With 3.5 Bathrooms Bathrooms Residential For Sale Beech Brook Farm Rd In 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949
    [meta_description_manual] => 0
    [meta_keywords] => 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949, 4 Bedrooms Bedrooms, 11 Rooms Rooms,3.5 BathroomsBathrooms,Residential,For Sale,Beech Brook Farm Rd,73223746
    [meta_keywords_manual] => 0
    [street_no] => 4
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Fabulous New Construction. Amazing privacy abounds with this magnificent property situated at the prestigious Beech Brook Farm Estates, the North Shore’s spectacular, private, and new four home luxury subdivision. Property will be ready for occupancy this summer. Buyers still have time to add the finishing touches on this lifetime home tucked away in a perfectly positioned cul de sac. 4 Beech Brook Farm features a 70,000 SF+ lot boarded by a tree line, conservation land and a meadow.  A spacious Master BR Suite with deck, gourmet kitchen, three car garage, outdoor areas for entertaining, cathedral ceilings, lofts, home office, a bonus room, and a finished lower level are just some of the features. The possibilities are endless! More photos coming soon.\n Property Type Residential Listing Type For Sale Ref ID fea213a28e3d08aab00531d37e0e1ede Full Bathrooms 3 Full Bathrooms three Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 01949 Office Name RE/MAX Andrew Realty Services Agent MLSID CT000306 Office Phone 781-395-7676 Agent Phone 617-312-7156 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 7 ParkingTotal seven UnparsedAddress 4 Beech Brook Farm Rd, Middleton MA 01949 OpenParkingYN 1 OpenParkingYN one  beech brook farm rd middleton massachusetts 01949 
    [location_text] => 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949
    [field_42] => Beech Brook Farm Rd
    [field_312] => Residential For Sale - 11 Rooms - 4 Bedrooms - 3.5 Bathrooms - Price $
    [field_313] => Residential For Sale
    [field_308] => Fabulous New Construction. Amazing privacy abounds with this magnificent property situated at the prestigious Beech Brook Farm Estates, the North Shore’s spectacular, private, and new four home luxury subdivision. Property will be ready for occupancy this summer. Buyers still have time to add the finishing touches on this lifetime home tucked away in a perfectly positioned cul de sac. 4 Beech Brook Farm features a 70,000 SF+ lot boarded by a tree line, conservation land and a meadow.  A spacious Master BR Suite with deck, gourmet kitchen, three car garage, outdoor areas for entertaining, cathedral ceilings, lofts, home office, a bonus room, and a finished lower level are just some of the features. The possibilities are endless! More photos coming soon.
    [field_7] => 0
    [n_103] => 
    [n_103_distance] => 
    [n_103_distance_by] => 
    [n_105] => 
    [n_105_distance] => 
    [n_105_distance_by] => 
    [n_107] => 
    [n_107_distance] => 
    [n_107_distance_by] => 
    [n_108] => 
    [n_108_distance] => 
    [n_108_distance_by] => 
    [n_109] => 
    [n_109_distance] => 
    [n_109_distance_by] => 
    [f_130_options] => ,29,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,4,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,0,2,
    [f_137] => 1
    [f_138_options] => 
    [f_138] => 
    [f_139_options] => 
    [f_139] => 
    [f_140_options] => ,6,
    [f_140] => 1
    [f_141_options] => 
    [f_141] => 
    [f_144_options] => ,20,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,27,15,16,
    [f_150] => 1
    [f_151_options] => 
    [f_151] => 
    [f_152_options] => 
    [f_152] => 
    [f_156_options] => 
    [f_156] => 
    [f_157_options] => 
    [f_157] => 
    [f_159_options] => 
    [f_159] => 
    [f_161_options] => 
    [f_161] => 
    [f_163_options] => 
    [f_163] => 
    [f_165_options] => 
    [f_165] => 
    [f_166_options] => 
    [f_166] => 
    [ref_id] => fea213a28e3d08aab00531d37e0e1ede
    [field_54] => 
    [half_bathrooms] => 1
    [half_bathrooms_max] => 0
    [field_55] => 0
    [rendered] => {"rendered":{"313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 11 Rooms - 4 Bedrooms - 3.5 Bathrooms - Price $"},"3":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"2":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"materials":{"field_313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"field_312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 11 Rooms - 4 Bedrooms - 3.5 Bathrooms - Price $"},"property_type":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"listing":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"field_55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"location_text":"4 Beech Brook Farm Rd, Middleton, Massachusetts 01949"}
    [alias] => Single-Family-4-Beech-Brook-Farm-Rd-Middleton-Massachusetts-01949-73223746-USD2-249-900
    [source] => mls
    [last_sync_date] => 2024-10-07 20:33:10
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => RE/MAX Andrew Realty Services
    [field_2112] => Chuck Andre
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => CT000306
    [field_3001] => AC2354
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 125
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-08-16 15:11:00
    [f_3102_options] => ,54,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 4 Beech Brook Farm Rd
    [field_3171] => 781-395-7676
    [field_3172] => 617-312-7156
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 3
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 0
    [field_3191] => 0
    [field_3192] => 7
    [field_3212] => 0
    [field_3217] => 0
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 4 Beech Brook Farm Rd, Middleton MA 01949
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 2
    [field_3186] => 
    [field_3301] => 0
    [field_3306] => 0
    [field_3306_si] => 0
    [field_3306_unit] => 260
    [fly_field] => 
    [fly_value] => 
    [field_3120] => 
    [field_3055] => 
    [field_3056] => 0
    [field_3056_si] => 0
    [field_3056_unit] => 260
    [field_3311] => 
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 100
    [visit_time] => 38
    [visit_date] => 2024-11-20 04:18:43
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,0,2,4,1,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,0,17,3,
    [f_3006] => 1
    [f_3007_options] => ,14,
    [f_3007] => 1
    [f_3008_options] => ,9,
    [f_3008] => 1
    [f_3009_options] => ,0,15,14,
    [f_3009] => 1
    [f_3010_options] => ,224,
    [f_3010] => 1
    [field_3011] => 0
    [field_3011_si] => 0
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 11
    [field_3019] => 2024-04-13 18:38:09
    [field_3020] => 12
    [field_3021] => Call List Agent,Email List Agent,Property Is Still
    [field_3022] => 
    [field_3023] => 0
    [field_3023_si] => 0
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,0,8,1,
    [f_3025] => 1
    [field_3027] => 0
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => RES
    [field_3039] => Set GPS for 161 Essex St, Middleton MA 01949
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 1
    [field_3060] => 
    [field_3069] => 357.13
    [field_3069_si] => 357.13
    [field_3069_unit] => 260
    [field_3079] => 2024-04-13 18:31:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 4
    [field_3096] => 
    [field_3097] => B0527470
    [field_3098] => 1
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 3
    [field_3113] => 
    [field_3114] => 
    [field_3115] => 
    [field_3116] => 
    [field_3118] => 0
    [field_3118_si] => 0
    [field_3118_unit] => 260
    [field_3119] => 
    [field_3121] => 
    [field_3122] => 
    [field_3123] => 
    [f_3125_options] => ,16,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 3
    [field_3134] => 1
    [field_3135] => 2
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => Living Area is approximate at this time and is tak
    [f_3166_options] => ,94,
    [f_3166] => 1
    [field_3168] => 0
    [field_3168_si] => 0
    [field_3168_unit] => 260
    [field_3178] => 0
    [field_3179] => 
    [field_3182] => 0
    [field_3183] => 6300
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,6,1,2,3,17,4,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,0,
    [f_3190] => 1
    [field_3193] => 3
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [field_3197] => 
    [f_3198_options] => ,5,
    [f_3198] => 1
    [field_3199] => 
    [field_3200] => 0
    [field_3200_si] => 0
    [field_3200_unit] => 260
    [field_3201] => 
    [field_3202] => 
    [field_3203] => 
    [field_3204] => 
    [field_3205] => 1900-01-01
    [field_3206] => 0
    [f_3207_options] => ,10,
    [f_3207] => 1
    [field_3208] => 0
    [field_3209] => Concrete Perimeter
    [field_3210] => 
    [field_3211] => 3
    [field_3213] => 
    [field_3214] => 
    [field_3215] => 
    [field_3216] => 0
    [field_3216_si] => 0
    [field_3216_unit] => 260
    [field_3218] => 
    [field_3220] => 0
    [field_3220_si] => 0
    [field_3220_unit] => 260
    [field_3221] => 
    [field_3222] => Exclusive Right To Sell
    [field_3223] => 2024-04-13
    [field_3224] => 
    [f_3225_options] => ,7,0,
    [f_3225] => 1
    [field_3226_si] => 6549.618
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 2249900
    [field_3231_si] => 2249900
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Please submit offers in one PDF to chuck.andre@rem
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Under Construction
    [field_3244] => 
    [field_3245] => Builder
    [field_3246] => 
    [field_3248] => 2024-04-13 18:31:00
    [field_3249] => 
    [field_3250] => 
    [field_3251] => 
    [field_3252] => 
    [field_3253] => 
    [field_3254] => 
    [field_3255] => 
    [field_3256] => 
    [field_3257] => 
    [field_3258] => 
    [field_3259] => 
    [field_3260] => N
    [field_3261] => 
    [field_3262] => 
    [field_3263] => 
    [field_3264] => 
    [field_3265] => 0
    [field_3265_si] => 0
    [field_3265_unit] => 260
    [field_3266] => 0
    [field_3266_si] => 0
    [field_3266_unit] => 260
    [field_3267] => 
    [field_3268] => 
    [field_3269] => 
    [field_3270] => 
    [field_3271] => 
    [field_3272] => None
    [field_3273] => 
    [field_3274] => 
    [field_3275] => 
    [field_3276] => 
    [field_3277] => AC2354
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 125
    [field_3281] => 0
    [field_3281_si] => 0
    [field_3281_unit] => 260
    [field_3282] => 0
    [field_3282_si] => 0
    [field_3282_unit] => 260
    [field_3283] => 
    [field_3284] => 
    [field_3285] => 0
    [field_3285_si] => 0
    [field_3285_unit] => 260
    [field_3286] => 
    [field_3287] => 
    [field_3288] => 
    [field_3289] => 
    [field_3290] => 357.13
    [field_3290_si] => 357.13
    [field_3290_unit] => 260
    [field_3291] => 
    [field_3292] => 0
    [field_3292_si] => 0
    [field_3292_unit] => 260
    [field_3293] => 0
    [field_3293_si] => 0
    [field_3293_unit] => 260
    [field_3294] => 
    [field_3295] => 
    [field_3297] => 
    [field_3303] => [{"id":"B0527470","name":"John Veneziano","phone":
    [f_3304_options] => ,22,
    [f_3304] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 70426
)

Array
(
    [property_type] => Array
        (
            [field_id] => 3
            [type] => property_types
            [name] => Property Type
            [value] => Residential
        )

[field_3236] => Array
        (
            [field_id] => 3236
            [type] => select
            [name] => PropertySubType
            [value] => Single Family Residence
        )

[listing] => Array
        (
            [field_id] => 2
            [type] => listings
            [name] => Listing Type
            [value] => For Sale
        )

[field_3176] => Array
        (
            [field_id] => 3176
            [type] => number
            [name] => Full Bathrooms
            [value] => 3
        )

[field_3175] => Array
        (
            [field_id] => 3175
            [type] => select
            [name] => Status
            [value] => Active
        )

[field_3299] => Array
        (
            [field_id] => 3299
            [type] => select
            [name] => Property Category
            [value] => Residential
        )

[field_3298] => Array
        (
            [field_id] => 3298
            [type] => select
            [name] => Property Type
            [value] => Single Family
        )

[field_3300] => Array
        (
            [field_id] => 3300
            [type] => select
            [name] => C_Style
            [value] => Detached
        )

[f_131] => Array
        (
            [field_id] => 131
            [type] => feature
            [name] => Swimming Pool
            [values] => Array
                (
                    [0] => No
                )

)

[f_140] => Array
        (
            [field_id] => 140
            [type] => feature
            [name] => Pet Policy
            [values] => Array
                (
                    [0] => No
                )

)

[field_55] => Array
        (
            [field_id] => 55
            [type] => number
            [name] => Floor Number
            [value] => 0
        )

[googlemap_ln] => Array
        (
            [field_id] => 51
            [type] => text
            [name] => Longitude
            [value] => W72° 59' 9.2'' 
        )

[googlemap_lt] => Array
        (
            [field_id] => 52
            [type] => text
            [name] => Latitude
            [value] => N42° 36' 2.6'' 
        )

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => RE/MAX Andrew Realty Services
        )

[field_3000] => Array
        (
            [field_id] => 3000
            [type] => text
            [name] => Agent MLSID
            [value] => CT000306
        )

[field_3045] => Array
        (
            [field_id] => 3045
            [type] => price
            [name] => HOA_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3046] => Array
        (
            [field_id] => 3046
            [type] => feature
            [name] => ASSC_FEE_INCLUDES
            [values] => Array
                (
                    [0] => No
                )

)

[field_3056] => Array
        (
            [field_id] => 3056
            [type] => price
            [name] => ClosePrice
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3058] => Array
        (
            [field_id] => 3058
            [type] => select
            [name] => COMP_BASED_ON
            [value] => Net Sale Price
        )

[field_3069] => Array
        (
            [field_id] => 3069
            [type] => price
            [name] => LIST_PRICE_PER_SQFT
            [raw] => 357.13
            [unit_id] => 260
            [value] => $357
            [price_only] => $357
        )

[field_3071] => Array
        (
            [field_id] => 3071
            [type] => number
            [name] => MARKET_TIME_BROKER
            [value] => 125
        )

[field_3072] => Array
        (
            [field_id] => 3072
            [type] => number
            [name] => MARKET_TIME_BROKER_PREV
            [value] => 0
        )

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 16/08/2024 15:11:00
        )

[field_3094] => Array
        (
            [field_id] => 3094
            [type] => price
            [name] => SOLD_PRICE_PER_SQFT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3095] => Array
        (
            [field_id] => 3095
            [type] => number
            [name] => STREET_NUM
            [value] => 4
        )

[field_3097] => Array
        (
            [field_id] => 3097
            [type] => text
            [name] => TEAM_MEMBER
            [value] => B0527470
        )

[field_3098] => Array
        (
            [field_id] => 3098
            [type] => text
            [name] => TransactionBrokerCompensation
            [value] => 1
        )

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => Array
                (
                    [0] => No
                )

)

[field_3109] => Array
        (
            [field_id] => 3109
            [type] => number
            [name] => FIRE_PLACES
            [value] => 1
        )

[field_3112] => Array
        (
            [field_id] => 3112
            [type] => number
            [name] => HEAT_ZONES
            [value] => 3
        )

[field_3118] => Array
        (
            [field_id] => 3118
            [type] => price
            [name] => NOI
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3125] => Array
        (
            [field_id] => 3125
            [type] => feature
            [name] => ROAD_TYPE
            [values] => Array
                (
                    [0] => No
                )

)

[field_3131] => Array
        (
            [field_id] => 3131
            [type] => number
            [name] => COOLING_ZONES
            [value] => 3
        )

[field_3134] => Array
        (
            [field_id] => 3134
            [type] => select
            [name] => SQUARE_FEET_INCL_BASE
            [value] => Yes
        )

[field_3135] => Array
        (
            [field_id] => 3135
            [type] => select
            [name] => WARRANTY
            [value] => 1
        )

[field_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => Living Area is approximate at this time and is tak
        )

[field_3164] => Array
        (
            [field_id] => 3164
            [type] => boolean
            [name] => AvailableNow
            [value] => No
        )

[f_3166] => Array
        (
            [field_id] => 3166
            [type] => feature
            [name] => RENT_FEE_INCLUDES
            [values] => Array
                (
                    [0] => No
                )

)

[field_3168] => Array
        (
            [field_id] => 3168
            [type] => price
            [name] => SEC_DEPOSIT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3171] => Array
        (
            [field_id] => 3171
            [type] => text
            [name] => Office Phone
            [value] => 781-395-7676
        )

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 617-312-7156
        )

[field_3178] => Array
        (
            [field_id] => 3178
            [type] => boolean
            [name] => AdditionalParcelsYN
            [value] => No
        )

[field_3181] => Array
        (
            [field_id] => 3181
            [type] => select
            [name] => AttachedGarageYN
            [value] => 1
        )

[field_3182] => Array
        (
            [field_id] => 3182
            [type] => select
            [name] => BuildingAreaSource
            [value] => Other
        )

[field_3183] => Array
        (
            [field_id] => 3183
            [type] => number
            [name] => BuildingAreaTotal
            [value] => 6300
        )

[field_3184] => Array
        (
            [field_id] => 3184
            [type] => select
            [name] => BuildingAreaUnits
            [value] => Square Feet
        )

[field_3185] => Array
        (
            [field_id] => 3185
            [type] => text
            [name] => BuyerAgencyCompensation
            [value] => 2
        )

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Conservation Area
                    [1] => Highway Access
                    [2] => House Of Worship
                    [3] => Public School
                    [4] => Golf
                    [5] => Private School
                )

)

[field_3189] => Array
        (
            [field_id] => 3189
            [type] => price
            [name] => ConcessionsAmount
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3190] => Array
        (
            [field_id] => 3190
            [type] => feature
            [name] => ConstructionMaterials
            [values] => Array
                (
                    [0] => Frame
                )

)

[field_3191] => Array
        (
            [field_id] => 3191
            [type] => select
            [name] => CoolingYN
            [value] => 1
        )

[field_3192] => Array
        (
            [field_id] => 3192
            [type] => number
            [name] => ParkingTotal
            [value] => 7
        )

[field_3193] => Array
        (
            [field_id] => 3193
            [type] => number
            [name] => CoveredSpaces
            [value] => 3
        )

[f_3195] => Array
        (
            [field_id] => 3195
            [type] => feature
            [name] => CurrentFinancing
            [values] => Array
                (
                    [0] => No
                )

)

[f_3196] => Array
        (
            [field_id] => 3196
            [type] => feature
            [name] => DocumentsAvailable
            [values] => Array
                (
                    [0] => No
                )

)

[f_3198] => Array
        (
            [field_id] => 3198
            [type] => feature
            [name] => DoorFeatures
            [values] => Array
                (
                    [0] => No
                )

)

[field_3200] => Array
        (
            [field_id] => 3200
            [type] => price
            [name] => ElectricExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3205] => Array
        (
            [field_id] => 3205
            [type] => date
            [name] => ExpirationDate
            [value] => 01/01/1900
        )

[field_3206] => Array
        (
            [field_id] => 3206
            [type] => select
            [name] => FarmLandAreaUnits
            [value] => Square Feet
        )

[f_3207] => Array
        (
            [field_id] => 3207
            [type] => feature
            [name] => FinancialDataSource
            [values] => Array
                (
                    [0] => No
                )

)

[field_3208] => Array
        (
            [field_id] => 3208
            [type] => select
            [name] => FireplaceYN
            [value] => 1
        )

[field_3209] => Array
        (
            [field_id] => 3209
            [type] => text
            [name] => FoundationDetails
            [value] => Concrete Perimeter
        )

[field_3211] => Array
        (
            [field_id] => 3211
            [type] => number
            [name] => GarageSpaces
            [value] => 3
        )

[field_3212] => Array
        (
            [field_id] => 3212
            [type] => select
            [name] => GarageYN
            [value] => 1
        )

[field_3216] => Array
        (
            [field_id] => 3216
            [type] => price
            [name] => GrossIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3217] => Array
        (
            [field_id] => 3217
            [type] => select
            [name] => HeatingYN
            [value] => 1
        )

[field_3220] => Array
        (
            [field_id] => 3220
            [type] => price
            [name] => InsuranceExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3222] => Array
        (
            [field_id] => 3222
            [type] => text
            [name] => ListingAgreement
            [value] => Exclusive Right To Sell
        )

[field_3223] => Array
        (
            [field_id] => 3223
            [type] => date
            [name] => ListingContractDate
            [value] => 13/04/2024
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Gentle Sloping
                    [1] => Wooded
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 70,426 Sqft
            [raw] => 70426
            [unit_id] => 1
        )

[field_3230] => Array
        (
            [field_id] => 3230
            [type] => price
            [name] => OperatingExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3231] => Array
        (
            [field_id] => 3231
            [type] => price
            [name] => OriginalListPrice
            [raw] => 2249900
            [unit_id] => 260
            [value] => $2,249,900
            [price_only] => $2,249,900
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Please submit offers in one PDF to chuck.andre@rem
        )

[f_3238] => Array
        (
            [field_id] => 3238
            [type] => feature
            [name] => SpecialListingConditions
            [values] => Array
                (
                    [0] => No
                )

)

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 4 Beech Brook Farm Rd, Middleton MA 01949
        )

[field_3241] => Array
        (
            [field_id] => 3241
            [type] => price
            [name] => WaterSewerExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3243] => Array
        (
            [field_id] => 3243
            [type] => text
            [name] => YearBuiltDetails
            [value] => Under Construction
        )

[field_3245] => Array
        (
            [field_id] => 3245
            [type] => text
            [name] => YearBuiltSource
            [value] => Builder
        )

[f_3247] => Array
        (
            [field_id] => 3247
            [type] => feature
            [name] => BusinessType
            [values] => Array
                (
                    [0] => No
                )

)

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 13/04/2024 18:31:00
        )

[field_3260] => Array
        (
            [field_id] => 3260
            [type] => text
            [name] => MLSPIN_DISCLOSURE
            [value] => N
        )

[field_3265] => Array
        (
            [field_id] => 3265
            [type] => price
            [name] => MLSPIN_GRE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3266] => Array
        (
            [field_id] => 3266
            [type] => price
            [name] => MLSPIN_HTE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3272] => Array
        (
            [field_id] => 3272
            [type] => text
            [name] => MLSPIN_LEAD_PAINT
            [value] => None
        )

[field_3277] => Array
        (
            [field_id] => 3277
            [type] => text
            [name] => MLSPIN_MAIN_LO
            [value] => AC2354
        )

[field_3280] => Array
        (
            [field_id] => 3280
            [type] => number
            [name] => MLSPIN_MARKET_TIME_PROPERTY
            [value] => 125
        )

[field_3281] => Array
        (
            [field_id] => 3281
            [type] => price
            [name] => MLSPIN_MGF
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3282] => Array
        (
            [field_id] => 3282
            [type] => price
            [name] => MLSPIN_MSE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3285] => Array
        (
            [field_id] => 3285
            [type] => price
            [name] => MLSPIN_OPTIONAL_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3290] => Array
        (
            [field_id] => 3290
            [type] => price
            [name] => MLSPIN_PRICE_PER_SQFT
            [raw] => 357.13
            [unit_id] => 260
            [value] => $357
            [price_only] => $357
        )

[field_3292] => Array
        (
            [field_id] => 3292
            [type] => price
            [name] => MLSPIN_RFS
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3293] => Array
        (
            [field_id] => 3293
            [type] => price
            [name] => MLSPIN_RME
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3296] => Array
        (
            [field_id] => 3296
            [type] => select
            [name] => OpenParkingYN
            [value] => 1
        )

[field_3301] => Array
        (
            [field_id] => 3301
            [type] => select
            [name] => RoomMasterBathroomFeatures
            [value] => Yes
        )

[field_3303] => Array
        (
            [field_id] => 3303
            [type] => text
            [name] => Co Agent Info
            [value] => [{"id":"B0527470","name":"John Veneziano","phone":
        )

[f_3304] => Array
        (
            [field_id] => 3304
            [type] => feature
            [name] => AssociationAmenities
            [values] => Array
                (
                    [0] => No
                )

)

[f_3305] => Array
        (
            [field_id] => 3305
            [type] => feature
            [name] => TenantPays
            [values] => Array
                (
                    [0] => No
                )

)

[field_3306] => Array
        (
            [field_id] => 3306
            [type] => price
            [name] => GrossScheduledIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

)

EXIT

9 More Photos

Active

4 Beech Brook Farm Rd Middleton. MA 01949

$2,249,900

General Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Interior Features for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Exterior Features for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Disclosures for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Financial Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Lifestyle Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Location information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Marketing History for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Agent Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Payment Calculator

Exclusive Listing Agent

Chuck Andre

RE/MAX Andrew Realty Services

EXIT

9 More Photos

Active

4 Beech Brook Farm Rd Middleton. MA 01949

$2,249,900

General Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Interior Features for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Exterior Features for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Disclosures for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Financial Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Lifestyle Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Location information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Marketing History for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Agent Information for 4 Beech Brook Farm Rd, Middleton, Massachusetts 01949

Payment Calculator

Exclusive Listing Agent

Chuck Andre

RE/MAX Andrew Realty Services

Neighborhood

Properties for sale in Ipswich