Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

154 S Quinsigamond Ave, Shrewsbury MA 01545

Closed

154 S Quinsigamond Ave, Shrewsbury MA 01545

$1,350,000

Estimated $9,426/month Calculator

Single Family

4 Bedrooms

Baths

3366

Total Parking: 6 (2 Garage)

16,223 (0.37)

Built in 2004

RARE, large lakefront colonial with nearly 25' of Lake Quinsigamond frontage is now available! Don't miss this incredible opportunity to own it all: well-maintained, spacious floorplan plus expansive outdoor enjoyment in a large yard with bonus shed, playground, paver patios and dock! Welcoming, light-filled entry connects main floor study, formal sitting room and elegant kitchen with island seating. Fireplaced family room and dining room offer stunning water views. Generously sized waterview primary suite with fireplaced sitting room, oversized custom closet and en-suite bath with standing shower and separate soaking tub provides a daily oasis! Full size second floor laundry room for easy access from all secondary bedrooms. Bonus en-suite bedroom. Unfinished basement with full egress offers possible future expansion opportunity. Ample storage throughout. Conveniently located, 3 min drive to Whole Foods, Trader Joes and Starbucks.

This home has been viewed 16 times

Last Checked: May 11th, 2024 at 2:23am (Source: MLS PIN #73089232)

Garage Parking

Air Conditioning

Waterview

General Information for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Listing ID73089232

Property TypeSingle Family / Detached

Price$1,350,000 ($401.07/SqFt)

StyleColonial

CityShrewsbury

CountyWorcester

Neighborhood(s)

Garage Parking2

ZoningRES B-

Year Built2004

Year Built SourcePublic Records

Year Built DetailsActual

Interior Features for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Approximate Living Area Total3366

Living Area Includes BasementNo

Rooms9

Bedrooms4

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric220 Volts

Exterior Features for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Approximate Lot Size (Acres)0.37

Approximate Lot Size (Square Feet)16223

Total Parking6 (2 Garage)

Garage Parking2

WaterPublic

SewerPublic Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction MaterialsFrame

Road Frontage Type

Patio & Porch

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections

Water ViewsYes

Water Views FeaturesBay

Waterfront FeaturesRiver

Pool Features

Horse AmenitiesRiver

Disclosures for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Lead Paint

UFFI

Living Area Includes BasementNo

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsOutside Hot Tub.

Buyer Agent Compensation2

Facilitator Compensation0

Compensation Based OnNet Sale Price

Financial Information for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax13295

Tax Year2023

Assessed Value$1,013,354

Location Information for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Neighborhood(s)

Area AmenitiesWalk/jog Trails

Contact Information for 154 S Quinsigamond Ave, Shrewsbury MA 01545

Agent

Name: Andrea Beth Castinetti

Office

Name: Castinetti Realty Group

Phone: 508-719-8804

Payment Calculator

, Interest

Property Taxes 1107.92

Principal & Interest 8318.27

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Castinetti Realty Group

Andrea Beth Castinetti

Agent Phone

Office Phone

(508) 719-8804

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 0.37 acres (16,223 SqFt)
    [add_date] => 2024-05-11 02:23:34
    [address] => S Quinsigamond Ave
    [agent] => Array
        (
            [address] => 25 King Street
            [city] => Shrewsbury
            [id] => CN213891
            [name] => Andrea Beth Castinetti
            [national_association] => 453012999
            [office] => AN4508
            [state] => MA
            [zip] => 01545
        )

[apod_available] => Array
        (
        )

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

[approx_living_area_total] => 3366
    [approx_lot_size_acres] => 0.37
    [approx_lot_size_sqft] => 16223
    [assessed_value] => $1,013,354
    [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] => 2
    [buyer_agent_id] => cn213891
    [buyer_office_id] => an4508
    [c_style] => Array
        (
            [0] => Detached
        )

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

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

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

[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] => RARE, large lakefront colonial with nearly 25' of Lake Quinsigamond frontage is now available! Don't miss this incredible opportunity to own it all: well-maintained, spacious floorplan plus expansive outdoor enjoyment in a large yard with bonus shed, playground, paver patios and dock! Welcoming, light-filled entry connects main floor study, formal sitting room and elegant kitchen with island seating. Fireplaced family room and dining room offer stunning water views. Generously sized waterview primary suite with fireplaced sitting room, oversized custom closet and en-suite bath with standing shower and separate soaking tub provides a daily oasis! Full size second floor laundry room for easy access from all secondary bedrooms. Bonus en-suite bedroom. Unfinished basement with full egress offers possible future expansion opportunity. Ample storage throughout. Conveniently located, 3 min drive to Whole Foods, Trader Joes and Starbucks.
    [disclosures] => 
    [documents_available] => Array
        (
        )

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

[electric_expense] => Array
        (
        )

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

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

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Outside Hot Tub.
        )

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

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

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

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

[horse_permitted] => 
    [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-11 02:23:34
    [laundry_features] => Array
        (
        )

[lead_paint] => Array
        (
        )

[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] => 
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => 
    [mls_id] => 73089232
    [neighborhoods] => 
    [net_income_calc] => -13295
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => AN4508
            [name] => Castinetti Realty Group
            [phone] => 508-719-8804
        )

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

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

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

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

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

[rooms] => 9
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Public Sewer
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

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

[street_number] => 154
    [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] => 
    [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] => 2023
    [team] => 
    [team_agents] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => 
    [total_gross_expense] => 13295
    [total_gross_income] => 0
    [total_parking] => 6 (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] => 154 S Quinsigamond Ave, Shrewsbury MA 01545
    [utilities] => Array
        (
        )

[view] => Array
        (
        )

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

[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