Ipswich Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Pending

196-200 B1 North Main St. Middleton. MA 01949

$400,000

Land

0 Bedrooms

0 Bathrooms

0 sq ft

Parking Spots

6.67 Acres

Built in 0

Raw Land in a Lovely setting. Approved Building Plans on File with Town for a Duplex. Set back from street with views of Emerson Brook Reservoir and Harold Parker. Convenient to shopping and major Routes. Lot B1 - 6,67 Acres also available adjacent lots

This listing has been viewed 10 times in the past 212 days

Last Updated: June 1st, 2024 at 7:47am

Conservation Area

Highway Access

House Of Worship

Public School

Shopping

Golf

Park

General Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Property TypeLand

Property Sub TypeLand

Price$400,000

MLS #73161163

Handicap Access / FeaturesNo

List Date2023-09-19

Special Listing Conditions

StateMassachusetts

Street NameNorth Main St.

CityMiddleton

Zip Code01949

CountyEssex

MLS StatusUnder Agreement

AssociationNo

Heat Zones

Sold Date17/05/2025

Property Sub TypeLand

AdditionalParcelsYNNo

AvailabilityDate

Close Date

Close Price$0

Gas

Listing Service

UnparsedAddress196-200 B1 North Main St., Middleton MA 01949

ZoningR1B

Interior Features for 196-200 B1 North Main St., Middleton, Massachusetts 01949

ElectricOther (see Remarks)

ElectricYes

Electric$0

Electric on PropertyNo

MLS Area (Major)

OffMarketDate29/05/2024

Exterior Features for 196-200 B1 North Main St., Middleton, Massachusetts 01949

* Approximate Lot Size6.67 acres

Lot FeaturesOther

* Parking Spaces

* Sewer UtilitiesOther

* Water UtilitiesOn-site

Approx. Street Frontage

Parking Features

Utilities

Cultivated Area

FarmLandAreaUnits

Lot Size (Square Feet)290,356 Sqft

MLSPIN_PERC_TEST

MLSPIN_PERC_TEST_DATE

PastureArea

Wooded Area

Disclosures for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Buyer Agent Compensation2

ContingencyThird-Party Approval

Financing

Disclosures

Documents Available

MLSPIN_COMP_BASED_ONNet Sale Price

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintUnknown

Facilitator Compensation1

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Association Fee$0

Association Fee Frequency

Associaton Fee Includes

AssociationNo

Assessed Value$617,900

Real Estate Tax$7,952

Tax Year2023

OriginalListPrice$500,000

Lifestyle Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Association Amenities

Frontage Type

GarageYNNo

WaterviewPond

Waterfront FeaturesPond, Waterfront

Location information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Elementary School

High School

NumberOfLots

Marketing History for 196-200 B1 North Main St., Middleton, Massachusetts 01949

MLSPIN_MARKET_TIME_BROKER249

MLSPIN_MARKET_TIME_PROPERTY467

PurchaseContractDate2024-05-22

Agent Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Agent MLS IDB8000399

Office MLS IDAN2612

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $7,952

Principal & Interest 2464.67

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

John E. Magazzu

RE/MAX Renaissance Inc.

Agent Phone

(978) 815-6098

Office Phone

(978) 664-3000

Text Agent Call Agent Call Office

Array
(
    [id] => 303260
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73161163
    [mls_id_num] => 73161163
    [parent] => 0
    [pic_numb] => 35
    [user_id] => 1
    [listing] => 9
    [property_type] => 20
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 12
    [location4_id] => 184
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Essex
    [location4_name] => Middleton
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 400000
    [price_unit] => 260
    [price_si] => 400000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 0
    [bedrooms_max] => 0
    [rooms] => 0
    [rooms_max] => 0
    [bathrooms] => 0
    [bathrooms_max] => 0
    [living_area] => 0
    [living_area_unit] => 1
    [living_area_si] => 0
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 6.67
    [lot_area_unit] => 1
    [lot_area_si] => 0.62031
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.61007900
    [googlemap_ln] => -71.03681600
    [geopoints] => �������
�~1[�Q��|�NE@
    [finalized] => 1
    [add_date] => 2024-04-27 08:12:18
    [last_finalize_date] => 2024-06-01 07:48:04
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 0
    [zip_id] => 315
    [zip_name] => 01949
    [last_modified_time_stamp] => 2024-07-13 21:18:49
    [post_code] => 
    [meta_description] => Land For Sale North Main St. In 196-200 B1 North Main St., Middleton, Massachusetts 01949
    [meta_description_manual] => 0
    [meta_keywords] => 196-200 B1 North Main St., Middleton, Massachusetts 01949, ,Land,For Sale,North Main St.,73161163
    [meta_keywords_manual] => 0
    [street_no] => 196-200 B1
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Raw Land in a Lovely setting.  Approved Building Plans on File with Town for a Duplex. Set back from street with views of Emerson Brook Reservoir and Harold Parker. Convenient to shopping and major Routes. Lot B1 – 6,67 Acres also available adjacent lots\n Property Type Land Listing Type For Sale Listing ID 73161163 Ref ID 1b60e380ce3acfdfc072848711364ca4 Price $400,000 Square Footage 0 Sqft Lot Area 6.67 Sqft MLSStatus Under Agreement Status Pending Property Category Land C_SType_Temp Land C_Style Residential LOC-Country LOC-United LOC-States LOC-US LOC-USA LOC-State LOC-Massachusetts LOC-MA LOC-County LOC-Essex LOC-City LOC-Middleton LOC-Zipcode LOC-01949 LOC-States, LOC-Massachusetts, LOC-Essex, LOC-Middleton, LOC-North LOC-Main LOC-St. LOC-196-200 LOC-B1 LOC-St., LOC-Avenue LOC-Ave LOC-Boulevard LOC-Blvd LOC-Highway LOC-Hwy LOC-Lane LOC-Ln LOC-Square LOC-Sq LOC-Street LOC-St LOC-Road LOC-Rd LOC-Drive LOC-Dr LOC-Place LOC-Pl LOC-Plaza LOC-Crescent LOC-Cresc LOC-Court LOC-Cou LOC-Path. Pa LOC-Gate LOC-Gt LOC-Terrace LOC-Ter Zipcode 01949 Street North Main St. Street Number 196-200 B1 Office Name RE/MAX Renaissance Inc. Agent Name John E. Magazzu Agent MLSID B8000399 Office MLSID AN2612 Office Phone 978-664-3000 Agent Phone 978-815-6098 UnparsedAddress 196-200 B1 North Main St., Middleton MA 01949  196-200 b1 north main st. middleton massachusetts 01949 
    [location_text] => 196-200 B1 North Main St., Middleton, Massachusetts 01949
    [field_42] => North Main St.
    [field_312] => Land For Sale - - - - Price $400,000 - 73161163
    [field_313] => Land For Sale
    [field_308] => Raw Land in a Lovely setting.  Approved Building Plans on File with Town for a Duplex. Set back from street with views of Emerson Brook Reservoir and Harold Parker. Convenient to shopping and major Routes. Lot B1 - 6,67 Acres also available adjacent lots
    [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] => 
    [f_130] => 0
    [f_131_options] => 
    [f_131] => 0
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => 
    [f_134] => 0
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => 
    [f_137] => 0
    [f_138_options] => 
    [f_138] => 
    [f_139_options] => 
    [f_139] => 
    [f_140_options] => 
    [f_140] => 0
    [f_141_options] => 
    [f_141] => 
    [f_144_options] => 
    [f_144] => 0
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => 
    [f_147] => 0
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => 
    [f_150] => 0
    [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] => 1b60e380ce3acfdfc072848711364ca4
    [field_54] => 
    [half_bathrooms] => 0
    [half_bathrooms_max] => 0
    [field_55] => 0
    [rendered] => {"rendered":{"313":{"field_id":"313","type":"text","name":"Property Title","value":"Land For Sale"},"312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Land For Sale - - - - Price $400,000 - 73161163"},"3":{"field_id":"3","type":"property_types","name":"Property Type","value":"Land"},"2":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"5":{"field_id":"5","type":"text","name":"Listing ID","value":"73161163"},"6":{"field_id":"6","type":"price","name":"Price","raw":"400000","unit_id":"260","value":"$400,000","price_only":"$400,000"},"8":{"field_id":"8","type":"number","name":"Bedrooms","value":"0"},"13":{"field_id":"13","type":"number","name":"Rooms","value":"0"},"9":{"field_id":"9","type":"number","name":"Bathrooms","value":"0"},"17":{"field_id":"17","type":"number","name":"Half Bathrooms","value":"0"},"10":{"field_id":"10","type":"area","name":"Square Footage","value":"0 Sqft","raw":"0","unit_id":"1"},"11":{"field_id":"11","type":"area","name":"Lot Area","value":"6.67 Sqft","raw":"6.67","unit_id":"1"},"41":{"field_id":"41","type":"locations","name":"Location","location_ids":{"1":"254","2":"6026","3":"12","4":"184","zips":"315"},"locations":{"1":"US","2":"MA","3":"Essex","4":"Middleton","zips":"01949"},"raw":{"1":"United States","2":"Massachusetts","3":"Essex","4":"Middleton","zips":"01949"},"keywords":{"1":"Country","2":"State","3":"County","4":"City","zips":"Zipcode"},"value":"United States, Massachusetts, Essex, Middleton, 01949","settings":{"1":{"enabled":"1"},"2":{"enabled":"1"},"3":{"enabled":"1"},"4":{"enabled":"1"},"5":{"enabled":"1"},"zips":{"enabled":"1"}}},"42":{"field_id":"42","type":"text","name":"Street","value":"North Main St."},"45":{"field_id":"45","type":"text","name":"Street Number","value":"196-200 B1"},"55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"materials":{"field_313":{"field_id":"313","type":"text","name":"Property Title","value":"Land For Sale"},"field_312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Land For Sale - - - - Price $400,000 - 73161163"},"property_type":{"field_id":"3","type":"property_types","name":"Property Type","value":"Land"},"listing":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"mls_id":{"field_id":"5","type":"text","name":"Listing ID","value":"73161163"},"price":{"field_id":"6","type":"price","name":"Price","raw":"400000","unit_id":"260","value":"$400,000","price_only":"$400,000"},"bedrooms":{"field_id":"8","type":"number","name":"Bedrooms","value":"0"},"rooms":{"field_id":"13","type":"number","name":"Rooms","value":"0"},"bathrooms":{"field_id":"9","type":"number","name":"Bathrooms","value":"0"},"half_bathrooms":{"field_id":"17","type":"number","name":"Half Bathrooms","value":"0"},"living_area":{"field_id":"10","type":"area","name":"Square Footage","value":"0 Sqft","raw":"0","unit_id":"1"},"lot_area":{"field_id":"11","type":"area","name":"Lot Area","value":"6.67 Sqft","raw":"6.67","unit_id":"1"},"locations":{"field_id":"41","type":"locations","name":"Location","location_ids":{"1":"254","2":"6026","3":"12","4":"184","zips":"315"},"locations":{"1":"US","2":"MA","3":"Essex","4":"Middleton","zips":"01949"},"raw":{"1":"United States","2":"Massachusetts","3":"Essex","4":"Middleton","zips":"01949"},"keywords":{"1":"Country","2":"State","3":"County","4":"City","zips":"Zipcode"},"value":"United States, Massachusetts, Essex, Middleton, 01949","settings":{"1":{"enabled":"1"},"2":{"enabled":"1"},"3":{"enabled":"1"},"4":{"enabled":"1"},"5":{"enabled":"1"},"zips":{"enabled":"1"}}},"field_42":{"field_id":"42","type":"text","name":"Street","value":"North Main St."},"street_no":{"field_id":"45","type":"text","name":"Street Number","value":"196-200 B1"},"field_55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"location_text":"196-200 B1 North Main St., Middleton, Massachusetts 01949"}
    [alias] => Land-196-200-B1-North-Main-St-Middleton-Massachusetts-01949-73161163-USD400-000
    [source] => mls
    [last_sync_date] => 2024-06-01 07:47:52
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => RE/MAX Renaissance Inc.
    [field_2112] => John E. Magazzu
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => B8000399
    [field_3001] => AN2612
    [listing_status] => 13
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 249
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-05-31 18:19:00
    [f_3102_options] => ,29,2,
    [f_3102] => 1
    [field_3103] => 2
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 196-200 B1 North Main St.
    [field_3171] => 978-664-3000
    [field_3172] => 978-815-6098
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 4
    [field_3176] => 
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 
    [field_3191] => 
    [field_3192] => 
    [field_3212] => 
    [field_3217] => 
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 0
    [f_3238_options] => 
    [f_3238] => 0
    [field_3240] => 196-200 B1 North Main St., Middleton MA 01949
    [f_3247_options] => 
    [f_3247] => 0
    [field_3296] => 
    [field_3298] => 4
    [field_3299] => 3
    [field_3300] => 20
    [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] => 37
    [visit_time] => 9
    [visit_date] => 2024-11-24 20:35:50
    [vids_numb] => 0
    [f_3002_options] => ,7,
    [f_3002] => 1
    [f_3003_options] => 
    [f_3003] => 0
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => 
    [f_3006] => 0
    [f_3007_options] => ,7,
    [f_3007] => 1
    [f_3008_options] => 
    [f_3008] => 0
    [f_3009_options] => 
    [f_3009] => 0
    [f_3010_options] => 
    [f_3010] => 0
    [field_3011] => 617900
    [field_3011_si] => 617900
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 35
    [field_3019] => 2023-09-20 20:52:37
    [field_3020] => 13
    [field_3021] => Call List Agent,Accompanied Showings,Appointment R
    [field_3022] => 
    [field_3023] => 7952
    [field_3023_si] => 7952
    [field_3023_unit] => 260
    [field_3024] => 2023
    [f_3025_options] => 
    [f_3025] => 0
    [field_3027] => 
    [field_3028] => 26
    [field_3029] => 0
    [field_3032] => R1B
    [field_3039] => Route 114 Across from Middleton Electric Co.
    [field_3043] => 2025-05-17
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => 
    [f_3046] => 0
    [field_3058] => 1
    [field_3060] => Third-Party Approval
    [field_3069] => 0
    [field_3069_si] => 0
    [field_3069_unit] => 260
    [field_3079] => 2024-05-29 21:10:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 196
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 1
    [field_3105] => 
    [field_3109] => 
    [field_3112] => 
    [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] => ,0,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 
    [field_3134] => 
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => 
    [f_3166_options] => 
    [f_3166] => 0
    [field_3168] => 0
    [field_3168_si] => 0
    [field_3168_unit] => 260
    [field_3178] => 0
    [field_3179] => 
    [field_3182] => 
    [field_3183] => 
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,5,7,6,1,2,3,4,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => 
    [f_3190] => 0
    [field_3193] => 
    [field_3194] => 
    [f_3195_options] => 
    [f_3195] => 0
    [f_3196_options] => 
    [f_3196] => 0
    [field_3197] => 
    [f_3198_options] => 
    [f_3198] => 0
    [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] => 
    [f_3207] => 0
    [field_3208] => 
    [field_3209] => 
    [field_3210] => 
    [field_3211] => 
    [field_3213] => 3
    [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] => 2023-09-19
    [field_3224] => 
    [f_3225_options] => ,5,
    [f_3225] => 1
    [field_3226_si] => 27003.108
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 2024-05-29
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 500000
    [field_3231_si] => 500000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => 
    [field_3237] => 2024-05-22
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => 
    [field_3244] => 
    [field_3245] => 
    [field_3246] => 
    [field_3248] => 2023-09-20 01:12: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] => 
    [field_3273] => 
    [field_3274] => 
    [field_3275] => 
    [field_3276] => 
    [field_3277] => AN2612
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 467
    [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] => 0
    [field_3290_si] => 0
    [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] => 1
    [field_3297] => 
    [field_3303] => 
    [f_3304_options] => 
    [f_3304] => 0
    [f_3305_options] => 
    [f_3305] => 0
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 290356
)

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

[field_3236] => Array
        (
            [field_id] => 3236
            [type] => select
            [name] => PropertySubType
            [value] => Residential
        )

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

[mls_id] => Array
        (
            [field_id] => 5
            [type] => text
            [name] => Listing ID
            [value] => 73161163
        )

[price] => Array
        (
            [field_id] => 6
            [type] => price
            [name] => Price
            [raw] => 400000
            [unit_id] => 260
            [value] => $400,000
            [price_only] => $400,000
        )

[bedrooms] => Array
        (
            [field_id] => 8
            [type] => number
            [name] => Bedrooms
            [value] => 0
        )

[rooms] => Array
        (
            [field_id] => 13
            [type] => number
            [name] => Rooms
            [value] => 0
        )

[bathrooms] => Array
        (
            [field_id] => 9
            [type] => number
            [name] => Bathrooms
            [value] => 0
        )

[half_bathrooms] => Array
        (
            [field_id] => 17
            [type] => number
            [name] => Half Bathrooms
            [value] => 0
        )

[living_area] => Array
        (
            [field_id] => 10
            [type] => area
            [name] => Square Footage
            [value] => 0 Sqft
            [raw] => 0
            [unit_id] => 1
        )

[build_year] => Array
        (
            [field_id] => 12
            [type] => number
            [name] => Year Built
            [value] => 0
        )

[lot_area] => Array
        (
            [field_id] => 11
            [type] => area
            [name] => Lot Area
            [value] => 6.67 Sqft
            [raw] => 6.67
            [unit_id] => 1
        )

[listing_status] => Array
        (
            [field_id] => 23
            [type] => select
            [name] => MLSStatus
            [value] => Under Agreement
        )

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

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

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

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

[locations] => Array
        (
            [field_id] => 41
            [type] => locations
            [name] => Location
            [location_ids] => Array
                (
                    [1] => 254
                    [2] => 6026
                    [3] => 12
                    [4] => 184
                    [zips] => 315
                )

[locations] => Array
                (
                    [1] => US
                    [2] => MA
                    [3] => Essex
                    [4] => Middleton
                    [zips] => 01949
                )

[raw] => Array
                (
                    [1] => United States
                    [2] => Massachusetts
                    [3] => Essex
                    [4] => Middleton
                    [zips] => 01949
                )

[keywords] => Array
                (
                    [1] => Country
                    [2] => State
                    [3] => County
                    [4] => City
                    [zips] => Zipcode
                )

[value] => United States, Massachusetts, Essex, Middleton, 01949
            [settings] => Array
                (
                    [1] => Array
                        (
                            [enabled] => 1
                        )

[2] => Array
                        (
                            [enabled] => 1
                        )

[3] => Array
                        (
                            [enabled] => 1
                        )

[4] => Array
                        (
                            [enabled] => 1
                        )

[5] => Array
                        (
                            [enabled] => 1
                        )

[zips] => Array
                        (
                            [enabled] => 1
                        )

)

[field_42] => Array
        (
            [field_id] => 42
            [type] => text
            [name] => Street
            [value] => North Main St.
        )

[street_no] => Array
        (
            [field_id] => 45
            [type] => text
            [name] => Street Number
            [value] => 196-200 B1
        )

[f_3007] => Array
        (
            [field_id] => 3007
            [type] => feature
            [name] => ELECTRIC_FEATURE
            [values] => Array
                (
                    [0] => Other (see Remarks)
                )

)

[field_3011] => Array
        (
            [field_id] => 3011
            [type] => price
            [name] => ASSESSMENTS
            [raw] => 617900
            [unit_id] => 260
            [value] => $617,900
            [price_only] => $617,900
        )

[field_3020] => Array
        (
            [field_id] => 3020
            [type] => select
            [name] => SEWER
            [value] => Other
        )

[field_3023] => Array
        (
            [field_id] => 3023
            [type] => price
            [name] => TAXES
            [raw] => 7952
            [unit_id] => 260
            [value] => $7,952
            [price_only] => $7,952
        )

[field_3024] => Array
        (
            [field_id] => 3024
            [type] => number
            [name] => TAX_YEAR
            [value] => 2023
        )

[field_3028] => Array
        (
            [field_id] => 3028
            [type] => select
            [name] => WATER
            [value] => On-site
        )

[field_3029] => Array
        (
            [field_id] => 3029
            [type] => boolean
            [name] => DISCLOSURE
            [value] => No
        )

[field_3032] => Array
        (
            [field_id] => 3032
            [type] => text
            [name] => ZONING
            [value] => R1B
        )

[field_3039] => Array
        (
            [field_id] => 3039
            [type] => textarea
            [name] => DIRECTION
            [value] => Route 114 Across from Middleton Electric Co.
        )

[field_3021] => Array
        (
            [field_id] => 3021
            [type] => text
            [name] => SHOW_INSTRUCTION
            [value] => Call List Agent,Accompanied Showings,Appointment R
        )

[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° 57' 47.5'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => RE/MAX Renaissance Inc.
        )

[field_2112] => Array
        (
            [field_id] => 2112
            [type] => text
            [name] => Agent Name
            [value] => John E. Magazzu
        )

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

[field_3001] => Array
        (
            [field_id] => 3001
            [type] => text
            [name] => Office MLSID
            [value] => AN2612
        )

[f_3002] => Array
        (
            [field_id] => 3002
            [type] => feature
            [name] => WATERVIEW_FEATURES
            [values] => Array
                (
                    [0] => Pond
                )

)

[field_3043] => Array
        (
            [field_id] => 3043
            [type] => date
            [name] => ANT_SOLD_DATE
            [value] => 17/05/2025
        )

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

[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_3060] => Array
        (
            [field_id] => 3060
            [type] => text
            [name] => CONTINGENCY_TYPE
            [value] => Third-Party Approval
        )

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

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

[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] => 31/05/2024 18:19: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] => 196
        )

[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] => Pond
                    [1] => Waterfront
                )

)

[field_3103] => Array
        (
            [field_id] => 3103
            [type] => select
            [name] => WATERFRONT_FLAG
            [value] => 1
        )

[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] => Public
                )

)

[field_3164] => Array
        (
            [field_id] => 3164
            [type] => boolean
            [name] => AvailableNow
            [value] => 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] => 978-664-3000
        )

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 978-815-6098
        )

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

[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] => Shopping
                    [5] => Golf
                    [6] => Park
                )

)

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

[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
        )

[field_3213] => Array
        (
            [field_id] => 3213
            [type] => select
            [name] => Gas
            [value] => None
        )

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

[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] => 19/09/2023
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Other
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 290,356 Sqft
            [raw] => 290356
            [unit_id] => 1
        )

[field_3229] => Array
        (
            [field_id] => 3229
            [type] => date
            [name] => OffMarketDate
            [value] => 29/05/2024
        )

[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] => 500000
            [unit_id] => 260
            [value] => $500,000
            [price_only] => $500,000
        )

[field_3237] => Array
        (
            [field_id] => 3237
            [type] => date
            [name] => PurchaseContractDate
            [value] => 22/05/2024
        )

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 196-200 B1 North Main St., Middleton MA 01949
        )

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

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 20/09/2023 01:12: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_3277] => Array
        (
            [field_id] => 3277
            [type] => text
            [name] => MLSPIN_MAIN_LO
            [value] => AN2612
        )

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

[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] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[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_3295] => Array
        (
            [field_id] => 3295
            [type] => select
            [name] => MLSPIN_WATERVIEW_FLAG
            [value] => Yes
        )

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

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

)

EXIT

33 More Photos

Pending

196-200 B1 North Main St. Middleton. MA 01949

$400,000

General Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Interior Features for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Exterior Features for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Disclosures for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Financial Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Lifestyle Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Location information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Marketing History for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Agent Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Payment Calculator

Exclusive Listing Agent

John E. Magazzu

RE/MAX Renaissance Inc.

EXIT

33 More Photos

Pending

196-200 B1 North Main St. Middleton. MA 01949

$400,000

General Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Interior Features for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Exterior Features for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Disclosures for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Financial Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Lifestyle Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Location information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Marketing History for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Agent Information for 196-200 B1 North Main St., Middleton, Massachusetts 01949

Payment Calculator

Exclusive Listing Agent

John E. Magazzu

RE/MAX Renaissance Inc.

Neighborhood

Properties for sale in Ipswich