Overview Property Details Walkability

Withdrawn

334 Columbus Ave, Pittsfield MA 01201

Commercial Sale

A unique opportunity to own a work/live space. The building consists of an updated 3 bedroom house with kitchen, dining, and living room. The ''shop'' space has heat and a separate bathroom. It also boasts a detached two car garage with power. There are endless possibilities...

This home has been viewed 72 times

Last Checked: February 4th, 2025 at 5:20am (Source: MLS PIN #73309545)

General Information for 334 Columbus Ave, Pittsfield MA 01201

Listing ID73309545

Property TypeCommercial Sale / Commercial

Price$168,999

Style

CityPittsfield

CountyBerkshire

MLS Area

Neighborhood(s)

Garage Parking

ZoningCWS

AssociationNo

Year Built1954

Year Built Source

Year Renovated

Year Built Details

Handicap Access / FeaturesNo

Energy Features

Disclosures for 334 Columbus Ave, Pittsfield MA 01201

Lead Paint

UFFI

Living Area Includes Basement

Living Area Disclosure

Building Area Source

Senior CommunityNo

Special Listing Conditions

For Sale By OwnerNo

Exclusions

Disclosures

Title 5

Buyer Agent Compensation

Facilitator Compensation

Sub-Agent Compensation

Compensation Based On

Contact Information for 334 Columbus Ave, Pittsfield MA 01201

Agent

Name: Michele Purcell

MLS ID: CN256679

Office ID: AN8599

Address: 99 Meadowview Drive

City: Cheshire

State: MA

Zip: 01225

Office

Name: Lamacchia Realty, Inc.

MLS Office ID: AN8599

Phone: 413-443-7274

Exclusive Listing Agent

Lamacchia Realty, Inc.

Michele Purcell

Agent Phone

Office Phone

(413) 443-7274

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 0.16 acres (6,795 SqFt)
    [add_date] => 2024-11-05 09:53:21
    [address] => Columbus Ave
    [agent] => Array
        (
            [address] => 99 Meadowview Drive
            [city] => Cheshire
            [id] => CN256679
            [name] => Michele Purcell
            [national_association] => 
            [office] => AN8599
            [state] => MA
            [zip] => 01225
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
        )

[approx_living_area_total] => 
    [approx_lot_size_acres] => 0.16 acres
    [approx_lot_size_sqft] => 6,795 SqFt
    [assessed_value] => 
    [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
        (
        )

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

[building_area_source] => Array
        (
        )

[building_management] => Array
        (
        )

[building_debug] => 334 Columbus Ave Pittsfield
    [building_id] => 
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Commercial
        )

[c_type] => Commercial Sale
    [cap_rate] => -1.23%
    [city] => Pittsfield
    [community_features] => Array
        (
        )

[compensation_based_on] => Array
        (
        )

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
        )

[construction_status] => 
    [cooling] => No
    [cooperating_agent_commission] => Array
        (
        )

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

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => A unique opportunity to own a work/live space. The building consists of an updated 3 bedroom house with kitchen, dining, and living room. The ''shop'' space has heat and a separate bathroom. It also boasts a detached two car garage with power. There are endless possibilities with this property. Bring your ideas and let them flow!
    [disclosures] => 
    [documents_available] => Array
        (
        )

[electric] => Array
        (
        )

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

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

[energy_features] => Array
        (
        )

[entry_level] => Array
        (
        )

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

[exterior_features] => Array
        (
        )

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

[fireplaces] => Array
        (
        )

[first_month_required] => Array
        (
        )

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

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

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

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

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

[half_baths] => 0
    [handicap_access] => No
    [heating] => No
    [heating_expense] => Array
        (
            [0] => $0
        )

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

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

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

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2025-02-04 05:20:22
    [laundry_features] => Array
        (
        )

[lead_paint] => Array
        (
        )

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

[living_area_includes_basement] => Array
        (
        )

[lot_features] => Array
        (
        )

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

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

[mls_area] => 
    [mls_id] => 73309545
    [neighborhoods] => Array
        (
        )

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

[number_of_lots] => Array
        (
        )

[number_of_units] => 1
    [office] => Array
        (
            [id] => AN8599
            [name] => Lamacchia Realty, Inc.
            [phone] => 413-443-7274
        )

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

[optional_fee_includes] => Array
        (
        )

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

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

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

[perc_test] => Array
        (
        )

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

[phone] => 413-441-2879
    [pool_features] => Array
        (
        )

[price] => $168,999
    [price_per_sqft] => 0
    [price_per_unit] => 168999
    [private_pool] => No
    [property_sub_type] => Array
        (
        )

[real_estate_tax] => $2,079.52
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

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

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
        )

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

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

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

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

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

[style] => Array
        (
        )

[subagent_compensation] => 
    [tag_accessible_features] => 
    [tag_air_conditioning] => 
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 
    [tag_elevator] => 
    [tag_equestrian] => 
    [tag_garage_parking] => 
    [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] => 2079
    [total_gross_income] => 0
    [total_parking] => 6
    [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] => 334 Columbus Ave, Pittsfield MA 01201
        )

[utilities] => Array
        (
        )

[view] => Array
        (
        )

[water] => Array
        (
        )

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

[water_views] => Array
        (
        )

[water_views_features] => Array
        (
        )

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

[year_built] => 1954
    [year_built_details] => 
    [year_built_source] => 
    [year_renovated] => 
    [zip] => 01201
    [zoning] => CWS
    [zoning_details] => Legal Conforming
    [media] => Array
        (
            [0] => Array
                (
                    [id] => 68964593
                    [name] => MLS1.jpg
                    [type] => gallery
                    [category] => image
                    [url] => https://www.bostonrealestate.com/wp-content/uploads/WPL/561825/MLS1.jpg
                    [index] => 1
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[1] => Array
                (
                    [id] => 68964626
                    [name] => MLS2.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=2
                    [index] => 2
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[2] => Array
                (
                    [id] => 68964627
                    [name] => MLS3.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=3
                    [index] => 3
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[3] => Array
                (
                    [id] => 68964628
                    [name] => MLS4.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=4
                    [index] => 4
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[4] => Array
                (
                    [id] => 68964629
                    [name] => MLS5.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=5
                    [index] => 5
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[5] => Array
                (
                    [id] => 68964630
                    [name] => MLS6.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=6
                    [index] => 6
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[6] => Array
                (
                    [id] => 68964631
                    [name] => MLS7.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=7
                    [index] => 7
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[7] => Array
                (
                    [id] => 68964632
                    [name] => MLS8.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=8
                    [index] => 8
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[8] => Array
                (
                    [id] => 68964633
                    [name] => MLS9.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=9
                    [index] => 9
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[9] => Array
                (
                    [id] => 68964634
                    [name] => MLS10.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=10
                    [index] => 10
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[10] => Array
                (
                    [id] => 68964635
                    [name] => MLS11.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=11
                    [index] => 11
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[11] => Array
                (
                    [id] => 68964636
                    [name] => MLS12.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=12
                    [index] => 12
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[12] => Array
                (
                    [id] => 68964637
                    [name] => MLS13.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=13
                    [index] => 13
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[13] => Array
                (
                    [id] => 68964638
                    [name] => MLS14.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=14
                    [index] => 14
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[14] => Array
                (
                    [id] => 68964639
                    [name] => MLS15.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=15
                    [index] => 15
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[15] => Array
                (
                    [id] => 68964640
                    [name] => MLS16.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=16
                    [index] => 16
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[16] => Array
                (
                    [id] => 68964641
                    [name] => MLS17.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=17
                    [index] => 17
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[17] => Array
                (
                    [id] => 68964642
                    [name] => MLS18.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=18
                    [index] => 18
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[18] => Array
                (
                    [id] => 68964643
                    [name] => MLS19.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=19
                    [index] => 19
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[19] => Array
                (
                    [id] => 68964644
                    [name] => MLS20.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=20
                    [index] => 20
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[20] => Array
                (
                    [id] => 68964645
                    [name] => MLS21.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=21
                    [index] => 21
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[21] => Array
                (
                    [id] => 68964646
                    [name] => MLS22.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=22
                    [index] => 22
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[22] => Array
                (
                    [id] => 68964647
                    [name] => MLS23.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=23
                    [index] => 23
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[23] => Array
                (
                    [id] => 68964648
                    [name] => MLS24.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=24
                    [index] => 24
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[24] => Array
                (
                    [id] => 68964649
                    [name] => MLS25.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=25
                    [index] => 25
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[25] => Array
                (
                    [id] => 68964650
                    [name] => MLS26.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=26
                    [index] => 26
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[26] => Array
                (
                    [id] => 68964651
                    [name] => MLS27.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=27
                    [index] => 27
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[27] => Array
                (
                    [id] => 68964652
                    [name] => MLS28.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=28
                    [index] => 28
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[28] => Array
                (
                    [id] => 68964653
                    [name] => MLS29.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=29
                    [index] => 29
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[29] => Array
                (
                    [id] => 68964654
                    [name] => MLS30.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=30
                    [index] => 30
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

[30] => Array
                (
                    [id] => 68964655
                    [name] => MLS31.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73309545&w=1024&h=768&n=31
                    [index] => 31
                    [enabled] => 1
                    [created] => 2025-02-04 05:20:22
                    [modified] => 2025-02-04 05:20:22
                )

)

)

EXIT