Ipswich Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

173 Miles River Rd Hamilton. MA 01982

$2,699,999

Single Family

5 Bedrooms

4.5 Bathrooms

5,975 sq ft

10 Parking Spots

1.24 Acres

Built in 2024

This beautifully crafted new construction home sits on 1.24 acres with gorgeous views, offering a peaceful & private setting. Featuring 5 bedrooms & 4.5 baths, the open & modern floor plan is designed for comfortable living, entertaining, & working from home. The 1st floor impresses with 9.5” wide engineered white oak hardwood floors, 9-foot ceilings, crown molding, tray ceilings, & raised grid wall details. The chef’s kitchen with a center island, pantry, stainless steel appliances, & Shaker/Slab cabinets flows seamlessly into the dining & great rooms, each with its own fireplace. A guest bedroom with a full bath, living/game room/, & home office complete the main level. The 2nd floor continues with the beautiful hardwoods, featuring a luxurious primary suite with a spa-like bath, three additional spacious bedrooms, two more full baths, & a large laundry room. A 4-car garage, mudroom, expansive driveway, maintenance-free decks, and a patio complete this exceptional home.

This listing has been viewed 21 times in the past 22 days

Last Updated: November 16th, 2024 at 5:33pm

Walk/jog Trails

Public School

Shopping

Golf

Park

Bike Path

Public Transportation

T-station

Stable(s)

Private School

University

Sidewalks

General Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Property TypeResidential

Property Sub TypeResidential

Price$2,699,999

Price per sqft$451.88

MLS #73306416

Handicap Access / FeaturesNo

List Date2024-10-25

List Price$2,699,999

Special Listing Conditions

Specific Zoning CodeR1

StateMassachusetts

Street NameMiles River Rd

Style

TownHamilton

CityHamilton

Zip Code01982

CountyEssex

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces4

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones5

Attached/DetachedYes

Sold Date

Green Energy EfficientThermostat

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourceMeasured

Building Area Total5975

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces4

Listing Service

UnparsedAddress173 Miles River Rd, Hamilton MA 01982

Zoning

Interior Features for 173 Miles River Rd, Hamilton, Massachusetts 01982

Master BathYes

* Approx. Living Area Total5,975 sq ft

Living Area Includes BasementYes

* Living Area Source5

Bedrooms5

* # Fireplaces2

Bathrooms (Total)4.5

Full Baths4

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

Appliances

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area DisclosureDoes not include finished mudroom in Lower Level o

Living Area Includes BasementYes

Door FeaturesFrench Doors, Insulated Doors

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate

Exterior Features for 173 Miles River Rd, Hamilton, Massachusetts 01982

* Approximate Lot Size1.24 acres

Covered Parking Spaces4

Lot FeaturesCleared, Corner Lot, Gentle Sloping

* Parking Spaces10

* 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)54,014 Sqft

Disclosures for 173 Miles River Rd, Hamilton, Massachusetts 01982

Buyer Agent Compensation

Contingency

Financing

Disclosures

Documents Available

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ON

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintNone

Living Area DisclosureDoes not include finished mudroom in Lower Level o

Living Area Includes BasementYes

Senior Community

Short Sale / Foreclosure (bank owned)

Facilitator Compensation

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

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$2,850,000

Lifestyle Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Association Amenities

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool Features

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features

Location information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Elementary School

Middle School

High School

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)Ipswich

Marketing History for 173 Miles River Rd, Hamilton, Massachusetts 01982

MLSPIN_MARKET_TIME_BROKER22

MLSPIN_MARKET_TIME_PROPERTY22

PurchaseContractDate

Agent Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Agent NameThe Lopes Group

Agent MLS IDTM326374

Agent Phone #617-835-2394

Agent Phone Area

Office NameJ. Barrett & Company

Office Phone781-631-9800

Office Phone Area

Office MLS IDAN0125

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 16636.54

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

The Lopes Group

J. Barrett & Company

Agent Phone

(617) 835-2394

Office Phone

(781) 631-9800

Text Agent Call Agent Call Office

Array
(
    [id] => 558758
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73306416
    [mls_id_num] => 73306416
    [parent] => 0
    [pic_numb] => 42
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 12
    [location4_id] => 210
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Essex
    [location4_name] => Hamilton
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 2699999
    [price_unit] => 260
    [price_si] => 2699999
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 5
    [bedrooms_max] => 0
    [rooms] => 13
    [rooms_max] => 0
    [bathrooms] => 4.5
    [bathrooms_max] => 0
    [living_area] => 5975
    [living_area_unit] => 1
    [living_area_si] => 555.675
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 1.24
    [lot_area_unit] => 1
    [lot_area_si] => 0.11532
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.61382700
    [googlemap_ln] => -70.84958200
    [geopoints] => �������LQ.�_�Q�n3�NE@
    [finalized] => 1
    [add_date] => 2024-10-25 19:08:19
    [last_finalize_date] => 2024-11-16 17:33:19
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 2024
    [zip_id] => 388
    [zip_name] => 01982
    [last_modified_time_stamp] => 2024-11-17 02:34:40
    [post_code] => 
    [meta_description] => 5 Bedrooms Bedrooms 13 Rooms Rooms With 4.5 Bathrooms Bathrooms Residential For Sale Miles River Rd In 173 Miles River Rd, Hamilton, Massachusetts 01982
    [meta_description_manual] => 0
    [meta_keywords] => 173 Miles River Rd, Hamilton, Massachusetts 01982, 5 Bedrooms Bedrooms, 13 Rooms Rooms,4.5 BathroomsBathrooms,Residential,For Sale,Miles River Rd,73306416
    [meta_keywords_manual] => 0
    [street_no] => 173
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description This beautifully crafted new construction home sits on 1.24 acres with gorgeous views, offering a peaceful & private setting. Featuring 5 bedrooms & 4.5 baths, the open & modern floor plan is designed for comfortable living, entertaining, & working from home. The 1st floor impresses with 9.5” wide engineered white oak hardwood floors, 9-foot ceilings, crown molding, tray ceilings, & raised grid wall details. The chef’s kitchen with a center island, pantry, stainless steel appliances, & Shaker/Slab cabinets flows seamlessly into the dining & great rooms, each with its own fireplace. A guest bedroom with a full bath, living/game room/, & home office complete the main level. The 2nd floor continues with the beautiful hardwoods, featuring a luxurious primary suite with a spa-like bath, three additional spacious bedrooms, two more full baths, & a large laundry room. A 4-car garage, mudroom, expansive driveway, maintenance-free decks, and a patio complete this exceptional home.\n Property Type Residential Listing Type For Sale Ref ID 882bb92d40d1417505b57bdafe9421e6 Full Bathrooms 4 Full Bathrooms four Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 01982 Office Name J. Barrett & Company Agent MLSID TM326374 Office Phone 781-631-9800 Agent Phone 617-835-2394 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 10 ParkingTotal ten UnparsedAddress 173 Miles River Rd, Hamilton MA 01982 OpenParkingYN 1 OpenParkingYN one BRE_Total_Parking 14 BRE_Total_Parking fourteen  173 miles river rd hamilton massachusetts 01982 
    [location_text] => 173 Miles River Rd, Hamilton, Massachusetts 01982
    [field_42] => Miles River Rd
    [field_312] => Residential For Sale - 13 Rooms - 5 Bedrooms - 4.5 Bathrooms - Price $
    [field_313] => Residential For Sale
    [field_308] => This beautifully crafted new construction home sits on 1.24 acres with gorgeous views, offering a peaceful & private setting. Featuring 5 bedrooms & 4.5 baths, the open & modern floor plan is designed for comfortable living, entertaining, & working from home. The 1st floor impresses with 9.5” wide engineered white oak hardwood floors, 9-foot ceilings, crown molding, tray ceilings, & raised grid wall details. The chef’s kitchen with a center island, pantry, stainless steel appliances, & Shaker/Slab cabinets flows seamlessly into the dining & great rooms, each with its own fireplace. A guest bedroom with a full bath, living/game room/, & home office complete the main level. The 2nd floor continues with the beautiful hardwoods, featuring a luxurious primary suite with a spa-like bath, three additional spacious bedrooms, two more full baths, & a large laundry room. A 4-car garage, mudroom, expansive driveway, maintenance-free decks, and a patio complete this exceptional home.
    [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] => ,3,6,8,29,70,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 0
    [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,13,17,16,
    [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] => ,7,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,19,27,20,21,23,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] => 882bb92d40d1417505b57bdafe9421e6
    [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 - 13 Rooms - 5 Bedrooms - 4.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 - 13 Rooms - 5 Bedrooms - 4.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":"173 Miles River Rd, Hamilton, Massachusetts 01982"}
    [alias] => Single-Family-173-Miles-River-Rd-Hamilton-Massachusetts-01982-73306416-USD2-699-999
    [source] => mls
    [last_sync_date] => 2024-11-16 17:33:10
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => J. Barrett & Company
    [field_2112] => The Lopes Group
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => TM326374
    [field_3001] => AN0125
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 22
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-11-16 08:05:00
    [f_3102_options] => ,54,
    [f_3102] => 0
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 173 Miles River Rd
    [field_3171] => 781-631-9800
    [field_3172] => 617-835-2394
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 4
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 0
    [field_3191] => 0
    [field_3192] => 10
    [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] => 173 Miles River Rd, Hamilton MA 01982
    [f_3247_options] => ,18,
    [f_3247] => 0
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 
    [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] => 14
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 37
    [visit_time] => 20
    [visit_date] => 2024-11-11 19:07:51
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 0
    [f_3003_options] => ,30,75,0,37,2,4,1,43,29,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,0,3,52,19,
    [f_3006] => 1
    [f_3007_options] => ,2,
    [f_3007] => 1
    [f_3008_options] => ,0,
    [f_3008] => 0
    [f_3009_options] => ,0,38,44,10,47,14,
    [f_3009] => 1
    [f_3010_options] => ,116,45,16,24,32,161,107,17,53,145,27,11,12,
    [f_3010] => 1
    [field_3011] => 1478200
    [field_3011_si] => 1478200
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 42
    [field_3019] => 2024-10-25 16:02:11
    [field_3020] => 12
    [field_3021] => Accompanied Showings,Appointment Required,Email Li
    [field_3022] => 
    [field_3023] => 22336
    [field_3023_si] => 22336
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,8,1,
    [f_3025] => 1
    [field_3027] => 21
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => R1
    [field_3039] => Bay Rd to Bridge St to Miles River Rd
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 0
    [field_3058] => 
    [field_3060] => 
    [field_3069] => 451.88
    [field_3069_si] => 451.88
    [field_3069_unit] => 260
    [field_3079] => 2024-11-12 14:43:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 173
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 
    [field_3105] => 
    [field_3109] => 2
    [field_3112] => 5
    [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] => 4
    [field_3134] => 1
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => Does not include finished mudroom in Lower Level o
    [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] => 5
    [field_3183] => 5975
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,5,7,0,15,6,10,17,4,12,18,20,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,0,
    [f_3190] => 1
    [field_3193] => 4
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 0
    [f_3196_options] => ,40,
    [f_3196] => 0
    [field_3197] => 
    [f_3198_options] => ,0,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] => 4
    [field_3213] => 
    [field_3214] => Thermostat
    [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-10-25
    [field_3224] => 
    [f_3225_options] => ,6,8,0,
    [f_3225] => 1
    [field_3226_si] => 5023.302
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 2850000
    [field_3231_si] => 2850000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Private showings only, no open houses. Email The L
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Actual
    [field_3244] => 
    [field_3245] => Builder
    [field_3246] => 
    [field_3248] => 2024-10-25 16:01: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] => C95243
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 22
    [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] => 451.88
    [field_3290_si] => 451.88
    [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] => 
    [f_3304_options] => ,22,
    [f_3304] => 0
    [f_3305_options] => ,12,
    [f_3305] => 0
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 54014
)

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

[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] => W71° 9' 1.5'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => J. Barrett & Company
        )

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

[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_3069] => Array
        (
            [field_id] => 3069
            [type] => price
            [name] => LIST_PRICE_PER_SQFT
            [raw] => 451.88
            [unit_id] => 260
            [value] => $452
            [price_only] => $452
        )

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

[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/11/2024 08:05: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] => 173
        )

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

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

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

[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] => Does not include finished mudroom in Lower Level o
        )

[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] => 781-631-9800
        )

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

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

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

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

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Walk/jog Trails
                    [1] => Public School
                    [2] => Shopping
                    [3] => Golf
                    [4] => Park
                    [5] => Bike Path
                    [6] => Public Transportation
                    [7] => T-station
                    [8] => Stable(s)
                    [9] => Private School
                    [10] => University
                    [11] => Sidewalks
                )

)

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

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

[f_3198] => Array
        (
            [field_id] => 3198
            [type] => feature
            [name] => DoorFeatures
            [values] => Array
                (
                    [0] => Insulated Doors
                    [1] => 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] => 4
        )

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

[field_3214] => Array
        (
            [field_id] => 3214
            [type] => text
            [name] => GreenEnergyEfficient
            [value] => Thermostat
        )

[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] => 25/10/2024
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Gentle Sloping
                    [1] => Corner Lot
                    [2] => Cleared
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 54,014 Sqft
            [raw] => 54014
            [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] => 2850000
            [unit_id] => 260
            [value] => $2,850,000
            [price_only] => $2,850,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Private showings only, no open houses. Email The L
        )

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 173 Miles River Rd, Hamilton MA 01982
        )

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

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 25/10/2024 16:01: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] => C95243
        )

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

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

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

)

EXIT

40 More Photos

Active

173 Miles River Rd Hamilton. MA 01982

$2,699,999

General Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Interior Features for 173 Miles River Rd, Hamilton, Massachusetts 01982

Exterior Features for 173 Miles River Rd, Hamilton, Massachusetts 01982

Disclosures for 173 Miles River Rd, Hamilton, Massachusetts 01982

Financial Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Lifestyle Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Location information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Marketing History for 173 Miles River Rd, Hamilton, Massachusetts 01982

Agent Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Payment Calculator

Exclusive Listing Agent

The Lopes Group

J. Barrett & Company

EXIT

40 More Photos

Active

173 Miles River Rd Hamilton. MA 01982

$2,699,999

General Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Interior Features for 173 Miles River Rd, Hamilton, Massachusetts 01982

Exterior Features for 173 Miles River Rd, Hamilton, Massachusetts 01982

Disclosures for 173 Miles River Rd, Hamilton, Massachusetts 01982

Financial Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Lifestyle Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Location information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Marketing History for 173 Miles River Rd, Hamilton, Massachusetts 01982

Agent Information for 173 Miles River Rd, Hamilton, Massachusetts 01982

Payment Calculator

Exclusive Listing Agent

The Lopes Group

J. Barrett & Company

Neighborhood

Properties for sale in Ipswich