Overview Property Details Payment Calculator Walkability

Canceled

5 Beech Brook Farm Rd, Middleton MA 01949

$1,999,900

Estimated $13,556.08/month Calculator

Single Family

5 Bedrooms

3 Full, 2 Half Baths

5,624 SqFt

Total Parking: 9 (3 Garage)

1 SqFt

Built in 2024

MAGNIFICENT GRAND NEW CONSTRUCTION. Beech Brook Farm Estates, spectacular, private, and prestigious new 5 bedroom home, located in a luxury cul de sac subdivision. An exquisitely designed contemporary colonial with over 5,000 +SF of living space (including finished LL). Cust...

This home has been viewed 17 times

Last Checked: May 18th, 2024 at 12:13am (Source: MLS PIN #73199012)

Garage Parking

Air Conditioning

General Information for 5 Beech Brook Farm Rd, Middleton MA 01949

Listing ID73199012

Property TypeSingle Family / Detached

Price$1,999,900 ($355.6/SqFt)

StyleColonial, Contemporary, Other (see Remarks)

CityMiddleton

CountyEssex

MLS Area

Neighborhood(s)Ipswich

Garage Parking3 / Detached

ZoningRES

AssociationNo

Year Built2024

Year Built SourceBuilder

Year Renovated

Year Built DetailsUnder Construction

Handicap Access / FeaturesNo

Energy Features200+ Amp Service

Interior Features for 5 Beech Brook Farm Rd, Middleton MA 01949

Approximate Living Area Total5,624 SqFt

Living Area Includes BasementYes

Rooms11

Bedrooms5

Full Baths3

Half Baths2

Primary En Suite BathroomYes

BasementFull, Partially Finished

HeatingYes / Natural Gas

CoolingYes / Central Air

Fireplaces1

AppliancesDishwasher, Range Hood

FlooringTile, Hardwood

Electric200+ Amp Service

Exterior Features for 5 Beech Brook Farm Rd, Middleton MA 01949

Approximate Lot Size (Acres)0

Approximate Lot Size (Square Feet)1 SqFt

Total Parking9 (3 Garage)

Garage Parking3 / Detached

WaterPublic

SewerPrivate Sewer

Lot FeaturesWooded

Parking FeaturesPaved Drive, Off Street, Attached

Exterior FeaturesPorch, Deck, Stone Wall, Deck - Composite

Foundation Area

Foundation MaterialsConcrete Perimeter

Construction MaterialsFrame

Approximate Street Frontage

Road Frontage Type

Patio & Porch

Roof MaterialShingle

Utility Connections

Water Views

Water Views Features

WaterfrontNo

Waterfront Features

Private PoolNo

Pool Features

Horse PermittedNo

Horse Amenities

Disclosures for 5 Beech Brook Farm Rd, Middleton MA 01949

Lead Paint

UFFI

Living Area Includes BasementYes

Living Area Disclosureapprox sq ftg-provided by floor plans Buyer agent

Building Area SourceOther

Senior CommunityNo

Special Listing Conditions

For Sale By OwnerNo

Exclusions

Disclosures

Title 5

Buyer Agent Compensation2.0

Facilitator Compensation2.0

Sub-Agent Compensation

Compensation Based OnNet Sale Price

Financial Information for 5 Beech Brook Farm Rd, Middleton MA 01949

AssociationNo

Association Fee$0

Association Fee Frequency

Association Fee Includes

Real Estate Tax$14,800

Tax Year2024

Assessed Value$1,255,300

Location Information for 5 Beech Brook Farm Rd, Middleton MA 01949

Elementary School

Middle School

High School

Neighborhood(s)Ipswich

MLS Area

Area Amenities

Contact Information for 5 Beech Brook Farm Rd, Middleton MA 01949

Agent

Name: Lisa Simmons

MLS ID: G8000549

Office ID: AN0949

National Association ID: 456000193

Address: 197 8th St

City: Boston

State: MA

Zip: 02129

Office

Name: William Raveis R.E. & Home Services

MLS Office ID: AN0949

Phone: 978-475-5100

Payment Calculator

$13,556.08 per month

30 Years Fixed, 6.75% Interest

Property Taxes $1,233.33

Principal & Interest $12,322.75

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

William Raveis R.E. & Home Services

Lisa Simmons

Agent Phone

Office Phone

(978) 475-5100

Text Agent Call Agent Call Office

Array
(
    [acres] => 
    [add_date] => 2024-05-18 00:13:02
    [address] => Beech Brook Farm Rd
    [agent] => Array
        (
            [address] => 197 8th St
            [city] => Boston
            [id] => G8000549
            [name] => Lisa Simmons
            [national_association] => 456000193
            [office] => AN0949
            [state] => MA
            [zip] => 02129
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Dishwasher
            [1] => Range Hood
        )

[approx_living_area_total] => 5,624 SqFt
    [approx_lot_size_acres] => 0
    [approx_lot_size_sqft] => 1 SqFt
    [assessed_value] => $1,255,300
    [association] => No
    [association_fee] => Array
        (
            [0] => $0
        )

[association_fee_frequency] => Array
        (
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => Yes
    [basement] => Array
        (
            [0] => Full
            [1] => Partially Finished
        )

[bathrooms] => 3 Full, 2 Half
    [bedrooms] => 5
    [building_amenities] => Array
        (
        )

[building_area_source] => Array
        (
            [0] => Other
        )

[building_management] => Array
        (
        )

[building_debug] => 5 Beech Brook Farm Rd Middleton
    [building_id] => 
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 2.0
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Single Family
    [cap_rate] => -0.74%
    [city] => Middleton
    [community_features] => Array
        (
        )

[compensation_based_on] => Array
        (
            [0] => Net Sale Price
        )

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
            [0] => Frame
        )

[construction_status] => 
    [cooling] => Yes / Central Air
    [cooperating_agent_commission] => Array
        (
        )

[county] => Essex
    [cultivation_acres] => None
    [date_available_note] => 
    [deposit_amount] => Array
        (
            [0] => $0
        )

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => MAGNIFICENT GRAND NEW CONSTRUCTION. Beech Brook Farm Estates, spectacular, private, and prestigious new 5 bedroom home, located in a luxury cul de sac subdivision. An exquisitely designed contemporary colonial with over 5,000 +SF of living space (including finished LL). Custom features such as wide plank hardwood floors, gourmet kitchen with upgraded appliances; include Wolfe stove, quartz counters, soaring ceilings, and a dramatic fireplace. Three full bath and two half baths all have custom cabinetry and quartz counters. A spacious optional first floor Primary BR Suite, with large walk-in closet, farmer's porch, outdoor decks for entertaining, lofts and a bonus finished lower level, includes: bathroom, mudroom, laundry room and walk in storage room. Buyers still have time to add some finishing touches……. More photos coming
    [disclosures] => 
    [documents_available] => Array
        (
        )

[electric] => Array
        (
            [0] => 200+ Amp Service
        )

[electric_expense] => Array
        (
            [0] => $0
        )

[elementary_school] => 
    [en_suite_bath] => Array
        (
            [0] => Yes
        )

[energy_features] => Array
        (
            [0] => 200+ Amp Service
        )

[entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
        )

[exterior_features] => Array
        (
            [0] => Porch
            [1] => Deck
            [2] => Stone Wall
            [3] => Deck - Composite
        )

[facilitator_compensation] => 2.0
    [fee_paid_by_tennant] => Contact Agent
    [financial_data_source] => Array
        (
        )

[fireplaces] => Array
        (
            [0] => 1
        )

[first_month_required] => Array
        (
        )

[floor_number] => 0
    [flooring] => Array
        (
            [0] => Tile
            [1] => Hardwood
        )

[for_sale_by_owner] => No
    [foundation_area] => 
    [foundation_materials] => Array
        (
            [0] => Concrete Perimeter
        )

[frontage_length] => 
    [full_baths] => 3
    [garage_parking] => 3 / Detached
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
            [0] => $0
        )

[gross_income] => Array
        (
            [0] => $0
        )

[half_baths] => 2
    [handicap_access] => No
    [heating] => Yes / Natural Gas
    [heating_expense] => Array
        (
            [0] => $0
        )

[high_school] => 
    [horse_features] => Array
        (
        )

[horse_permitted] => No
    [hot_water] => Array
        (
        )

[id] => 490258
    [insurance_expense] => Array
        (
            [0] => $0
        )

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2024-05-18 00:13:02
    [laundry_features] => Array
        (
        )

[lead_paint] => Array
        (
        )

[lease_term] => 
    [levels_in_unit] => 1
    [living_area] => 5,624 Sq. Ft.
    [living_area_disclosure] => Array
        (
            [0] => approx sq ftg-provided by floor plans Buyer agent 
        )

[living_area_includes_basement] => Array
        (
            [0] => Yes
        )

[lot_features] => Array
        (
            [0] => Wooded
        )

[management_expense] => Array
        (
            [0] => $0
        )

[middle_school] => 
    [miscellaneuos_expense] => Array
        (
            [0] => $0
        )

[mls_area] => 
    [mls_id] => 73199012
    [neighborhoods] => Array
        (
            [0] => Ipswich
        )

[net_income_calc] => -14800
    [net_operating_income] => Array
        (
            [0] => $0
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 1
    [office] => Array
        (
            [id] => AN0949
            [name] => William Raveis R.E. & Home Services
            [phone] => 978-475-5100
        )

[operating_expense] => Array
        (
            [0] => $0
        )

[optional_fee_includes] => Array
        (
        )

[optional_price] => 0
    [outdoor_space_available] => Array
        (
        )

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => Paved Drive
            [1] => Off Street
            [2] => Attached
        )

[pasture_area] => None
    [patio_and_porch] => Array
        (
        )

[perc_test] => Array
        (
        )

[perc_test_date] => Unknown
    [pet_policy] => Array
        (
        )

[phone] => 978-835-8940
    [pool_features] => Array
        (
        )

[price] => $1,999,900
    [price_per_sqft] => 355.6
    [price_per_unit] => 1999900
    [private_pool] => No
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => $14,800
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
            [0] => $0
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Shingle
        )

[rooms] => 11
    [senior_community] => No
    [sewer] => Array
        (
            [0] => Private Sewer
        )

[sewer_expense] => Array
        (
            [0] => $0
        )

[short_sale] => 
    [special_listing_conditions] => Array
        (
        )

[state] => Massachusetts
    [state_code] => MA
    [status] => Array
        (
            [0] => Canceled
        )

[street_number] => 5
    [structure_type] => Array
        (
        )

[style] => Array
        (
            [0] => Colonial
            [1] => Contemporary
            [2] => Other (see Remarks)
        )

[subagent_compensation] => 
    [tag_accessible_features] => 
    [tag_air_conditioning] => 1
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 
    [tag_elevator] => 
    [tag_equestrian] => 
    [tag_garage_parking] => 1
    [tag_generator] => 
    [tag_green_features] => 
    [tag_laundry] => 
    [tag_lead_paint_free] => 
    [tag_loft] => 
    [tag_pet_friendly] => 
    [tag_pre_construction] => 
    [tag_private_outdoor_space] => 
    [tag_private_pool] => 
    [tag_professional_management] => 
    [tag_recently_renovated] => 
    [tag_senior_community] => 
    [tag_townhouse] => 
    [tag_waterfront] => 
    [tag_waterview] => 
    [tax_year] => 2024
    [team] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => None
    [title_5] => 
    [total_gross_expense] => 14800
    [total_gross_income] => 0
    [total_parking] => 9 (3 Garage)
    [trash_expense] => Array
        (
            [0] => $0
        )

[uffi] => Array
        (
        )

[unit_1_bathrooms] => 
    [unit_1_bedrooms] => 
    [unit_1_floor] => 
    [unit_1_lease] => Array
        (
        )

[unit_1_levels] => 
    [unit_1_rent] => Array
        (
        )

[unit_2_bathrooms] => 
    [unit_2_bedrooms] => 
    [unit_2_floor] => 
    [unit_2_lease] => Array
        (
        )

[unit_2_levels] => 
    [unit_2_rent] => Array
        (
        )

[unit_3_bathrooms] => 
    [unit_3_bedrooms] => 
    [unit_3_floor] => 
    [unit_3_lease] => Array
        (
        )

[unit_3_levels] => 
    [unit_3_rent] => Array
        (
        )

[unit_4_bathrooms] => 
    [unit_4_bedrooms] => 
    [unit_4_floor] => 
    [unit_4_lease] => Array
        (
        )

[unit_4_levels] => 
    [unit_4_rent] => Array
        (
        )

[unit_level] => 
    [unit_number] => 
    [units_owner_occupied] => 
    [unparsed] => Array
        (
            [0] => 5 Beech Brook Farm Rd, Middleton MA 01949
        )

[utilities] => Array
        (
        )

[view] => Array
        (
        )

[water] => Array
        (
            [0] => Public
        )

[water_expense] => Array
        (
            [0] => $0
        )

[water_views] => Array
        (
        )

[water_views_features] => Array
        (
        )

[waterfront] => No
    [waterfront_features] => Array
        (
        )

[year_built] => 2024
    [year_built_details] => Under Construction
    [year_built_source] => Builder
    [year_renovated] => 
    [zip] => 01949
    [zoning] => RES
    [zoning_details] => 
    [media] => Array
        (
            [0] => Array
                (
                    [id] => 19058245
                    [name] => MLS1.jpg
                    [type] => gallery
                    [category] => image
                    [url] => https://www.bostonrealestate.com/wp-content/uploads/WPL/490258/MLS1.jpg
                    [index] => 1
                    [enabled] => 1
                    [created] => 2024-05-18 00:13:07
                    [modified] => 2024-05-18 00:13:07
                )

)

)

EXIT