Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Pending

174 Cedar St, Sturbridge MA 01566

$649,000

Estimated $4,770/month Calculator

Single Family

4 Bedrooms

Baths

2848

Total Parking: 10 (2 Garage)

43,560 (1.00)

Built in 1986

Stunning Post and Beam Contemporary with custom details throughout! Front porch with composite decking and elegant vaulted entry welcomes your guests. Spacious family room with an impressive 2 story double sided stone fireplace & interior balcony. Remodeled kitchen w/custom Wellborn cabinets, new chefs gas range, ss appliances, double sink & pantry closets. Large dining room w/beautiful teak parquet floors, skylights & wood fireplace. Work from home? Custom home office with built-in desks, sound control insulation & high speed ethernet to meet all your needs! Two 1/2 baths & 2 car garage complete the 1st floor. The 2nd floor includes a large primary with walk-in closet, double windows & ensuite bath w/jacuzzi spa tub. The remaining 3 good sized bedrooms all have wood floors, double closets & full bath. Spectacular fenced salt water in-ground pool, cabana & lovely yard overlooking the wooded grounds. Easy commute, only 5 minutes to the MA Pike and Rt 84!!

This home has been viewed 9 times

Last Checked: June 18th, 2026 at 5:58am (Source: MLS PIN #73524529)

Garage Parking

Air Conditioning

Waterview

Lead Paint Free

General Information for 174 Cedar St, Sturbridge MA 01566

Listing ID73524529

Property TypeSingle Family / Detached

Price$649,000 ($227.88/SqFt)

StyleColonial

CitySturbridge

CountyWorcester

Neighborhood(s)

Garage Parking2

ZoningSR

Year Built1986

Year Built SourcePublic Records

Year Built DetailsActual,Renovated Since

Interior Features for 174 Cedar St, Sturbridge MA 01566

Approximate Living Area Total2848

Living Area Includes BasementNo

Rooms8

Bedrooms4

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric220 Volts

Exterior Features for 174 Cedar St, Sturbridge MA 01566

Approximate Lot Size (Acres)1

Approximate Lot Size (Square Feet)43560

Total Parking10 (2 Garage)

Garage Parking2

WaterPrivate

SewerPrivate Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction MaterialsFrame

Approximate Street Frontage145.00

Road Frontage Type

Patio & PorchCovered

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections110 Volts

Water ViewsNo

Water Views Features

Waterfront0

Waterfront FeaturesRiver

Pool FeaturesAssociation

Horse Permitted0

Horse AmenitiesRiver

Disclosures for 174 Cedar St, Sturbridge MA 01566

Lead PaintNone

UFFI

Living Area Includes BasementNo

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsTree House

Title 5A

Compensation Based On

Financial Information for 174 Cedar St, Sturbridge MA 01566

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax9247

Tax Year2025

Assessed Value$580,500

Location Information for 174 Cedar St, Sturbridge MA 01566

Elementary SchoolBurgess Elementary

Middle SchoolTantasqua Junior High

High SchoolTantasqua High School

Neighborhood(s)

Area AmenitiesWalk/jog Trails

Contact Information for 174 Cedar St, Sturbridge MA 01566

Agent

Name: Amy J. Gerrish

Office

Name: RE/MAX Prof Associates

Phone: 508-347-9595

Payment Calculator

, Interest

Property Taxes 770.58

Principal & Interest 3998.93

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

RE/MAX Prof Associates

Amy J. Gerrish

Agent Phone

Office Phone

(508) 347-9595

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 1 acres (43,560 SqFt)
    [add_date] => 2026-05-27 19:48:35
    [address] => Cedar St
    [agent] => Array
        (
            [address] => 45 Prospect Hill Road
            [city] => Brimfield
            [id] => M9502221
            [name] => Amy J. Gerrish
            [national_association] => 452502489
            [office] => K01527
            [state] => MA
            [zip] => 01010
        )

[apod_available] => Array
        (
        )

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

[approx_living_area_total] => 2848
    [approx_lot_size_acres] => 1
    [approx_lot_size_sqft] => 43560
    [assessed_value] => $580,500
    [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] => 4
    [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] => 
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

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

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

[compensation_based_on] => Array
        (
        )

[complex_complete] => Array
        (
        )

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

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

[cooperating_agent_commission] => Array
        (
        )

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

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => Stunning Post and Beam Contemporary with custom details throughout! Front porch with composite decking and elegant vaulted entry welcomes your guests. Spacious family room with an impressive 2 story double sided stone fireplace & interior balcony. Remodeled kitchen w/custom Wellborn cabinets, new chefs gas range, ss appliances, double sink & pantry closets. Large dining room w/beautiful teak parquet floors, skylights & wood fireplace. Work from home? Custom home office with built-in desks, sound control insulation & high speed ethernet to meet all your needs! Two 1/2 baths & 2 car garage complete the 1st floor. The 2nd floor includes a large primary with walk-in closet, double windows & ensuite bath w/jacuzzi spa tub. The remaining 3 good sized bedrooms all have wood floors, double closets & full bath. Spectacular fenced salt water in-ground pool, cabana & lovely yard overlooking the wooded grounds. Easy commute, only 5 minutes to the MA Pike and Rt 84!!
    [disclosures] => 
    [documents_available] => Array
        (
        )

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

[electric_expense] => Array
        (
        )

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

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

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Tree House
        )

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

[facilitator_compensation] => 
    [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] => 145.00
    [full_baths] => 
    [garage_parking] => 2
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

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

[high_school] => Tantasqua High School
    [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] => 2026-06-18 05:58:37
    [laundry_features] => Array
        (
            [0] => Archway
        )

[lead_paint] => Array
        (
            [0] => None
        )

[lease_term] => Array
        (
        )

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

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

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

[management_expense] => Array
        (
        )

[middle_school] => Tantasqua Junior High
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => 
    [mls_id] => 73524529
    [neighborhoods] => 
    [net_income_calc] => -9247
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => K01527
            [name] => RE/MAX Prof Associates
            [phone] => 508-347-9595
        )

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

[perc_test] => Array
        (
        )

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

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

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

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

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

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

[rooms] => 8
    [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] => Pending
        )

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

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

[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] => 1
    [tag_lead_paint_free] => 1
    [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] => 2025
    [team] => 
    [team_agents] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => A
    [total_gross_expense] => 9247
    [total_gross_income] => 0
    [total_parking] => 10 (2 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] => 174 Cedar St, Sturbridge MA 01566
    [utilities] => Array
        (
            [0] => 110 Volts
        )

[view] => Array
        (
        )

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

[water_expense] => Array
        (
        )

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

[water_views_features] => Array
        (
        )

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

[raw] => 
)

EXIT

39 More Photos