Ipswich Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

151 River Street Middleton. MA 01949

$1,200,000

Single Family

4 Bedrooms

2 Bathrooms

3,052 sq ft

12 Parking Spots

1.92 Acres

Built in 1967

PERC TEST COMPELTED and APPROVED TO BUILD ANOTHER HOME ON LOT if Buyer chooses to SUBDIVIDE. Buyers to do their own due diligence to verify all information. Beautiful setting, well maintained custom built raised ranch sets on 1.92 acres. Legal two family home but could be converted back to a single family home if subdiving the lot. Large sunroom/great room with hardwood floors, skylights and french doors lead into kitchen and dining area with hardwood floors and granite counter tops and attached screened porch. Fireplaced LR w/hardwood floors. Three bedrooms and full bath on main level. Second floor (4th bedroom) currently used as a legal one bedroom apt, full bath w/laundry hookups, open kitchen/living area and balcony off bedroom. Partially finished heated basement with laundry hookups. New furnace 2023. Three car detached garage, tons of storage on second level. An additional two story tool shed/horse barn. Sprinkler lawn system.

This listing has been viewed 7 times in the past 52 days

Last Updated: November 25th, 2024 at 7:23am

Walk/jog Trails

Highway Access

House Of Worship

Public School

Shopping

Golf

Medical Facility

Bike Path

Public Transportation

General Information for 151 River Street, Middleton, Massachusetts 01949

Property TypeResidential

Property Sub TypeResidential

Price$1,200,000

Price per sqft$393.18

MLS #73286264

Handicap Access / FeaturesNo

List Date2024-09-05

List Price$1,200,000

Special Listing Conditions

Specific Zoning CodeRes

StateMassachusetts

Street NameRiver Street

Style

TownMiddleton

CityMiddleton

Zip Code01949

CountyEssex

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces3

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones4

Attached/DetachedNo

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 Total3052

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces3

Listing Service

UnparsedAddress151 River Street, Middleton MA 01949

Zoning

Interior Features for 151 River Street, Middleton, Massachusetts 01949

Master BathNo

* Approx. Living Area Total3,052 sq ft

Living Area Includes BasementYes

* Living Area Source0

Bedrooms4

* # Fireplaces1

Bathrooms (Total)2

Full Baths2

* # Half Baths0

* # Rooms

Basement

* CoolingNo

Heating System

Appliances

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosure2552 living area above grade, plus approximately 5

Living Area Includes BasementYes

Door FeaturesFrench Doors

ElectricNo

Electric$0

MLS Area (Major)

OffMarketDate

Exterior Features for 151 River Street, Middleton, Massachusetts 01949

* Approximate Lot Size1.92 acres

Covered Parking Spaces3

Lot FeaturesWooded

* Parking Spaces12

* Sewer Utilities

* Water Utilities

* Year Built1967

Year Built Details

Year Built SourcePublic Records

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)83,635 Sqft

Disclosures for 151 River Street, Middleton, Massachusetts 01949

Buyer Agent Compensation0

Contingency

Financing

Disclosures

Documents Available

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ONCompensation Offered But Not In Mls

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintUnknown

Living Area Disclosure2552 living area above grade, plus approximately 5

Living Area Includes BasementYes

Senior Community

Short Sale / Foreclosure (bank owned)

Facilitator Compensation0

TransactionBrokerCompensationType%

BuyerAgencyCompensationType%

Financial Information for 151 River Street, Middleton, Massachusetts 01949

Association Fee$0

Association Fee Frequency

Associaton Fee Includes

AssociationNo

Assessed Value

Real Estate Tax$0

Tax Year

MLSPIN_SOLD_PRICE_PER_SQFT$0

OriginalListPrice$1,475,000

Lifestyle Information for 151 River Street, Middleton, Massachusetts 01949

Association Amenities

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool Features

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features

Location information for 151 River Street, Middleton, Massachusetts 01949

Elementary SchoolHowe-Manning

Middle SchoolMasconomet

High SchoolMasconomet

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)Ipswich

Marketing History for 151 River Street, Middleton, Massachusetts 01949

MLSPIN_MARKET_TIME_BROKER80

MLSPIN_MARKET_TIME_PROPERTY80

PurchaseContractDate

Agent Information for 151 River Street, Middleton, Massachusetts 01949

Agent NamePatti Anne Madden

Agent MLS IDB7000015

Agent Phone #978-314-5566

Agent Phone Area

Office NameDoyle Real Estate

Office Phone978-777-8700

Office Phone Area

Office MLS IDNB9081

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 7394.02

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Patti Anne Madden

Doyle Real Estate

Agent Phone

(978) 314-5566

Office Phone

(978) 777-8700

Text Agent Call Agent Call Office

Array
(
    [id] => 539464
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73286264
    [mls_id_num] => 73286264
    [parent] => 0
    [pic_numb] => 41
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [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] => 1200000
    [price_unit] => 260
    [price_si] => 1200000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 4
    [bedrooms_max] => 0
    [rooms] => 10
    [rooms_max] => 0
    [bathrooms] => 2
    [bathrooms_max] => 0
    [living_area] => 3052
    [living_area_unit] => 1
    [living_area_si] => 283.836
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 1.92
    [lot_area_unit] => 1
    [lot_area_si] => 0.17856
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.57150500
    [googlemap_ln] => -71.02737000
    [geopoints] => ��������n��Q�@j'IE@
    [finalized] => 1
    [add_date] => 2024-10-08 14:28:11
    [last_finalize_date] => 2024-11-25 07:23:20
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1967
    [zip_id] => 315
    [zip_name] => 01949
    [last_modified_time_stamp] => 2024-11-26 12:21:48
    [post_code] => 
    [meta_description] => 4 Bedrooms Bedrooms 10 Rooms Rooms With 2 Bathrooms Bathrooms Residential For Sale River Street In 151 River Street, Middleton, Massachusetts 01949
    [meta_description_manual] => 0
    [meta_keywords] => 151 River Street, Middleton, Massachusetts 01949, 4 Bedrooms Bedrooms, 10 Rooms Rooms,2 BathroomsBathrooms,Residential,For Sale,River Street,73286264
    [meta_keywords_manual] => 0
    [street_no] => 151
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description PERC TEST COMPELTED and APPROVED TO BUILD ANOTHER HOME ON LOT if Buyer chooses to SUBDIVIDE.  Buyers to do their own due diligence to verify all information. Beautiful setting, well maintained custom built raised ranch sets on 1.92 acres. Legal two family home but could be converted back to a single family home if subdiving the lot. Large sunroom/great room with hardwood floors, skylights and french doors lead into kitchen and dining area with hardwood floors and granite counter tops and attached screened porch. Fireplaced LR w/hardwood floors.  Three bedrooms and full bath on main level. Second floor (4th bedroom) currently used as a legal one bedroom apt, full bath w/laundry hookups,  open kitchen/living area and balcony off bedroom.   Partially finished heated basement with laundry hookups.  New furnace 2023.   Three car detached garage, tons of storage on second level.  An additional two story tool shed/horse barn. Sprinkler lawn system.\n Property Type Residential Listing Type For Sale Ref ID 967613c3ff45ef10349501e48a1ac366 Full Bathrooms 2 Full Bathrooms two Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 01949 Office Name Doyle Real Estate Agent MLSID B7000015 Office Phone 978-777-8700 Agent Phone 978-314-5566 CoolingYN 1 CoolingYN one ParkingTotal 12 ParkingTotal twelve UnparsedAddress 151 River Street, Middleton MA 01949 OpenParkingYN 1 OpenParkingYN one BRE_Total_Parking 15 BRE_Total_Parking fifteen  151 river st middleton massachusetts 01949 
    [location_text] => 151 River Street, Middleton, Massachusetts 01949
    [field_42] => River Street
    [field_312] => Residential For Sale - 10 Rooms - 4 Bedrooms - 2 Bathrooms - Price $1,
    [field_313] => Residential For Sale
    [field_308] => PERC TEST COMPELTED and APPROVED TO BUILD ANOTHER HOME ON LOT if Buyer chooses to SUBDIVIDE.  Buyers to do their own due diligence to verify all information. Beautiful setting, well maintained custom built raised ranch sets on 1.92 acres. Legal two family home but could be converted back to a single family home if subdiving the lot. Large sunroom/great room with hardwood floors, skylights and french doors lead into kitchen and dining area with hardwood floors and granite counter tops and attached screened porch. Fireplaced LR w/hardwood floors.  Three bedrooms and full bath on main level. Second floor (4th bedroom) currently used as a legal one bedroom apt, full bath w/laundry hookups,  open kitchen/living area and balcony off bedroom.   Partially finished heated basement with laundry hookups.  New furnace 2023.   Three car detached garage, tons of storage on second level.  An additional two story tool shed/horse barn. Sprinkler lawn system.
    [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] => ,28,12,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 0
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,16,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,0,2,15,4,5,17,
    [f_137] => 1
    [f_138_options] => 
    [f_138] => 
    [f_139_options] => 
    [f_139] => 
    [f_140_options] => ,6,
    [f_140] => 0
    [f_141_options] => 
    [f_141] => 
    [f_144_options] => ,5,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,34,20,21,15,18,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] => 967613c3ff45ef10349501e48a1ac366
    [field_54] => 
    [half_bathrooms] => 0
    [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 - 10 Rooms - 4 Bedrooms - 2 Bathrooms - Price $1,"},"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 - 10 Rooms - 4 Bedrooms - 2 Bathrooms - Price $1,"},"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":"151 River Street, Middleton, Massachusetts 01949"}
    [alias] => Single-Family-151-River-Street-Middleton-Massachusetts-01949-73286264-USD1-200-000
    [source] => mls
    [last_sync_date] => 2024-11-25 07:23:11
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => Doyle Real Estate
    [field_2112] => Patti Anne Madden
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => B7000015
    [field_3001] => NB9081
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 80
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-11-24 22:45:00
    [f_3102_options] => ,54,
    [f_3102] => 0
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 151 River Street
    [field_3171] => 978-777-8700
    [field_3172] => 978-314-5566
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 2
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 
    [field_3191] => 0
    [field_3192] => 12
    [field_3212] => 0
    [field_3217] => 0
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 0
    [field_3240] => 151 River Street, Middleton MA 01949
    [f_3247_options] => ,18,
    [f_3247] => 0
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 0
    [field_3186] => 1
    [field_3301] => 1
    [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] => 15
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 13
    [visit_time] => 6
    [visit_date] => 2024-11-27 00:21:46
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 0
    [f_3003_options] => ,74,75,0,2,4,1,7,8,42,
    [f_3003] => 1
    [field_3004] => Masconomet
    [field_3005] => Howe-Manning
    [f_3006_options] => ,0,1,17,3,21,18,2,
    [f_3006] => 1
    [f_3007_options] => ,29,
    [f_3007] => 0
    [f_3008_options] => ,172,
    [f_3008] => 1
    [f_3009_options] => ,57,60,35,12,44,8,4,10,14,
    [f_3009] => 1
    [f_3010_options] => ,116,32,16,37,21,49,27,20,57,
    [f_3010] => 1
    [field_3011] => 880800
    [field_3011_si] => 880800
    [field_3011_unit] => 260
    [field_3017] => Masconomet
    [field_3018] => 41
    [field_3019] => 2024-10-21 12:53:56
    [field_3020] => 12
    [field_3021] => Call List Agent,Appointment Required,Call Or Text 
    [field_3022] => 
    [field_3023] => 10385
    [field_3023_si] => 10385
    [field_3023_unit] => 260
    [field_3024] => 2023
    [f_3025_options] => ,29,
    [f_3025] => 1
    [field_3027] => 6
    [field_3028] => 8
    [field_3029] => 0
    [field_3032] => Res
    [field_3039] => Rt. 114 to River Street or Rt. 62/Boston St. to Ri
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 0
    [field_3058] => 3
    [field_3060] => 
    [field_3069] => 393.18
    [field_3069_si] => 393.18
    [field_3069_unit] => 260
    [field_3079] => 2024-11-19 18:59:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 151
    [field_3096] => 0
    [field_3097] => 
    [field_3098] => 0
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 4
    [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] => 0
    [field_3134] => 1
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => 2552 living area above grade, plus approximately 5
    [f_3166_options] => ,94,
    [f_3166] => 0
    [field_3168] => 0
    [field_3168_si] => 0
    [field_3168_unit] => 260
    [field_3178] => 0
    [field_3179] => 
    [field_3182] => 0
    [field_3183] => 3052
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,5,0,6,8,10,2,3,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] => 0
    [f_3196_options] => ,40,
    [f_3196] => 0
    [field_3197] => 
    [f_3198_options] => ,4,
    [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] => 0
    [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-09-05
    [field_3224] => 
    [f_3225_options] => ,7,
    [f_3225] => 1
    [field_3226_si] => 7778.055
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 1475000
    [field_3231_si] => 1475000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Buyers to do their own due diligence to verify all
    [field_3237] => 
    [field_3239] => 0
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Actual
    [field_3244] => 
    [field_3245] => Public Records
    [field_3246] => 
    [field_3248] => 2024-09-06 01:44: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] => Unknown
    [field_3273] => 
    [field_3274] => 
    [field_3275] => 
    [field_3276] => 
    [field_3277] => NB9081
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 80
    [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] => 1
    [field_3285] => 0
    [field_3285_si] => 0
    [field_3285_unit] => 260
    [field_3286] => 
    [field_3287] => 
    [field_3288] => 
    [field_3289] => 
    [field_3290] => 393.18
    [field_3290_si] => 393.18
    [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] => 0
    [field_3297] => 
    [field_3303] => 
    [f_3304_options] => ,22,
    [f_3304] => 0
    [f_3305_options] => ,12,
    [f_3305] => 0
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 83635
)

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] => 2
        )

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

[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° 58' 21.5'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => Doyle Real Estate
        )

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

[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] => Compensation Offered But Not In Mls
        )

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

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

[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] => 24/11/2024 22:45: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] => 151
        )

[field_3096] => Array
        (
            [field_id] => 3096
            [type] => text
            [name] => SELLING_BROKER_COMP
            [value] => 0
        )

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

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

[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_3131] => Array
        (
            [field_id] => 3131
            [type] => number
            [name] => COOLING_ZONES
            [value] => 0
        )

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

[field_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => 2552 living area above grade, plus approximately 5
        )

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

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

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

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

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

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

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

[field_3186] => Array
        (
            [field_id] => 3186
            [type] => select
            [name] => BuyerAgencyCompensationType
            [value] => %
        )

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Walk/jog Trails
                    [1] => Highway Access
                    [2] => House Of Worship
                    [3] => Public School
                    [4] => Shopping
                    [5] => Golf
                    [6] => Medical Facility
                    [7] => Bike Path
                    [8] => Public Transportation
                )

)

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

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

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

)

[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_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] => 05/09/2024
        )

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

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 83,635 Sqft
            [raw] => 83635
            [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] => 1475000
            [unit_id] => 260
            [value] => $1,475,000
            [price_only] => $1,475,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Buyers to do their own due diligence to verify all
        )

[field_3239] => Array
        (
            [field_id] => 3239
            [type] => select
            [name] => TransactionBrokerCompensationType
            [value] => %
        )

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 151 River Street, 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] => Actual
        )

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

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 06/09/2024 01:44: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] => Unknown
        )

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

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

[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_3284] => Array
        (
            [field_id] => 3284
            [type] => number
            [name] => MLSPIN_OH_FLAG
            [value] => 1
        )

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

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

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

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

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

[field_3311] => Array
        (
            [field_id] => 3311
            [type] => number
            [name] => BRE_Total_Parking
            [value] => 15
        )

)

EXIT

39 More Photos

Active

151 River Street Middleton. MA 01949

$1,200,000

General Information for 151 River Street, Middleton, Massachusetts 01949

Interior Features for 151 River Street, Middleton, Massachusetts 01949

Exterior Features for 151 River Street, Middleton, Massachusetts 01949

Disclosures for 151 River Street, Middleton, Massachusetts 01949

Financial Information for 151 River Street, Middleton, Massachusetts 01949

Lifestyle Information for 151 River Street, Middleton, Massachusetts 01949

Location information for 151 River Street, Middleton, Massachusetts 01949

Marketing History for 151 River Street, Middleton, Massachusetts 01949

Agent Information for 151 River Street, Middleton, Massachusetts 01949

Payment Calculator

Exclusive Listing Agent

Patti Anne Madden

Doyle Real Estate

EXIT

39 More Photos

Active

151 River Street Middleton. MA 01949

$1,200,000

General Information for 151 River Street, Middleton, Massachusetts 01949

Interior Features for 151 River Street, Middleton, Massachusetts 01949

Exterior Features for 151 River Street, Middleton, Massachusetts 01949

Disclosures for 151 River Street, Middleton, Massachusetts 01949

Financial Information for 151 River Street, Middleton, Massachusetts 01949

Lifestyle Information for 151 River Street, Middleton, Massachusetts 01949

Location information for 151 River Street, Middleton, Massachusetts 01949

Marketing History for 151 River Street, Middleton, Massachusetts 01949

Agent Information for 151 River Street, Middleton, Massachusetts 01949

Payment Calculator

Exclusive Listing Agent

Patti Anne Madden

Doyle Real Estate

Neighborhood

Properties for sale in Ipswich