Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Withdrawn

88 Hillcrest Rd Waltham. MA 02451

$1,695,000

Single Family

4 Bedrooms

4.5 Bathrooms

4,250 sq ft

4 Parking Spots

0.25 Acres

Built in 2024

Magnificent New Construction Single Family located in a sought after Waltham location. This 4 Bedroom 4.5 bathroom Colonial has been built with the highest quality paying attention to every detail. First floor boasts 5 rooms which include a large great room with fireplace, casual dining area, custom kitchen with quartz counters, SS appliances & an oversized island. Formal dining room, bonus living room/office. Second level Main Bedroom with 2 walk-in closets, double sink vanity & oversized shower. Three additional bedrooms with Jack & Jill bathroom for 2 bedrooms and third bedroom with ensuite. Finished lower level playroom/gameroom with additional full bath. Hardwood floors throughout. 3 Zoned Central Air & Forced Hot Air. Oversized two car garage with direct entry into mudroom with half bath. Spacious composite deck leading to a fenced in back yard. Conveniently located minutes to Rt128/95. Close to restaurants & shopping. Welcome to Waltham!

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

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

Highway Access

Shopping

Park

Tennis Court(s)

General Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Property TypeResidential

Property Sub TypeResidential

Price$1,695,000

Price per sqft$398.82

MLS #73219007

Handicap Access / FeaturesYes

List Date2024-04-03

List Price$1,695,000

Special Listing ConditionsNo

Specific Zoning CodeRes

StateMassachusetts

Street NameHillcrest Rd

Style

TownWaltham

CityWaltham

Zip Code02451

CountyMiddlesex

StatusWithdrawn

MLS Status

AssociationNo

Covered Parking Spaces2

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones3

Attached/DetachedYes

Sold Date

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourceOwner

Building Area Total4250

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces2

Listing Service

UnparsedAddress88 Hillcrest Rd, Waltham MA 02451

Zoning

Interior Features for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Master BathYes

* Approx. Living Area Total4,250 sq ft

Living Area Includes BasementYes

* Living Area Source4

Bedrooms4

* # Fireplaces1

Bathrooms (Total)4.5

Full Baths4

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area DisclosureApproximate

Living Area Includes BasementYes

Door FeaturesNo

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate19/08/2024

Exterior Features for 88 Hillcrest Rd, Waltham, Massachusetts 02451

* Approximate Lot Size0.25 acres

Covered Parking Spaces2

Lot FeaturesCorner Lot

* Parking Spaces4

* 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)10,849 Sqft

Disclosures for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Buyer Agent Compensation2.0

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ONNet Sale Price

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintNone

Living Area DisclosureApproximate

Living Area Includes BasementYes

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation2.0

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Association Fee$0

Association Fee Frequency

Associaton Fee IncludesNo

AssociationNo

Assessed Value

Real Estate Tax$0

Tax Year

MLSPIN_SOLD_PRICE_PER_SQFT$0

OriginalListPrice$1,695,000

Lifestyle Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features3/10 To 1/2 Mile To Beach, Beach Front, Beach Ownership(public), Lake/pond

Location information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Elementary School

Middle School

High SchoolWhs

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 88 Hillcrest Rd, Waltham, Massachusetts 02451

MLSPIN_MARKET_TIME_BROKER138

MLSPIN_MARKET_TIME_PROPERTY138

PurchaseContractDate

Agent Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Agent NameAri Koufos

Agent MLS IDBB980983

Agent Phone #617-799-8948

Agent Phone Area

Office NameRealty Executives

Office Phone617-923-7778

Office Phone Area

Office MLS IDBB2353

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 10444.05

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Ari Koufos

Realty Executives

Agent Phone

(617) 799-8948

Office Phone

(617) 923-7778

Text Agent Call Agent Call Office

Array
(
    [id] => 309763
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73219007
    [mls_id_num] => 73219007
    [parent] => 0
    [pic_numb] => 42
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 3
    [location4_id] => 170
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Middlesex
    [location4_name] => Waltham
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 1695000
    [price_unit] => 260
    [price_si] => 1695000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 4
    [bedrooms_max] => 0
    [rooms] => 10
    [rooms_max] => 0
    [bathrooms] => 4.5
    [bathrooms_max] => 0
    [living_area] => 4250
    [living_area_unit] => 1
    [living_area_si] => 395.25
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 0.25
    [lot_area_unit] => 1
    [lot_area_si] => 0.02325
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.41251500
    [googlemap_ln] => -71.24904100
    [geopoints] => �������>��I��Q��J�4E@
    [finalized] => 1
    [add_date] => 2024-04-27 11:02:38
    [last_finalize_date] => 2024-10-07 20:00:30
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 2024
    [zip_id] => 377
    [zip_name] => 02451
    [last_modified_time_stamp] => 2024-10-14 14:53:37
    [post_code] => 
    [meta_description] => 4 Bedrooms Bedrooms 10 Rooms Rooms With 4.5 Bathrooms Bathrooms Residential For Sale Hillcrest Rd In 88 Hillcrest Rd, Waltham, Massachusetts 02451
    [meta_description_manual] => 0
    [meta_keywords] => 88 Hillcrest Rd, Waltham, Massachusetts 02451, 4 Bedrooms Bedrooms, 10 Rooms Rooms,4.5 BathroomsBathrooms,Residential,For Sale,Hillcrest Rd,73219007
    [meta_keywords_manual] => 0
    [street_no] => 88
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Magnificent New Construction Single Family located in a sought after Waltham location. This 4 Bedroom 4.5 bathroom Colonial has been built with the highest quality paying attention to every detail. First floor boasts 5 rooms which include a large great room with fireplace, casual dining area, custom kitchen with quartz counters, SS appliances & an oversized island. Formal dining room, bonus living room/office. Second level Main Bedroom with 2 walk-in closets, double sink vanity & oversized shower. Three additional bedrooms with Jack & Jill bathroom for 2 bedrooms and third bedroom with ensuite. Finished lower level playroom/gameroom with additional full bath. Hardwood floors throughout. 3 Zoned Central Air & Forced Hot Air. Oversized two car garage with direct entry into mudroom with half bath. Spacious composite deck leading to a fenced in back yard. Conveniently located minutes to Rt128/95. Close to restaurants & shopping. Welcome to Waltham!\n Property Type Residential Listing Type For Sale Ref ID 6fa4772026ab32fd53e24333ec60ca59 Full Bathrooms 4 Full Bathrooms four Status Withdrawn Property Category Residential Property Type Single Family C_Style Detached Zipcode 02451 Office Name Realty Executives Agent MLSID BB980983 Office Phone 617-923-7778 Agent Phone 617-799-8948 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 4 ParkingTotal four UnparsedAddress 88 Hillcrest Rd, Waltham MA 02451 OpenParkingYN 1 OpenParkingYN one  88 hillcrest rd waltham massachusetts 02451 
    [location_text] => 88 Hillcrest Rd, Waltham, Massachusetts 02451
    [field_42] => Hillcrest Rd
    [field_312] => Residential For Sale - 10 Rooms - 4 Bedrooms - 4.5 Bathrooms - Price $
    [field_313] => Residential For Sale
    [field_308] => Magnificent New Construction Single Family located in a sought after Waltham location. This 4 Bedroom 4.5 bathroom Colonial has been built with the highest quality paying attention to every detail. First floor boasts 5 rooms which include a large great room with fireplace, casual dining area, custom kitchen with quartz counters, SS appliances & an oversized island. Formal dining room, bonus living room/office. Second level Main Bedroom with 2 walk-in closets, double sink vanity & oversized shower. Three additional bedrooms with Jack & Jill bathroom for 2 bedrooms and third bedroom with ensuite. Finished lower level playroom/gameroom with additional full bath. Hardwood floors throughout. 3 Zoned Central Air & Forced Hot Air. Oversized two car garage with direct entry into mudroom with half bath. Spacious composite deck leading to a fenced in back yard. Conveniently located minutes to Rt128/95. Close to restaurants & shopping. Welcome to Waltham!
    [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] => ,6,11,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,4,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,0,11,15,4,
    [f_137] => 1
    [f_138_options] => 
    [f_138] => 
    [f_139_options] => 
    [f_139] => 
    [f_140_options] => ,6,
    [f_140] => 1
    [f_141_options] => 
    [f_141] => 
    [f_144_options] => ,20,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,19,15,18,
    [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] => 6fa4772026ab32fd53e24333ec60ca59
    [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 - 10 Rooms - 4 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 - 10 Rooms - 4 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":"88 Hillcrest Rd, Waltham, Massachusetts 02451"}
    [alias] => Single-Family-88-Hillcrest-Rd-Waltham-Massachusetts-02451-73219007-USD1-695-000
    [source] => mls
    [last_sync_date] => 2024-10-07 20:00:00
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 14
    [field_2111] => Realty Executives
    [field_2112] => Ari Koufos
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => BB980983
    [field_3001] => BB2353
    [listing_status] => 14
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 138
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-08-19 12:33:00
    [f_3102_options] => ,19,28,27,21,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 88 Hillcrest Rd
    [field_3171] => 617-923-7778
    [field_3172] => 617-799-8948
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 5
    [field_3176] => 4
    [field_3177] => 0
    [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] => 1
    [field_3240] => 88 Hillcrest Rd, Waltham MA 02451
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 2.0
    [field_3186] => 
    [field_3301] => 0
    [field_3306] => 0
    [field_3306_si] => 0
    [field_3306_unit] => 260
    [fly_field] => 
    [fly_value] => 
    [field_3120] => 
    [field_3055] => 
    [field_3056] => 0
    [field_3056_si] => 0
    [field_3056_unit] => 260
    [field_3311] => 
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 56
    [visit_time] => 21
    [visit_date] => 2024-11-25 10:17:00
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,0,2,3,4,1,
    [f_3003] => 1
    [field_3004] => Whs
    [field_3005] => 
    [f_3006_options] => ,4,
    [f_3006] => 1
    [f_3007_options] => ,2,
    [f_3007] => 1
    [f_3008_options] => ,245,
    [f_3008] => 1
    [f_3009_options] => ,15,44,16,
    [f_3009] => 1
    [f_3010_options] => ,131,37,56,29,
    [f_3010] => 1
    [field_3011] => 0
    [field_3011_si] => 0
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 42
    [field_3019] => 2024-05-28 23:44:35
    [field_3020] => 14
    [field_3021] => Call List Agent,Appointment Required
    [field_3022] => 
    [field_3023] => 0
    [field_3023_si] => 0
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,0,
    [f_3025] => 1
    [field_3027] => 
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => Res
    [field_3039] => Trapelo Rd to Pheasant to Hillcrest
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 1
    [field_3060] => 
    [field_3069] => 398.82
    [field_3069_si] => 398.82
    [field_3069_unit] => 260
    [field_3079] => 2024-08-19 12:33:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 88
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 2.0
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 3
    [field_3113] => 
    [field_3114] => 
    [field_3115] => 
    [field_3116] => 
    [field_3118] => 0
    [field_3118_si] => 0
    [field_3118_unit] => 260
    [field_3119] => 
    [field_3121] => 
    [field_3122] => 
    [field_3123] => 
    [f_3125_options] => ,0,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 3
    [field_3134] => 1
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => Approximate
    [f_3166_options] => ,94,
    [f_3166] => 1
    [field_3168] => 0
    [field_3168_si] => 0
    [field_3168_unit] => 260
    [field_3178] => 0
    [field_3179] => 
    [field_3182] => 4
    [field_3183] => 4250
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,5,14,7,2,
    [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] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [field_3197] => 
    [f_3198_options] => ,5,
    [f_3198] => 1
    [field_3199] => 
    [field_3200] => 0
    [field_3200_si] => 0
    [field_3200_unit] => 260
    [field_3201] => 
    [field_3202] => 
    [field_3203] => 
    [field_3204] => 
    [field_3205] => 1900-01-01
    [field_3206] => 0
    [f_3207_options] => ,10,
    [f_3207] => 1
    [field_3208] => 0
    [field_3209] => Concrete Perimeter
    [field_3210] => 
    [field_3211] => 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 Right To Sell
    [field_3223] => 2024-04-03
    [field_3224] => 
    [f_3225_options] => ,6,
    [f_3225] => 1
    [field_3226_si] => 1008.957
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 2024-08-19
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 1695000
    [field_3231_si] => 1695000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Square footage is approximate. Landscaping is not 
    [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-04-03 09:18: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] => BB2353
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 138
    [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] => 398.82
    [field_3290_si] => 398.82
    [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] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 10849
)

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

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

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

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

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

)

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

)

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

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

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

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

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

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

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

)

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

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

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

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

[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] => 19/08/2024 12:33: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] => 88
        )

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

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => Array
                (
                    [0] => Beach Front
                    [1] => Beach Ownership(public)
                    [2] => 3/10 To 1/2 Mile To Beach
                    [3] => Lake/pond
                )

)

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

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

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

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

)

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

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

[field_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => Approximate
        )

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

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

)

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

[field_3171] => Array
        (
            [field_id] => 3171
            [type] => text
            [name] => Office Phone
            [value] => 617-923-7778
        )

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

[field_3177] => Array
        (
            [field_id] => 3177
            [type] => select
            [name] => AccessibilityFeatures
            [value] => No
        )

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

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

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

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

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Highway Access
                    [1] => Shopping
                    [2] => Park
                    [3] => Tennis Court(s)
                )

)

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

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

)

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

)

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

)

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

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

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

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

)

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

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

[field_3211] => Array
        (
            [field_id] => 3211
            [type] => number
            [name] => GarageSpaces
            [value] => 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 Right To Sell
        )

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

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

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 10,849 Sqft
            [raw] => 10849
            [unit_id] => 1
        )

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

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

[field_3231] => Array
        (
            [field_id] => 3231
            [type] => price
            [name] => OriginalListPrice
            [raw] => 1695000
            [unit_id] => 260
            [value] => $1,695,000
            [price_only] => $1,695,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Square footage is approximate. Landscaping is not 
        )

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

)

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 88 Hillcrest Rd, Waltham MA 02451
        )

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

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

)

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 03/04/2024 09:18: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] => BB2353
        )

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

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

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

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

)

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

)

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

)

EXIT

40 More Photos

Withdrawn

88 Hillcrest Rd Waltham. MA 02451

$1,695,000

General Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Interior Features for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Exterior Features for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Disclosures for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Financial Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Lifestyle Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Location information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Marketing History for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Agent Information for 88 Hillcrest Rd, Waltham, Massachusetts 02451

Payment Calculator

Exclusive Listing Agent

Ari Koufos

Realty Executives