Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Pending

296 Yew St Douglas. MA 01516

$499,900

Single Family

1 Bedrooms

2 Bathrooms

594 sq ft

10 Parking Spots

2.08 Acres

Built in 1992

Over 20 Acres of farmland! Nestled in the heart of the picturesque Town of Douglas, this exceptional property offers a rare and compelling opportunity to own a one-bedroom home accompanied by a vast expanse of fertile farmland, complete with barn and bonus room above. This unique offering is a harmonious blend of modern comfort and the timeless allure of rural living. This charming one-bedroom residence boasts a seamless fusion of classic architecture and contemporary design. With its open floor plan and abundant natural light, this home exudes warmth. The spacious bedroom is a tranquil sanctuary, and the living area is an inviting space for relaxation. Step outside onto the patio, where you can savor the serene surroundings and appreciate the beauty of your land. Encompassing acres of fertile, sun-kissed land, this property is a haven for agricultural enthusiasts and nature lovers alike.

This listing has been viewed 21 times in the past 210 days

Last Updated: October 25th, 2024 at 8:28am

Walk/jog Trails

Conservation Area

Highway Access

Public School

Park

Bike Path

Stable(s)

General Information for 296 Yew St, Douglas, Massachusetts 01516

Property TypeResidential

Property Sub TypeResidential

Price$499,900

Price per sqft$841.58

MLS #73162724

Handicap Access / FeaturesNo

List Date2023-09-22

List Price$499,900

Special Listing ConditionsNo

Specific Zoning CodeRA

StateMassachusetts

Street NameYew St

Style

TownDouglas

CityDouglas

Zip Code01516

CountyWorcester

StatusPending

MLS Status

AssociationNo

Covered Parking Spaces0

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones

Attached/DetachedNo

Sold Date29/11/2024

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleFarm

Building Area SourcePublic Records

Building Area Total594

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces0

Listing Service

UnparsedAddress296 Yew St, Douglas MA 01516

Zoning

Interior Features for 296 Yew St, Douglas, Massachusetts 01516

Master BathYes

* Approx. Living Area Total594 sq ft

Living Area Includes BasementNo

* Living Area Source1

Bedrooms1

* # Fireplaces2

Bathrooms (Total)2

Full Baths2

* # Half Baths0

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosure

Living Area Includes BasementNo

Door FeaturesInsulated Doors

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate22/11/2023

Exterior Features for 296 Yew St, Douglas, Massachusetts 01516

* Approximate Lot Size2.08 acres

Covered Parking Spaces0

Lot FeaturesCleared, Farm, Wooded

* Parking Spaces10

* Sewer Utilities

* Water Utilities

* Year Built1992

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsFrame, Log

Exterior Features

Foundation Area440

Foundation MaterialsConcrete Perimeter

Approx. Street Frontage200.00

Horse PermittedYes

Horse AmenitiesPaddocks

Parking Features

Utilities

Lot Size (Square Feet)90,648 Sqft

Disclosures for 296 Yew St, Douglas, Massachusetts 01516

Buyer Agent Compensation2.5

ContingencyPending P&S

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ONNet Sale Price

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREY

Lead PaintNone

Living Area Disclosure

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation2

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 296 Yew St, 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$499,900

Lifestyle Information for 296 Yew St, Douglas, Massachusetts 01516

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront FeaturesNo

Location information for 296 Yew St, Douglas, Massachusetts 01516

Elementary School

Middle School

High School

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 296 Yew St, Douglas, Massachusetts 01516

MLSPIN_MARKET_TIME_BROKER62

MLSPIN_MARKET_TIME_PROPERTY62

PurchaseContractDate2023-11-09

Agent Information for 296 Yew St, Douglas, Massachusetts 01516

Agent NameTracy Sharkey

Agent MLS IDCT003405

Agent Phone #774-280-1505

Agent Phone Area

Office NameSharkey Realty

Office Phone774-280-1505

Office Phone Area

Office MLS IDAN7243

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 3080.22

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Tracy Sharkey

Sharkey Realty

Agent Phone

(774) 280-1505

Office Phone

(774) 280-1505

Text Agent Call Agent Call Office

Array
(
    [id] => 270376
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73162724
    [mls_id_num] => 73162724
    [parent] => 0
    [pic_numb] => 42
    [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] => 499900
    [price_unit] => 260
    [price_si] => 499900
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 1
    [bedrooms_max] => 0
    [rooms] => 2
    [rooms_max] => 0
    [bathrooms] => 2
    [bathrooms_max] => 0
    [living_area] => 594
    [living_area_unit] => 1
    [living_area_si] => 55.242
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 2.08
    [lot_area_unit] => 1
    [lot_area_si] => 0.19344
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.04519400
    [googlemap_ln] => -71.68953000
    [geopoints] => ��������oB!�Q������E@
    [finalized] => 1
    [add_date] => 2024-04-26 19:05:37
    [last_finalize_date] => 2024-10-25 08:28:20
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1992
    [zip_id] => 546
    [zip_name] => 01516
    [last_modified_time_stamp] => 2024-10-25 18:44:48
    [post_code] => 
    [meta_description] => 1 Bedroom Bedrooms 2 Rooms Rooms With 2 Bathrooms Bathrooms Residential For Sale Yew St In 296 Yew St, Douglas, Massachusetts 01516
    [meta_description_manual] => 0
    [meta_keywords] => 296 Yew St, Douglas, Massachusetts 01516, 1 Bedroom Bedrooms, 2 Rooms Rooms,2 BathroomsBathrooms,Residential,For Sale,Yew St,73162724
    [meta_keywords_manual] => 0
    [street_no] => 296
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Over 20 Acres of farmland!  Nestled in the heart of the picturesque Town of Douglas, this exceptional property offers a rare and compelling opportunity to own a one-bedroom home accompanied by a vast expanse of fertile farmland, complete with barn and bonus room above. This unique offering is a harmonious blend of modern comfort and the timeless allure of rural living. This charming one-bedroom residence boasts a seamless fusion of classic architecture and contemporary design. With its open floor plan and abundant natural light, this home exudes warmth. The spacious bedroom is a tranquil sanctuary, and the living area is an inviting space for relaxation. Step outside onto the patio, where you can savor the serene surroundings and appreciate the beauty of your land. Encompassing acres of fertile, sun-kissed land, this property is a haven for agricultural enthusiasts and nature lovers alike.\n Property Type Residential Listing Type For Sale Ref ID c70e83a9f288b2db8a87155c95a8ec54 Full Bathrooms 2 Full Bathrooms two Status Pending Property Category Residential Property Type Single Family C_Style Farm Zipcode 01516 Office Name Sharkey Realty Agent MLSID CT003405 Office Phone 774-280-1505 Agent Phone 774-280-1505 ParkingTotal 10 ParkingTotal ten UnparsedAddress 296 Yew St, Douglas MA 01516 BRE_Total_Parking 10 BRE_Total_Parking ten  296 yew st douglas massachusetts 01516 
    [location_text] => 296 Yew St, Douglas, Massachusetts 01516
    [field_42] => Yew St
    [field_312] => Residential For Sale - 2 Rooms - 1 Bedroom - 2 Bathrooms - Price $499,
    [field_313] => Residential For Sale
    [field_308] => Over 20 Acres of farmland!  Nestled in the heart of the picturesque Town of Douglas, this exceptional property offers a rare and compelling opportunity to own a one-bedroom home accompanied by a vast expanse of fertile farmland, complete with barn and bonus room above. This unique offering is a harmonious blend of modern comfort and the timeless allure of rural living. This charming one-bedroom residence boasts a seamless fusion of classic architecture and contemporary design. With its open floor plan and abundant natural light, this home exudes warmth. The spacious bedroom is a tranquil sanctuary, and the living area is an inviting space for relaxation. Step outside onto the patio, where you can savor the serene surroundings and appreciate the beauty of your land. Encompassing acres of fertile, sun-kissed land, this property is a haven for agricultural enthusiasts and nature lovers alike.
    [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] => ,13,11,92,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,47,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,0,
    [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] => ,18,
    [f_150] => 1
    [f_151_options] => 
    [f_151] => 
    [f_152_options] => 
    [f_152] => 
    [f_156_options] => 
    [f_156] => 
    [f_157_options] => 
    [f_157] => 
    [f_159_options] => 
    [f_159] => 
    [f_161_options] => 
    [f_161] => 
    [f_163_options] => 
    [f_163] => 
    [f_165_options] => 
    [f_165] => 
    [f_166_options] => 
    [f_166] => 
    [ref_id] => c70e83a9f288b2db8a87155c95a8ec54
    [field_54] => 
    [half_bathrooms] => 0
    [half_bathrooms_max] => 0
    [field_55] => 0
    [rendered] => {"rendered":{"313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 2 Rooms - 1 Bedroom - 2 Bathrooms - Price $499,"},"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 - 2 Rooms - 1 Bedroom - 2 Bathrooms - Price $499,"},"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":"296 Yew St, Douglas, Massachusetts 01516"}
    [alias] => Single-Family-296-Yew-St-Douglas-Massachusetts-01516-73162724-USD499-900
    [source] => mls
    [last_sync_date] => 2024-10-25 08:28:10
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => Sharkey Realty
    [field_2112] => Tracy Sharkey
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => CT003405
    [field_3001] => AN7243
    [listing_status] => 13
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 62
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-10-24 22:28:00
    [f_3102_options] => ,54,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 296 Yew St
    [field_3171] => 774-280-1505
    [field_3172] => 774-280-1505
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 4
    [field_3176] => 2
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 
    [field_3191] => 
    [field_3192] => 10
    [field_3212] => 
    [field_3217] => 0
    [field_3219] => 0
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 16
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 296 Yew St, Douglas MA 01516
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 11
    [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] => 10
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 71
    [visit_time] => 20
    [visit_date] => 2024-11-21 20:45:30
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,74,2,7,8,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,4,
    [f_3006] => 1
    [f_3007_options] => ,0,17,
    [f_3007] => 1
    [f_3008_options] => ,0,
    [f_3008] => 1
    [f_3009_options] => ,0,1,45,8,9,10,30,14,
    [f_3009] => 1
    [f_3010_options] => ,224,
    [f_3010] => 1
    [field_3011] => 215600
    [field_3011_si] => 215600
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 42
    [field_3019] => 2023-09-22 20:10:17
    [field_3020] => 12
    [field_3021] => Call List Office,Call List Agent,Accompanied Showi
    [field_3022] => 
    [field_3023] => 3096
    [field_3023_si] => 3096
    [field_3023_unit] => 260
    [field_3024] => 2023
    [f_3025_options] => ,5,
    [f_3025] => 1
    [field_3027] => 10
    [field_3028] => 8
    [field_3029] => 0
    [field_3032] => RA
    [field_3039] => Rt. 16, Right on Franklin St, Right on Martin Rd, 
    [field_3043] => 2024-11-29
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 1
    [field_3060] => Pending P&S
    [field_3069] => 841.58
    [field_3069_si] => 841.58
    [field_3069_unit] => 260
    [field_3079] => 2023-11-23 08:05:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 296
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 2
    [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] => ,0,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 0
    [field_3134] => 0
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 440
    [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] => 594
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,7,0,15,10,1,2,4,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,0,14,
    [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] => ,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] => 200.00
    [field_3211] => 0
    [field_3213] => 
    [field_3214] => 
    [field_3215] => 
    [field_3216] => 0
    [field_3216_si] => 0
    [field_3216_unit] => 260
    [field_3218] => Paddocks
    [field_3220] => 0
    [field_3220_si] => 0
    [field_3220_unit] => 260
    [field_3221] => 
    [field_3222] => Exclusive Right To Sell
    [field_3223] => 2023-09-22
    [field_3224] => 
    [f_3225_options] => ,7,8,9,
    [f_3225] => 1
    [field_3226_si] => 8430.264
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 2023-11-22
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 499900
    [field_3231_si] => 499900
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => 
    [field_3237] => 2023-11-09
    [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] => 2023-09-22 20:07: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] => Y
    [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] => AN7243
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 62
    [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] => 841.58
    [field_3290_si] => 841.58
    [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] => 90648
)

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

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

[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° 18' 37.7'' 
        )

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

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

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

[field_3043] => Array
        (
            [field_id] => 3043
            [type] => date
            [name] => ANT_SOLD_DATE
            [value] => 29/11/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_3058] => Array
        (
            [field_id] => 3058
            [type] => select
            [name] => COMP_BASED_ON
            [value] => Net Sale Price
        )

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

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

[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] => 24/10/2024 22:28: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] => 296
        )

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

[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] => 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_3151] => Array
        (
            [field_id] => 3151
            [type] => text
            [name] => FOUNDATION_SIZE
            [value] => 440
        )

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

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 774-280-1505
        )

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

[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] => Conservation Area
                    [2] => Highway Access
                    [3] => Public School
                    [4] => Park
                    [5] => Bike Path
                    [6] => Stable(s)
                )

)

[field_3189] => Array
        (
            [field_id] => 3189
            [type] => price
            [name] => ConcessionsAmount
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3190] => Array
        (
            [field_id] => 3190
            [type] => feature
            [name] => ConstructionMaterials
            [values] => Array
                (
                    [0] => Frame
                    [1] => Log
                )

)

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

[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] => 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_3210] => Array
        (
            [field_id] => 3210
            [type] => text
            [name] => FrontageLength
            [value] => 200.00
        )

[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_3218] => Array
        (
            [field_id] => 3218
            [type] => text
            [name] => HorseAmenities
            [value] => Paddocks
        )

[field_3219] => Array
        (
            [field_id] => 3219
            [type] => select
            [name] => HorseYN
            [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] => 22/09/2023
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Wooded
                    [1] => Cleared
                    [2] => Farm
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 90,648 Sqft
            [raw] => 90648
            [unit_id] => 1
        )

[field_3229] => Array
        (
            [field_id] => 3229
            [type] => date
            [name] => OffMarketDate
            [value] => 22/11/2023
        )

[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] => 499900
            [unit_id] => 260
            [value] => $499,900
            [price_only] => $499,900
        )

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

[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] => 296 Yew St, 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] => 22/09/2023 20:07:00
        )

[field_3260] => Array
        (
            [field_id] => 3260
            [type] => text
            [name] => MLSPIN_DISCLOSURE
            [value] => Y
        )

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

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

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

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

)

EXIT

40 More Photos

Pending

296 Yew St Douglas. MA 01516

$499,900

General Information for 296 Yew St, Douglas, Massachusetts 01516

Interior Features for 296 Yew St, Douglas, Massachusetts 01516

Exterior Features for 296 Yew St, Douglas, Massachusetts 01516

Disclosures for 296 Yew St, Douglas, Massachusetts 01516

Financial Information for 296 Yew St, Douglas, Massachusetts 01516

Lifestyle Information for 296 Yew St, Douglas, Massachusetts 01516

Location information for 296 Yew St, Douglas, Massachusetts 01516

Marketing History for 296 Yew St, Douglas, Massachusetts 01516

Agent Information for 296 Yew St, Douglas, Massachusetts 01516

Payment Calculator

Exclusive Listing Agent

Tracy Sharkey

Sharkey Realty