Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Expired

1 Old Farm Rd, Berkley MA 02779

$5,250,000

Estimated $37,640/month Calculator

Single Family

7 Bedrooms

Baths

11652

Total Parking: 30 (5 Garage)

2,178,000 (50.00)

Built in 2010

Waterfront estate with unrivaled privacy & tranquility on 50+ acres, “Tetequet” is a stunning custom 10,000sf Nantucket shingle style residence & guest house with total of 7 bedrooms & 6.2 bathrooms. Expertly sited to maximize water views & offer endless sunsets over the water. Highlights include masterful millwork, gorgeous Carlisle wide plank walnut floors, double height great room with stone fireplace, abundant windows providing beautiful natural light, large eat-in kitchen, formal dining room, billiard room, 4 seasons room, office with fireplace, home cinema, elevator to all levels, sumptuous primary suite, wine cellar & 5 garage bays. Exterior living areas feature infinity pool, spa tub, patio, grilling kitchen & multiple decks. A nature lover’s paradise surrounded by bountiful wildlife including nesting bald eagles, osprey, seals & swans, yet only 30-40 minutes to Providence & Gillette Stadium & 1hr to Boston & Newport. To experience its splendor, you must visit “Tetequet”!

This home has been viewed 32 times

Last Checked: May 10th, 2024 at 11:38pm (Source: MLS PIN #72987251)

Garage Parking

Air Conditioning

Waterview

Accessible Features

General Information for 1 Old Farm Rd, Berkley MA 02779

Listing ID72987251

Property TypeSingle Family / Detached

Price$5,250,000 ($450.57/SqFt)

StyleColonial

CityBerkley

CountyBristol

MLS AreaBerkley Bridge

Neighborhood(s)

Garage Parking5

ZoningRES-109

Year Built2010

Year Built SourcePublic Records

Year Built DetailsApproximate

Handicap Access / Features1

Interior Features for 1 Old Farm Rd, Berkley MA 02779

Approximate Living Area Total11652

Living Area Includes BasementYes

Rooms25

Bedrooms7

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric220 Volts

Exterior Features for 1 Old Farm Rd, Berkley MA 02779

Approximate Lot Size (Acres)50

Approximate Lot Size (Square Feet)2178000

Total Parking30 (5 Garage)

Garage Parking5

WaterPrivate

SewerPrivate Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction Materials

Road Frontage Type

Patio & Porch

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections

Water ViewsYes

Water Views FeaturesBay

Waterfront FeaturesRiver

Private Pool0

Pool FeaturesAssociation

Horse Permitted0

Horse AmenitiesRiver

Disclosures for 1 Old Farm Rd, Berkley MA 02779

Lead Paint

UFFI

Living Area Includes BasementYes

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsFireplace Mantel In Living Room Is Excluded.

Buyer Agent Compensation2.5%

Facilitator Compensation0

Compensation Based OnNet Sale Price

Financial Information for 1 Old Farm Rd, Berkley MA 02779

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax63495

Tax Year2022

Assessed Value$4,617,800

Location Information for 1 Old Farm Rd, Berkley MA 02779

Elementary SchoolBerkley Comm Sc

Middle SchoolBerkley Middle

High SchoolSb Regional Hig

Neighborhood(s)

MLS AreaBerkley Bridge

Area AmenitiesWalk/jog Trails

Contact Information for 1 Old Farm Rd, Berkley MA 02779

Agent

Name: Alyce Wright

Office

Name: Lila Delman Compass

Phone: 401-848-2101

Payment Calculator

, Interest

Property Taxes 5291.25

Principal & Interest 32348.83

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Lila Delman Compass

Alyce Wright

Agent Phone

Office Phone

(401) 848-2101

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 50 acres (2,178,000 SqFt)
    [add_date] => 2024-05-10 23:38:32
    [address] => Old Farm Rd
    [agent] => Array
        (
            [address] => 23 Ayrault Street
            [city] => Newport
            [id] => CN243502
            [name] => Alyce Wright
            [national_association] => 
            [office] => AN7644
            [state] => RI
            [zip] => 02840
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Range
        )

[approx_living_area_total] => 11652
    [approx_lot_size_acres] => 50
    [approx_lot_size_sqft] => 2178000
    [assessed_value] => $4,617,800
    [association] => 
    [association_fee] => Array
        (
        )

[association_fee_frequency] => Array
        (
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => 0
    [basement] => Array
        (
            [0] => Full
        )

[bathrooms] => 
    [bedrooms] => 7
    [building_amenities] => Array
        (
        )

[building_area_source] => Array
        (
            [0] => Public Records
        )

[building_management] => Array
        (
        )

[building_debug] => 
    [building_id] => 
    [building_parent] => 0
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 2.5%
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Array
        (
            [0] => Single Family
        )

[cap_rate] => 
    [city] => Berkley
    [community_features] => Array
        (
            [0] => Walk/jog Trails
        )

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

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
        )

[construction_status] => 
    [cooling] => Array
        (
            [0] => 1
            [1] => Split
        )

[cooperating_agent_commission] => Array
        (
        )

[county] => Bristol
    [cultivation_acres] => 
    [date_available_note] => 
    [deposit_amount] => Array
        (
        )

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => Waterfront estate with unrivaled privacy & tranquility on 50+ acres, “Tetequet” is a stunning custom 10,000sf Nantucket shingle style residence & guest house with total of 7 bedrooms & 6.2 bathrooms.  Expertly sited to maximize water views & offer endless sunsets over the water.  Highlights include masterful millwork, gorgeous Carlisle wide plank walnut floors, double height great room with stone fireplace, abundant windows providing beautiful natural light, large eat-in kitchen, formal dining room, billiard room, 4 seasons room, office with fireplace, home cinema, elevator to all levels, sumptuous primary suite, wine cellar & 5 garage bays. Exterior living areas feature infinity pool, spa tub, patio, grilling kitchen & multiple decks.  A nature lover’s paradise surrounded by bountiful wildlife including nesting bald eagles, osprey, seals & swans, yet only 30-40 minutes to Providence & Gillette Stadium & 1hr to Boston & Newport.  To experience its splendor, you must visit “Tetequet”!
    [disclosures] => 
    [documents_available] => Array
        (
        )

[electric] => Array
        (
            [0] => 220 Volts
        )

[electric_expense] => Array
        (
        )

[elementary_school] => Berkley Comm Sc
    [en_suite_bath] => Array
        (
            [0] => Yes
        )

[energy_features] => 
    [entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Fireplace Mantel In Living Room Is Excluded.
        )

[exterior_features] => Array
        (
            [0] => Porch
        )

[facilitator_compensation] => 0
    [fee_paid_by_tennant] => 
    [financial_data_source] => Array
        (
        )

[fireplaces] => Array
        (
        )

[first_month_required] => Array
        (
        )

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

[for_sale_by_owner] => 
    [foundation_area] => 
    [foundation_materials] => Array
        (
        )

[frontage_length] => 
    [full_baths] => 
    [garage_parking] => 5
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

[half_baths] => 
    [handicap_access] => 1
    [heating] => 
    [heating_expense] => Array
        (
        )

[high_school] => Sb Regional Hig
    [horse_features] => Array
        (
            [0] => River
        )

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

[id] => 
    [insurance_expense] => Array
        (
        )

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
            [0] => French Doors
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2024-05-10 23:38:32
    [laundry_features] => Array
        (
        )

[lead_paint] => Array
        (
        )

[lease_term] => Array
        (
        )

[levels_in_unit] => 
    [living_area] => 
    [living_area_disclosure] => Array
        (
        )

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

[lot_features] => Array
        (
            [0] => Gentle Sloping
        )

[management_expense] => Array
        (
        )

[middle_school] => Berkley Middle
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => Berkley Bridge
    [mls_id] => 72987251
    [neighborhoods] => 
    [net_income_calc] => -63495
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => AN7200
            [name] => Lila Delman Compass
            [phone] => 401-848-2101
        )

[operating_expense] => Array
        (
        )

[optional_fee_includes] => Array
        (
        )

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

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => 1
        )

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

[perc_test] => Array
        (
        )

[perc_test_date] => 
    [pet_policy] => Array
        (
            [0] => Allowed
        )

[phone] => 
    [pool_features] => Array
        (
            [0] => Association
        )

[price] => 5250000
    [price_per_sqft] => 450.57
    [price_per_unit] => 5250000
    [private_pool] => 0
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => 63495
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Asphalt/fiberglass Shingles
        )

[rooms] => 25
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Private Sewer
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

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

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

[style] => Array
        (
            [0] => Colonial
        )

[subagent_compensation] => 
    [tag_accessible_features] => 1
    [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] => 1
    [tax_year] => 2022
    [team] => 
    [team_agents] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => 
    [total_gross_expense] => 63495
    [total_gross_income] => 0
    [total_parking] => 30 (5 Garage)
    [trash_expense] => Array
        (
        )

[travel_routes] => 
    [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] => 1 Old Farm Rd, Berkley MA 02779
    [utilities] => Array
        (
        )

[view] => Array
        (
        )

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

[water_expense] => Array
        (
        )

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

[water_views_features] => Array
        (
            [0] => Bay
        )

[waterfront] => 
    [waterfront_features] => Array
        (
            [0] => River
        )

[raw] => 
)

EXIT

39 More Photos