Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Withdrawn

37 Sunset Rock Road Andover. MA 01810

$2,995,000

Single Family

5 Bedrooms

7 Bathrooms

5,490 sq ft

4 Parking Spots

0.7 Acres

Built in 2024

Set on an idyllic lot across from Pike School, this stunning colonial is set to break ground this spring. Offering an expansive foot print, this home illuminates exquisite millwork, timeless architectural details & designer finishes. The spacious & inviting floor plan is ideal for entertaining & modern day living. Convenient 4 car garage leads to mudroom with built ins. Open concept kitchen outfitted with top of the line appliances & an eat in kitchen area opens to a large family room. Home office, formal dining room, living room, and two half baths complete the first level. Upstairs find 5 spacious bedrooms, each with an ensuite bath & walk in closet. The primary suite features two walk in closets & a spa like bath with tile shower & soaking tub. Find even more space in walkout lower level. DON’T MISS YOUR OPPORTUNITY TO CUSTOMIZE THIS HOME WITH ONE OF ANDOVER’S MOST PREMIER BUILDERS.

This listing has been viewed 28 times in the past 212 days

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

Walk/jog Trails

Highway Access

House Of Worship

Public School

Shopping

Golf

Park

Public Transportation

T-station

Private School

General Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Property TypeResidential

Property Sub TypeResidential

Price$2,995,000

Price per sqft$545.54

MLS #73216357

Handicap Access / FeaturesNo

List Date2024-03-26

List Price$2,995,000

Special Listing ConditionsNo

Specific Zoning CodeSRC

StateMassachusetts

Street NameSunset Rock Road

Style

TownAndover

CityAndover

Zip Code01810

CountyEssex

StatusWithdrawn

MLS Status

AssociationNo

Covered Parking Spaces4

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones

Attached/DetachedYes

Sold Date

Green Energy EfficientThermostat

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourceOwner

Building Area Total5490

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces4

Listing Service

UnparsedAddress37 Sunset Rock Road, Andover MA 01810

Zoning

Interior Features for 37 Sunset Rock Road, Andover, Massachusetts 01810

Master BathYes

* Approx. Living Area Total5,490 sq ft

Living Area Includes BasementNo

* Living Area Source4

Bedrooms5

* # Fireplaces2

Bathrooms (Total)7

Full Baths6

* # Half Baths2

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosureper builder. subject to change. Addt'l 1565 sq ft

Living Area Includes BasementNo

Door FeaturesInsulated Doors

ElectricYes

Electric$0

MLS Area (Major)South Andover

OffMarketDate29/08/2024

Exterior Features for 37 Sunset Rock Road, Andover, Massachusetts 01810

* Approximate Lot Size0.7 acres

Covered Parking Spaces4

Lot FeaturesCul-de-sac, Wooded

* 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)30,491 Sqft

Disclosures for 37 Sunset Rock Road, Andover, Massachusetts 01810

Buyer Agent Compensation2.5

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ONGross/full Sale Price

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintNone

Living Area Disclosureper builder. subject to change. Addt'l 1565 sq ft

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation2.0

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

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

Lifestyle Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront FeaturesNo

Location information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Elementary SchoolSouth

Middle SchoolDoherty

High SchoolAndover Hs

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 37 Sunset Rock Road, Andover, Massachusetts 01810

MLSPIN_MARKET_TIME_BROKER156

MLSPIN_MARKET_TIME_PROPERTY156

PurchaseContractDate

Agent Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Agent NameThe Deborah Lucci Team

Agent MLS IDTM309944

Agent Phone #

Agent Phone Area

Office NameWilliam Raveis R.E. & Home Services

Office Phone978-475-5100

Office Phone Area

Office MLS IDAN0949

Buyer Agent MLS ID

Buyer Office MLS ID

Team MembersCN247348,CN238795

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 18454.24

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

The Deborah Lucci Team

William Raveis R.E. & Home Services

Agent Phone

Office Phone

(978) 475-5100

Text Agent Call Agent Call Office

Array
(
    [id] => 300135
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73216357
    [mls_id_num] => 73216357
    [parent] => 0
    [pic_numb] => 22
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 12
    [location4_id] => 163
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Essex
    [location4_name] => Andover
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 2995000
    [price_unit] => 260
    [price_si] => 2995000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 5
    [bedrooms_max] => 0
    [rooms] => 12
    [rooms_max] => 0
    [bathrooms] => 7
    [bathrooms_max] => 0
    [living_area] => 5490
    [living_area_unit] => 1
    [living_area_si] => 510.57
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 0.7
    [lot_area_unit] => 1
    [lot_area_si] => 0.0651
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.63179500
    [googlemap_ln] => -71.13565700
    [geopoints] => �������M�����Q�^c���PE@
    [finalized] => 1
    [add_date] => 2024-04-27 06:51:13
    [last_finalize_date] => 2024-10-07 20:35:12
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 2024
    [zip_id] => 256
    [zip_name] => 01810
    [last_modified_time_stamp] => 2024-10-14 14:03:44
    [post_code] => 
    [meta_description] => 5 Bedrooms Bedrooms 12 Rooms Rooms With 7 Bathrooms Bathrooms Residential For Sale Sunset Rock Road In 37 Sunset Rock Road, Andover, Massachusetts 01810
    [meta_description_manual] => 0
    [meta_keywords] => 37 Sunset Rock Road, Andover, Massachusetts 01810, 5 Bedrooms Bedrooms, 12 Rooms Rooms,7 BathroomsBathrooms,Residential,For Sale,Sunset Rock Road,73216357
    [meta_keywords_manual] => 0
    [street_no] => 37
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Set on an idyllic lot across from Pike School, this stunning colonial is set to break ground this spring. Offering an expansive foot print, this home illuminates exquisite millwork, timeless architectural details & designer finishes. The spacious & inviting floor plan is ideal for entertaining & modern day living. Convenient 4 car garage leads to mudroom with built ins. Open concept kitchen outfitted with top of the line appliances & an eat in kitchen area opens to a large family room. Home office, formal dining room, living room, and two half baths complete the first level. Upstairs find 5 spacious bedrooms, each with an ensuite bath & walk in closet. The primary suite features two walk in closets & a spa like bath with tile shower & soaking tub. Find even more space in walkout lower level. DON’T MISS YOUR OPPORTUNITY TO CUSTOMIZE THIS HOME WITH ONE OF ANDOVER’S MOST PREMIER BUILDERS.\n Property Type Residential Listing Type For Sale Ref ID 76086e147ccccc8b722cd2e8b3764d10 Full Bathrooms 6 Full Bathrooms six Status Withdrawn Property Category Residential Property Type Single Family C_Style Detached Zipcode 01810 Office Name William Raveis R.E. & Home Services Agent MLSID TM309944 Office Phone 978-475-5100 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 4 ParkingTotal four UnparsedAddress 37 Sunset Rock Road, Andover MA 01810 OpenParkingYN 1 OpenParkingYN one  37 sunset rock rd andover massachusetts 01810 
    [location_text] => 37 Sunset Rock Road, Andover, Massachusetts 01810
    [field_42] => Sunset Rock Road
    [field_312] => Residential For Sale - 12 Rooms - 5 Bedrooms - 7 Bathrooms - Price $2,
    [field_313] => Residential For Sale
    [field_308] => Set on an idyllic lot across from Pike School, this stunning colonial is set to break ground this spring. Offering an expansive foot print, this home illuminates exquisite millwork, timeless architectural details & designer finishes. The spacious & inviting floor plan is ideal for entertaining & modern day living. Convenient 4 car garage leads to mudroom with built ins. Open concept kitchen outfitted with top of the line appliances & an eat in kitchen area opens to a large family room. Home office, formal dining room, living room, and two half baths complete the first level. Upstairs find 5 spacious bedrooms, each with an ensuite bath & walk in closet. The primary suite features two walk in closets & a spa like bath with tile shower & soaking tub. Find even more space in walkout lower level. DON’T MISS YOUR OPPORTUNITY TO CUSTOMIZE THIS HOME WITH ONE OF ANDOVER’S MOST PREMIER BUILDERS.
    [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,
    [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,15,16,
    [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,15,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] => 76086e147ccccc8b722cd2e8b3764d10
    [field_54] => 
    [half_bathrooms] => 2
    [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 - 12 Rooms - 5 Bedrooms - 7 Bathrooms - Price $2,"},"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 - 12 Rooms - 5 Bedrooms - 7 Bathrooms - Price $2,"},"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":"37 Sunset Rock Road, Andover, Massachusetts 01810"}
    [alias] => Single-Family-37-Sunset-Rock-Road-Andover-Massachusetts-01810-73216357-USD2-995-000
    [source] => mls
    [last_sync_date] => 2024-10-07 20:34:59
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 14
    [field_2111] => William Raveis R.E. & Home Services
    [field_2112] => The Deborah Lucci Team
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => TM309944
    [field_3001] => AN0949
    [listing_status] => 14
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 156
    [field_3072] => 0
    [field_3074] => South Andover
    [field_3075] => 2024-08-29 22:25:00
    [f_3102_options] => ,54,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 37 Sunset Rock Road
    [field_3171] => 978-475-5100
    [field_3172] => 
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 5
    [field_3176] => 6
    [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] => 37 Sunset Rock Road, Andover MA 01810
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 2.5
    [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] => 88
    [visit_time] => 27
    [visit_date] => 2024-11-22 19:28:41
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,74,0,37,2,3,4,1,15,29,32,
    [f_3003] => 1
    [field_3004] => Andover Hs
    [field_3005] => South
    [f_3006_options] => ,0,3,21,19,
    [f_3006] => 1
    [f_3007_options] => ,14,17,
    [f_3007] => 1
    [f_3008_options] => ,9,
    [f_3008] => 1
    [f_3009_options] => ,15,18,44,13,4,63,
    [f_3009] => 1
    [f_3010_options] => ,46,16,115,32,37,38,26,44,17,53,29,27,12,
    [f_3010] => 1
    [field_3011] => 0
    [field_3011_si] => 0
    [field_3011_unit] => 260
    [field_3017] => Doherty
    [field_3018] => 22
    [field_3019] => 2024-03-28 22:19:09
    [field_3020] => 14
    [field_3021] => Accompanied Showings,Appointment Required,Sign,App
    [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] => 323
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => SRC
    [field_3039] => S Main St to Ballardvale to Sunset Rock Rd. Diagon
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 0
    [field_3060] => 
    [field_3069] => 545.54
    [field_3069_si] => 545.54
    [field_3069_unit] => 260
    [field_3079] => 2024-08-29 22:25:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 37
    [field_3096] => 
    [field_3097] => CN247348,CN238795
    [field_3098] => 2.0
    [field_3105] => 
    [field_3109] => 2
    [field_3112] => 
    [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] => ,16,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 
    [field_3134] => 0
    [field_3135] => 2
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => per builder. subject to change. Addt'l 1565 sq ft 
    [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] => 5490
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,5,7,0,6,2,3,17,4,12,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,0,
    [f_3190] => 1
    [field_3193] => 4
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [field_3197] => 
    [f_3198_options] => ,0,
    [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] => 4
    [field_3213] => 
    [field_3214] => Thermostat
    [field_3215] => 
    [field_3216] => 0
    [field_3216_si] => 0
    [field_3216_unit] => 260
    [field_3218] => 
    [field_3220] => 0
    [field_3220_si] => 0
    [field_3220_unit] => 260
    [field_3221] => 
    [field_3222] => Exclusive Right To Sell
    [field_3223] => 2024-03-26
    [field_3224] => 
    [f_3225_options] => ,10,7,
    [f_3225] => 1
    [field_3226_si] => 2835.663
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 2024-08-29
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 2995000
    [field_3231_si] => 2995000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Do not walk walk lot w/o listing agents present. C
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => To Be Built,Under Construction
    [field_3244] => 
    [field_3245] => Builder
    [field_3246] => 
    [field_3248] => 2024-03-26 13:32: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] => M59500
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 156
    [field_3281] => 0
    [field_3281_si] => 0
    [field_3281_unit] => 260
    [field_3282] => 0
    [field_3282_si] => 0
    [field_3282_unit] => 260
    [field_3283] => 
    [field_3284] => 
    [field_3285] => 0
    [field_3285_si] => 0
    [field_3285_unit] => 260
    [field_3286] => 
    [field_3287] => 
    [field_3288] => 
    [field_3289] => 
    [field_3290] => 545.54
    [field_3290_si] => 545.54
    [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":"CN247348","name":"Leah Cormier","phone":"9
    [f_3304_options] => ,22,
    [f_3304] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 30491
)

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

[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° 51' 51.6'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => William Raveis R.E. & Home Services
        )

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

[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] => Gross/full Sale Price
        )

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

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

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

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 29/08/2024 22:25: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] => 37
        )

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

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

)

[field_3109] => Array
        (
            [field_id] => 3109
            [type] => number
            [name] => FIRE_PLACES
            [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] => No
                )

)

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

[field_3135] => Array
        (
            [field_id] => 3135
            [type] => select
            [name] => WARRANTY
            [value] => 1
        )

[field_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => per builder. subject to change. Addt'l 1565 sq ft 
        )

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

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

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

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Walk/jog Trails
                    [1] => Highway Access
                    [2] => House Of Worship
                    [3] => Public School
                    [4] => Shopping
                    [5] => Golf
                    [6] => Park
                    [7] => Public Transportation
                    [8] => T-station
                    [9] => Private School
                )

)

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

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

)

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

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

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

[field_3216] => Array
        (
            [field_id] => 3216
            [type] => price
            [name] => GrossIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3217] => Array
        (
            [field_id] => 3217
            [type] => select
            [name] => HeatingYN
            [value] => 1
        )

[field_3220] => Array
        (
            [field_id] => 3220
            [type] => price
            [name] => InsuranceExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3222] => Array
        (
            [field_id] => 3222
            [type] => text
            [name] => ListingAgreement
            [value] => Exclusive Right To Sell
        )

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

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

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 30,491 Sqft
            [raw] => 30491
            [unit_id] => 1
        )

[field_3229] => Array
        (
            [field_id] => 3229
            [type] => date
            [name] => OffMarketDate
            [value] => 29/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] => 2995000
            [unit_id] => 260
            [value] => $2,995,000
            [price_only] => $2,995,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Do not walk walk lot w/o listing agents present. C
        )

[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] => 37 Sunset Rock Road, Andover MA 01810
        )

[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] => To Be Built,Under Construction
        )

[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] => 26/03/2024 13:32: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] => M59500
        )

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

[field_3281] => Array
        (
            [field_id] => 3281
            [type] => price
            [name] => MLSPIN_MGF
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3282] => Array
        (
            [field_id] => 3282
            [type] => price
            [name] => MLSPIN_MSE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3285] => Array
        (
            [field_id] => 3285
            [type] => price
            [name] => MLSPIN_OPTIONAL_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3290] => Array
        (
            [field_id] => 3290
            [type] => price
            [name] => MLSPIN_PRICE_PER_SQFT
            [raw] => 545.54
            [unit_id] => 260
            [value] => $546
            [price_only] => $546
        )

[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":"CN247348","name":"Leah Cormier","phone":"9
        )

[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

20 More Photos

Withdrawn

37 Sunset Rock Road Andover. MA 01810

$2,995,000

General Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Interior Features for 37 Sunset Rock Road, Andover, Massachusetts 01810

Exterior Features for 37 Sunset Rock Road, Andover, Massachusetts 01810

Disclosures for 37 Sunset Rock Road, Andover, Massachusetts 01810

Financial Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Lifestyle Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Location information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Marketing History for 37 Sunset Rock Road, Andover, Massachusetts 01810

Agent Information for 37 Sunset Rock Road, Andover, Massachusetts 01810

Payment Calculator

Exclusive Listing Agent

The Deborah Lucci Team

William Raveis R.E. & Home Services