Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

25 Hamilton Way Holbrook. MA 02343

$799,000

Single Family

3 Bedrooms

3 Bathrooms

2,464 sq ft

4 Parking Spots

1.38 Acres

Built in 2000

HAMILTON ESTATES - Holbrook's premier neighborhood located off Rte 37, close to Rte 3 @ 24, 1.5 mi to Montello commuter rail station,. MBTA bus at top of street with access to the Red Line T station - a commuters dream This colonial style home is situated on a large lot with conservation land in rear providing privacy for your peaceful enjoyment. The first floor has a large kitchen/dining room with granite counters and hardwood floors. Stone wood burning fireplace in living room. There is an office/4th bedroom on the first floor across from BA w/ seated shower providing a great option for 1st FL living. The dining room leads to a large deck for your outdoor enjoyment. Upstairs has 3 spacious bedrooms, 2 bathrooms and a great room over the garage with access from the 2nd FL or the garage. The master suite has a large whirlpool tub and double sinks. Laundry is located on the 2nd FL. Forced hot water heated by gas and central air. Two car attached garage and large shed.

This listing has been viewed 8 times in the past 50 days

Last Updated: November 18th, 2024 at 5:18am

Walk/jog Trails

Conservation Area

Highway Access

Public School

Shopping

Public Transportation

T-station

Sidewalks

General Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Property TypeResidential

Property Sub TypeResidential

Price$799,000

Price per sqft$324.27

MLS #73288753

Handicap Access / FeaturesNo

List Date2024-09-11

List Price$799,000

Special Listing Conditions

Specific Zoning CodeR1

StateMassachusetts

Street NameHamilton Way

Style

TownHolbrook

CityHolbrook

Zip Code02343

CountyNorfolk

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces2

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones4

Attached/DetachedYes

Sold Date

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourcePublic Records

Building Area Total2464

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces2

Listing ServiceEntry Only

UnparsedAddress25 Hamilton Way, Holbrook MA 02343

Zoning

Interior Features for 25 Hamilton Way, Holbrook, Massachusetts 02343

Master BathYes

* Approx. Living Area Total2,464 sq ft

Living Area Includes BasementNo

* Living Area Source1

Bedrooms3

* # Fireplaces1

Bathrooms (Total)3

Full Baths3

* # Half Baths0

* # Rooms

Basement

* CoolingNo

Heating System

Appliances

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosure

Living Area Includes BasementNo

Door Features

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate

Exterior Features for 25 Hamilton Way, Holbrook, Massachusetts 02343

* Approximate Lot Size1.38 acres

Covered Parking Spaces2

Lot FeaturesCleared, Cul-de-sac, Level

* Parking Spaces4

* Sewer Utilities

* Water Utilities

* Year Built2000

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsFrame

Exterior Features

Foundation Area936

Foundation MaterialsConcrete Perimeter

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)59,982 Sqft

Disclosures for 25 Hamilton Way, Holbrook, Massachusetts 02343

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 Disclosure

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)

Facilitator Compensation

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

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$839,000

Lifestyle Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Association Amenities

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool Features

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features

Location information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Elementary SchoolJohn F. Kennedy

Middle SchoolHolbrook Middle

High SchoolHolbrook High

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 25 Hamilton Way, Holbrook, Massachusetts 02343

MLSPIN_MARKET_TIME_BROKER67

MLSPIN_MARKET_TIME_PROPERTY67

PurchaseContractDate

Agent Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Agent NameMichael Consoli

Agent MLS IDC8002722

Agent Phone #978-376-5755

Agent Phone Area

Office NameConsoli Realty Group

Office Phone978-376-5755

Office Phone Area

Office MLS IDAC2458

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 4923.18

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Michael Consoli

Consoli Realty Group

Agent Phone

(978) 376-5755

Office Phone

(978) 376-5755

Text Agent Call Agent Call Office

Array
(
    [id] => 533751
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73288753
    [mls_id_num] => 73288753
    [parent] => 0
    [pic_numb] => 17
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 5
    [location4_id] => 31
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Norfolk
    [location4_name] => Holbrook
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 799000
    [price_unit] => 260
    [price_si] => 799000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 3
    [bedrooms_max] => 0
    [rooms] => 7
    [rooms_max] => 0
    [bathrooms] => 3
    [bathrooms_max] => 0
    [living_area] => 2464
    [living_area_unit] => 1
    [living_area_si] => 229.152
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 1.38
    [lot_area_unit] => 1
    [lot_area_si] => 0.12834
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.12299600
    [googlemap_ln] => -71.01785600
    [geopoints] => �������d~�$�Q���:U�E@
    [finalized] => 1
    [add_date] => 2024-10-08 07:03:12
    [last_finalize_date] => 2024-11-18 05:18:39
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 2000
    [zip_id] => 610
    [zip_name] => 02343
    [last_modified_time_stamp] => 2024-11-20 07:55:06
    [post_code] => 
    [meta_description] => 3 Bedrooms Bedrooms 7 Rooms Rooms With 3 Bathrooms Bathrooms Residential For Sale Hamilton Way In 25 Hamilton Way, Holbrook, Massachusetts 02343
    [meta_description_manual] => 0
    [meta_keywords] => 25 Hamilton Way, Holbrook, Massachusetts 02343, 3 Bedrooms Bedrooms, 7 Rooms Rooms,3 BathroomsBathrooms,Residential,For Sale,Hamilton Way,73288753
    [meta_keywords_manual] => 0
    [street_no] => 25
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description HAMILTON ESTATES – Holbrook’s premier neighborhood located off Rte 37, close to Rte 3 @ 24, 1.5 mi to Montello commuter rail station,. MBTA bus at top of street with access to the Red Line T station – a commuters dream  This colonial style home is situated on a large lot with conservation land in rear providing privacy for your peaceful enjoyment. The first floor has a large kitchen/dining room with granite counters and hardwood floors.  Stone wood burning fireplace in living room.  There is an office/4th bedroom on the first floor across from BA w/ seated shower providing a great option for 1st FL living.  The dining room leads to a large deck for your outdoor enjoyment.   Upstairs has 3 spacious bedrooms, 2 bathrooms and a great room over the garage with access from the 2nd FL or the garage.  The master suite has a large whirlpool tub and double sinks.  Laundry is located on the 2nd FL.   Forced hot water heated by gas and central air. Two car attached garage and large shed.\n Property Type Residential Listing Type For Sale Ref ID d16e2c095dc3e00abf4f33f23e5f0e29 Full Bathrooms 3 Full Bathrooms three Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 02343 Office Name Consoli Realty Group Agent MLSID C8002722 Office Phone 978-376-5755 Agent Phone 978-376-5755 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 4 ParkingTotal four UnparsedAddress 25 Hamilton Way, Holbrook MA 02343 OpenParkingYN 1 OpenParkingYN one BRE_Total_Parking 6 BRE_Total_Parking six  25 hamilton way holbrook massachusetts 02343 
    [location_text] => 25 Hamilton Way, Holbrook, Massachusetts 02343
    [field_42] => Hamilton Way
    [field_312] => Residential For Sale - 7 Rooms - 3 Bedrooms - 3 Bathrooms - Price $799
    [field_313] => Residential For Sale
    [field_308] => HAMILTON ESTATES - Holbrook's premier neighborhood located off Rte 37, close to Rte 3 @ 24, 1.5 mi to Montello commuter rail station,. MBTA bus at top of street with access to the Red Line T station - a commuters dream  This colonial style home is situated on a large lot with conservation land in rear providing privacy for your peaceful enjoyment. The first floor has a large kitchen/dining room with granite counters and hardwood floors.  Stone wood burning fireplace in living room.  There is an office/4th bedroom on the first floor across from BA w/ seated shower providing a great option for 1st FL living.  The dining room leads to a large deck for your outdoor enjoyment.   Upstairs has 3 spacious bedrooms, 2 bathrooms and a great room over the garage with access from the 2nd FL or the garage.  The master suite has a large whirlpool tub and double sinks.  Laundry is located on the 2nd FL.   Forced hot water heated by gas and central air. Two car attached garage and large shed.
    [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,29,
    [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,15,4,5,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] => ,5,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,19,20,22,33,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] => d16e2c095dc3e00abf4f33f23e5f0e29
    [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 - 7 Rooms - 3 Bedrooms - 3 Bathrooms - Price $799"},"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 - 7 Rooms - 3 Bedrooms - 3 Bathrooms - Price $799"},"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":"25 Hamilton Way, Holbrook, Massachusetts 02343"}
    [alias] => Single-Family-25-Hamilton-Way-Holbrook-Massachusetts-02343-73288753-USD799-000
    [source] => mls
    [last_sync_date] => 2024-11-18 05:18:17
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => Consoli Realty Group
    [field_2112] => Michael Consoli
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => C8002722
    [field_3001] => AC2458
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 67
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-11-17 08:05:00
    [f_3102_options] => ,54,
    [f_3102] => 0
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 25 Hamilton Way
    [field_3171] => 978-376-5755
    [field_3172] => 978-376-5755
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 3
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 0
    [field_3191] => 0
    [field_3192] => 4
    [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] => 25 Hamilton Way, Holbrook MA 02343
    [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] => 6
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 25
    [visit_time] => 7
    [visit_date] => 2024-11-26 18:10:48
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 0
    [f_3003_options] => ,30,0,4,1,27,
    [f_3003] => 1
    [field_3004] => Holbrook High
    [field_3005] => John F. Kennedy
    [f_3006_options] => ,1,17,3,21,
    [f_3006] => 1
    [f_3007_options] => ,14,
    [f_3007] => 1
    [f_3008_options] => ,0,
    [f_3008] => 0
    [f_3009_options] => ,2,5,44,45,10,
    [f_3009] => 1
    [f_3010_options] => ,33,21,22,85,23,82,
    [f_3010] => 1
    [field_3011] => 723800
    [field_3011_si] => 723800
    [field_3011_unit] => 260
    [field_3017] => Holbrook Middle
    [field_3018] => 17
    [field_3019] => 2024-10-14 20:01:47
    [field_3020] => 12
    [field_3021] => Owner,Appointment Required,Submit All Offers Onlin
    [field_3022] => 
    [field_3023] => 9728
    [field_3023_si] => 9728
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,0,
    [f_3025] => 1
    [field_3027] => 13
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => R1
    [field_3039] => South Franklin St (Rte 37) to Hamilton Way, #25 is
    [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] => 324.27
    [field_3069_si] => 324.27
    [field_3069_unit] => 260
    [field_3079] => 2024-11-14 00:39:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 25
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 
    [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] => 1
    [field_3134] => 0
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 936
    [field_3156] => 
    [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] => 1
    [field_3183] => 2464
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,5,0,1,2,4,12,20,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,0,
    [f_3190] => 1
    [field_3193] => 2
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 0
    [f_3196_options] => ,40,
    [f_3196] => 0
    [field_3197] => 
    [f_3198_options] => ,5,
    [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] => ,10,
    [f_3207] => 0
    [field_3208] => 0
    [field_3209] => Concrete Perimeter
    [field_3210] => 
    [field_3211] => 2
    [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 Agency
    [field_3223] => 2024-09-11
    [field_3224] => Entry Only
    [f_3225_options] => ,10,8,2,
    [f_3225] => 1
    [field_3226_si] => 5578.326
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 839000
    [field_3231_si] => 839000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => IMPORTANT: Schedule all showings and submit all of
    [field_3237] => 
    [field_3239] => 
    [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-11 20:22: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] => AC2458
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 67
    [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] => 324.27
    [field_3290_si] => 324.27
    [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] => 59982
)

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

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

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

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

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

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

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

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

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

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => Consoli Realty Group
        )

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

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

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

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

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

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

[field_3151] => Array
        (
            [field_id] => 3151
            [type] => text
            [name] => FOUNDATION_SIZE
            [value] => 936
        )

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

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

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

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

[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] => Conservation Area
                    [2] => Highway Access
                    [3] => Public School
                    [4] => Shopping
                    [5] => Public Transportation
                    [6] => T-station
                    [7] => 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] => 4
        )

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

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

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

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

[field_3224] => Array
        (
            [field_id] => 3224
            [type] => text
            [name] => ListingService
            [value] => Entry Only
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Level
                    [1] => Cleared
                    [2] => Cul-de-sac
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 59,982 Sqft
            [raw] => 59982
            [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] => 839000
            [unit_id] => 260
            [value] => $839,000
            [price_only] => $839,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => IMPORTANT: Schedule all showings and submit all of
        )

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 25 Hamilton Way, Holbrook MA 02343
        )

[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] => 11/09/2024 20:22: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] => AC2458
        )

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

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

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

)

EXIT

15 More Photos

Active

25 Hamilton Way Holbrook. MA 02343

$799,000

General Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Interior Features for 25 Hamilton Way, Holbrook, Massachusetts 02343

Exterior Features for 25 Hamilton Way, Holbrook, Massachusetts 02343

Disclosures for 25 Hamilton Way, Holbrook, Massachusetts 02343

Financial Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Lifestyle Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Location information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Marketing History for 25 Hamilton Way, Holbrook, Massachusetts 02343

Agent Information for 25 Hamilton Way, Holbrook, Massachusetts 02343

Payment Calculator

Exclusive Listing Agent

Michael Consoli

Consoli Realty Group