Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

246 Yew Street Douglas. MA 01516

$420,000

Single Family

3 Bedrooms

2.5 Bathrooms

1,742 sq ft

2 Parking Spots

1.55 Acres

Built in 1750

Great opportunity for investors, contractors, flippers or lovers of older homes! Don’t miss the chance to make this home yours while keeping the 1700’s charm and detail. Offering over 1,700+ sqft and settled on over 1.5 acres (An extra lot abuts, making a total of 2.5 acres!), this home was built for the entertainer and homesteader in mind. Spacious kitchen gives you an incredible opportunity to add tons of cabinetry. Formal living room has a gorgeous stone mantle, beamed ceilings and stunning wood flooring. Wood deck overlooks the private corner lot surrounded by mature trees making this home an absolute dream. The roof and windows are all in good condition. All mechanicals are in good working order. MassSave checked, insulation added. A large well-kept yard and original stone walls provide a classic country road view. An extra lot abuts, making a total of 2.5 acres. Just mins from Blissful Meadows Golf Club, Rt 16, Rt 146, Rt 96 and more. Will not pass FHA/VA financing. Sold AS IS.

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

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

General Information for 246 Yew Street, Douglas, Massachusetts 01516

Property TypeResidential

Property Sub TypeResidential

Price$420,000

Price per sqft$241.10

MLS #73308230

Handicap Access / FeaturesYes

List Date2024-10-31

List Price$420,000

Special Listing ConditionsNo

Specific Zoning CodeRA

StateMassachusetts

Street NameYew Street

Style

TownDouglas

CityDouglas

Zip Code01516

CountyWorcester

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces0

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones1

Attached/DetachedNo

Sold Date

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourcePublic Records

Building Area Total1742

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces0

Listing Service

UnparsedAddress246 Yew Street, Douglas MA 01516

Zoning

Interior Features for 246 Yew Street, Douglas, Massachusetts 01516

Master BathYes

* Approx. Living Area Total1,742 sq ft

Living Area Includes BasementNo

* Living Area Source1

Bedrooms3

* # Fireplaces1

Bathrooms (Total)2.5

Full Baths2

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosure

Living Area Includes BasementNo

Door FeaturesNo

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate

Exterior Features for 246 Yew Street, Douglas, Massachusetts 01516

* Approximate Lot Size1.55 acres

Covered Parking Spaces0

Lot FeaturesCorner Lot, Other

* Parking Spaces2

* Sewer Utilities

* Water Utilities

* Year Built1750

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsNo

Exterior Features

Foundation Area

Foundation MaterialsStone,Other

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)67,518 Sqft

Disclosures for 246 Yew Street, Douglas, Massachusetts 01516

Buyer Agent Compensation

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ON

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintUnknown

Living Area Disclosure

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 246 Yew Street, Douglas, Massachusetts 01516

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

Lifestyle Information for 246 Yew Street, Douglas, Massachusetts 01516

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront FeaturesNo

Location information for 246 Yew Street, Douglas, Massachusetts 01516

Elementary School

Middle School

High School

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 246 Yew Street, Douglas, Massachusetts 01516

MLSPIN_MARKET_TIME_BROKER4

MLSPIN_MARKET_TIME_PROPERTY4

PurchaseContractDate

Agent Information for 246 Yew Street, Douglas, Massachusetts 01516

Agent NameCharles Jolin

Agent MLS IDCN207699

Agent Phone #508-208-6941

Agent Phone Area

Office NameKeller Williams Realty

Office Phone508-238-5000

Office Phone Area

Office MLS IDBB4624

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 2587.91

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Charles Jolin

Keller Williams Realty

Agent Phone

(508) 208-6941

Office Phone

(508) 238-5000

Text Agent Call Agent Call Office

Array
(
    [id] => 560585
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73308230
    [mls_id_num] => 73308230
    [parent] => 0
    [pic_numb] => 40
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 6
    [location4_id] => 26
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Worcester
    [location4_name] => Douglas
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 420000
    [price_unit] => 260
    [price_si] => 420000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 3
    [bedrooms_max] => 0
    [rooms] => 7
    [rooms_max] => 0
    [bathrooms] => 2.5
    [bathrooms_max] => 0
    [living_area] => 1742
    [living_area_unit] => 1
    [living_area_si] => 162.006
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 1.55
    [lot_area_unit] => 1
    [lot_area_si] => 0.14415
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.04757100
    [googlemap_ln] => -71.70006600
    [geopoints] => �����������Q�w�x�E@
    [finalized] => 1
    [add_date] => 2024-10-31 19:08:13
    [last_finalize_date] => 2024-11-05 05:48:34
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1750
    [zip_id] => 546
    [zip_name] => 01516
    [last_modified_time_stamp] => 2024-11-05 12:13:44
    [post_code] => 
    [meta_description] => 3 Bedrooms Bedrooms 7 Rooms Rooms With 2.5 Bathrooms Bathrooms Residential For Sale Yew Street In 246 Yew Street, Douglas, Massachusetts 01516
    [meta_description_manual] => 0
    [meta_keywords] => 246 Yew Street, Douglas, Massachusetts 01516, 3 Bedrooms Bedrooms, 7 Rooms Rooms,2.5 BathroomsBathrooms,Residential,For Sale,Yew Street,73308230
    [meta_keywords_manual] => 0
    [street_no] => 246
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Great opportunity for investors, contractors, flippers or lovers of older homes! Don’t miss the chance to make this home yours while keeping the 1700’s charm and detail. Offering over 1,700+ sqft and settled on over 1.5 acres (An extra lot abuts, making a total of 2.5 acres!), this home was built for the entertainer and homesteader in mind. Spacious kitchen gives you an incredible opportunity to add tons of cabinetry. Formal living room has a gorgeous stone mantle, beamed ceilings and stunning wood flooring. Wood deck overlooks the private corner lot surrounded by mature trees making this home an absolute dream. The roof and windows are all in good condition. All mechanicals are in good working order. MassSave checked, insulation added.  A large well-kept yard and original stone walls provide a classic country road view. An extra lot abuts, making a total of 2.5 acres. Just mins from Blissful Meadows Golf Club, Rt 16, Rt 146, Rt 96 and more. Will not pass FHA/VA financing. Sold AS IS.\n Property Type Residential Listing Type For Sale Ref ID f0d1d29ecee389d360bdb63cd4502327 Full Bathrooms 2 Full Bathrooms two Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 01516 Office Name Keller Williams Realty Agent MLSID CN207699 Office Phone 508-238-5000 Agent Phone 508-208-6941 CoolingYN 1 CoolingYN one ParkingTotal 2 ParkingTotal two UnparsedAddress 246 Yew Street, Douglas MA 01516 OpenParkingYN 1 OpenParkingYN one BRE_Total_Parking 2 BRE_Total_Parking two  246 yew st douglas massachusetts 01516 
    [location_text] => 246 Yew Street, Douglas, Massachusetts 01516
    [field_42] => Yew Street
    [field_312] => Residential For Sale - 7 Rooms - 3 Bedrooms - 2.5 Bathrooms - Price $4
    [field_313] => Residential For Sale
    [field_308] => Great opportunity for investors, contractors, flippers or lovers of older homes! Don’t miss the chance to make this home yours while keeping the 1700’s charm and detail. Offering over 1,700+ sqft and settled on over 1.5 acres (An extra lot abuts, making a total of 2.5 acres!), this home was built for the entertainer and homesteader in mind. Spacious kitchen gives you an incredible opportunity to add tons of cabinetry. Formal living room has a gorgeous stone mantle, beamed ceilings and stunning wood flooring. Wood deck overlooks the private corner lot surrounded by mature trees making this home an absolute dream. The roof and windows are all in good condition. All mechanicals are in good working order. MassSave checked, insulation added.  A large well-kept yard and original stone walls provide a classic country road view. An extra lot abuts, making a total of 2.5 acres. Just mins from Blissful Meadows Golf Club, Rt 16, Rt 146, Rt 96 and more. Will not pass FHA/VA financing. Sold AS IS.
    [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] => ,26,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,18,
    [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] => ,21,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,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] => f0d1d29ecee389d360bdb63cd4502327
    [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 - 7 Rooms - 3 Bedrooms - 2.5 Bathrooms - Price $4"},"3":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"2":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"materials":{"field_313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"field_312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 7 Rooms - 3 Bedrooms - 2.5 Bathrooms - Price $4"},"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":"246 Yew Street, Douglas, Massachusetts 01516"}
    [alias] => Single-Family-246-Yew-Street-Douglas-Massachusetts-01516-73308230-USD420-000
    [source] => mls
    [last_sync_date] => 2024-11-05 05:48:16
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => Keller Williams Realty
    [field_2112] => Charles Jolin
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => CN207699
    [field_3001] => BB4624
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 4
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-11-04 08:05:00
    [f_3102_options] => ,54,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 246 Yew Street
    [field_3171] => 508-238-5000
    [field_3172] => 508-208-6941
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 2
    [field_3177] => 0
    [field_3180] => 
    [field_3181] => 
    [field_3191] => 0
    [field_3192] => 2
    [field_3212] => 
    [field_3217] => 0
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 246 Yew Street, Douglas MA 01516
    [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] => 2
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 57
    [visit_time] => 7
    [visit_date] => 2024-11-13 05:10:26
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,40,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,4,
    [f_3006] => 1
    [f_3007_options] => ,2,14,
    [f_3007] => 1
    [f_3008_options] => ,0,
    [f_3008] => 1
    [f_3009_options] => ,67,
    [f_3009] => 1
    [f_3010_options] => ,27,49,
    [f_3010] => 1
    [field_3011] => 360500
    [field_3011_si] => 360500
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 40
    [field_3019] => 2024-10-31 15:45:58
    [field_3020] => 12
    [field_3021] => Schedule with ShowingTime or Call 888-627-2775,Sel
    [field_3022] => 
    [field_3023] => 4874
    [field_3023_si] => 4874
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,5,10,
    [f_3025] => 1
    [field_3027] => 1
    [field_3028] => 8
    [field_3029] => 0
    [field_3032] => RA
    [field_3039] => Take MA-16 to Yew St in Douglas
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 
    [field_3060] => 
    [field_3069] => 241.1
    [field_3069_si] => 241.1
    [field_3069_unit] => 260
    [field_3079] => 2024-10-31 14:24:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 246
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 1
    [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] => 0
    [field_3134] => 0
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => 
    [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] => 1742
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,22,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,24,
    [f_3190] => 1
    [field_3193] => 0
    [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] => Stone,Other
    [field_3210] => 
    [field_3211] => 0
    [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-10-31
    [field_3224] => 
    [f_3225_options] => ,6,5,
    [f_3225] => 1
    [field_3226_si] => 6279.174
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 420000
    [field_3231_si] => 420000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => *fireplaces not used.  Believe chimney work is nee
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Actual
    [field_3244] => 
    [field_3245] => Public Records
    [field_3246] => 
    [field_3248] => 2024-10-31 14:24: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] => Unknown
    [field_3273] => 
    [field_3274] => 
    [field_3275] => 
    [field_3276] => 
    [field_3277] => BB4624
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 4
    [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] => 241.1
    [field_3290_si] => 241.1
    [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] => 67518
)

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

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

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

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

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

[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° 17' 59.8'' 
        )

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

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

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

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

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

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

[field_3094] => Array
        (
            [field_id] => 3094
            [type] => price
            [name] => SOLD_PRICE_PER_SQFT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3095] => Array
        (
            [field_id] => 3095
            [type] => number
            [name] => STREET_NUM
            [value] => 246
        )

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

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

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

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

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 508-208-6941
        )

[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_3182] => Array
        (
            [field_id] => 3182
            [type] => select
            [name] => BuildingAreaSource
            [value] => Public Records
        )

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

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

)

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

)

[field_3191] => Array
        (
            [field_id] => 3191
            [type] => select
            [name] => CoolingYN
            [value] => 1
        )

[field_3192] => Array
        (
            [field_id] => 3192
            [type] => number
            [name] => ParkingTotal
            [value] => 2
        )

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

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

[field_3211] => Array
        (
            [field_id] => 3211
            [type] => number
            [name] => GarageSpaces
            [value] => 0
        )

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

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

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 67,518 Sqft
            [raw] => 67518
            [unit_id] => 1
        )

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

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

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => *fireplaces not used.  Believe chimney work is nee
        )

[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] => 246 Yew Street, Douglas MA 01516
        )

[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] => 31/10/2024 14:24: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] => Unknown
        )

[field_3277] => Array
        (
            [field_id] => 3277
            [type] => text
            [name] => MLSPIN_MAIN_LO
            [value] => BB4624
        )

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

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

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

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

)

EXIT

38 More Photos

Active

246 Yew Street Douglas. MA 01516

$420,000

General Information for 246 Yew Street, Douglas, Massachusetts 01516

Interior Features for 246 Yew Street, Douglas, Massachusetts 01516

Exterior Features for 246 Yew Street, Douglas, Massachusetts 01516

Disclosures for 246 Yew Street, Douglas, Massachusetts 01516

Financial Information for 246 Yew Street, Douglas, Massachusetts 01516

Lifestyle Information for 246 Yew Street, Douglas, Massachusetts 01516

Location information for 246 Yew Street, Douglas, Massachusetts 01516

Marketing History for 246 Yew Street, Douglas, Massachusetts 01516

Agent Information for 246 Yew Street, Douglas, Massachusetts 01516

Payment Calculator

Exclusive Listing Agent

Charles Jolin

Keller Williams Realty