Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Pending

38 Roseanna Park Drive Waltham. MA 02452

$1,675,000

Single Family

4 Bedrooms

3.5 Bathrooms

4,453 sq ft

4 Parking Spots

0.39 Acres

Built in 1997

Welcome to 38 Roseanna Park Drive a custom built meticulously maintained 4453 sq.ft colonial that sits on 16836 sq.ft of pristine landscape in the heart of the prestigious Pigeon Hill Estates. Thoughtfully crafted, this home offers 4 bedrooms, 3.5 baths, bonus rooms, a finished basement & more! Designed to provide the perfect blend versatility & comfort. The open flow concept of the main level offers an abundance of natural light, high ceilings, large windows & HW floors throughout. Updated kitchen, dining nook & family room areas. Easy deck/outside access. The formal dining room w/french doors & formal living room are perfect for holiday gatherings. Private laundry room, den & half bath complete the floor. The elegant staircase & upper hall welcome you to floor two where you will find the primary suite complete w/juliette balcony, WICs & spa like bathroom, 3 additional bedrooms w/DBL closets & lush carpets, a full bath & a finishable walk up attic. Close to all major routes & Boston.

This listing has been viewed 13 times in the past 29 days

Last Updated: November 11th, 2024 at 5:48am

Walk/jog Trails

Public School

Park

Public Transportation

Private School

Sidewalks

General Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Property TypeResidential

Property Sub TypeResidential

Price$1,675,000

Price per sqft$376.15

MLS #73307998

Handicap Access / FeaturesNo

List Date2024-10-30

List Price$1,675,000

Special Listing ConditionsNo

Specific Zoning CodeRes

StateMassachusetts

Street NameRoseanna Park Drive

Style

TownWaltham

CityWaltham

Zip Code02452

CountyMiddlesex

StatusPending

MLS Status

AssociationNo

Covered Parking Spaces2

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones2

Attached/DetachedYes

Sold Date11/12/2024

Green Energy EfficientThermostat

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourcePublic Records

Building Area Total4453

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces2

Listing Service

UnparsedAddress38 Roseanna Park Drive, Waltham MA 02452

Zoning

Interior Features for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Master BathYes

* Approx. Living Area Total4,453 sq ft

Living Area Includes BasementYes

* Living Area Source1

Bedrooms4

* # Fireplaces1

Bathrooms (Total)3.5

Full Baths3

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area DisclosureMeasurements are approximate

Living Area Includes BasementYes

Door FeaturesFrench Doors, Insulated Doors

ElectricYes

Electric$0

MLS Area (Major)Pigeon Hill

OffMarketDate09/11/2024

Pigeon Hill / Forest Street / Bentley

Exterior Features for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

* Approximate Lot Size0.39 acres

Covered Parking Spaces2

Lot FeaturesNo

* Parking Spaces4

* Sewer Utilities

* Water Utilities

* Year Built1997

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsFrame

Exterior Features

Foundation Area

Foundation MaterialsConcrete Perimeter

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)16,836 Sqft

Disclosures for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Buyer Agent Compensation

ContingencyPending P&S

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ON

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintNone

Living Area DisclosureMeasurements are approximate

Living Area Includes BasementYes

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

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,675,000

Lifestyle Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront FeaturesNo

Location information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Elementary SchoolNortheast

Middle SchoolKennedy

High SchoolWhs

Neighborhood/Sub-DivisionPigeon Hill / Forest Street / Bentley

Neighborhood (WPL, not MLS)

Marketing History for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

MLSPIN_MARKET_TIME_BROKER10

MLSPIN_MARKET_TIME_PROPERTY10

PurchaseContractDate2024-11-04

Agent Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Agent NameTeam Jill & Di

Agent MLS IDTM313535

Agent Phone #617-899-5606

Agent Phone Area

Office NameLamacchia Realty, Inc.

Office Phone781-786-8080

Office Phone Area

Office MLS IDAN2314

Buyer Agent MLS ID

Buyer Office MLS ID

Team MembersCT008218,BB301393

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 10320.82

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Team Jill & Di

Lamacchia Realty, Inc.

Agent Phone

(617) 899-5606

Office Phone

(781) 786-8080

Text Agent Call Agent Call Office

Array
(
    [id] => 560401
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73307998
    [mls_id_num] => 73307998
    [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] => 7135
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Middlesex
    [location4_name] => Waltham
    [location5_name] => Pigeon Hill / Forest Street / Bentley
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 1675000
    [price_unit] => 260
    [price_si] => 1675000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 4
    [bedrooms_max] => 0
    [rooms] => 9
    [rooms_max] => 0
    [bathrooms] => 3.5
    [bathrooms_max] => 0
    [living_area] => 4453
    [living_area_unit] => 1
    [living_area_si] => 414.129
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 0.39
    [lot_area_unit] => 1
    [lot_area_si] => 0.03627
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.39865900
    [googlemap_ln] => -71.22222200
    [geopoints] => �������霟�8�Q�ǠB3E@
    [finalized] => 1
    [add_date] => 2024-10-31 10:08:19
    [last_finalize_date] => 2024-11-11 05:48:21
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1997
    [zip_id] => 12883
    [zip_name] => 02452
    [last_modified_time_stamp] => 2024-11-29 16:28:26
    [post_code] => 
    [meta_description] => 4 Bedrooms Bedrooms 9 Rooms Rooms With 3.5 Bathrooms Bathrooms Residential For Sale Roseanna Park Drive In 38 Roseanna Park Drive, Waltham, Massachusetts 02452
    [meta_description_manual] => 0
    [meta_keywords] => 38 Roseanna Park Drive, Waltham, Massachusetts 02452, 4 Bedrooms Bedrooms, 9 Rooms Rooms,3.5 BathroomsBathrooms,Residential,For Sale,Roseanna Park Drive,73307998
    [meta_keywords_manual] => 0
    [street_no] => 38
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Welcome to 38 Roseanna Park Drive a custom built meticulously maintained 4453 sq.ft colonial that sits on 16836 sq.ft of pristine landscape in the heart of the prestigious Pigeon Hill Estates. Thoughtfully crafted, this home offers 4 bedrooms, 3.5 baths, bonus rooms, a finished basement & more! Designed to provide the perfect blend versatility & comfort. The open flow concept of the main level offers an abundance of natural light, high ceilings, large windows & HW floors throughout. Updated kitchen, dining nook & family room areas. Easy deck/outside access. The formal dining room w/french doors & formal living room are perfect for holiday gatherings. Private laundry room, den &  half bath complete the floor. The elegant staircase & upper hall welcome you to floor two where you will find the primary suite complete w/juliette balcony, WICs & spa like bathroom, 3 additional bedrooms w/DBL closets & lush carpets, a full bath & a finishable walk up attic. Close to all major routes & Boston.\n Property Type Residential Listing Type For Sale Ref ID 5033480606384924493c3b4cea9cdd80 Full Bathrooms 3 Full Bathrooms three Status Pending Property Category Residential Property Type Single Family C_Style Detached Zipcode 02452 Office Name Lamacchia Realty, Inc. Agent MLSID TM313535 Office Phone 781-786-8080 Agent Phone 617-899-5606 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 4 ParkingTotal four UnparsedAddress 38 Roseanna Park Drive, Waltham MA 02452 OpenParkingYN 1 OpenParkingYN one BRE_Total_Parking 6 BRE_Total_Parking six  38 roseanna park dr waltham massachusetts 02452 
    [location_text] => 38 Roseanna Park Drive, Waltham, Massachusetts 02452
    [field_42] => Roseanna Park Drive
    [field_312] => Residential For Sale - 9 Rooms - 4 Bedrooms - 3.5 Bathrooms - Price $1
    [field_313] => Residential For Sale
    [field_308] => Welcome to 38 Roseanna Park Drive a custom built meticulously maintained 4453 sq.ft colonial that sits on 16836 sq.ft of pristine landscape in the heart of the prestigious Pigeon Hill Estates. Thoughtfully crafted, this home offers 4 bedrooms, 3.5 baths, bonus rooms, a finished basement & more! Designed to provide the perfect blend versatility & comfort. The open flow concept of the main level offers an abundance of natural light, high ceilings, large windows & HW floors throughout. Updated kitchen, dining nook & family room areas. Easy deck/outside access. The formal dining room w/french doors & formal living room are perfect for holiday gatherings. Private laundry room, den &  half bath complete the floor. The elegant staircase & upper hall welcome you to floor two where you will find the primary suite complete w/juliette balcony, WICs & spa like bathroom, 3 additional bedrooms w/DBL closets & lush carpets, a full bath & a finishable walk up attic. Close to all major routes & Boston.
    [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,12,
    [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,18,15,13,
    [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] => ,6,
    [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,33,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] => 5033480606384924493c3b4cea9cdd80
    [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 - 9 Rooms - 4 Bedrooms - 3.5 Bathrooms - Price $1"},"3":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"2":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"materials":{"field_313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"field_312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 9 Rooms - 4 Bedrooms - 3.5 Bathrooms - Price $1"},"property_type":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"listing":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"field_55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"location_text":"38 Roseanna Park Drive, Waltham, Massachusetts 02452"}
    [alias] => Single-Family-38-Roseanna-Park-Drive-Waltham-Massachusetts-02452-73307998-USD1-675-000
    [source] => mls
    [last_sync_date] => 2024-11-11 05:48:10
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => Lamacchia Realty, Inc.
    [field_2112] => Team Jill & Di
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => TM313535
    [field_3001] => AN2314
    [listing_status] => 13
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 10
    [field_3072] => 0
    [field_3074] => Pigeon Hill
    [field_3075] => 2024-11-10 02:41:00
    [f_3102_options] => ,54,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 38 Roseanna Park Drive
    [field_3171] => 781-786-8080
    [field_3172] => 617-899-5606
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 4
    [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] => 1
    [field_3240] => 38 Roseanna Park Drive, Waltham MA 02452
    [f_3247_options] => ,18,
    [f_3247] => 1
    [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] => 28
    [visit_time] => 12
    [visit_date] => 2024-11-13 17:51:34
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,40,0,2,3,4,1,7,8,55,
    [f_3003] => 1
    [field_3004] => Whs
    [field_3005] => Northeast
    [f_3006_options] => ,0,17,3,18,21,
    [f_3006] => 1
    [f_3007_options] => ,2,
    [f_3007] => 1
    [f_3008_options] => ,756,
    [f_3008] => 1
    [f_3009_options] => ,5,12,44,13,4,28,10,14,
    [f_3009] => 1
    [f_3010_options] => ,31,41,16,101,88,54,45,131,35,142,150,51,47,27,2,11,12,
    [f_3010] => 1
    [field_3011] => 1287100
    [field_3011_si] => 1287100
    [field_3011_unit] => 260
    [field_3017] => Kennedy
    [field_3018] => 42
    [field_3019] => 2024-10-30 21:23:43
    [field_3020] => 14
    [field_3021] => Appointment Required,Schedule with ShowingTime or 
    [field_3022] => 
    [field_3023] => 9854.27
    [field_3023_si] => 9854.27
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,0,
    [f_3025] => 1
    [field_3027] => 6
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => Res
    [field_3039] => Forest Street to Harrington to Roseanna Park Drive
    [field_3043] => 2024-12-11
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 
    [field_3060] => Pending P&S
    [field_3069] => 376.15
    [field_3069_si] => 376.15
    [field_3069_unit] => 260
    [field_3079] => 2024-11-10 02:41:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 38
    [field_3096] => 
    [field_3097] => CT008218,BB301393
    [field_3098] => 
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 2
    [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] => 2
    [field_3134] => 1
    [field_3135] => 
    [field_3136] => 
    [field_3140] => MWRA
    [field_3145] => 
    [field_3151] => 
    [field_3156] => Measurements are 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] => 1
    [field_3183] => 4453
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,7,0,17,4,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] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [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] => 1
    [field_3208] => 0
    [field_3209] => Concrete Perimeter
    [field_3210] => 
    [field_3211] => 2
    [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-30
    [field_3224] => 
    [f_3225_options] => ,27,
    [f_3225] => 1
    [field_3226_si] => 1565.748
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 2024-11-09
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 1675000
    [field_3231_si] => 1675000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Buyers Agents must accompany all buyers during pri
    [field_3237] => 2024-11-04
    [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-10-30 21:20: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] => AN2314
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 10
    [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] => 376.15
    [field_3290_si] => 376.15
    [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] => [{"id":"CT008218","name":"Jill Hogan","phone":"617
    [f_3304_options] => ,22,
    [f_3304] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 16836
)

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

[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° 46' 40'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => Lamacchia Realty, Inc.
        )

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

[field_3043] => Array
        (
            [field_id] => 3043
            [type] => date
            [name] => ANT_SOLD_DATE
            [value] => 11/12/2024
        )

[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_3060] => Array
        (
            [field_id] => 3060
            [type] => text
            [name] => CONTINGENCY_TYPE
            [value] => Pending P&S
        )

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

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

[field_3072] => Array
        (
            [field_id] => 3072
            [type] => number
            [name] => MARKET_TIME_BROKER_PREV
            [value] => 0
        )

[field_3074] => Array
        (
            [field_id] => 3074
            [type] => text
            [name] => AREA
            [value] => Pigeon Hill
        )

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 10/11/2024 02:41: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] => 38
        )

[field_3097] => Array
        (
            [field_id] => 3097
            [type] => text
            [name] => TEAM_MEMBER
            [value] => CT008218,BB301393
        )

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => Array
                (
                    [0] => No
                )

)

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

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

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

[field_3140] => Array
        (
            [field_id] => 3140
            [type] => text
            [name] => SEWAGE_DISTRICT
            [value] => MWRA
        )

[field_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => Measurements are 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] => 781-786-8080
        )

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

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

[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] => Park
                    [3] => Public Transportation
                    [4] => Private School
                    [5] => 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
        )

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

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

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

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 16,836 Sqft
            [raw] => 16836
            [unit_id] => 1
        )

[field_3229] => Array
        (
            [field_id] => 3229
            [type] => date
            [name] => OffMarketDate
            [value] => 09/11/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] => 1675000
            [unit_id] => 260
            [value] => $1,675,000
            [price_only] => $1,675,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Buyers Agents must accompany all buyers during pri
        )

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

[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] => 38 Roseanna Park Drive, Waltham MA 02452
        )

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

[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] => 30/10/2024 21:20: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] => AN2314
        )

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

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

[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_3303] => Array
        (
            [field_id] => 3303
            [type] => text
            [name] => Co Agent Info
            [value] => [{"id":"CT008218","name":"Jill Hogan","phone":"617
        )

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

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

)

EXIT

40 More Photos

Pending

38 Roseanna Park Drive Waltham. MA 02452

$1,675,000

General Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Interior Features for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Exterior Features for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Disclosures for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Financial Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Lifestyle Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Location information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Marketing History for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Agent Information for 38 Roseanna Park Drive, Waltham, Massachusetts 02452

Payment Calculator

Exclusive Listing Agent

Team Jill & Di

Lamacchia Realty, Inc.